Real Estate Investment Analysis Excel Spreadsheet 43077 | C92537fc 9e54 4d1e 89b3 500c5de5342a

Partial file snippet.

Sheet 1: Inputs

	
	
	
	
	
	
	
	
	
	
	
	
		Investment Property Analysis Sheet
		

		1
	
	
		Provided by Joe Massey of Castle & Cooke Mortgage and Charles Roberts of Your Castle Real Estate
		

		2
	
	
		

		

		

		Joe Massey: 303-809-7769 - Email: jmassey@castlecookemortgage.com - Website: www.loansbyjoemassey.com 
		

		

		

		

		

		

		3
	
	
		

		

		

		Charles Roberts: 303-523-3837 - Email: croberts@yourcastle.com - Website: www.yourcastle.com
		

		

		

		

		

		

		3
	
	
		

		

		

		

		

		

		

		

		

		

		4
	
	
		Instructions:  
		1 - Work your way down this sheet inputting the appropriate information in to each highlighted tab. 
		

		

	
	
		

		2 - Be sure to input the correct number of units for your subject property (SFR through Four-Plex) 
		

		

	
	
		Latest Revision Date: 
		3 - Please note that certain lines have comments to provide additional help for you
		

		

	
	
		December 1st, 2017
		4 - Once the highlighted cells are completed, you can view your results on the Cash-Flow Tab and What-If Tab
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Property Address
		123 Main St
		

		

		

		

		

		

		

		

		

	
	
		Number of Units
		1
		

		

		

		

		

		

		

		

		

	
	
		

		

		 
		

		

	
	
		Down Payment Percentage
		25%
		

		

	
	
		

		

		

		

	
	
		Purchase Price
		 $165,000 
		 
		

		

	
	
		Acquisition Costs 
		 $972 
		

		

	
	
		Loan Costs
		 $1,490 
		 
		

		

		

	
	
		Down Payment 
		 $41,250 
		

		

		

	
	
		Mortgage Balance
		 $123,750 
		

		

		

	
	
		Initial Repair Costs
		 $5,000.00 
		

		

		

		

		

		

		

		

		

	
	
		Total Initial Investment
		 $48,712 
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Mortgage Interest Rate
		4.375%
		

		

		

		

		

		

		

		

		

	
	
		Mortgage Term (years) 
		30
		

		

		

		

		

		

		

		

		

	
	
		Extra Principal per Month
		0
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		MONTHLY Rental Income Per Unit
		

		

		

		

		

		

		

		

		

	
	
		Unit #1
		 $1,726 
		

		

		

		

		

		

		

		

		

	
	
		Unit #2
		

		 
		

		

		

		

		

		

		

		

	
	
		Unit #3
		

		 
		

		

		

		

		

		

		

		

	
	
		Unit #4
		

		 
		

		

		

		

		

		

		

		

	
	
		Total Rental Income
		 $1,726 
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Vacancy Factor
		3%
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Annual Rent Increase
		5%
		

		

		

		

		

		

		

		

		

	
	
		

		

		 
		

		

	
	
		Annual Appreciation Rate
		6.0%
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		ANNUAL Operating Expenses
		

		Comments/Footnotes On Expenses
		

		

		

	
	
		Real Estate Taxes
		1116.34
		

		

		

		

		

	
	
		Property Insurance
		216
		

		

		

		

		

	
	
		Property Management
		 $1,450 
		

		Standard 10% of gross rents for Property Management
		

		

		

	
	
		Repairs and Maintenance
		 $1,036 
		

		Generally a minimum of 5% for repairs/maintenance
		

		

		

	
	
		Utilities (If paid by owner) 
		

		

		

		

		

		

	
	
		 - Water and Sewer
		

		

		

		

		

		

	
	
		 - Trash
		

		

		

		

		

		

	
	
		 - Electric
		

		

		

		

		

		

	
	
		Landscaping
		

		

		

		

		

		

	
	
		HOA Dues
		2160
		

		

		

		

		

	
	
		Other
		

		

		

		

		

		

	
	
		Other
		

		

		

		

		

		

	
	
		Other
		

		

		

		

		

		

	
	
		Other
		

		

		

		

		

		

	
	
		Other
		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		What If Scenarios
		

		

		

		

		

		

		

		

		

		

	
	
		What if you got a discount on the purchase price…  What percentage?  
		

		

		

		5%
		

		

		

		

		

		

	
	
		What if you lowered expenses…. What percentage? 
		

		

		

		5%
		

		

		

		

		

		

	
	
		What if you increased rents…  What percentage? 
		

		

		

		5%
		

		

		

		

		

		

	
	
		
 
		
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	

 


