Question

An amortization schedule is a common concept within a banking enterprise. Create your own amortization schedule for a $10,000 loan with monthly payments paid over two years. Assume the annual percentage rate (APR) is 4%. Create the amortization schedule within Excel or another spreadsheet application. Use page 184 as a template. Keep in mind that the example on page 184 uses annual payments, while your schedule will use monthly payments. You will need to adjust the number of payment periods and period interest rates accordingly (e.g. - 2 years = 24 payment periods [months]; 4% annual interest = 0.33% period [monthly] interest). Attach your Excel document to your post.

Answer 1

Payment	Loan beginning balance	Payment	Interest payment	Principal payment	Loan ending balance
1	10000	$434.25	$33.33	$400.92	$9,599.08
2	$9,599.08	$434.25	$32.00	$402.25	$9,196.83
3	$9,196.83	$434.25	$30.66	$403.59	$8,793.24
4	$8,793.24	$434.25	$29.31	$404.94	$8,388.30
5	$8,388.30	$434.25	$27.96	$406.29	$7,982.01
6	$7,982.01	$434.25	$26.61	$407.64	$7,574.37
7	$7,574.37	$434.25	$25.25	$409.00	$7,165.37
8	$7,165.37	$434.25	$23.88	$410.36	$6,755.00
9	$6,755.00	$434.25	$22.52	$411.73	$6,343.27
10	$6,343.27	$434.25	$21.14	$413.10	$5,930.17
11	$5,930.17	$434.25	$19.77	$414.48	$5,515.68
12	$5,515.68	$434.25	$18.39	$415.86	$5,099.82
13	$5,099.82	$434.25	$17.00	$417.25	$4,682.57
14	$4,682.57	$434.25	$15.61	$418.64	$4,263.93
15	$4,263.93	$434.25	$14.21	$420.04	$3,843.89
16	$3,843.89	$434.25	$12.81	$421.44	$3,422.46
17	$3,422.46	$434.25	$11.41	$422.84	$2,999.62
18	$2,999.62	$434.25	$10.00	$424.25	$2,575.37
19	$2,575.37	$434.25	$8.58	$425.66	$2,149.70
20	$2,149.70	$434.25	$7.17	$427.08	$1,722.62
21	$1,722.62	$434.25	$5.74	$428.51	$1,294.11
22	$1,294.11	$434.25	$4.31	$429.94	$864.18
23	$864.18	$434.25	$2.88	$431.37	$432.81
24	$432.81	$434.25	$1.44	$432.81	($0.00)