ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
2
Daughter's College Finaces Analysis
3
4
SlabsYearTotalSegment
Question Part
Amount
5
20222023202420252026202720282029203020312032203320342035203620372038TOTAL FWa$131,839.71
6
Present annual college cost payable
$20,000 $20,000 $20,000 $20,000 -------------$80,000.00 TOTAL FWb$131,839.71
7
TOTAL FWc$395,519.13
8
Future annual college cost payable
------------- $ 31,279.12 $ 32,373.89 $ 33,506.98 $ 34,679.72 $131,839.71 PRESENT WORTHd$54,708.79
9
AFFORDABLE AMOUNT
d$38,296.15
10
Future annual college cost at tripple rate payable
------------- $ 93,837.36 $ 97,121.67 $ 100,520.93 $ 104,039.16 $395,519.13 ANNUITYe$6,545.95
11
ANNUITY 1f$5,507.20
12
Present equivalace of fututre college amount
 $ 54,708.79 ----------------$54,708.79 ANNUITY 2f$4,781.72
13
ANNUITY 3f$1,856.77
14
Present affordabilty
 $ 38,296.15 ----------------$38,296.15
15
16
Annual Investment
$ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 $ 6,545.95 ----$85,097.39
17
18
Inheritance amount
 $ 20,000.00 ----------------$20,000.00
19
20
Annual investment at 7% ROR
$5,507.20 $5,507.20 $5,507.20 $5,507.20 $5,507.20 $5,507.20 $5,507.20 $5,507.20 $5,507.20 $5,507.20 $5,507.20 $5,507.20 $5,507.20 ----$71,593.58
21
22
Annual investment at 5% ROR
 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 $ 4,781.72 ----$62,162.33
23
24
Annual investment at 10% ROR
 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 $ 1,856.77 ----$24,137.95
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