Sheet 2: Cash-Flow

	
	
	
	
	
	
	
	
	
	
	
	
		Cash Flow Analysis for 
		

		123 Main St
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Number of Units 
		

		1
		

		

		

		

		

		

		

		

	
	
		

		

		

		
 
		
		
	
		Cash Investment Breakdown
		

		

		
	
		Purchase Price
		

		 $165,000 
		
	
		Mortgage
		

		 $123,750 
		
	
		Down Payment
		

		 $41,250 
		

		

	
	
		Estimated Finance and Acquisition Costs
		

		 $2,462 
		

		

	
	
		Repair Costs
		

		 $5,000 
		

		

	
	
		Total Cash Investment 
		

		 $48,712 
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Annual Cash Flow Statement 
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Annual Income
		

		

		

		

		

		

		

		

		

		

	
	
		Annual Rental Income
		

		 $20,712 
		

		$1,726
		per month
		

		

		

		

		

	
	
		 - Vacancy
		3%
		 $(621)
		

		

		

		

		

		

		

		

	
	
		Expected Annual Rental Income
		

		 $20,091 
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Annual Expenses
		

		

		

		Comments/Footnotes
		

		

		

		

		

		

	
	
		Real Estate Taxes
		

		 $1,116 
		

		 -   
		

	
	
		Property Insurance
		

		 $216 
		

		 -   
		

	
	
		Property Management
		

		 $1,450 
		

		 Standard 10% of gross rents for Property Management 
		

	
	
		Repairs and Maintenance
		

		 $1,036 
		

		 Generally a minimum of 5% for repairs/maintenance 
		

	
	
		Utilities (If paid by owner) 
		

		 $- 
		

		 -   
		

	
	
		  Water and Sewer
		

		 $- 
		

		 -   
		

	
	
		  Trash
		

		 $- 
		

		 -   
		

	
	
		  Electric
		

		 $- 
		

		 -   
		

	
	
		Landscaping
		

		 $- 
		

		 -   
		

	
	
		HOA Dues
		

		 $2,160 
		

		 -   
		

	
	
		Other
		

		 $- 
		

		 -   
		

	
	
		Other
		

		 $- 
		

		 -   
		

	
	
		Other
		

		 $- 
		

		 -   
		

	
	
		Other
		

		 $- 
		

		 -   
		

	
	
		Other
		

		 $- 
		

		 -   
		

	
	
		Total Annual Expenses
		

		 $5,978 
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Net Operating Income
		

		 $14,113 
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Less: Annual Mortgage Payments
		

		 $(7,414)
		

		$123,750
		@
		4.375%
		=
		$617.87
		 per month
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Annual Cash Flow Before Taxes
		

		 $6,698 
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Cash-on-Cash Rate of Return
		

		14%
		

		$6,698
		÷
		$48,712
		=
		14%
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		CAP Rate
		

		8.3%
		

		$14,113
		÷
		$170,000
		=
		8.3%
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		GRM - Gross Rent Multiplier
		

		98.5
		

		$170,000
		÷
		$1,726
		=
		98.5
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		5 Year After-Tax Return 
		

		21.0%
		

		5 Year After Tax Cash-flows + 5 Year Exit - Capital Gains
		
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		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 do not represent, warrant or guarantee these numbers.  Charles Roberts and Your Castle Real Estate 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.  
		
	
		
	
		
	
		

 


