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?
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%
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 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 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 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 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 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 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. 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 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 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...