Total Program Payments to be made in 6 years = $14,800 x 6 = $88,800
Starting 7th year (Child’s 18th Birthday) Returns for 4 Years from the Program = 35,000 x 4 = $140,000
Since, Last/4th Payment (of $35,000) made occurs at the end of 10th year
Total Payments received in 10 Years = $140,000
Investment made in 10 years (ignoring PV/FV Factors) = $88,800
Net Return in 10 Years would be $140,000 – 88,800 = $51,200
= 51,200/88,800 /10 = 0.0576 = 5.76%
ssignment Saved A financial planning service offers a college savings program. The plan calls for you...
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 %
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 $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?
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...
Your financial planner offers you two different investment plans. Plan X is an annual perpetuity of $10,000. Plan Y is an annuity for 16 years and an annual payment of $25,000. Both plans will make their first payment one year from today. At what discount rate would you be indifferent between these two plans? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
Your financial planner offers you two different investment plans. Plan X is a $14,000 annual perpetuity Plan Y is a 13-year, $20,000 annual annuity. Both plans will make their first payment one year from today At what discount rate would you be indifferent between these two plans? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Discount rate References eBook & Resources Learning Objective: 06-04 How interest rates are quoted (and...
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...
Finance math problems
6 You plan to deposit $4,500 at the end of each of the next 20 years into an account paying 9.7 percent interest a. How much money will you have in the account in 20 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. How much will you have if you make deposits for 40 years? (Do not round intermediate calculations and round your answer to 2 decimal places,...