follow the instructions on the files
aboznada007
college_1.xlsxDocumentation
| College Savers | |
| Author | |
| Date | |
| Purpose | To design a college savings plan that projects the future cost of college and analyze whether enough savings can be generated to cover those costs |
&D
&F Page &P &A
Savings Plan
| College Savers | ||||||||
| Client Information | Savings Schedule | |||||||
| Student | Year | Age | Date(s) | Deposit(s) | Net Cash Flow | |||
| Age | Savings Years | 0 | 0 | 3/1/16 | ||||
| Years until College | 1 | 1 | 7/17/16 | |||||
| Parent(s) | 12/1/16 | |||||||
| 12/25/16 | ||||||||
| College Costs | 2 | 2 | 7/17/17 | |||||
| Current 1-Year Cost | 12/1/17 | |||||||
| Annual Inflation Rate | 12/25/17 | |||||||
| Projected 4-Year Cost | 3 | 3 | 7/17/18 | |||||
| 12/1/18 | ||||||||
| College Portfolio | 12/25/18 | |||||||
| Portfolio Rate of Return | 4 | 4 | 7/17/19 | |||||
| Initial Investment | 12/1/19 | |||||||
| Annual Deposit | 12/25/19 | |||||||
| Annual Gifts | 5 | 5 | 7/17/20 | |||||
| Total Deposits | 12/1/20 | |||||||
| 12/25/20 | ||||||||
| Conclusions | 6 | 6 | 7/17/21 | |||||
| Net Present Value | 12/1/21 | |||||||
| Plan Will Cover Expenses | 12/25/21 | |||||||
| 7 | 7 | 7/17/22 | ||||||
| 12/1/22 | ||||||||
| 12/25/22 | ||||||||
| 8 | 8 | 7/17/23 | ||||||
| 12/1/23 | ||||||||
| 12/25/23 | ||||||||
| 9 | 9 | 7/17/24 | ||||||
| 12/1/24 | ||||||||
| 12/25/24 | ||||||||
| Freshman | 10 | 10 | 7/17/25 | |||||
| 8/15/25 | ||||||||
| 12/1/25 | ||||||||
| 12/25/25 | ||||||||
| Sophomore | 11 | 11 | 7/17/26 | |||||
| 8/15/26 | ||||||||
| 12/1/26 | ||||||||
| 12/25/26 | ||||||||
| Junior | 12 | 12 | 7/17/27 | |||||
| 8/15/27 | ||||||||
| 12/1/27 | ||||||||
| 12/25/27 | ||||||||
| Senior | 13 | 13 | 7/17/28 | |||||
| 8/15/28 |
&D
&F Page &P &A
