Question

Create an amortization schedules using the following assumptions:
Loan Term - 30 Year ARM
Purchase Price	$120,000
Down Payment	6%
Loan Amount	112,800
Interest Rate	11%	15%	13%
Balance @ beginning of the year	Year 15	Year 16	Year 25

Please show all the formulas you use so I can understand. 360 months = 30 years

Please use this set up

Month

Beginning Loan Balance

PMT

Interest.

Amortization

Ending Cash Balance

Answer 1

Month	Beginning Balance	Total Payment	Principal	Interest	Ending Balance
1	$112,800	$1,074	$40	$1,034	$112,760
2	$112,760	$1,074	$41	$1,034	$112,719
3	$112,719	$1,074	$41	$1,033	$112,678
4	$112,678	$1,074	$41	$1,033	$112,637
5	$112,637	$1,074	$42	$1,033	$112,595
6	$112,595	$1,074	$42	$1,032	$112,553
7	$112,553	$1,074	$42	$1,032	$112,511
8	$112,511	$1,074	$43	$1,031	$112,468
9	$112,468	$1,074	$43	$1,031	$112,424
10	$112,424	$1,074	$44	$1,031	$112,381
11	$112,381	$1,074	$44	$1,030	$112,337
12	$112,337	$1,074	$44	$1,030	$112,292
13	$112,292	$1,074	$45	$1,029	$112,247
14	$112,247	$1,074	$45	$1,029	$112,202
15	$112,202	$1,074	$46	$1,029	$112,156
16	$112,156	$1,074	$46	$1,028	$112,110
17	$112,110	$1,074	$47	$1,028	$112,064
18	$112,064	$1,074	$47	$1,027	$112,017
19	$112,017	$1,074	$47	$1,027	$111,969
20	$111,969	$1,074	$48	$1,026	$111,922
21	$111,922	$1,074	$48	$1,026	$111,873
22	$111,873	$1,074	$49	$1,026	$111,825
23	$111,825	$1,074	$49	$1,025	$111,775
24	$111,775	$1,074	$50	$1,025	$111,726
25	$111,726	$1,074	$50	$1,024	$111,676
26	$111,676	$1,074	$51	$1,024	$111,625
27	$111,625	$1,074	$51	$1,023	$111,574
28	$111,574	$1,074	$51	$1,023	$111,523
29	$111,523	$1,074	$52	$1,022	$111,471
30	$111,471	$1,074	$52	$1,022	$111,418
31	$111,418	$1,074	$53	$1,021	$111,365
32	$111,365	$1,074	$53	$1,021	$111,312
33	$111,312	$1,074	$54	$1,020	$111,258
34	$111,258	$1,074	$54	$1,020	$111,204
35	$111,204	$1,074	$55	$1,019	$111,149
36	$111,149	$1,074	$55	$1,019	$111,094
37	$111,094	$1,074	$56	$1,018	$111,038
38	$111,038	$1,074	$56	$1,018	$110,981
39	$110,981	$1,074	$57	$1,017	$110,925
40	$110,925	$1,074	$57	$1,017	$110,867
41	$110,867	$1,074	$58	$1,016	$110,809
42	$110,809	$1,074	$58	$1,016	$110,751
43	$110,751	$1,074	$59	$1,015	$110,692
44	$110,692	$1,074	$60	$1,015	$110,632
45	$110,632	$1,074	$60	$1,014	$110,572
46	$110,572	$1,074	$61	$1,014	$110,511
47	$110,511	$1,074	$61	$1,013	$110,450
48	$110,450	$1,074	$62	$1,012	$110,389
49	$110,389	$1,074	$62	$1,012	$110,326
50	$110,326	$1,074	$63	$1,011	$110,263
51	$110,263	$1,074	$63	$1,011	$110,200
52	$110,200	$1,074	$64	$1,010	$110,136
53	$110,136	$1,074	$65	$1,010	$110,071
54	$110,071	$1,074	$65	$1,009	$110,006
55	$110,006	$1,074	$66	$1,008	$109,940
56	$109,940	$1,074	$66	$1,008	$109,874
57	$109,874	$1,074	$67	$1,007	$109,807
58	$109,807	$1,074	$68	$1,007	$109,739
59	$109,739	$1,074	$68	$1,006	$109,671
60	$109,671	$1,074	$69	$1,005	$109,602
61	$109,602	$1,074	$70	$1,005	$109,532
62	$109,532	$1,074	$70	$1,004	$109,462
63	$109,462	$1,074	$71	$1,003	$109,391
64	$109,391	$1,074	$71	$1,003	$109,320
65	$109,320	$1,074	$72	$1,002	$109,248
66	$109,248	$1,074	$73	$1,001	$109,175
67	$109,175	$1,074	$73	$1,001	$109,101
68	$109,101	$1,074	$74	$1,000	$109,027
69	$109,027	$1,074	$75	$999	$108,952
70	$108,952	$1,074	$75	$999	$108,877
71	$108,877	$1,074	$76	$998	$108,801
72	$108,801	$1,074	$77	$997	$108,724
73	$108,724	$1,074	$78	$997	$108,646
74	$108,646	$1,074	$78	$996	$108,568
75	$108,568	$1,074	$79	$995	$108,489
76	$108,489	$1,074	$80	$994	$108,409
77	$108,409	$1,074	$80	$994	$108,329
78	$108,329	$1,074	$81	$993	$108,248
79	$108,248	$1,074	$82	$992	$108,166
80	$108,166	$1,074	$83	$992	$108,083
81	$108,083	$1,074	$83	$991	$107,999
82	$107,999	$1,074	$84	$990	$107,915
83	$107,915	$1,074	$85	$989	$107,830
84	$107,830	$1,074	$86	$988	$107,744
85	$107,744	$1,074	$87	$988	$107,658
86	$107,658	$1,074	$87	$987	$107,571
87	$107,571	$1,074	$88	$986	$107,482
88	$107,482	$1,074	$89	$985	$107,393
89	$107,393	$1,074	$90	$984	$107,304
90	$107,304	$1,074	$91	$984	$107,213
91	$107,213	$1,074	$91	$983	$107,122
92	$107,122	$1,074	$92	$982	$107,029
93	$107,029	$1,074	$93	$981	$106,936
94	$106,936	$1,074	$94	$980	$106,842
95	$106,842	$1,074	$95	$979	$106,747
96	$106,747	$1,074	$96	$979	$106,652
97	$106,652	$1,074	$97	$978	$106,555
98	$106,555	$1,074	$97	$977	$106,458
99	$106,458	$1,074	$98	$976	$106,359
100	$106,359	$1,074	$99	$975	$106,260
101	$106,260	$1,074	$100	$974	$106,160
102	$106,160	$1,074	$101	$973	$106,059
103	$106,059	$1,074	$102	$972	$105,957
104	$105,957	$1,074	$103	$971	$105,854
105	$105,854	$1,074	$104	$970	$105,750
106	$105,750	$1,074	$105	$969	$105,645
107	$105,645	$1,074	$106	$968	$105,539
108	$105,539	$1,074	$107	$967	$105,432
109	$105,432	$1,074	$108	$966	$105,325
110	$105,325	$1,074	$109	$965	$105,216
111	$105,216	$1,074	$110	$964	$105,106
112	$105,106	$1,074	$111	$963	$104,995
113	$104,995	$1,074	$112	$962	$104,884
114	$104,884	$1,074	$113	$961	$104,771
115	$104,771	$1,074	$114	$960	$104,657
116	$104,657	$1,074	$115	$959	$104,542
117	$104,542	$1,074	$116	$958	$104,426
118	$104,426	$1,074	$117	$957	$104,309
119	$104,309	$1,074	$118	$956	$104,191
120	$104,191	$1,074	$119	$955	$104,072
121	$104,072	$1,074	$120	$954	$103,952
122	$103,952	$1,074	$121	$953	$103,831
123	$103,831	$1,074	$122	$952	$103,708
124	$103,708	$1,074	$124	$951	$103,585
125	$103,585	$1,074	$125	$950	$103,460
126	$103,460	$1,074	$126	$948	$103,334
127	$103,334	$1,074	$127	$947	$103,207
128	$103,207	$1,074	$128	$946	$103,079
129	$103,079	$1,074	$129	$945	$102,950
130	$102,950	$1,074	$131	$944	$102,819
131	$102,819	$1,074	$132	$943	$102,687
132	$102,687	$1,074	$133	$941	$102,554
133	$102,554	$1,074	$134	$940	$102,420
134	$102,420	$1,074	$135	$939	$102,285
135	$102,285	$1,074	$137	$938	$102,148
136	$102,148	$1,074	$138	$936	$102,010
137	$102,010	$1,074	$139	$935	$101,871
138	$101,871	$1,074	$140	$934	$101,731
139	$101,731	$1,074	$142	$933	$101,589
140	$101,589	$1,074	$143	$931	$101,446
141	$101,446	$1,074	$144	$930	$101,302
142	$101,302	$1,074	$146	$929	$101,156
143	$101,156	$1,074	$147	$927	$101,009
144	$101,009	$1,074	$148	$926	$100,861
145	$100,861	$1,074	$150	$925	$100,711
146	$100,711	$1,074	$151	$923	$100,560
147	$100,560	$1,074	$152	$922	$100,408
148	$100,408	$1,074	$154	$920	$100,254
149	$100,254	$1,074	$155	$919	$100,099
150	$100,099	$1,074	$157	$918	$99,942
151	$99,942	$1,074	$158	$916	$99,784
152	$99,784	$1,074	$160	$915	$99,625
153	$99,625	$1,074	$161	$913	$99,464
154	$99,464	$1,074	$162	$912	$99,301
155	$99,301	$1,074	$164	$910	$99,137
156	$99,137	$1,074	$165	$909	$98,972
157	$98,972	$1,074	$167	$907	$98,805
158	$98,805	$1,074	$169	$906	$98,636
159	$98,636	$1,074	$170	$904	$98,466
160	$98,466	$1,074	$172	$903	$98,295
161	$98,295	$1,074	$173	$901	$98,121
162	$98,121	$1,074	$175	$899	$97,947
163	$97,947	$1,074	$176	$898	$97,770
164	$97,770	$1,074	$178	$896	$97,592
165	$97,592	$1,074	$180	$895	$97,413
166	$97,413	$1,074	$181	$893	$97,231
167	$97,231	$1,074	$183	$891	$97,048
168	$97,048	$1,074	$185	$890	$96,864
169	$96,864	$1,074	$186	$888	$96,678
170	$96,678	$1,074	$188	$886	$96,490
171	$96,490	$1,074	$190	$884	$96,300
172	$96,300	$1,074	$191	$883	$96,108
173	$96,108	$1,074	$193	$881	$95,915
174	$95,915	$1,074	$195	$879	$95,720
175	$95,720	$1,074	$197	$877	$95,523
176	$95,523	$1,074	$199	$876	$95,325
177	$95,325	$1,074	$200	$874	$95,124
178	$95,124	$1,074	$202	$872	$94,922
179	$94,922	$1,074	$204	$870	$94,718
180	$94,718	$1,074	$206	$868	$94,512
181	$94,512	$1,323	$141	$1,181	$94,371
182	$94,371	$1,323	$143	$1,180	$94,227
183	$94,227	$1,323	$145	$1,178	$94,083
184	$94,083	$1,323	$147	$1,176	$93,936
185	$93,936	$1,323	$149	$1,174	$93,787
186	$93,787	$1,323	$150	$1,172	$93,637
187	$93,637	$1,323	$152	$1,170	$93,484
188	$93,484	$1,323	$154	$1,169	$93,330
189	$93,330	$1,323	$156	$1,167	$93,174
190	$93,174	$1,323	$158	$1,165	$93,016
191	$93,016	$1,323	$160	$1,163	$92,856
192	$92,856	$1,323	$162	$1,161	$92,694
193	$92,694	$1,323	$164	$1,159	$92,530
194	$92,530	$1,323	$166	$1,157	$92,364
195	$92,364	$1,323	$168	$1,155	$92,195
196	$92,195	$1,323	$170	$1,152	$92,025
197	$92,025	$1,323	$172	$1,150	$91,853
198	$91,853	$1,323	$175	$1,148	$91,678
199	$91,678	$1,323	$177	$1,146	$91,501
200	$91,501	$1,323	$179	$1,144	$91,322
201	$91,322	$1,323	$181	$1,142	$91,141
202	$91,141	$1,323	$184	$1,139	$90,957
203	$90,957	$1,323	$186	$1,137	$90,771
204	$90,771	$1,323	$188	$1,135	$90,583
205	$90,583	$1,323	$190	$1,132	$90,393
206	$90,393	$1,323	$193	$1,130	$90,200
207	$90,200	$1,323	$195	$1,127	$90,005
208	$90,005	$1,323	$198	$1,125	$89,807
209	$89,807	$1,323	$200	$1,123	$89,607
210	$89,607	$1,323	$203	$1,120	$89,404
211	$89,404	$1,323	$205	$1,118	$89,199
212	$89,199	$1,323	$208	$1,115	$88,991
213	$88,991	$1,323	$210	$1,112	$88,781
214	$88,781	$1,323	$213	$1,110	$88,568
215	$88,568	$1,323	$216	$1,107	$88,352
216	$88,352	$1,323	$218	$1,104	$88,134
217	$88,134	$1,323	$221	$1,102	$87,913
218	$87,913	$1,323	$224	$1,099	$87,689
219	$87,689	$1,323	$227	$1,096	$87,462
220	$87,462	$1,323	$230	$1,093	$87,232
221	$87,232	$1,323	$232	$1,090	$87,000
222	$87,000	$1,323	$235	$1,088	$86,765
223	$86,765	$1,323	$238	$1,085	$86,527
224	$86,527	$1,323	$241	$1,082	$86,285
225	$86,285	$1,323	$244	$1,079	$86,041
226	$86,041	$1,323	$247	$1,076	$85,794
227	$85,794	$1,323	$250	$1,072	$85,544
228	$85,544	$1,323	$253	$1,069	$85,290
229	$85,290	$1,323	$257	$1,066	$85,033
230	$85,033	$1,323	$260	$1,063	$84,774
231	$84,774	$1,323	$263	$1,060	$84,510
232	$84,510	$1,323	$266	$1,056	$84,244
233	$84,244	$1,323	$270	$1,053	$83,974
234	$83,974	$1,323	$273	$1,050	$83,701
235	$83,701	$1,323	$277	$1,046	$83,425
236	$83,425	$1,323	$280	$1,043	$83,145
237	$83,145	$1,323	$283	$1,039	$82,861
238	$82,861	$1,323	$287	$1,036	$82,574
239	$82,574	$1,323	$291	$1,032	$82,284
240	$82,284	$1,323	$294	$1,029	$81,989
241	$81,989	$1,323	$298	$1,025	$81,691
242	$81,691	$1,323	$302	$1,021	$81,390
243	$81,390	$1,323	$305	$1,017	$81,084
244	$81,084	$1,323	$309	$1,014	$80,775
245	$80,775	$1,323	$313	$1,010	$80,462
246	$80,462	$1,323	$317	$1,006	$80,145
247	$80,145	$1,323	$321	$1,002	$79,824
248	$79,824	$1,323	$325	$998	$79,499
249	$79,499	$1,323	$329	$994	$79,170
250	$79,170	$1,323	$333	$990	$78,837
251	$78,837	$1,323	$337	$985	$78,500
252	$78,500	$1,323	$342	$981	$78,158
253	$78,158	$1,323	$346	$977	$77,812
254	$77,812	$1,323	$350	$973	$77,462
255	$77,462	$1,323	$355	$968	$77,108
256	$77,108	$1,323	$359	$964	$76,749
257	$76,749	$1,323	$363	$959	$76,385
258	$76,385	$1,323	$368	$955	$76,017
259	$76,017	$1,323	$373	$950	$75,645
260	$75,645	$1,323	$377	$946	$75,268
261	$75,268	$1,323	$382	$941	$74,886
262	$74,886	$1,323	$387	$936	$74,499
263	$74,499	$1,323	$392	$931	$74,107
264	$74,107	$1,323	$396	$926	$73,711
265	$73,711	$1,323	$401	$921	$73,310
266	$73,310	$1,323	$406	$916	$72,903
267	$72,903	$1,323	$411	$911	$72,492
268	$72,492	$1,323	$417	$906	$72,075
269	$72,075	$1,323	$422	$901	$71,653
270	$71,653	$1,323	$427	$896	$71,226
271	$71,226	$1,323	$432	$890	$70,794
272	$70,794	$1,323	$438	$885	$70,356
273	$70,356	$1,323	$443	$879	$69,912
274	$69,912	$1,323	$449	$874	$69,464
275	$69,464	$1,323	$454	$868	$69,009
276	$69,009	$1,323	$460	$863	$68,549
277	$68,549	$1,323	$466	$857	$68,083
278	$68,083	$1,323	$472	$851	$67,611
279	$67,611	$1,323	$478	$845	$67,134
280	$67,134	$1,323	$484	$839	$66,650
281	$66,650	$1,323	$490	$833	$66,160
282	$66,160	$1,323	$496	$827	$65,665
283	$65,665	$1,323	$502	$821	$65,163
284	$65,163	$1,323	$508	$815	$64,654
285	$64,654	$1,323	$515	$808	$64,140
286	$64,140	$1,323	$521	$802	$63,619
287	$63,619	$1,323	$528	$795	$63,091
288	$63,091	$1,323	$534	$789	$62,557
289	$62,557	$1,323	$541	$782	$62,016
290	$62,016	$1,323	$548	$775	$61,469
291	$61,469	$1,323	$554	$768	$60,914
292	$60,914	$1,323	$561	$761	$60,353
293	$60,353	$1,323	$568	$754	$59,784
294	$59,784	$1,323	$575	$747	$59,209
295	$59,209	$1,323	$583	$740	$58,626
296	$58,626	$1,323	$590	$733	$58,036
297	$58,036	$1,323	$597	$725	$57,439
298	$57,439	$1,323	$605	$718	$56,834
299	$56,834	$1,323	$612	$710	$56,222
300	$56,222	$1,323	$620	$703	$55,602
301	$55,602	$1,265	$663	$602	$54,939
302	$54,939	$1,265	$670	$595	$54,269
303	$54,269	$1,265	$677	$588	$53,592
304	$53,592	$1,265	$685	$581	$52,907
305	$52,907	$1,265	$692	$573	$52,216
306	$52,216	$1,265	$699	$566	$51,516
307	$51,516	$1,265	$707	$558	$50,809
308	$50,809	$1,265	$715	$550	$50,094
309	$50,094	$1,265	$722	$543	$49,372
310	$49,372	$1,265	$730	$535	$48,642
311	$48,642	$1,265	$738	$527	$47,904
312	$47,904	$1,265	$746	$519	$47,157
313	$47,157	$1,265	$754	$511	$46,403
314	$46,403	$1,265	$762	$503	$45,641
315	$45,641	$1,265	$771	$494	$44,870
316	$44,870	$1,265	$779	$486	$44,091
317	$44,091	$1,265	$787	$478	$43,304
318	$43,304	$1,265	$796	$469	$42,508
319	$42,508	$1,265	$805	$460	$41,703
320	$41,703	$1,265	$813	$452	$40,890
321	$40,890	$1,265	$822	$443	$40,067
322	$40,067	$1,265	$831	$434	$39,236
323	$39,236	$1,265	$840	$425	$38,396
324	$38,396	$1,265	$849	$416	$37,547
325	$37,547	$1,265	$858	$407	$36,689
326	$36,689	$1,265	$868	$397	$35,821
327	$35,821	$1,265	$877	$388	$34,944
328	$34,944	$1,265	$887	$379	$34,058
329	$34,058	$1,265	$896	$369	$33,161
330	$33,161	$1,265	$906	$359	$32,256
331	$32,256	$1,265	$916	$349	$31,340
332	$31,340	$1,265	$926	$340	$30,414
333	$30,414	$1,265	$936	$329	$29,479
334	$29,479	$1,265	$946	$319	$28,533
335	$28,533	$1,265	$956	$309	$27,577
336	$27,577	$1,265	$966	$299	$26,610
337	$26,610	$1,265	$977	$288	$25,634
338	$25,634	$1,265	$987	$278	$24,646
339	$24,646	$1,265	$998	$267	$23,648
340	$23,648	$1,265	$1,009	$256	$22,639
341	$22,639	$1,265	$1,020	$245	$21,619
342	$21,619	$1,265	$1,031	$234	$20,588
343	$20,588	$1,265	$1,042	$223	$19,546
344	$19,546	$1,265	$1,053	$212	$18,493
345	$18,493	$1,265	$1,065	$200	$17,428
346	$17,428	$1,265	$1,076	$189	$16,352
347	$16,352	$1,265	$1,088	$177	$15,264
348	$15,264	$1,265	$1,100	$165	$14,164
349	$14,164	$1,265	$1,112	$153	$13,053
350	$13,053	$1,265	$1,124	$141	$11,929
351	$11,929	$1,265	$1,136	$129	$10,793
352	$10,793	$1,265	$1,148	$117	$9,645
353	$9,645	$1,265	$1,161	$104	$8,484
354	$8,484	$1,265	$1,173	$92	$7,311
355	$7,311	$1,265	$1,186	$79	$6,125
356	$6,125	$1,265	$1,199	$66	$4,926
357	$4,926	$1,265	$1,212	$53	$3,714
358	$3,714	$1,265	$1,225	$40	$2,490
359	$2,490	$1,265	$1,238	$27	$1,251
360	$1,251	$1,265	$1,252	$14	$0
TOTAL	$428,000	$112,800	$315,200