Number of useful financial spreadsheets

Assignment Help Financial Management

Reference no: EM131972787

The recorded session, provides a good overview on working this problem. Use the "A Number of Useful Financial Spreadsheets" to find a sample template you can use to work this problem. I went over this in the recorded session. The problem you will answer has the following fact pattern:

A couple has just given birth to a baby and named him Jimmy. They want to set up a college savings account for Jimmy and start saving for his college education. The following facts will help you work this problem:

Current Cost of Tuition, Room & Board $25,000

Expected Average Inflation for College Costs 5%

Expected Average Percentage Return on Savings 4%

Years until you need the first tuition payment 18

You will make 18 yearly payments with the first payment starting a year from now.

How much will the couple need at the end of 18 years to fund Jimmy's college education for 4 years? Round your answer to a whole number (Example 150450.61 rounded to 150451 with no commas or dollar signs)

Reference no: EM131972787

Questions Cloud

Recreational tennis racket-what will cash flows for project : You are evaluating a project for The Ultimate recreational tennis racket, guaranteed to correct that wimpy backhand. What will the cash flows for this project?

How will this impact a portfolio made up of stocks-bonds : How will this impact a portfolio made up of stocks, bonds, cash and foreign exchange.

Monthly payment amounts and year-end loan balances : Compute the monthly payment amounts and year-end loan balances for the first 5 years. What will be the yield on the loan over that period?

What will be the loan balance at the end of year one : What will be the loan balance at the end of year 1?

Number of useful financial spreadsheets : Use the "A Number of Useful Financial Spreadsheets" to find a sample template you can use to work this problem.

What is the percentage increase in payment : What will be the payment in year 2 if the composite is 6.5% at the end of year 1? By what is the percentage increase in payment?

Determine the yield-to-maturity : On October 1, 2008, the bonds were selling for $1000. Determine the yield-to-maturity. Calculate the yield-to-maturity of the bonds.

Present description of one actual capital project : the financial literature to identify and present a description of one actual capital project/product success and the reasons attributed to the success.

Why do the differences in the PVs occur : Find the present value of $700 due in the future under each of these conditions. Why do the differences in the PVs occur?

User Account

All Pages