Financial Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This Spreadsheet Provided by Jed Wunderli - Noble Home Loans
2
3
4
Penny Doubled
Time Value of Money / Rule of 72Break-even Point - Lower rate or lower fees?
5
1 $ 0.01 Investment Amount: $ 100,000.00 Loan Amount: $ 240,000.00
6
2 $ 0.02 Rate of Return (ROR):8%Loan Term:360
7
3 $ 0.04 Value after (yrs):9 $ 204,953.02 Interest Rate:4.250%4.500%4.750%
8
4 $ 0.08 Value after (yrs):18 $ 420,057.42 P & I Payment: $ 1,180.66 $ 1,216.04 $ 1,251.95
9
5 $ 0.16 Value after (yrs):27 $ 860,920.38 Payment Savings: $ 71.30 $ 35.91 N/A
10
6 $ 0.32 Value after (yrs):36 $ 1,764,482.35 Cost: $ 5,700.00 $ 2,400.00 N/A
11
7 $ 0.64 Value after (yrs):45 $ 3,616,359.93 Break-even Point (Yrs):6.6621907015.569655444
12
8 $ 1.28
13
9 $ 2.56 Value after (yrs):30 $ 1,093,572.97 Money in your house vs. money in investment
14
10 $ 5.12 Opportunity Cost vs. D.P: $ 393,875.13 Purchase Price: $ 300,000.00
15
11 $ 10.24 Interest Rate:4.750%
16
12 $ 20.48 Down Payment - %:50%20%
17
13 $ 40.96
Down Payment - $:
$ 150,000.00 $ 60,000.00
18
14 $ 81.92
Loan Amount:
$ 150,000.00 $ 240,000.00
19
15 $ 163.84 P & I Payment: $ 782.47 $ 1,251.95
20
16 $ 327.68 Mortgage Insurance: $ - $ -
21
17 $ 655.36 Total Payment: $ 782.47 $ 1,251.95
22
18 $ 1,310.72 Payment Savings*: $ 469.48 N/A
23
19 $ 2,621.44 Value of Payment Savings after 30 Years: $ 699,697.83
24
20 $ 5,242.88
25
21 $ 10,485.76 30-year vs. 15-year Mortgage
26
22 $ 20,971.52 Loan Term:360180
27
23 $ 41,943.04 Interest Rate:4.250%3.500%
28
24 $ 83,886.08 P & I Payment $ 1,180.66 $ 1,715.72
29
25 $ 167,772.16 Payment Savings: $ 535.06
30
26 $ 335,544.32 Value of Savings after 15 Years: $ 185,152.03
31
27 $ 671,088.64 Value of Savings after 30 Years: $ 797,435.24
32
28 $ 1,342,177.28 Value of 15-year mtg. at 30 yrs: $ 593,704.04
33
29 $ 2,684,354.56 Net Benefit of This Option: $ 203,731.20 N/A
34
30 $ 5,368,709.12
35
31 $ 10,737,418.24
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu