Question

A financial planning service offers a college savings program. The plan calls for you to make...

A financial planning service offers a college savings program. The plan calls for you to make six annual payments of $15,500 each, with the first payment occurring today, your child’s 12th birthday. Beginning on your child’s 18th birthday, the plan will provide $28,000 per year for four years. What return is this investment offering?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Value of owne payments at 18th birthday=Value of plan payments at 18th birthday

15500/r*(1-1/(1+r)^6)*(1+r)*(1+r)^6=28000/r*(1-1/(1+r)^4)*(1+r)

=>r=3.7644%

Add a comment
Know the answer?
Add Answer to:
A financial planning service offers a college savings program. The plan calls for you to make...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A financial planning service offers a college savings program. The plan calls for you to make...

    A financial planning service offers a college savings program. The plan calls for you to make six annual payments of $15,800 each, with the first payment occurring today, your child’s 12th birthday. Beginning on your child’s 18th birthday, the plan will provide $35,000 per year for four years. What return is this investment offering? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)   

  • A financial planning service offers a college savings program. The plan calls for you to make...

    A financial planning service offers a college savings program. The plan calls for you to make six annual payments of $13,000 each, with the first payment occurring today, your child's 12th birthday. Beginning on your child's 18th birthday, the plan will provide $25,000 per year for four years. What return is this investment offering? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Return %

  • ssignment Saved A financial planning service offers a college savings program. The plan calls for you...

    ssignment Saved A financial planning service offers a college savings program. The plan calls for you to ach, with the first payment occurring today, your child's 12th birthday. Beginning on your child's 18th birthday, the plan will provide $35,000 per year for four years. What return is this investment offering? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Return

  • Education Plus financial services is offering education savings plan. The plan calls for you to make...

    Education Plus financial services is offering education savings plan. The plan calls for you to make sik annual payments of $5,000 each, with the first payment occurring today. your child's 12th birthday. Beginning on your child's 18th birthday, the plan will provide $10,000 per year for four years. What return is this investment offering? a) 4.61% b) 4.97% c) 5.87% d) 6.49% e) 8.83% (

  • please help me solve this problem with excel formulas please and thank you!! A financial planning...

    please help me solve this problem with excel formulas please and thank you!! A financial planning service offers a unique program for parents to save for a child's college education. Starting on the child's 12th birthday, annual deposits are made. The first deposit is $5,000 and the required deposit increases by $1000 each year, until the child's 18th birthday, when the final deposit is made. Beginning on the child's 19th birthday, four annual withdrawals of $10,000 can be made. Assuming...

  • A father is now planning a savings program to put his daughter through college. She just...

    A father is now planning a savings program to put his daughter through college. She just celebrated her 13th birthday, she plans to enroll at the university in 5 years when she turns 18 years old, and she should graduate in 4 years. Currently, the annual cost (for everything – food, clothing, tuition, books, transportation, and so forth) is $15,000, but these costs are expected to increase by 5% annually. The college requires that this amount be paid at the...

  • eBook A father is now planning a savings program to put his daughter through college. She...

    eBook A father is now planning a savings program to put his daughter through college. She is 13, plans to enroll at the university in 5 years, and she should graduate 4 years later. Currently, the annual cost (for everything - food, clothing, tuition, books, transportation, and so forth) is $18,000, but these costs are expected to increase by 7% annually. The college requires total payment at the start of the year. She now has $9,500 in a college savings...

  • College Problem ther and mother are planning a savings program to put their daughter through college....

    College Problem ther and mother are planning a savings program to put their daughter through college. Their mer is now 4 years old. She plans to enroll at the university when she is 18 and it should take her 4 years to complete her education. Currently, the cost per year (for tuition, etc.) is $12,000, but a 370 ation rate in these costs is forecasted. The cost for each year of college will be withdrawn when she turns 18, 19,...

  • You are considering a savings plan that calls for a deposit of $12,000 at the BEGINNING...

    You are considering a savings plan that calls for a deposit of $12,000 at the BEGINNING of each of the next five years. If the plan offers an interest rate of 8 percent, how much will you accumulate at the end of year 5? Do this calculation by completing the following template using Excel. Your spreadsheet will do the FV calculation twice - once using the FV function (in Cell B4) and once using a simple table that shows the...

  • Retirement Planning. A couple will retire in 50 years; they plan to spend about $30,000 a...

    Retirement Planning. A couple will retire in 50 years; they plan to spend about $30,000 a year in retirement, which should last about 25 years. They believe that they can earn 8% interest on retirement savings. a. If they make annual payments into a savings plan, how much will they need to save each year? Assume the first payment comes in 1 year. b. How would the answer to part (a) change if the couple also realize that in 20...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT