Augusta Deal Analysis

Let's look at deal analysis for Augusta, GA 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 Augusta, Georgia Nomad™ Property with 10% Higher Rents

Typical Augusta, Georgia Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$147,066
Purchase Price		$147,066
Seller Concessions	—	$0
Down Payment	5.000%	$7,353
Closing Costs	1.000%	$1,471
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$0
Total Invested		$8,824
Mortgage
Mortgage Amount		$139,712.70
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$98.96
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,675 $1674.75
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$603
Property Taxes	1.314%	$1,932
Property Insurance	0.878%	$1,291
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%	$22,060
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	$151,478	$156,022	$160,703	$165,524	$170,490
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$4,412	$4,544	$4,681	$4,821	$4,966
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,675	$1,725	$1,777	$1,830	$1,885
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,675	$1,725	$1,777	$1,830	$1,885
Vacancy Percent	3.000%	3.000%	3.000%	3.000%	3.000%
Monthly Vacancy Dollar	$50	$52	$53	$55	$57
Monthly Gross Operating Income	$1,625	$1,673	$1,723	$1,775	$1,828
Annual Income	1	2	3	4	5
Annual Rent	$20,097	$20,700	$21,321	$21,961	$22,619
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$20,097	$20,700	$21,321	$21,961	$22,619
Annual Vacancy Dollar	$603	$621	$640	$659	$679
Annual Gross Operating Income	$19,494	$20,079	$20,681	$21,302	$21,941
Annual Expenses	1	2	3	4	5
Property Taxes Percent	1.314%	1.314%	1.314%	1.314%	1.314%
Property Taxes Dollar	$1,932	$1,990	$2,050	$2,112	$2,175
Insurance Percent	0.878%	0.878%	0.878%	0.878%	0.878%
Insurance Dollar	$1,291	$1,330	$1,370	$1,411	$1,453
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	$1,949	$2,008	$2,068	$2,130	$2,194
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,173	$5,328	$5,488	$5,653	$5,822
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$14,321	$14,751	$15,193	$15,649	$16,118
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$10,597	$10,597	$10,597	$10,597	$10,597
Principal	$1,562	$1,666	$1,778	$1,897	$2,024
Interest	$9,035	$8,931	$8,819	$8,700	$8,573
Loan Balance at End of Year	$138,151	$136,485	$134,707	$132,810	$130,786
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	$1,188	$1,188	$1,188	$1,188	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$13,327	$19,537	$25,996	$32,714	$39,703
Cash Flow	1	2	3	4	5
Annual Cash Flow	$2,536	$2,966	$3,409	$3,864	$5,521
Monhtly Cash Flow	$211	$247	$284	$322	$460
Cash on Cash Return on Investment	0.287%	0.336%	0.386%	0.438%	0.626%
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