Answer is $5,085.48
Solution:
We can solve this problem with 3 steps, i.e.
Step 1: Find out the present value of annuity of $40,000 for 5 years.
Step 2: Find present value of "answer to Step 1" for 4 years.
Step 3: Use future value of annuity formula, Where future value of annuity will be "answer to Step 2".
Step 1:

Where,
PVA = Present Value of Annuity
A = Annuity
i = rate of interest
n = number of years


Step 2:

FV = Future Value ( 4 years from last payment)
PV = Present Value (Balance amount that should be at the end of
last payment)
i = rate of interest
n = number of periods


Step 3:

Where,
FVA = Future Value of Annuity. ($106,269.27 from step 2)
A = Annuity (to find)
i = rate of interest
n = number of years


Therefore, their yearly contributions must be $5,085.48.
Brianna and Ricky plan to send their daughter to university. To pay for this they will...
Tiffany and Levi plan to send their son to university. To pay for this they will contribute 9 equal yearly payments to an account bearing interest at the APR of 3.1%, compounded annually. Five years after their last contribution, they will begin the first of five, yearly, withdrawals of $56,400 to pay the university's bills. How large must their yearly contributions be? Please show your work.
Sam and Brian plan to send their son to university. To pay for this they will contribute equal monthly payments to an account bearing interest at an annual rate of 4.8%, compounded monthly. They will make these payments for 10 years. Five years after their last contribution, they will begin the first of 60 monthly withdrawals of $2,960 to pay the university's installment bills. How large must their monthly contributions be? Answer = $ 554.81 X (Round to the nearest...
You are saving for your child's college education. You plan on making a total of six tuition payments each one-year apart. The annual estimated tuition payment will be made 14-years from today and you estimate that payment will be $50,000. The remaining five-payments will be made from t=15 to t=19. You decide to make 15 yearly contributions into an investment account. The first contribution is made today and your last contribution will be at t=14, you expect your investment account...
You just borrowed $300,000 to buy a house. You plan to pay off your loan by making equal monthly payments over the next 20 years. Suppose the interest rate your bank charges you is an APR of 6%, compounded semi-annually. What is the principal payback for the last month in Year 20? $2126.07 $2136.57 $1250 $1500 $1879.22
1. Suppose that you are age 25 today and plan on retiring at age 65. You determined that you need to have saved $659754 in real dollars by the time you retire. How much must you contribute (in real dollars) each year to your retirement account to achieve your goal? Assume the following: you make annual contributions; each contribution is the same amount in real dollars; the first contribution will be one year from today; your last contribution will be...
Q1. After 18 years, how much money will we have for the university education for our 3 children? If we invest in the given below option: Current savings = $20,000 semi-monthly contribution of $150 at the end of each period, set aside for the next 18 years = $150 (semi-monthly contribution) average annual rate of return compounded semi-monthly = 8% Please use (display + name) the excel function/ formula for all questions 1. University education savings plan APR 8.00% period...
Suppose you are a financial planner at Tangerine Bank, A client of yours has recently become a parent. The family wants to open up an RESP account for their child to save for her university expenses, They plan to send their daughter to study Bachelor of Commerce at UOIT, at the age of 18. (solve using excel formulas) 1. How much should they save before her school starts 2. For that, how much should the parents save in the account...
1. You are current saving for your son's college expenses (tuition, room/board). She is 10 years old and will begin college in 8 years. Set aside for her education you have a brokerage account with $10,000 fully invested in an equity index fund that is expected to earn 10% per year. Your plan is to send your son to a public school where the expenses are currently (at T = 0) $18,000 per year, however you expect the expenses to...
Please solve the following time value of money problem: John's Retirement Contribution John, 22 is about to begin his career as a rocket scientist for a NASA contractor. Being a rocket scientist, John knows that he should begin saving for retirement immediately Part of his inspiration came from reading an article on Social Security in Newsweek. The article indicated that the ratio of workers paying taxes to retirees collecting checks will drop dramatically in the future. In fact, the number...
You are currently saving for your spouse's college expenses (tuition, room/board). She is 20 years old and will begin college in 8 years. Set aside for his education you have a brokerage account with $10,000 fully invested in an equity index fund that is expected to earn 10% per year. Your plan is to send your wife to a state school where the expenses are currently (at T = 0) $18,000 per year, however, you expect the expenses to grow...