Question

Suppose you are offered a bullet loan. The payments are made monthly and they are calculated using a 30-year traditional mortgage. So, you have 5-year bullet. In this situation, you will make the payments for the 30-year traditional mortgage in the first 5 years, but the bullet payment is due after you make the 60th payment. Note that the bullet payment is the remaining principal of the loan which can calculated using amortization table, however, in addition, it is the PV of the remaining 25-years of mortgage payments for the 30-years mortgage. Find the payments on this type of loan.

Answer 1

HERE RATE AND LOAN AMOUNT IS NOT GIVEN

Assuming rate of 5% compounded monthly
Loan amount of 100000

Monthly payments=100000*(5%/12)/(1-1/(1+5%/12)^(12*30))=536.8216

Bullet payment=536.8216/(5%/12)*(1-1/(1+5%/12)^(12*25))=91828.7281

Loan amortization schedule

Payment	Loan beginning balance	Payment	Interest payment	Principal payment	Loan ending balance
1	100000	$536.82	$416.67	$120.15	$99,879.85
2	$99,879.85	$536.82	$416.17	$120.66	$99,759.19
3	$99,759.19	$536.82	$415.66	$121.16	$99,638.03
4	$99,638.03	$536.82	$415.16	$121.66	$99,516.37
5	$99,516.37	$536.82	$414.65	$122.17	$99,394.20
6	$99,394.20	$536.82	$414.14	$122.68	$99,271.52
7	$99,271.52	$536.82	$413.63	$123.19	$99,148.33
8	$99,148.33	$536.82	$413.12	$123.70	$99,024.62
9	$99,024.62	$536.82	$412.60	$124.22	$98,900.41
10	$98,900.41	$536.82	$412.09	$124.74	$98,775.67
11	$98,775.67	$536.82	$411.57	$125.26	$98,650.41
12	$98,650.41	$536.82	$411.04	$125.78	$98,524.63
13	$98,524.63	$536.82	$410.52	$126.30	$98,398.33
14	$98,398.33	$536.82	$409.99	$126.83	$98,271.50
15	$98,271.50	$536.82	$409.46	$127.36	$98,144.15
16	$98,144.15	$536.82	$408.93	$127.89	$98,016.26
17	$98,016.26	$536.82	$408.40	$128.42	$97,887.84
18	$97,887.84	$536.82	$407.87	$128.96	$97,758.88
19	$97,758.88	$536.82	$407.33	$129.49	$97,629.39
20	$97,629.39	$536.82	$406.79	$130.03	$97,499.36
21	$97,499.36	$536.82	$406.25	$130.57	$97,368.78
22	$97,368.78	$536.82	$405.70	$131.12	$97,237.66
23	$97,237.66	$536.82	$405.16	$131.66	$97,106.00
24	$97,106.00	$536.82	$404.61	$132.21	$96,973.79
25	$96,973.79	$536.82	$404.06	$132.76	$96,841.02
26	$96,841.02	$536.82	$403.50	$133.32	$96,707.71
27	$96,707.71	$536.82	$402.95	$133.87	$96,573.83
28	$96,573.83	$536.82	$402.39	$134.43	$96,439.40
29	$96,439.40	$536.82	$401.83	$134.99	$96,304.41
30	$96,304.41	$536.82	$401.27	$135.55	$96,168.86
31	$96,168.86	$536.82	$400.70	$136.12	$96,032.74
32	$96,032.74	$536.82	$400.14	$136.69	$95,896.05
33	$95,896.05	$536.82	$399.57	$137.25	$95,758.80
34	$95,758.80	$536.82	$398.99	$137.83	$95,620.97
35	$95,620.97	$536.82	$398.42	$138.40	$95,482.57
36	$95,482.57	$536.82	$397.84	$138.98	$95,343.59
37	$95,343.59	$536.82	$397.26	$139.56	$95,204.04
38	$95,204.04	$536.82	$396.68	$140.14	$95,063.90
39	$95,063.90	$536.82	$396.10	$140.72	$94,923.18
40	$94,923.18	$536.82	$395.51	$141.31	$94,781.87
41	$94,781.87	$536.82	$394.92	$141.90	$94,639.97
42	$94,639.97	$536.82	$394.33	$142.49	$94,497.48
43	$94,497.48	$536.82	$393.74	$143.08	$94,354.40
44	$94,354.40	$536.82	$393.14	$143.68	$94,210.72
45	$94,210.72	$536.82	$392.54	$144.28	$94,066.45
46	$94,066.45	$536.82	$391.94	$144.88	$93,921.57
47	$93,921.57	$536.82	$391.34	$145.48	$93,776.09
48	$93,776.09	$536.82	$390.73	$146.09	$93,630.00
49	$93,630.00	$536.82	$390.12	$146.70	$93,483.30
50	$93,483.30	$536.82	$389.51	$147.31	$93,335.99
51	$93,335.99	$536.82	$388.90	$147.92	$93,188.07
52	$93,188.07	$536.82	$388.28	$148.54	$93,039.53
53	$93,039.53	$536.82	$387.66	$149.16	$92,890.38
54	$92,890.38	$536.82	$387.04	$149.78	$92,740.60
55	$92,740.60	$536.82	$386.42	$150.40	$92,590.20
56	$92,590.20	$536.82	$385.79	$151.03	$92,439.17
57	$92,439.17	$536.82	$385.16	$151.66	$92,287.51
58	$92,287.51	$536.82	$384.53	$152.29	$92,135.22
59	$92,135.22	$536.82	$383.90	$152.92	$91,982.29
60	$91,982.29	$536.82	$383.26	$153.56	$91,828.73