Inflation with rents
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNO
1
Inputs:Inflation3%
2
Purchase price
$100,000
3
Mortgage$80,000
4
Interest rate5%
<-- used to calculate principle and interest payments on 30 year loan
5
6
YearMonthly RentMonthly principle and interestMonthly taxes and insuranceMonthly repairs and cap exMonthly property managementMonthly cash flowYearValue of a dollar at end of year*Yearly cash flow with 1 month vacancyCash flow feels like**Mortgage balance at end of yearMortgage balance feels like**
7
1$1,000$430$158$100$100$2121$0.97$1,540$1,495$78,820$76,524
8
2$1,030$430$163$103$103$2312$0.94$1,741$1,641$77,579$73,126
9
3$1,061$430$168$106$106$2513$0.92$1,948$1,783$76,275$69,802
10
4$1,093$430$173$109$109$2714$0.89$2,161$1,920$74,904$66,551
11
5$1,126$430$178$113$113$2925$0.86$2,381$2,054$73,463$63,370
12
6$1,159$430$184$116$116$3146$0.84$2,607$2,183$71,948$60,256
13
7$1,194$430$189$119$119$3367$0.81$2,840$2,309$70,356$57,206
14
8$1,230$430$195$123$123$3598$0.79$3,080$2,432$68,682$54,218
15
9$1,267$430$201$127$127$3839$0.77$3,327$2,550$66,923$51,291
16
10$1,305$430$207$130$130$40710$0.74$3,582$2,665$65,074$48,421
17
11$1,344$430$213$134$134$43211$0.72$3,844$2,777$63,130$45,606
18
12$1,384$430$219$138$138$45812$0.70$4,114$2,886$61,086$42,845
19
13$1,426$430$226$143$143$48513$0.68$4,393$2,991$58,938$40,134
20
14$1,469$430$233$147$147$51214$0.66$4,679$3,093$56,680$37,472
21
15$1,513$430$239$151$151$54115$0.64$4,974$3,193$54,307$34,858
22
* $1 in year X is worth how much at the beginning of year 1
23
** Translate it to beginning of year 1 dollars for better intuitiveness
Loading...
Main menu