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.
Reset
Print All
Submit
New Property
New Property
Data Input
ROI
Your email address
Address 1
Address 2
City
State
Zip
Country
USA
Summary
Loan Terms
Loan Amount
Mortgage
Interest Rate
Cash Invest.
Term (Months)
$3,100.00
Cash Reqd
Total ROI
Repairs
Trim
Utilities
Purchase Price
Appliances
Closing Costs
Cabinets
Prop Tax Credit
CTOPS
FENCE
Cost to Acquire
Foundation
Repairs
Flooring
Total Cost
Garage
Hardware
Loan To Value %
HVAC
Mortgage
Landscape
Interest Rate
Lighting
Term (Months)
Paint
Earnest Money
ext Paint
Plumbing
Closing Costs
Roof
Lender Fees
Sheetrock
orig
Trash
u/w, clos
Windows
Appraisal
Grout
Title Fees
Lawn
Policy
Final Clean
Escrow
Survey
misc
Prepaids
Insur
Taxes
Closing Costs
Repairs
Summary
Loan Terms
Loan Amount
Mortgage
Interest Rate
Cash Invest.
Term (Months)
P And I
Monthly
Cash Reqd to Close
Annual
ROI #1 :
Cashflow vs Cash Investment
Estimated Cash Flow
Monthly
Annually
Rent
Less Vacancy Reserves
Less First Trust P/I Payment
Less Property Taxes
Less CPA FEE
Less Insusurance
Less Association Fees
Less Maint Reserve
Less Other Expenses
Monthly
Annually
Cashflow before tax
Annual Cashflow / Initial Investment
ROI # 1
ROI #2 :
Principle Reduction and Equity Appreciation
Principle Balance:
End of YR 1
YR 2
YR 3
YR 4
YR 5
Balance on 1st row, Reduction 2nd row, Return on 3rd row
ROI # 2
ROI #3:
Estimated Annual Appreciation
Estimated Appreciation Rate:
Yearly Appreciation Value:
Return from Appreciation:
ROI # 3
Total Return on Investment:
%
$
ROI #1 : Cash Flow
ROI #2 : Principle Reduction
ROI #3 : Annual Appreciation
TOTAL ROI
Print All Information
Please host the converted page in server to use Print All.
Reset
Print All
Submit