what if analysis Data Table.xlsx

	A	B	C	D	E	H	I	J	K	L	M	N	O	P	Q	R
1								single variable data table
2	Loan Amount	Interest Rate	Loan Term (month)	Monthly Payment				856	Monthly Payment for 5% interest Rate
3	10000	5%	12	$856	PMT(B3/12,C3,-A3		5%	856.07
4		1000.00%					10%	879.16
5		15.0%					15%	902.58
6		20.0%					20%	926.35
7						Interest Rate changes	25%	950.44
8							30%	974.87
9							35%	999.63
10							40%	1024.71
11							45%	1050.12
12							50%	1075.85
13							55%	1101.90
14							60%	1128.25
15							65%	1154.92
16							70%	1181.90
17
18
19
20
21
22								Two variable data table			Months Changes
23								Two variable data table			Months Changes
24							$856	12	18	24	30	36	42	48	54	60
25							5%	856.07	577.81	438.71	355.29	299.71	260.03	230.29	207.18	188.71
26							10%	879.16	600.57	461.45	378.11	322.67	283.17	253.63	230.72	212.47
27						Interest Rate changes	15%	902.58	623.85	484.87	401.79	346.65	307.49	278.31	255.78	237.90
28							20%	926.35	647.63	508.96	426.30	371.64	332.97	304.30	282.29	264.94
29							25%	950.44	671.92	533.72	451.63	397.60	359.58	331.57	310.22	293.51
30							30%	974.87	696.70	559.13	477.78	424.52	387.29	360.06	339.48	323.53
31							35%	999.63	721.97	585.19	504.71	452.36	416.04	389.71	370.01	354.90
32							40%	1024.71	747.73	611.88	532.42	481.10	445.81	420.47	401.71	387.52
33							45%	1050.12	773.97	639.19	560.88	510.71	476.53	452.26	434.52	421.27
34							50%	1075.85	800.67	667.11	590.06	541.14	508.16	485.02	468.33	456.05
35							55%	1101.90	827.84	695.62	619.95	572.36	540.65	518.69	503.07	491.75
36							60%	1128.25	855.46	724.71	650.51	604.34	573.95	553.18	538.64	528.28
37							65%	1154.92	883.53	754.36	681.73	637.04	608.00	588.45	574.97	565.54
38							70%	1181.90	912.04	784.56	713.58	670.42	642.75	624.41	611.98	603.44
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100