Sheet 3: 15 Year Analysis

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		Cash Flow Analysis for 
		

		123 Main St
		

		Cash Investment Breakdown
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Purchase Price
		

		

		

		 $165,000 
		

		
 
		
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Number of Units 
		

		1
		

		Mortgage
		

		

		

		 $123,750 
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Down Payment
		

		

		

		 $41,250 
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Estimated Finance and Acquisition Costs
		

		

		

		 $2,462 
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Repair Costs
		

		

		

		 $5,000 
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total Cash Investment 
		

		

		

		 $48,712 
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Annual Cash Flow Statement 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Annual Income
		

		Year 1
		

		Year 2
		

		Year 3
		

		Year 4
		

		Year 5
		

		Year 6
		

		Year 7
		

		Year 8
		

		Year 9
		

		Year 10
		

		Year 11
		

		Year 12
		

		Year 13
		

		Year 14
		

		Year 15
		

		Year 16
	
	
		Annual Rental Income
		

		 $20,712 
		

		 $21,748 
		

		 $22,835 
		

		 $23,977 
		

		 $25,176 
		

		 $26,434 
		

		 $27,756 
		

		 $29,144 
		

		 $30,601 
		

		 $32,131 
		

		 $33,738 
		

		 $35,425 
		

		 $37,196 
		

		 $39,056 
		

		 $41,008 
		

		 $43,059 
	
	
		 - Vacancy
		3%
		 $(621)
		

		 $(652)
		

		 $(685)
		

		 $(719)
		

		 $(755)
		

		 $(793)
		

		 $(833)
		

		 $(874)
		

		 $(918)
		

		 $(964)
		

		 $(1,012)
		

		 $(1,063)
		

		 $(1,116)
		

		 $(1,172)
		

		 $(1,230)
		

		 $(1,292)
	
	
		Expected Annual Rental Income
		

		 $20,091 
		

		 $21,095 
		

		 $22,150 
		

		 $23,257 
		

		 $24,420 
		

		 $25,641 
		

		 $26,923 
		

		 $28,270 
		

		 $29,683 
		

		 $31,167 
		

		 $32,726 
		

		 $34,362 
		

		 $36,080 
		

		 $37,884 
		

		 $39,778 
		

		 $41,767 
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Annual Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Real Estate Taxes
		

		 $1,116 
		

		 $1,183 
		

		 $1,254 
		

		 $1,330 
		

		 $1,409 
		

		 $1,494 
		

		 $1,584 
		

		 $1,679 
		

		 $1,779 
		

		 $1,886 
		

		 $1,999 
		

		 $2,119 
		

		 $2,246 
		

		 $2,381 
		

		 $2,524 
		

		 $2,675 
	
	
		Property Insurance
		

		 $216 
		

		 $222 
		

		 $229 
		

		 $236 
		

		 $243 
		

		 $250 
		

		 $258 
		

		 $266 
		

		 $274 
		

		 $282 
		

		 $290 
		

		 $299 
		

		 $308 
		

		 $317 
		

		 $327 
		

		 $337 
	
	
		Property Management
		

		 $1,450 
		

		 $1,493 
		

		 $1,538 
		

		 $1,584 
		

		 $1,632 
		

		 $1,681 
		

		 $1,731 
		

		 $1,783 
		

		 $1,837 
		

		 $1,892 
		

		 $1,948 
		

		 $2,007 
		

		 $2,067 
		

		 $2,129 
		

		 $2,193 
		

		 $2,259 
	
	
		Repairs and Maintenance
		

		 $1,036 
		

		 $1,067 
		

		 $1,099 
		

		 $1,132 
		

		 $1,166 
		

		 $1,201 
		

		 $1,237 
		

		 $1,274 
		

		 $1,312 
		

		 $1,351 
		

		 $1,392 
		

		 $1,434 
		

		 $1,477 
		

		 $1,521 
		

		 $1,566 
		

		 $1,613 
	
	
		Utilities (If paid by owner) 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		  Water and Sewer
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		  Trash
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		  Electric
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		Landscaping
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		HOA Dues
		

		 $2,160 
		

		 $2,225 
		

		 $2,292 
		

		 $2,360 
		

		 $2,431 
		

		 $2,504 
		

		 $2,579 
		

		 $2,657 
		

		 $2,736 
		

		 $2,818 
		

		 $2,903 
		

		 $2,990 
		

		 $3,080 
		

		 $3,172 
		

		 $3,267 
		

		 $3,365 
	
	
		Other
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		Other
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		Other
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		Other
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		Other
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
		

		 $- 
	
	
		Total Annual Expenses
		

		 $5,978 
		

		 $6,191 
		

		 $6,412 
		

		 $6,642 
		

		 $6,881 
		

		 $7,130 
		

		 $7,388 
		

		 $7,658 
		

		 $7,938 
		

		 $8,229 
		

		 $8,533 
		

		 $8,849 
		

		 $9,178 
		

		 $9,520 
		

		 $9,877 
		

		 $10,249 
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Net Operating Income
		

		 $14,113 
		

		 $14,905 
		

		 $15,738 
		

		 $16,616 
		

		 $17,539 
		

		 $18,512 
		

		 $19,535 
		

		 $20,612 
		

		 $21,745 
		

		 $22,938 
		

		 $24,193 
		

		 $25,513 
		

		 $26,902 
		

		 $28,364 
		

		 $29,901 
		

		 $31,518 
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Less: Annual Mortgage Payments
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
		

		 $(7,414)
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Annual Cash Flow Before Taxes
		

		 $6,698 
		

		 $7,490 
		

		 $8,324 
		

		 $9,201 
		

		 $10,125 
		

		 $11,097 
		

		 $12,121 
		

		 $13,198 
		

		 $14,331 
		

		 $15,524 
		

		 $16,779 
		

		 $18,099 
		

		 $19,488 
		

		 $20,949 
		

		 $22,486 
		

		 $24,103 
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Property Value at End of Year
		

		 $174,900 
		

		 $185,394 
		

		 $196,518 
		

		 $208,309 
		

		 $220,807 
		

		 $234,056 
		

		 $248,099 
		

		 $262,985 
		

		 $278,764 
		

		 $295,490 
		

		 $313,219 
		

		 $332,012 
		

		 $351,933 
		

		 $373,049 
		

		 $395,432 
		

		 $419,158 
	
	
		Mortgage Balance at End of Year
		

		 $121,709 
		

		 $119,577 
		

		 $117,350 
		

		 $115,023 
		

		 $112,593 
		

		 $110,054 
		

		 $107,402 
		

		 $104,631 
		

		 $101,736 
		

		 $98,713 
		

		 $95,554 
		

		 $92,255 
		

		 $88,808 
		

		 $85,194 
		

		 $81,433 
		

		 $-   
	
	
		Total Equity
		

		 $53,191 
		

		 $65,817 
		

		 $79,168 
		

		 $93,285 
		

		 $108,214 
		

		 $124,002 
		

		 $140,697 
		

		 $158,354 
		

		 $177,028 
		

		 $196,777 
		

		 $217,665 
		

		 $239,758 
		

		 $263,125 
		

		 $287,855 
		

		 $313,999 
		

		 $419,158 
	
	
		Equity + Cash Flow
		

		 $59,889 
		

		 $73,307 
		

		 $87,492 
		

		 $102,487 
		

		 $118,339 
		

		 $135,099 
		

		 $152,818 
		

		 $171,552 
		

		 $191,359 
		

		 $212,301 
		

		 $234,444 
		

		 $257,857 
		

		 $282,613 
		

		 $308,804 
		

		 $336,486 
		

		 $443,261 
	
	
		Annual Rate of Return
		

		22.9%
		

		41.3%
		

		44.5%
		

		47.9%
		

		51.4%
		

		55.2%
		

		59.2%
		

		63.3%
		

		67.8%
		

		72.4%
		

		77.3%
		

		82.5%
		

		88.0%
		

		93.8%
		

		99.8%
		

		265.4%
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Cumulative Cash Flow
		

		 $6,698 
		

		 $14,189 
		

		 $22,512 
		

		 $31,714 
		

		 $41,839 
		

		 $52,936 
		

		 $65,056 
		

		 $78,254 
		

		 $92,585 
		

		 $108,109 
		

		 $124,887 
		

		 $142,986 
		

		 $162,474 
		

		 $183,424 
		

		 $205,910 
		

		 $230,013 
	
	
		Cash on Cash Rate of Return
		

		13.8%
		

		29.1%
		

		46.2%
		

		65.1%
		

		85.9%
		

		108.7%
		

		133.6%
		

		160.6%
		

		190.1%
		

		221.9%
		

		256.4%
		

		293.5%
		

		333.5%
		

		376.5%
		

		422.7%
		

		472.2%
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Cumulative Cash and Equity Gain
		

		 $11,177 
		

		 $31,294 
		

		 $52,968 
		

		 $76,287 
		

		 $101,341 
		

		 $121,527 
		

		 $142,853 
		

		 $165,384 
		

		 $189,187 
		

		 $214,335 
		

		 $240,904 
		

		 $268,975 
		

		 $298,633 
		

		 $329,981 
		

		 $363,088 
		

		 $475,572 
	
	
		Rate of Return on Initial Cash Investment
		

		22.9%
		

		64.2%
		

		108.7%
		

		156.6%
		

		208.0%
		

		249.5%
		

		293.3%
		

		339.5%
		

		388.4%
		

		440.0%
		

		494.5%
		

		552.2%
		

		613.1%
		

		677.4%
		

		745.4%
		

		976.3%
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		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 do not represent, warrant or guarantee these numbers.  Charles Roberts and Your Castle Real Estate 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.  
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		 $(48,712)
		 $4,689 
		

		 $5,243 
		

		 $5,827 
		

		 $6,441 
		

		 $90,474 
		

		21%
		IRR
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 $7,087 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 $205,350.71 
		Net Future value after 7% sales cost 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 $92,757.95 
		Pre Tax Terminal Value 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 $47,812.71 
		Capital Gain Base
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 $9,371.29 
		Capital Gains Tax at 19.6%
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 $83,386.66 
		After Tax Terminal Value

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet inputs investment property analysis provided by joe massey of castle amp cooke mortgage and charles roberts your real estate email jmassey castlecookemortgagecom website wwwloansbyjoemasseycom croberts yourcastlecom wwwyourcastlecom instructions work way down this inputting the appropriate information in to each highlighted tab be sure input correct number units for subject sfr through fourplex latest revision date please note that certain lines have comments provide additional help you december st once cells are completed can view results on cashflow whatif address main payment percentage purchase price acquisition costs loan balance initial repair total interest rate term years extra principal per month monthly rental income unit vacancy factor annual rent increase appreciation operating expenses commentsfootnotes taxes insurance management standard gross rents repairs maintenance generally a minimum repairsmaintenance utilities if paid owner water sewer trash electric landscap...

