Filetype Excel XLSX | Posted on 16 Aug 2022 | 3 years ago
Authentication
digital resources
202x Filetype XLSX File size 0.02 MB Source: www.exceldemy.com
Sheet 1: Sample
| Investment Property Cash Flow Calculation | >> Is This a Good Deal? >> | |||||
| Investment | Cash on Cash Return (for Full Mortgage) | |||||
| Item | Rate | Amount | Item | Amount | ||
| Actual Purchase Price | $100,000.00 | Yearly Cash Flow | $180.78 | |||
| Taxes and Fees | 0.5% | $500.00 | Personal Investment | $35,000.00 | ||
| Lawyer, Appraisal, etc. | 1.0% | $1,000.00 | COC Return | 0.52% | ||
| Real Estate Commission | 1.0% | $1,000.00 | ||||
| Overhaul and Rehab Cost | $10,000.00 | |||||
| Total Investment Needed | $112,500.00 | Return on Investment (Without Principal Paydown) | ||||
| Personal Investment | $35,000.00 | |||||
| Bank Loan | $77,500.00 | Item | Amount | |||
| Monthly Interest Payment | $(101.74) | |||||
| Monthly Debt Service | Monthly Principal Payment | $(538.19) | ||||
| Monthly Cash Flow | $15.07 | |||||
| Item | Rate/Time | Amount | Monthly Principal Paydown | $538.19 | ||
| Annual Rate of Interest | 3.0% | Monthly Cash Flow (Without Principal Paydown) | $553.26 | |||
| Terms of Loan in Years | 12 Years | Yearly Cash Flow (Without Principal Paydown) | $6,639.12 | |||
| Monthly Loan Payment | $(639.93) | Personal Investment | $35,000.00 | |||
| Return on Investment (ROI) | 18.97% | |||||
| Monthly Income | ||||||
| Item | Amount | |||||
| Rental Income | $1,000.00 | |||||
| Other Income (If Any) | $- | |||||
| Total Income | $1,000.00 | |||||
| Monthly Expenses | ||||||
| Item | Rate | Amount | ||||
| Property Management | 10.0% | $(100.00) | ||||
| Repair and Maintenance | 3.0% | $(30.00) | ||||
| Utilities | 2.0% | $(20.00) | ||||
| Property Taxes | 1.5% | $(125.00) | ||||
| Vacancy | 5.0% | $(50.00) | ||||
| Insurance | $(20.00) | |||||
| Other Expenses | $- | |||||
| Total Expenses | $(345.00) | |||||
| Monthly Cash Flow | ||||||
| Item | Amount | |||||
| Monthly Debt Service | $(639.93) | |||||
| Monthly Expenses | $(345.00) | |||||
| Monthly Revenue | $1,000.00 | |||||
| Monthly Cash Flow | $15.07 | |||||
no reviews yet
Please Login to review.
