Rental Proforma
This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Update
Reset
Print All
Data & Summary
Data & Summary
Ten Year Detailed
Glossary
PROPERTY INFO
Address:
Property Type:
Single Fam Home
Condo
Townhouse
Duplex
3Plex
4 Plex
Purchase Price or Current Value:
Downpayment:
Purchase Closing Costs:
Estimated Rehab:
Total Out of Pocket (TOP):
ASSUMPTIONS
FINANCED INCOME BREAKDOWN
Down Payment
Monthly Rent
Purchase Closing Costs
Monthly Property Tax
Interest Rate
Monthly Insurance
Mrtg Term (years)
Monthly HOA Fee
Property Management Fee
Monthly Mrtg Payment
Repairs/CapEx - 10% Budget
Vacancy
Average Annual Return*
Annual Appreciation (YR 1-10)
Average Annual Cash on Cash**
Annual Rent/Expense Increase
10 Years Cash + Equity***
Closing Costs & Rehab for Future Sale
Ending Value of Investment + Cash Flow
The information and any statistical data contained herein have been obtained from sources which we believe to be reliable, but we do not represent that they are accurate or complete, and they should not be relied upon as such. All opinions expressed and data provided herein are subject to change without notice. Past performance is no guarantee of future results, and current performance may be lower or higher than the performance data quoted. Results shown here are not typical, results will vary based upon real estate prices, interest rates, creditworthiness and many other factors.
INCOME/EXPENSE
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 6
YEAR 7
YEAR 8
YEAR 9
YEAR 10
Gross Rent
Taxes
Insurance
HOA
Property Management
Repairs
Vacancy
Net Operating Income
Debt Service
FINANCIALS
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 6
YEAR 7
YEAR 8
YEAR 9
YEAR 10
Net Monthly Cash Flow
Net Annual Cash Flow
Total Cash Flow up to End of Year
Cap Rate
Cash on Cash Return
Current Value
Principal Reduction
Appreciation
Profit on Sale
ROI
The information and any statistical data contained herein have been obtained from sources which we believe to be reliable, but we do not represent that they are accurate or complete, and they should not be relied upon as such. All opinions expressed and data provided herein are subject to change without notice. Past performance is no guarantee of future results, and current performance may be lower or higher than the performance data quoted. Results shown here are not typical, results will vary based upon real estate prices, interest rates, creditworthiness and many other factors.
GLOSSARY OF TERMS
Expense Increase
Taxes, Insurance, and other costs are expected to increase annually.
Principal Reduction
The Principal Reduction is calculated cumulatively based off a fixed rate ammortized mortgage.
Appreciation
The Appreciation value is calculated cumulatively.
Profit on Sale
The Profit on the Sale is calculated by taking the market value (Purchase Price and cumulative Appreciation), and subtracting the initial Purchase Price, Closing Costs, Rehab Expenses and Closing Costs on the Future Sale, plus accumulated cash flow plus principal paydown. It is assumed year 10 is the end of the useful life of a rehab or new construction related condition, and a rehab of 2% of sales price has been added to closing costs related to the sale.
Total Out of Pocket (TOP)
The Total Out of Pocket value is calculated by adding the down payment, closing costs, rehab expenses, and other acquisition costs
Return on Investment (ROI)
The Return on Investment is calculated by taking the Profit on the Sale, divided by the initial Total Out of Pocket
Cash on Cash Return
The Cash on Cash Return is calculated by dividing the Annual Net Cash Flow by the Total Out of Pocket (TOP).
Cap Rate
Cap Rate is calculated by dividing the Net Operating Income by the Purchase Price.
*The Average Annual Return is calculated by dividing the ROI in year 10 by 10.
**The Average Annual Cash on Cash Return is the average of the Cash on Cash Return over all 10 years the investment is held
***10 Years Cash + Equity is the total cash flow plus total equity growth plus initial down payment
The information and any statistical data contained herein have been obtained from sources which we believe to be reliable, but we do not represent that they are accurate or complete, and they should not be relied upon as such. All opinions expressed and data provided herein are subject to change without notice. Past performance is no guarantee of future results, and current performance may be lower or higher than the performance data quoted. Results shown here are not typical, results will vary based upon real estate prices, interest rates, creditworthiness and many other factors.
Print All Information
Please host the converted page in server to use Print All.
Update
Reset
Print All