Related files

Share

Help

Investment Property Analysis Sheet				1
Provided by Joe Massey of Castle & Cooke Mortgage and Charles Roberts of Your Castle Real Estate				2
		Joe Massey: 303-809-7769 - Email: jmassey@castlecookemortgage.com - Website: www.loansbyjoemassey.com		3
		Charles Roberts: 303-523-3837 - Email: croberts@yourcastle.com - Website: www.yourcastle.com		3
				4
Instructions:	1 - Work your way down this sheet inputting the appropriate information in to each highlighted tab.
	2 - Be sure to input the correct number of units for your subject property (SFR through Four-Plex)
Latest Revision Date:	3 - Please note that certain lines have comments to provide additional help for you
December 1st, 2017	4 - Once the highlighted cells are completed, you can view your results on the Cash-Flow Tab and What-If Tab

Property Address	123 Main St
Number of Units	1

Down Payment Percentage	25%

Purchase Price	$165,000
Acquisition Costs	$972
Loan Costs	$1,490
Down Payment	$41,250
Mortgage Balance	$123,750
Initial Repair Costs	$5,000.00
Total Initial Investment	$48,712

Mortgage Interest Rate	4.375%
Mortgage Term (years)	30
Extra Principal per Month	0

MONTHLY Rental Income Per Unit
Unit #1	$1,726
Unit #2
Unit #3
Unit #4
Total Rental Income	$1,726

