Filetype Excel XLS | Posted on 16 Aug 2022 | 3 years ago
Authentication
digital resources
171x Filetype XLS File size 0.21 MB Source: d3ciwvs59ifrt8.cloudfront.net
Sheet 1: Inputs
| Cash Flow Analysis for | 1125 Rosemary St | Purchased with Cash | ||||||||
| Number of Units | 1 | |||||||||
| Cash Investment Breakdown | After Repair Value | $170,000 | ||||||||
| Purchase Price | $100,000 | Total Mortgage Balance | $- | |||||||
| Acquisition Costs | $1,500 | Total Equity | $170,000 | |||||||
| Rehab Costs | $15,000 | |||||||||
| Total Cash Investment | $116,500 | |||||||||
| Annual Cash Flow Statement | ||||||||||
| Annual Income | ||||||||||
| Annual Rental Income | $15,000 | $1,250 | per month | |||||||
| - Vacancy | 5% | $(750) | ||||||||
| Expected Annual Rental Income | $14,250 | |||||||||
| Annual Expenses | Comments/Footnotes | |||||||||
| Real Estate Taxes | $(894) | - | ||||||||
| Property Insurance | $(600) | - | ||||||||
| Property Management | $(1,500) | - | ||||||||
| Repairs and Maintenance | $(750) | - | ||||||||
| Utilities (If paid by owner) | $- | - | ||||||||
| Water and Sewer | $- | - | ||||||||
| Trash | $- | - | ||||||||
| Electric | $- | - | ||||||||
| Landscaping | $- | - | ||||||||
| HOA Dues | $- | - | ||||||||
| Other | $- | - | ||||||||
| Other | $- | - | ||||||||
| Other | $- | - | ||||||||
| Other | $- | - | ||||||||
| Other | $- | - | ||||||||
| Total Annual Expenses | $(3,744) | |||||||||
| Net Operating Income | $10,506 | |||||||||
| Less: Annual Mortgage Payments | N/A | Property Purchased With Cash - No Mortgage Payments | ||||||||
| Annual Cash Flow Before Taxes | $10,506 | |||||||||
| Cash-on-Cash Rate of Return | 9.0% | $10,506 | ÷ | $116,500 | = | 9.0% | ||||
| CAP Rate on Purchase Price | 9.0% | $10,506 | ÷ | $116,500 | = | 9.0% | ||||
| CAP Rate on After Repair Value | 6.2% | $10,506 | ÷ | $170,000 | = | 6.2% | ||||
| This sheet is for informational purposes only. This is not a commitment, approval or guarantee to lend. The figures included in this worksheet are entirely dependent on the information that you input. These figures and calculations are considered accurate, but not guaranteed. Joe Massey and Castle & Cooke Mortgage, LLC do not represent, warrant or guarantee these numbers. All information is for preliminary analysis and calculations only. Please contact your tax advisor, CPA, financial planner, attorney, insurance agent, real estate agent or other properly licensed professional for additional information as needed. | ||||||||||
| Cash Flow Analysis for | 1125 Rosemary St | Purchased with Conventional Financing | ||||||||
| Number of Units | 1 | |||||||||
| Cash Investment Breakdown | After Repair Value | $170,000 | ||||||||
| Purchase Price | $100,000 | Total Mortgage Balance | $(75,000) | |||||||
| Mortgage | $(75,000) | Total Equity | $95,000 | |||||||
| Down Payment | $25,000 | |||||||||
| Acquisition Costs | $1,500 | |||||||||
| Loan Costs | $1,490 | |||||||||
| Rehab Costs | $15,000 | |||||||||
| Total Cash Investment | $42,990 | |||||||||
| Annual Cash Flow Statement | ||||||||||
| Annual Income | ||||||||||
| Annual Rental Income | $15,000 | $1,250 | per month | |||||||
| - Vacancy | 5% | $(750) | ||||||||
| Expected Annual Rental Income | $14,250 | |||||||||
| Annual Expenses | Comments/Footnotes | |||||||||
| Real Estate Taxes | $(894) | - | ||||||||
| Property Insurance | $(600) | - | ||||||||
| Property Management | $(1,500) | - | ||||||||
| Repairs and Maintenance | $(750) | - | ||||||||
| Utilities (If paid by owner) | $- | - | ||||||||
| Water and Sewer | $- | - | ||||||||
| Trash | $- | - | ||||||||
| Electric | $- | - | ||||||||
| Landscaping | $- | - | ||||||||
| HOA Dues | $- | - | ||||||||
| Other | $- | - | ||||||||
| Other | $- | - | ||||||||
| Other | $- | - | ||||||||
| Other | $- | - | ||||||||
| Other | $- | - | ||||||||
| Total Annual Expenses | $(3,744) | |||||||||
| Net Operating Income | $10,506 | |||||||||
| Less: Annual Mortgage Payments | $(4,831) | $75,000 | @ | 5.000% | = | $402.62 | per month | |||
| Annual Cash Flow Before Taxes | $5,675 | |||||||||
| Cash-on-Cash Rate of Return | 13.2% | $5,675 | ÷ | $42,990 | = | 13.2% | ||||
| CAP Rate on Purchase Price | 8.9% | $10,506 | ÷ | $117,990 | = | 8.9% | ||||
| CAP Rate on After Repair Value | 6.2% | $10,506 | ÷ | $170,000 | = | 6.2% | ||||
| This sheet is for informational purposes only. This is not a commitment, approval or guarantee to lend. The figures included in this worksheet are entirely dependent on the information that you input. These figures and calculations are considered accurate, but not guaranteed. Joe Massey and Castle & Cooke Mortgage, LLC do not represent, warrant or guarantee these numbers. All information is for preliminary analysis and calculations only. Please contact your tax advisor, CPA, financial planner, attorney, insurance agent, real estate agent or other properly licensed professional for additional information as needed. | ||||||||||
no reviews yet
Please Login to review.
