3/17 - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	t	Projection	a(t)	1/a(t)	OB_t	K_t	I_t	PR_t	Recalculated	Projection	K_t	I_t	PR_t
2	0		1	1	$100,000.00				OB_t
3	1	3%	1.03	0.9708737864	$91,205.82	$11,794.18	$3,000.00	$8,794.18		3%
4	2	3%	1.0609	0.9425959091	$82,147.82	$11,794.18	$2,736.17	$9,058.00		3%
5	3	3%	1.092727	0.9151416594	$72,818.08	$11,794.18	$2,464.43	$9,329.74		3%
6	4	3%	1.12550881	0.8884870479	$63,208.44	$11,794.18	$2,184.54	$9,609.63		3%
7	5	3%	1.159274074	0.8626087844	$53,310.52	$11,794.18	$1,896.25	$9,897.92	$53,310.52	3%
8	6	0.032	1.196370845	0.8358612252	$43,222.28	$11,794.18	$1,705.94	$10,088.24	$43,662.66	5%	$12,313.39	$2,665.53	$9,647.86
9	7	0.034	1.237047453	0.8083764267	$32,897.66	$11,794.18	$1,469.56	$10,324.62	$33,532.40	5%	$12,313.39	$2,183.13	$10,130.25
10	8	0.036	1.281581162	0.7802861261	$22,287.80	$11,794.18	$1,184.32	$10,609.86	$22,895.64	5%	$12,313.39	$1,676.62	$10,636.77
11	9	0.038	1.330281246	0.7517207381	$11,340.56	$11,794.18	$846.94	$10,947.24	$11,727.03	5%	$12,313.39	$1,144.78	$11,168.60
12	10	0.04	1.383492496	0.722808402	$0.00	$11,794.18	$453.62	$11,340.56	$0.00	5%	$12,313.39	$586.35	$11,727.03
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
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