Casper Deal Analysis

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

Typical Casper, Wyoming Nomad™ Property with 10% Higher Rents
Purchase Inputs
	Percents	Dollars/#
ARV		$237,676
Purchase Price		$237,676
Seller Concessions	—	$0
Down Payment	5.000%	$11,884
Closing Costs	1.000%	$2,377
Rent Ready Costs		$0
Cumulative Negative Cash Flow		$16,386
Total Invested		$30,647
Mortgage
Mortgage Amount		$225,792.20
Mortgage Interest Rate	6.500%
Loan Term		360
Private Mortgage Insurance	0.850%	$159.94
Drop PMI LTV	80.000%
Income
Monthly Rent		$1,790 $1790.25
Other Income		$0
Annual Expenses
Vacancy Rate	3.000%	$644
Property Taxes	1.000%	$2,377
Property Insurance	0.800%	$1,901
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%	$35,651
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	$244,806	$252,150	$259,715	$267,506	$275,532
Appreciation Rate	3.000%	3.000%	3.000%	3.000%	3.000%
Appreciation Dollar	$7,130	$7,344	$7,565	$7,791	$8,025
Monthly Income	1	2	3	4	5
Rent Appreciation Rate		3.000%	3.000%	3.000%	3.000%
Monthly Rent	$1,790	$1,844	$1,899	$1,956	$2,015
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,790	$1,844	$1,899	$1,956	$2,015
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,737	$1,789	$1,842	$1,898	$1,954
Annual Income	1	2	3	4	5
Annual Rent	$21,483	$22,127	$22,791	$23,475	$24,179
Annual Other Income	$0	$0	$0	$0	$0
Annual Gross Potential Income	$21,483	$22,127	$22,791	$23,475	$24,179
Annual Vacancy Dollar	$644	$664	$684	$704	$725
Annual Gross Operating Income	$20,839	$21,464	$22,108	$22,771	$23,454
Annual Expenses	1	2	3	4	5
Property Taxes Percent	1.000%	1.000%	1.000%	1.000%	1.000%
Property Taxes Dollar	$2,377	$2,448	$2,522	$2,597	$2,675
Insurance Percent	0.800%	0.800%	0.800%	0.800%	0.800%
Insurance Dollar	$1,901	$1,958	$2,017	$2,078	$2,140
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,084	$2,146	$2,211	$2,277	$2,345
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	$6,362	$6,553	$6,749	$6,952	$7,161
Net Operating Income	1	2	3	4	5
Net Operating Income (NOI)	$14,476	$14,911	$15,358	$15,819	$16,293
Mortgage	1	2	3	4	5
Total Annual P&I Payments	$17,126	$17,126	$17,126	$17,126	$17,126
Principal	$2,524	$2,693	$2,873	$3,066	$3,271
Interest	$14,602	$14,433	$14,253	$14,060	$13,855
Loan Balance at End of Year	$223,268	$220,576	$217,703	$214,637	$211,366
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,919	$1,919	$1,919	$1,919	$0
Equity	1	2	3	4	5
ARV - Loan Balance at End of Year	$21,538	$31,575	$42,012	$52,869	$64,165
Cash Flow	1	2	3	4	5
Annual Cash Flow	-$4,569	-$4,134	-$3,687	-$3,226	-$833
Monhtly Cash Flow	-$381	-$345	-$307	-$269	-$69
Cash on Cash Return on Investment	-0.149%	-0.135%	-0.120%	-0.105%	-0.027%
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