Question

Amount financed = 240,000 - 91,088 = $148,912. This is Pv. Nper = 15 years*12 = 180 and rate = 4.5%/12 Amount paid each month = PMT(4.5%/12, 180, -148912) = 1139.07 find payment number 10-100. Payment no. Loan balance at the start of the month Amount of payment Interest Principal paid Loan balance at the end of the month.

6	145,986.41	1,139.17	547.45	591.72	145,394.69
7	145,394.69	1,139.17	545.23	593.94	144,800.75
8	144,800.75	1,139.17	543.00	596.16	144,204.59
9	144,204.59	1,139.17	540.77	598.40	143,606.19
10	143,606.19	1,139.17	538.52	600.64	143,005.54

Answer 1

Payment no 10 to 100 will be the same which is 1139.17

The table will be upto 50th payment (due to character limit of the portal )

Month	StartingBalance	Payment	Interest	Principal	EndingBalance
1	$148,912.00	$1,139.17	$558.42	$580.75	$148,331.25
2	$148,331.25	$1,139.17	$556.24	$582.92	$147,748.33
3	$147,748.33	$1,139.17	$554.06	$585.11	$147,163.22
4	$147,163.22	$1,139.17	$551.86	$587.30	$146,575.91
5	$146,575.91	$1,139.17	$549.66	$589.51	$145,986.41
6	$145,986.41	$1,139.17	$547.45	$591.72	$145,394.69
7	$145,394.69	$1,139.17	$545.23	$593.94	$144,800.75
8	$144,800.75	$1,139.17	$543.00	$596.16	$144,204.59
9	$144,204.59	$1,139.17	$540.77	$598.40	$143,606.19
10	$143,606.19	$1,139.17	$538.52	$600.64	$143,005.54
11	$143,005.54	$1,139.17	$536.27	$602.90	$142,402.65
12	$142,402.65	$1,139.17	$534.01	$605.16	$141,797.49
13	$141,797.49	$1,139.17	$531.74	$607.43	$141,190.07
14	$141,190.07	$1,139.17	$529.46	$609.70	$140,580.36
15	$140,580.36	$1,139.17	$527.18	$611.99	$139,968.37
16	$139,968.37	$1,139.17	$524.88	$614.29	$139,354.09
17	$139,354.09	$1,139.17	$522.58	$616.59	$138,737.50
18	$138,737.50	$1,139.17	$520.27	$618.90	$138,118.60
19	$138,118.60	$1,139.17	$517.94	$621.22	$137,497.37
20	$137,497.37	$1,139.17	$515.62	$623.55	$136,873.82
21	$136,873.82	$1,139.17	$513.28	$625.89	$136,247.93
22	$136,247.93	$1,139.17	$510.93	$628.24	$135,619.69
23	$135,619.69	$1,139.17	$508.57	$630.59	$134,989.10
24	$134,989.10	$1,139.17	$506.21	$632.96	$134,356.14
25	$134,356.14	$1,139.17	$503.84	$635.33	$133,720.81
26	$133,720.81	$1,139.17	$501.45	$637.71	$133,083.10
27	$133,083.10	$1,139.17	$499.06	$640.11	$132,442.99
28	$132,442.99	$1,139.17	$496.66	$642.51	$131,800.49
29	$131,800.49	$1,139.17	$494.25	$644.91	$131,155.57
30	$131,155.57	$1,139.17	$491.83	$647.33	$130,508.24
31	$130,508.24	$1,139.17	$489.41	$649.76	$129,858.48
32	$129,858.48	$1,139.17	$486.97	$652.20	$129,206.28
33	$129,206.28	$1,139.17	$484.52	$654.64	$128,551.64
34	$128,551.64	$1,139.17	$482.07	$657.10	$127,894.54
35	$127,894.54	$1,139.17	$479.60	$659.56	$127,234.98
36	$127,234.98	$1,139.17	$477.13	$662.04	$126,572.94
37	$126,572.94	$1,139.17	$474.65	$664.52	$125,908.42
38	$125,908.42	$1,139.17	$472.16	$667.01	$125,241.41
39	$125,241.41	$1,139.17	$469.66	$669.51	$124,571.90
40	$124,571.90	$1,139.17	$467.14	$672.02	$123,899.88
41	$123,899.88	$1,139.17	$464.62	$674.54	$123,225.34
42	$123,225.34	$1,139.17	$462.10	$677.07	$122,548.27
43	$122,548.27	$1,139.17	$459.56	$679.61	$121,868.65
44	$121,868.65	$1,139.17	$457.01	$682.16	$121,186.50
45	$121,186.50	$1,139.17	$454.45	$684.72	$120,501.78
46	$120,501.78	$1,139.17	$451.88	$687.29	$119,814.49
47	$119,814.49	$1,139.17	$449.30	$689.86	$119,124.63
48	$119,124.63	$1,139.17	$446.72	$692.45	$118,432.18
49	$118,432.18	$1,139.17	$444.12	$695.05	$117,737.13
50	$117,737.13	$1,139.17	$441.51	$697.65	$117,039.48

WORKINGS