Vacancy Factor	3%

Annual Rent Increase	5%

Annual Appreciation Rate	6.0%

ANNUAL Operating Expenses		Comments/Footnotes On Expenses
Real Estate Taxes	1116.34
Property Insurance	216
Property Management	$1,450	Standard 10% of gross rents for Property Management
Repairs and Maintenance	$1,036	Generally a minimum of 5% for repairs/maintenance
Utilities (If paid by owner)
- Water and Sewer
- Trash
- Electric
Landscaping
HOA Dues	2160
Other
Other
Other
Other
Other


What If Scenarios
What if you got a discount on the purchase price… What percentage?			5%
What if you lowered expenses…. What percentage?			5%
What if you increased rents… What percentage?			5%

Cash Flow Analysis for		123 Main St

Number of Units		1

Cash Investment Breakdown
Purchase Price		$165,000
Mortgage		$123,750
Down Payment		$41,250
Estimated Finance and Acquisition Costs		$2,462
Repair Costs		$5,000
Total Cash Investment		$48,712


Annual Cash Flow Statement

*Annual Income*
Annual Rental Income		$20,712	$1,726	per month
- Vacancy	3%	$(621)
Expected Annual Rental Income		$20,091

*Annual Expenses*			Comments/Footnotes
Real Estate Taxes		$1,116	-
Property Insurance		$216	-
Property Management		$1,450	Standard 10% of gross rents for Property Management
Repairs and Maintenance		$1,036	Generally a minimum of 5% for repairs/maintenance
Utilities (If paid by owner)		$-	-
Water and Sewer		$-	-
Trash		$-	-
Electric		$-	-
Landscaping		$-	-
HOA Dues		$2,160	-
Other		$-	-
Other		$-	-
Other		$-	-
Other		$-	-
Other		$-	-
Total Annual Expenses		$5,978

Net Operating Income		$14,113

Less: Annual Mortgage Payments		$(7,414)	$123,750	@	4.375%	=	$617.87	per month

Annual Cash Flow Before Taxes		$6,698

Cash-on-Cash Rate of Return		14%	$6,698	÷	$48,712	=	14%

CAP Rate		8.3%	$14,113	÷	$170,000	=	8.3%

GRM - Gross Rent Multiplier		98.5	$170,000	÷	$1,726	=	98.5

5 Year After-Tax Return		21.0%	5 Year After Tax Cash-flows + 5 Year Exit - Capital Gains

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 do not represent, warrant or guarantee these numbers. Charles Roberts and Your Castle Real Estate 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.

Related files

Share

Share to social media

Help

Login Area