Origination Fee Calculator and Worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
To use this document, go to the File menu and "Make a copy" for your own use (do not request access)
*IMPORTANT: These numbers and formulas might not be accurate or appropriate for your situation
2
Or click here for your own copy
You MUST verify all details, calculations, and projections with your financial institution before making any decisions.
3
Consult your tax advisor, financial advisor, and legal counsel before taking any action
4
Enter your loan details in the green boxes
5
Loan AInterest Rate
Term in Years
Monthly Payment
Extra Monthly
Loan B
Origination Fee (deducted)
Interest Rate
Term in Years
Monthly Payment
Extra Monthly
Payment Difference
Breakeven Period
6
$8,000.0010.00%7$132.810$8,000.001608.00%7$124.690-$8.1219.71Months
7
8
Month
StartingBalance
You PaidInterestPrincipal
EndingBalance
TotalInterestMonth
StartingBalance
You PaidInterestPrincipal
EndingBalance
TotalInterest
Interest + Fee
9
1$8,000.00$132.81$66.67$66.14$7,933.86$66.671$8,000.00$124.69$53.33$71.36$7,928.64$53.33$213.33
10
2$7,933.86$132.81$66.12$66.69$7,867.16$132.782$7,928.64$124.69$52.86$71.83$7,856.81$106.19$266.19
11
3$7,867.16$132.81$65.56$67.25$7,799.91$198.343$7,856.81$124.69$52.38$72.31$7,784.50$158.57$318.57
12
4$7,799.91$132.81$65.00$67.81$7,732.10$263.344$7,784.50$124.69$51.90$72.79$7,711.71$210.47$370.47
13
5$7,732.10$132.81$64.43$68.38$7,663.73$327.785$7,711.71$124.69$51.41$73.28$7,638.43$261.88$421.88
14
6$7,663.73$132.81$63.86$68.95$7,594.78$391.646$7,638.43$124.69$50.92$73.77$7,564.66$312.80$472.80
15
7$7,594.78$132.81$63.29$69.52$7,525.26$454.937$7,564.66$124.69$50.43$74.26$7,490.40$363.23$523.23
16
8$7,525.26$132.81$62.71$70.10$7,455.16$517.648$7,490.40$124.69$49.94$74.75$7,415.65$413.17$573.17
17
9$7,455.16$132.81$62.13$70.68$7,384.48$579.779$7,415.65$124.69$49.44$75.25$7,340.40$462.61$622.61
18
10$7,384.48$132.81$61.54$71.27$7,313.21$641.3010$7,340.40$124.69$48.94$75.75$7,264.64$511.54$671.54
19
11$7,313.21$132.81$60.94$71.87$7,241.34$702.2511$7,264.64$124.69$48.43$76.26$7,188.39$559.97$719.97
20
12$7,241.34$132.81$60.34$72.46$7,168.88$762.5912$7,188.39$124.69$47.92$76.77$7,111.62$607.89$767.89
21
13$7,168.88$132.81$59.74$73.07$7,095.81$822.3313$7,111.62$124.69$47.41$77.28$7,034.34$655.31$815.31
22
14$7,095.81$132.81$59.13$73.68$7,022.13$881.4614$7,034.34$124.69$46.90$77.79$6,956.55$702.20$862.20
23
15$7,022.13$132.81$58.52$74.29$6,947.84$939.9815$6,956.55$124.69$46.38$78.31$6,878.23$748.58$908.58
24
16$6,947.84$132.81$57.90$74.91$6,872.93$997.8816$6,878.23$124.69$45.85$78.83$6,799.40$794.43$954.43
25
17$6,872.93$132.81$57.27$75.54$6,797.39$1,055.1517$6,799.40$124.69$45.33$79.36$6,720.04$839.76$999.76
26
18$6,797.39$132.81$56.64$76.16$6,721.23$1,111.8018$6,720.04$124.69$44.80$79.89$6,640.15$884.56$1,044.56
27
19$6,721.23$132.81$56.01$76.80$6,644.43$1,167.8119$6,640.15$124.69$44.27$80.42$6,559.73$928.83$1,088.83
28
20$6,644.43$132.81$55.37$77.44$6,566.99$1,223.1820$6,559.73$124.69$43.73$80.96$6,478.77$972.56$1,132.56
29
21$6,566.99$132.81$54.72$78.08$6,488.91$1,277.9121$6,478.77$124.69$43.19$81.50$6,397.27$1,015.75$1,175.75
30
22$6,488.91$132.81$54.07$78.74$6,410.17$1,331.9822$6,397.27$124.69$42.65$82.04$6,315.23$1,058.40$1,218.40
31
23$6,410.17$132.81$53.42$79.39$6,330.78$1,385.4023$6,315.23$124.69$42.10$82.59$6,232.64$1,100.50$1,260.50
32
24$6,330.78$132.81$52.76$80.05$6,250.73$1,438.1524$6,232.64$124.69$41.55$83.14$6,149.50$1,142.05$1,302.05
33
25$6,250.73$132.81$52.09$80.72$6,170.01$1,490.2425$6,149.50$124.69$41.00$83.69$6,065.81$1,183.05$1,343.05
34
26$6,170.01$132.81$51.42$81.39$6,088.61$1,541.6626$6,065.81$124.69$40.44$84.25$5,981.56$1,223.49$1,383.49
35
27$6,088.61$132.81$50.74$82.07$6,006.54$1,592.4027$5,981.56$124.69$39.88$84.81$5,896.74$1,263.37$1,423.37
36
28$6,006.54$132.81$50.05$82.75$5,923.79$1,642.4528$5,896.74$124.69$39.31$85.38$5,811.37$1,302.68$1,462.68
37
29$5,923.79$132.81$49.36$83.44$5,840.34$1,691.8229$5,811.37$124.69$38.74$85.95$5,725.42$1,341.42$1,501.42
38
30$5,840.34$132.81$48.67$84.14$5,756.20$1,740.4930$5,725.42$124.69$38.17$86.52$5,638.90$1,379.59$1,539.59
39
31$5,756.20$132.81$47.97$84.84$5,671.36$1,788.4631$5,638.90$124.69$37.59$87.10$5,551.80$1,417.18$1,577.18
40
32$5,671.36$132.81$47.26$85.55$5,585.81$1,835.7232$5,551.80$124.69$37.01$87.68$5,464.12$1,454.20$1,614.20
41
33$5,585.81$132.81$46.55$86.26$5,499.55$1,882.2733$5,464.12$124.69$36.43$88.26$5,375.86$1,490.62$1,650.62
42
34$5,499.55$132.81$45.83$86.98$5,412.57$1,928.1034$5,375.86$124.69$35.84$88.85$5,287.01$1,526.46$1,686.46
43
35$5,412.57$132.81$45.10$87.70$5,324.87$1,973.2035$5,287.01$124.69$35.25$89.44$5,197.57$1,561.71$1,721.71
44
36$5,324.87$132.81$44.37$88.44$5,236.43$2,017.5736$5,197.57$124.69$34.65$90.04$5,107.53$1,596.36$1,756.36
45
37$5,236.43$132.81$43.64$89.17$5,147.26$2,061.2137$5,107.53$124.69$34.05$90.64$5,016.89$1,630.41$1,790.41
46
38$5,147.26$132.81$42.89$89.92$5,057.34$2,104.1038$5,016.89$124.69$33.45$91.24$4,925.65$1,663.86$1,823.86
47
39$5,057.34$132.81$42.14$90.66$4,966.68$2,146.2539$4,925.65$124.69$32.84$91.85$4,833.79$1,696.69$1,856.69
48
40$4,966.68$132.81$41.39$91.42$4,875.26$2,187.6440$4,833.79$124.69$32.23$92.46$4,741.33$1,728.92$1,888.92
49
41$4,875.26$132.81$40.63$92.18$4,783.08$2,228.2741$4,741.33$124.69$31.61$93.08$4,648.25$1,760.53$1,920.53
50
42$4,783.08$132.81$39.86$92.95$4,690.13$2,268.1242$4,648.25$124.69$30.99$93.70$4,554.55$1,791.52$1,951.52
51
43$4,690.13$132.81$39.08$93.73$4,596.40$2,307.2143$4,554.55$124.69$30.36$94.33$4,460.22$1,821.88$1,981.88
52
44$4,596.40$132.81$38.30$94.51$4,501.90$2,345.5144$4,460.22$124.69$29.73$94.95$4,365.27$1,851.61$2,011.61
53
45$4,501.90$132.81$37.52$95.29$4,406.60$2,383.0345$4,365.27$124.69$29.10$95.59$4,269.68$1,880.72$2,040.72
54
46$4,406.60$132.81$36.72$96.09$4,310.51$2,419.7546$4,269.68$124.69$28.46$96.23$4,173.45$1,909.18$2,069.18
55
47$4,310.51$132.81$35.92$96.89$4,213.63$2,455.6747$4,173.45$124.69$27.82$96.87$4,076.59$1,937.00$2,097.00
56
48$4,213.63$132.81$35.11$97.70$4,115.93$2,490.7848$4,076.59$124.69$27.18$97.51$3,979.07$1,964.18$2,124.18
57
49$4,115.93$132.81$34.30$98.51$4,017.42$2,525.0849$3,979.07$124.69$26.53$98.16$3,880.91$1,990.71$2,150.71
58
50$4,017.42$132.81$33.48$99.33$3,918.09$2,558.5650$3,880.91$124.69$25.87$98.82$3,782.09$2,016.58$2,176.58
59
51$3,918.09$132.81$32.65$100.16$3,817.93$2,591.2151$3,782.09$124.69$25.21$99.48$3,682.62$2,041.79$2,201.79
60
52$3,817.93$132.81$31.82$100.99$3,716.94$2,623.0352$3,682.62$124.69$24.55$100.14$3,582.48$2,066.34$2,226.34
61
53$3,716.94$132.81$30.97$101.84$3,615.10$2,654.0053$3,582.48$124.69$23.88$100.81$3,481.67$2,090.23$2,250.23
62
54$3,615.10$132.81$30.13$102.68$3,512.42$2,684.1354$3,481.67$124.69$23.21$101.48$3,380.19$2,113.44$2,273.44
63
55$3,512.42$132.81$29.27$103.54$3,408.88$2,713.4055$3,380.19$124.69$22.53$102.16$3,278.04$2,135.97$2,295.97
64
56$3,408.88$132.81$28.41$104.40$3,304.48$2,741.8156$3,278.04$124.69$21.85$102.84$3,175.20$2,157.83$2,317.83
65
57$3,304.48$132.81$27.54$105.27$3,199.20$2,769.3457$3,175.20$124.69$21.17$103.52$3,071.68$2,179.00$2,339.00
66
58$3,199.20$132.81$26.66$106.15$3,093.05$2,796.0058$3,071.68$124.69$20.48$104.21$2,967.47$2,199.47$2,359.47
67
59$3,093.05$132.81$25.78$107.03$2,986.02$2,821.7859$2,967.47$124.69$19.78$104.91$2,862.56$2,219.26$2,379.26
68
60$2,986.02$132.81$24.88$107.93$2,878.09$2,846.6660$2,862.56$124.69$19.08$105.61$2,756.96$2,238.34$2,398.34
69
61$2,878.09$132.81$23.98$108.83$2,769.27$2,870.6561$2,756.96$124.69$18.38$106.31$2,650.65$2,256.72$2,416.72
70
62$2,769.27$132.81$23.08$109.73$2,659.54$2,893.7262$2,650.65$124.69$17.67$107.02$2,543.63$2,274.39$2,434.39
71
63$2,659.54$132.81$22.16$110.65$2,548.89$2,915.8963$2,543.63$124.69$16.96$107.73$2,435.90$2,291.35$2,451.35
72
64$2,548.89$132.81$21.24$111.57$2,437.32$2,937.1364$2,435.90$124.69$16.24$108.45$2,327.45$2,307.59$2,467.59
73
65$2,437.32$132.81$20.31$112.50$2,324.82$2,957.4465$2,327.45$124.69$15.52$109.17$2,218.27$2,323.10$2,483.10
74
66$2,324.82$132.81$19.37$113.44$2,211.39$2,976.8166$2,218.27$124.69$14.79$109.90$2,108.37$2,337.89$2,497.89
75
67$2,211.39$132.81$18.43$114.38$2,097.01$2,995.2467$2,108.37$124.69$14.06$110.63$1,997.74$2,351.95$2,511.95
76
68$2,097.01$132.81$17.48$115.33$1,981.67$3,012.7268$1,997.74$124.69$13.32$111.37$1,886.37$2,365.27$2,525.27
77
69$1,981.67$132.81$16.51$116.30$1,865.38$3,029.2369$1,886.37$124.69$12.58$112.11$1,774.25$2,377.84$2,537.84
78
70$1,865.38$132.81$15.54$117.26$1,748.11$3,044.7770$1,774.25$124.69$11.83$112.86$1,661.39$2,389.67$2,549.67
79
71$1,748.11$132.81$14.57$118.24$1,629.87$3,059.3471$1,661.39$124.69$11.08$113.61$1,547.78$2,400.75$2,560.75
80
72$1,629.87$132.81$13.58$119.23$1,510.64$3,072.9272$1,547.78$124.69$10.32$114.37$1,433.41$2,411.07$2,571.07
81
73$1,510.64$132.81$12.59$120.22$1,390.42$3,085.5173$1,433.41$124.69$9.56$115.13$1,318.27$2,420.62$2,580.62
82
74$1,390.42$132.81$11.59$121.22$1,269.20$3,097.1074$1,318.27$124.69$8.79$115.90$1,202.37$2,429.41$2,589.41
83
75$1,269.20$132.81$10.58$122.23$1,146.97$3,107.6875$1,202.37$124.69$8.02$116.67$1,085.70$2,437.43$2,597.43
84
76$1,146.97$132.81$9.56$123.25$1,023.71$3,117.2376$1,085.70$124.69$7.24$117.45$968.25$2,444.66$2,604.66
85
77$1,023.71$132.81$8.53$124.28$899.44$3,125.7777$968.25$124.69$6.45$118.23$850.01$2,451.12$2,611.12
86
78$899.44$132.81$7.50$125.31$774.12$3,133.2678$850.01$124.69$5.67$119.02$730.99$2,456.79$2,616.79
87
79$774.12$132.81$6.45$126.36$647.76$3,139.7179$730.99$124.69$4.87$119.82$611.17$2,461.66$2,621.66
88
80$647.76$132.81$5.40$127.41$520.35$3,145.1180$611.17$124.69$4.07$120.62$490.56$2,465.73$2,625.73
89
81$520.35$132.81$4.34$128.47$391.88$3,149.4581$490.56$124.69$3.27$121.42$369.14$2,469.00$2,629.00
90
82$391.88$132.81$3.27$129.54$262.34$3,152.7182$369.14$124.69$2.46$122.23$246.91$2,471.46$2,631.46
91
83$262.34$132.81$2.19$130.62$131.71$3,154.9083$246.91$124.69$1.65$123.04$123.86$2,473.11$2,633.11
92
84$131.71$132.81$1.10$131.71$0.00$3,156.0084$123.86$124.69$0.83$123.86$0.00$2,473.94$2,633.94
93
85$0.00$0.00$0.00$0.00$0.00$3,156.0085$0.00$0.00$0.00$0.00$0.00$2,473.94$2,633.94
94
86$0.00$0.00$0.00$0.00$0.00$3,156.0086$0.00$0.00$0.00$0.00$0.00$2,473.94$2,633.94
95
87$0.00$0.00$0.00$0.00$0.00$3,156.0087$0.00$0.00$0.00$0.00$0.00$2,473.94$2,633.94
96
88$0.00$0.00$0.00$0.00$0.00$3,156.0088$0.00$0.00$0.00$0.00$0.00$2,473.94$2,633.94
97
89$0.00$0.00$0.00$0.00$0.00$3,156.0089$0.00$0.00$0.00$0.00$0.00$2,473.94$2,633.94
98
90$0.00$0.00$0.00$0.00$0.00$3,156.0090$0.00$0.00$0.00$0.00$0.00$2,473.94$2,633.94
99
91$0.00$0.00$0.00$0.00$0.00$3,156.0091$0.00$0.00$0.00$0.00$0.00$2,473.94$2,633.94
100
92$0.00$0.00$0.00$0.00$0.00$3,156.0092$0.00$0.00$0.00$0.00$0.00$2,473.94$2,633.94
Loading...