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

View only
 
 
ABCDEFGHIJKLMN
1
2
Loan$100,000.00 Muni tax0.97%Opp cost incr4.00%Bank loan fee$1,000
3
Rate3.750%Income tax25.00%Rent alternate$1,500 Club equity$0
4
Monthly factor
0.313%House val incr1.50%Rent incr2.00%Monthly HOA$100
5
Payment/mth
$463.11
Vendor comm%
5.00%
Lawyer close fee
$1,500.00
Bal @ 360 mos.
$4
6
7
Year
Month#
DatePaymentInterestPrincipalBalanceTaxMonthly costHouse valueRent costOpp costSale profit
8
11Sep-19$463.11 $312.50 $150.61 $99,849.39 $80.93 $3,065.92 $100,125.00 $1,500.00 $1,565.92 ($5,905.08)
9
12Oct-19$463.11 $312.03 $151.08 $99,698.31 $81.04 $566.14 $100,250.16 $1,502.50 $634.78 ($4,936.74)
10
13Nov-19$463.11 $311.56 $151.55 $99,546.76 $81.14 $566.36 $100,375.47 $1,505.00 ($301.75)($3,963.75)
11
14Dec-19$463.11 $311.08 $152.03 $99,394.73 $81.24 $566.58 $100,500.94 $1,507.51 ($1,243.69)($2,986.07)
12
15Jan-20$463.11 $310.61 $152.50 $99,242.23 $81.34 $566.80 $100,626.56 $1,510.03 ($2,191.07)($2,003.69)
13
16Feb-20$463.11 $310.13 $152.98 $99,089.25 $81.44 $567.02 $100,752.35 $1,512.54 ($3,143.89)($1,016.60)
14
17Mar-20$463.11 $309.65 $153.46 $98,935.79 $81.54 $567.24 $100,878.29 $1,515.06 ($4,102.20)($24.77)
15
18Apr-20$463.11 $309.17 $153.94 $98,781.86 $81.65 $567.46 $101,004.39 $1,517.59 ($5,066.00)$971.81
16
19May-20$463.11 $308.69 $154.42 $98,627.44 $81.75 $567.68 $101,130.64 $1,520.12 ($6,035.32)$1,973.15
17
110Jun-20$463.11 $308.21 $154.90 $98,472.54 $81.85 $567.91 $101,257.05 $1,522.65 ($7,010.18)$2,979.29
18
111Jul-20$463.11 $307.73 $155.38 $98,317.16 $81.95 $568.13 $101,383.63 $1,525.19 ($7,990.60)$3,990.24
19
112Aug-20$463.11 $307.24 $155.87 $98,161.29 $82.05 $568.35 $101,510.36 $1,527.73 ($8,976.62)$5,006.01
20
213Sep-20$463.11 $306.75 $156.36 $98,004.93 $82.16 $568.58 $101,637.24 $1,530.28 ($9,968.24)$6,026.62
21
214Oct-20$463.11 $306.27 $156.84 $97,848.09 $82.26 $568.80 $101,764.29 $1,532.83 ($10,965.49)$7,052.10
22
215Nov-20$463.11 $305.78 $157.33 $97,690.76 $82.36 $569.03 $101,891.50 $1,535.38 ($11,968.39)$8,082.46
23
216Dec-20$463.11 $305.28 $157.83 $97,532.93 $82.47 $569.25 $102,018.86 $1,537.94 ($12,976.97)$9,117.72
24
217Jan-21$463.11 $304.79 $158.32 $97,374.61 $82.57 $569.48 $102,146.38 $1,540.50 ($13,991.25)$10,157.89
25
218Feb-21$463.11 $304.30 $158.81 $97,215.80 $82.67 $569.71 $102,274.07 $1,543.07 ($15,011.25)$11,203.01
26
219Mar-21$463.11 $303.80 $159.31 $97,056.48 $82.77 $569.94 $102,401.91 $1,545.64 ($16,037.00)$12,253.08
27
220Apr-21$463.11 $303.30 $159.81 $96,896.68 $82.88 $570.16 $102,529.91 $1,548.22 ($17,068.51)$13,308.12
28
221May-21$463.11 $302.80 $160.31 $96,736.37 $82.98 $570.39 $102,658.07 $1,550.80 ($18,105.82)$14,368.16
29
222Jun-21$463.11 $302.30 $160.81 $96,575.56 $83.09 $570.62 $102,786.40 $1,553.38 ($19,148.93)$15,433.22
30
223Jul-21$463.11 $301.80 $161.31 $96,414.25 $83.19 $570.85 $102,914.88 $1,555.97 ($20,197.89)$16,503.30
31
224Aug-21$463.11 $301.29 $161.82 $96,252.43 $83.29 $571.08 $103,043.52 $1,558.57 ($21,252.70)$17,578.44
32
325Sep-21$463.11 $300.79 $162.32 $96,090.11 $83.40 $571.31 $103,172.33 $1,561.16 ($22,313.39)$18,658.65
33
326Oct-21$463.11 $300.28 $162.83 $95,927.28 $83.50 $571.54 $103,301.29 $1,563.77 ($23,380.00)$19,743.94
34
327Nov-21$463.11 $299.77 $163.34 $95,763.95 $83.61 $571.77 $103,430.42 $1,566.37 ($24,452.53)$20,834.35
35
328Dec-21$463.11 $299.26 $163.85 $95,600.10 $83.71 $572.01 $103,559.71 $1,568.98 ($25,531.02)$21,929.89
36
329Jan-22$463.11 $298.75 $164.36 $95,435.74 $83.82 $572.24 $103,689.16 $1,571.60 ($26,615.48)$23,030.57
37
330Feb-22$463.11 $298.24 $164.87 $95,270.87 $83.92 $572.47 $103,818.77 $1,574.22 ($27,705.94)$24,136.42
38
331Mar-22$463.11 $297.72 $165.39 $95,105.48 $84.03 $572.70 $103,948.54 $1,576.84 ($28,802.43)$25,247.46
39
332Apr-22$463.11 $297.20 $165.91 $94,939.57 $84.13 $572.94 $104,078.48 $1,579.47 ($29,904.97)$26,363.71
40
333May-22$463.11 $296.69 $166.42 $94,773.15 $84.24 $573.17 $104,208.58 $1,582.10 ($31,013.58)$27,485.19
41
334Jun-22$463.11 $296.17 $166.94 $94,606.20 $84.34 $573.41 $104,338.84 $1,584.74 ($32,128.29)$28,611.91
42
335Jul-22$463.11 $295.64 $167.47 $94,438.74 $84.45 $573.64 $104,469.26 $1,587.38 ($33,249.12)$29,743.90
43
336Aug-22$463.11 $295.12 $167.99 $94,270.75 $84.55 $573.88 $104,599.85 $1,590.03 ($34,376.09)$30,881.18
44
437Sep-22$463.11 $294.60 $168.51 $94,102.23 $84.66 $574.12 $104,730.60 $1,592.68 ($35,509.24)$32,023.76
45
438Oct-22$463.11 $294.07 $169.04 $93,933.19 $84.76 $574.36 $104,861.51 $1,595.33 ($36,648.58)$33,171.67
46
439Nov-22$463.11 $293.54 $169.57 $93,763.63 $84.87 $574.59 $104,992.59 $1,597.99 ($37,794.13)$34,324.93
47
440Dec-22$463.11 $293.01 $170.10 $93,593.53 $84.98 $574.83 $105,123.83 $1,600.65 ($38,945.93)$35,483.56
48
441Jan-23$463.11 $292.48 $170.63 $93,422.90 $85.08 $575.07 $105,255.23 $1,603.32 ($40,104.00)$36,647.57
49
442Feb-23$463.11 $291.95 $171.16 $93,251.73 $85.19 $575.31 $105,386.80 $1,605.99 ($41,268.36)$37,817.00
50
443Mar-23$463.11 $291.41 $171.70 $93,080.03 $85.29 $575.55 $105,518.53 $1,608.67 ($42,439.04)$38,991.85
51
444Apr-23$463.11 $290.88 $172.23 $92,907.80 $85.40 $575.79 $105,650.43 $1,611.35 ($43,616.06)$40,172.16
52
445May-23$463.11 $290.34 $172.77 $92,735.03 $85.51 $576.03 $105,782.50 $1,614.04 ($44,799.45)$41,357.93
53
446Jun-23$463.11 $289.80 $173.31 $92,561.71 $85.61 $576.28 $105,914.72 $1,616.73 ($45,989.23)$42,549.20
54
447Jul-23$463.11 $289.26 $173.85 $92,387.86 $85.72 $576.52 $106,047.12 $1,619.42 ($47,185.43)$43,745.98
55
448Aug-23$463.11 $288.71 $174.40 $92,213.46 $85.83 $576.76 $106,179.68 $1,622.12 ($48,388.08)$44,948.29
56
549Sep-23$463.11 $288.17 $174.94 $92,038.52 $85.94 $577.00 $106,312.40 $1,624.82 ($49,597.19)$46,156.15
57
550Oct-23$463.11 $287.62 $175.49 $91,863.03 $86.04 $577.25 $106,445.29 $1,627.53 ($50,812.79)$47,369.59
58
551Nov-23$463.11 $287.07 $176.04 $91,686.99 $86.15 $577.49 $106,578.35 $1,630.24 ($52,034.92)$48,588.63
59
552Dec-23$463.11 $286.52 $176.59 $91,510.40 $86.26 $577.74 $106,711.57 $1,632.96 ($53,263.59)$49,813.28
60
553Jan-24$463.11 $285.97 $177.14 $91,333.26 $86.37 $577.98 $106,844.96 $1,635.68 ($54,498.83)$51,043.58
61
554Feb-24$463.11 $285.42 $177.69 $91,155.57 $86.47 $578.23 $106,978.52 $1,638.41 ($55,740.67)$52,279.53
62
555Mar-24$463.11 $284.86 $178.25 $90,977.32 $86.58 $578.48 $107,112.24 $1,641.14 ($56,989.14)$53,521.16
63
556Apr-24$463.11 $284.30 $178.81 $90,798.51 $86.69 $578.72 $107,246.13 $1,643.87 ($58,244.25)$54,768.50
64
557May-24$463.11 $283.75 $179.36 $90,619.15 $86.80 $578.97 $107,380.19 $1,646.61 ($59,506.04)$56,021.56
65
558Jun-24$463.11 $283.18 $179.93 $90,439.22 $86.91 $579.22 $107,514.41 $1,649.36 ($60,774.53)$57,280.37
66
559Jul-24$463.11 $282.62 $180.49 $90,258.74 $87.02 $579.47 $107,648.81 $1,652.11 ($62,049.75)$58,544.94
67
560Aug-24$463.11 $282.06 $181.05 $90,077.69 $87.12 $579.72 $107,783.37 $1,654.86 ($63,331.72)$59,815.30
68
661Sep-24$463.11 $281.49 $181.62 $89,896.07 $87.23 $579.97 $107,918.10 $1,657.62 ($64,620.47)$61,091.48
69
662Oct-24$463.11 $280.93 $182.18 $89,713.88 $87.34 $580.22 $108,052.99 $1,660.38 ($65,916.04)$62,373.49
70
663Nov-24$463.11 $280.36 $182.75 $89,531.13 $87.45 $580.47 $108,188.06 $1,663.15 ($67,218.43)$63,661.35
71
664Dec-24$463.11 $279.78 $183.33 $89,347.80 $87.56 $580.73 $108,323.29 $1,665.92 ($68,527.69)$64,955.09
72
665Jan-25$463.11 $279.21 $183.90 $89,163.91 $87.67 $580.98 $108,458.70 $1,668.70 ($69,843.83)$66,254.73
73
666Feb-25$463.11 $278.64 $184.47 $88,979.43 $87.78 $581.23 $108,594.27 $1,671.48 ($71,166.89)$67,560.29
74
667Mar-25$463.11 $278.06 $185.05 $88,794.38 $87.89 $581.48 $108,730.02 $1,674.26 ($72,496.89)$68,871.80
75
668Apr-25$463.11 $277.48 $185.63 $88,608.76 $88.00 $581.74 $108,865.93 $1,677.05 ($73,833.86)$70,189.27
76
669May-25$463.11 $276.90 $186.21 $88,422.55 $88.11 $581.99 $109,002.01 $1,679.85 ($75,177.83)$71,512.74
77
670Jun-25$463.11 $276.32 $186.79 $88,235.76 $88.22 $582.25 $109,138.26 $1,682.65 ($76,528.82)$72,842.21
78
671Jul-25$463.11 $275.74 $187.37 $88,048.39 $88.33 $582.51 $109,274.69 $1,685.45 ($77,886.87)$74,177.72
79
672Aug-25$463.11 $275.15 $187.96 $87,860.43 $88.44 $582.76 $109,411.28 $1,688.26 ($79,251.99)$75,519.28
80
773Sep-25$463.11 $274.56 $188.55 $87,671.88 $88.55 $583.02 $109,548.04 $1,691.08 ($80,624.22)$76,866.92
81
774Oct-25$463.11 $273.97 $189.14 $87,482.75 $88.66 $583.28 $109,684.98 $1,693.89 ($82,003.58)$78,220.67
82
775Nov-25$463.11 $273.38 $189.73 $87,293.02 $88.77 $583.54 $109,822.08 $1,696.72 ($83,390.11)$79,580.54
83
776Dec-25$463.11 $272.79 $190.32 $87,102.70 $88.88 $583.80 $109,959.36 $1,699.55 ($84,783.83)$80,946.56
84
777Jan-26$463.11 $272.20 $190.91 $86,911.79 $88.99 $584.06 $110,096.81 $1,702.38 ($86,184.76)$82,318.76
85
778Feb-26$463.11 $271.60 $191.51 $86,720.28 $89.11 $584.32 $110,234.43 $1,705.22 ($87,592.94)$83,697.14
86
779Mar-26$463.11 $271.00 $192.11 $86,528.17 $89.22 $584.58 $110,372.23 $1,708.06 ($89,008.40)$85,081.75
87
780Apr-26$463.11 $270.40 $192.71 $86,335.46 $89.33 $584.84 $110,510.19 $1,710.90 ($90,431.16)$86,472.59
88
781May-26$463.11 $269.80 $193.31 $86,142.14 $89.44 $585.10 $110,648.33 $1,713.76 ($91,861.25)$87,869.71
89
782Jun-26$463.11 $269.19 $193.92 $85,948.23 $89.55 $585.36 $110,786.64 $1,716.61 ($93,298.70)$89,273.11
90
783Jul-26$463.11 $268.59 $194.52 $85,753.71 $89.66 $585.63 $110,925.12 $1,719.47 ($94,743.55)$90,682.82
91
784Aug-26$463.11 $267.98 $195.13 $85,558.58 $89.78 $585.89 $111,063.78 $1,722.34 ($96,195.81)$92,098.87
92
885Sep-26$463.11 $267.37 $195.74 $85,362.84 $89.89 $586.16 $111,202.61 $1,725.21 ($97,655.51)$93,521.27
93
886Oct-26$463.11 $266.76 $196.35 $85,166.49 $90.00 $586.42 $111,341.61 $1,728.08 ($99,122.69)$94,950.06
94
887Nov-26$463.11 $266.15 $196.96 $84,969.52 $90.11 $586.69 $111,480.79 $1,730.97 ($100,597.38)$96,385.26
95
888Dec-26$463.11 $265.53 $197.58 $84,771.94 $90.23 $586.95 $111,620.14 $1,733.85 ($102,079.60)$97,826.89
96
889Jan-27$463.11 $264.91 $198.20 $84,573.74 $90.34 $587.22 $111,759.66 $1,736.74 ($103,569.39)$99,274.98
97
890Feb-27$463.11 $264.29 $198.82 $84,374.93 $90.45 $587.49 $111,899.36 $1,739.63 ($105,066.76)$100,729.54
98
891Mar-27$463.11 $263.67 $199.44 $84,175.49 $90.57 $587.76 $112,039.24 $1,742.53 ($106,571.76)$102,190.61
99
892Apr-27$463.11 $263.05 $200.06 $83,975.43 $90.68 $588.03 $112,179.29 $1,745.44 ($108,084.41)$103,658.21
100
893May-27$463.11 $262.42 $200.69 $83,774.74 $90.79 $588.30 $112,319.51 $1,748.35 ($109,604.75)$105,132.35
Loading...