Publication number: ELQ-17001-1
View all versions & Certificate
Real-Estate Investment Excel Calculator
This tool will help newcomers to real-estate investment evaluate and analyse their potential real-estate investments.
This spreadsheet is an essential tool for anyone getting involved in real-estate investment.
This Excel Tool is broken down into five simple steps, making it incredibly easy to use and follow. These steps are: Finding the Net Operating Income, finding the Cap Rate, calculating appreciation 5 years past and 5 years future, financing and "cashflow", followed by the discounted cashflow, net present value and the net rate of return.
The first step of this tool will help you to calculate the overall profit that a property could generate, accounting for the total rent received and all of the possible fees to be paid. This will help you to calculate a yearly profit level for each individual property.
The second step will allow you to calculate and estimate the potential income of a property relative to its price. The tool will show you how you can calculate the cap rate for each of your properties, and show you what kind of numbers you should be looking for in your property investment.
The third step will help you identify potential real-estate investments that could be hugely profitable. Teddy suggests calculating the appreciation of a property over the past 5 years and using this, estimate its potential appreciation over the next five years. He demonstrates how you can find out a property's appreciation over the past 5 years and then how it can be applied to its current price to estimate its future appreciation. This process is absolutely essential in real estate property investment as it allows you to identify properties that could have huge potential.
The fourth step of this template will help you to plan the financing of your property investments. This will allow you to estimate what % of a property's price you can put down and what % of the property's price you will need to take out as a loan. This will allow you to calculate further expenses of your property's based on the monthly repayments of your loans. This step will also give you the chance to calculate the cashflow of your property. Teddy also demonstrates several other "fancy and useful metrics", such as the cash-on-cash return, operating expense ratio and debt coverage ratio. Teddy explains all of these different metrics and shows how they can be calculated and applied to your investments.
The final step of this tool will allow you to fully understand discounted cash flow, net present value and the internal rate of return. Through the input of your own information and data and information regarding your real-estate investment, this tool will calculate your DCF, NPV and IRR and your overall discount rate.
This tool is incredibly useful for those interested in real-estate investment. It will allow you to project and estimate the outcomes of different property investments based on several different factors. Therefore, it will allow you to establish which properties could be worth investment. Each step also comes with an incredibly simple explanation of what it is and how it can be used to help your investments, making this an essential for newcomers to the property market.
This business tool includes
1 Excel Spreadsheet
Teddy Smith offers you this business tool for free!
download for free
Add to bookmarks
- Donatas Juskus(last updated: 07/10/2018 15:48)
- Amit Kumar671(last updated: 01/10/2018 08:12)
- Amartya Ray(last updated: 01/10/2018 07:37)
- Tom Azzarelli(last updated: 20/09/2018 14:44)
- Vinayak Shanbhag(last updated: 12/09/2018 12:38)
- Linh Le493(last updated: 01/08/2018 02:07)
- Puleng Seakgwa(last updated: 23/07/2018 07:34)
- Ingrid Mendez(last updated: 16/07/2018 02:12)
- Sergei Safonov(last updated: 06/07/2018 18:59)
- Michael Raymond(last updated: 29/06/2018 02:24)
- Islam Raslan(last updated: 09/06/2018 16:22)
- Daelan Subban(last updated: 28/04/2018 08:27)
- J Vincent(last updated: 15/04/2018 08:57)
- Kunle Ogundijo(last updated: 05/04/2018 14:40)
People using this tool also downloaded
Discounted Cash Flow (DCF) Analysis with IRR and NPVSeveral spreadsheets that can be used for the analysis of a real estate investment from various perspectivesacquisitionfinancecash flownpvirrdcfreal estatefinancial analysisinvestingdiscounted cash flow10,925 remove_red_eye
Real Estate Excel ModelComprehensive excel model for tracking and projecting the finances of your real estate investments.real estatefinancial modelingreal estate financereal estate investmentreal estate financial modelreal estate calculatormixed use real estate457 remove_red_eye
Quick valuation: Net present value (NPV)A tool for a quick net present value (NPV) calculation for valuing a businessvaluationnpvdcfdiscounted cash flownet present value176 remove_red_eye$2.00by ModellingGuy
Quarterly DCF (Discounted Cash Flow) Discounting Formula Excel ModelIllustration of annual vs. quarterly DCF and discounting properly using the '=NPV' function in one cellnpvdcfdiscounted cash flownet present valuediscounting406 remove_red_eye
Leveraged Buyout LBO Model - DCFA comprehensive LBO model in excel of business acquisitionacquisitionbusinessfinanceleveraged buyoutirrcash flowsdcfcapmlbo analysislbo model2,171 remove_red_eyefreeby Amit Tandon
Capital Budgeting Analysis Excel ModelThis Excel Model allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROIanalysiscorporate financecapital budgetingprojectequitynpvirrroc2,979 remove_red_eye
NPV and IRR CalculationA model for calculating Net Present Value and Internal Rate of Return.financenpvirrfinancial modelnet present valuecalculationinternal rate of return2,699 remove_red_eye
Planeamatic: Financial modeling made easyPowerful, flexible, reliable and friendly financial models in minutescash flowvaluation modelirrdcfscenariosfinancial modelproject valuationfinancial modelingbreak-even pointfinancial models217 remove_red_eyefreeby Jose Corona
Commercial Real Estate Underwriting Excel Model - Full VersionCommercial Real Estate Underwriting Model to quickly analyze investment opportunities for Industrial/Retail/Officereal estatereal estate modelreal estate financeunderwriting69 remove_red_eye$89.00by Julian Scheeff
Project Finance Model – Toll Road – 30 Year ConcessionA project finance model for the construction of a toll road with a 30-year concession.feasibilitynpvirrbusiness modelfinancial modeldashboardproject financemodanoproject analysistoll road264 remove_red_eye$160.00by Dane Putranto
Discussion feed for Real-Estate Investment Excel Calculator
The user community and author are here to help. Go ahead!