College Woes

College Woes

Kim and John’s dream for their ten year old daughter, Kyleigh, is that one day she will attend their alma mater, Dayton University.  For the next 8 years, they plan to make monthly payment deposits to a long term savings account at a local bank.  The account pays 4.25% annual interest.  Create a worksheet for Kim and John that uses a financial function to show the future value of their investment and a formula to determine the percentage of the college’s tuition saved.  Kim and John have supplied the following information:

Rate per year = 4.25%

Payment = $375

Percentage of Tuition saved = FV/Sum of Tuition for four years

Kim and John are not sure how much they will be able to save each month.  Create a data table that shows the future value and percentage of tuition saved for monthly payments from $275 to $875, in $50 increments.  Insert a graphic file and assign it a hyperlink to a financial institution of your choice. Protect the worksheet.

Save it as Saving_for_College_Your_Name. 

Part II

Five years later, Kim was laid off from work leaving them with one income.  John is a New York City Police Officer making $70,000 a year.  But he is up for a raise in two months.  Please create a spreadsheet outlining their expenses with the following information:

Mortgage: $2200 a month

Utilities (water, heat, electricity, and gas): $500 a month

Cable TV: $100 a month

Telephone: $ 50 a month

Internet: $40 a month

Food: $600 a month

Car payment: $200 a month

Cell Phones: $45 a month (2)

Car Insurance: $135a month

Kyleigh’s Day Care: $1000 a month

Gas: $500 a month

Misc: $500 a month

Can Kim and John survive with one income and still put money away for Kyleigh’s college fund? If not, what is the minimum that John would have to make a year for them to just break even each month? Please outline increase in John’s salary in $1000 increments to $20,000 more than just breaking even, based off of their expenditures and need to save for their daughter’s education.

Save as Saving_for_College_Part_II_Your_Name.

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>