ABCDEFGHIJKLMNOPQR
1
Summary
(real, inflation-adjusted dollars)
CashflowAssumptionsSource
2
YearTotalYear12345678910
3
Hard Costs$80,080Hard Costs$32,128$5,328$5,328$5,328$5,328$5,328$5,328$5,328$5,328$5,32810% furnishing costs
4
Intangible Costs$0Intangible Costs$80 per square foot
5
Total Costs$80,080Total Costs$32,128$5,328$5,328$5,328$5,328$5,328$5,328$5,328$5,328$5,3283.5% closing costs
6
Hard Revenue$116,160Hard Revenue$47,796$7,596$7,596$7,596$7,596$7,596$7,596$7,596$7,596$7,5961000 sq ft house in low case, 1500 in high case
7
Intangible Revenue$0Intangible Revenue444 monthly costs (incl. tax) in low case 633 in high case
8
Total Revenue$116,160Total Revenue$47,796$7,596$7,596$7,596$7,596$7,596$7,596$7,596$7,596$7,59630 year mortgage
9
Hard Value$36,080Hard Value$15,668$2,268$2,268$2,268$2,268$2,268$2,268$2,268$2,268$2,26820% deposit
10
Hard Value w/Growth$48,154Intangible Value$0$0$0$0$0$0$0$0$0$0
11
Intangible Value$0Cumulative Hard Value$15,668$17,936$20,204$22,472$24,740$27,008$29,276$31,544$33,812$36,0804% real growth on savings
12
Present Value$36,080Cumulative Intangible Value$0$0$0$0$0$0$0$0$0$0
13
Cumulative Hard Value With Growth$16,295$19,305$22,436$25,692$29,079$32,601$36,263$40,073$44,034$48,154
14
Present Value w/ Growth$48,154Cumulative Total Value With Growth$16,295$19,305$22,436$25,692$29,079$32,601$36,263$40,073$44,034$48,154
15
Cumulative ROI60%Cumulative Costs$32,128$37,456$42,784$48,112$53,440$58,768$64,096$69,424$74,752$80,080
16
Payback Year(s)0.7Cumulative Revenue$47,796$55,392$62,988$70,584$78,180$85,776$93,372$100,968$108,564$116,160
17
Annual Safe Withdrawal$1,926Cumulative Value With Growth$16,295$19,305$22,436$25,692$29,079$32,601$36,263$40,073$44,034$48,154
18
Cumulative ROI51%52%52%53%54%55%57%58%59%60%
19
Payback Year(s)0.70.00.00.00.00.00.00.00.00.0
20
21
1.72
22
23
24
25
26
27
28
About an average savings of $100 per square foot
29
30
31
32
33
34
CHART INFO
35
Year12345678910
36
Annual Cost$32,128$5,328$5,328$5,328$5,328$5,328$5,328$5,328$5,328$5,328
37
Annual Rev.$47,796$7,596$7,596$7,596$7,596$7,596$7,596$7,596$7,596$7,596
38
Total Value w/Growth$16,295$19,305$22,436$25,692$29,079$32,601$36,263$40,073$44,034$48,154
39
40
41
42
43
44
45