Fresno Deal Analysis

Let's look at deal analysis for Fresno, CA and for 15 Buy 10 Nomads™ with 10% Higher Rents.

The analysis is based on The World's Greatest Real Estate Deal Analysis Spreadsheet™ (shown above)... a free spreadsheet download you can use to analyze your own deals.

Typical Fresno, California Nomad™ Property with 10% Higher Rents

Typical Fresno, California Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$336,813
Purchase Price		$336,813
Seller Concessions	—	$0
Down Payment	5.000%	$16,841
Closing Costs	1.000%	$3,368
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$92,475
Total Invested		$112,684
Mortgage
Mortgage Amount		$319,972.35
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$226.65
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,789 $1789.10
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$644
Property Taxes	0.889%	$2,994
Property Insurance	0.173%	$583
HOA Dues		$0
Utilities		$0
Other Expenses 1		$0
Other Expenses 2		$0
Maintenance	10.000%
CapEx		$0
Management	0.000%
Depreciation Details
Land Value	15.000%	$50,522
Property Type (C or R)	R	27.5
Effective Income Tax Rate	15.000%

Property Value	1	2	3	4	5
ARV at End of Year	$346,917	$357,325	$368,045	$379,086	$390,459
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$10,104	$10,408	$10,720	$11,041	$11,373
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,789	$1,843	$1,898	$1,955	$2,014
Monthly Other Income Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Other Income	$0	$0	$0	$0	$0
Monthly Gross Potential Income	$1,789	$1,843	$1,898	$1,955	$2,014
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$54	$55	$57	$59	$60
Monthly Gross Operating Income	$1,735	$1,787	$1,841	$1,896	$1,953
Annual Income	1	2	3	4	5
Annual Rent	$21,469	$22,113	$22,777	$23,460	$24,164
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$21,469	$22,113	$22,777	$23,460	$24,164
Annual Vacancy Dollar	$644	$663	$683	$704	$725
Annual Gross Operating Income	$20,825	$21,450	$22,093	$22,756	$23,439
Annual Expenses	1	2	3	4	5
Property Taxes Percent	0.889%	0.889%	0.889%	0.889%	0.889%
Property Taxes Dollar	$2,994	$3,084	$3,177	$3,272	$3,370
Insurance Percent	0.173%	0.173%	0.173%	0.173%	0.173%
Insurance Dollar	$583	$600	$618	$637	$656
HOA Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
HOA Dues Dollar	$0	$0	$0	$0	$0
Utilities Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Utilities Dollar	$0	$0	$0	$0	$0
Other Expense 1 Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Other Expense 1 Dollar	$0	$0	$0	$0	$0
Other Expense 2 Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Other Expense 2 Dollar	$0	$0	$0	$0	$0
Maintenance Percent	10.000%	10.000%	10.000%	10.000%	10.000%
Maintenance Dollar	$2,083	$2,145	$2,209	$2,276	$2,344
CapEx Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
CapEx Dollar	$0	$0	$0	$0	$0
Property Management Percent	0.000%	0.000%	0.000%	0.000%	0.000%
Property Management Dollar	$0	$0	$0	$0	$0
Annual Operating Expenses	$5,659	$5,829	$6,004	$6,184	$6,370
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$15,166	$15,621	$16,089	$16,572	$17,069
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$24,269	$24,269	$24,269	$24,269	$24,269
Principal	$3,576	$3,816	$4,071	$4,344	$4,635
Interest	$20,693	$20,453	$20,198	$19,925	$19,634
Loan Balance at End of Year	$316,396	$312,580	$308,509	$304,165	$299,529
Loan-To-Value	91.202%	87.478%	83.824%	80.236%	76.712%
Private Mortgage Insurance (PMI) Rate	0.850%	0.850%	0.850%	0.850%
Private Mortgage Insurance Dollar	$2,720	$2,720	$2,720	$2,720	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$30,521	$44,745	$59,536	$74,921	$90,929
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$11,823	-$11,368	-$10,900	-$10,417	-$7,200
Monhtly Cash Flow	-$985	-$947	-$908	-$868	-$600
Cash on Cash Return on Investment	-0.105%	-0.101%	-0.097%	-0.092%	-0.064%
Cap Rate
DSCR	0.00	0.00	0.00	0.00	0.00
Negative Cash Flow	$0	$0	$0	$0	$0
Cumulative Negative Cash Flow	$0	$0	$0	$0	$0