please help me solve this problem with excel formulas please and thank you!!
a]
present value of each deposit = deposit amount / (1 + discount rate)n
where n = number of years after which the deposit is made
total present value of deposits = $45,963
b]
present value of each withdrawal = withdrawal amount / (1 + discount rate)n
where n = number of years after which the withdrawal is made
total present value of withdrawals = $24,428
c]
This is not a good investment as the total present value of withdrawals is lower than the total present value of deposits
d]
No, the answer would not change.
At a discount rate of 4%, the total present value of withdrawals is still lower than the total present value of deposits
please help me solve this problem with excel formulas please and thank you!! A financial planning...
Suppose that the parents of a young child decide to make annual deposits into a savings account, with the first deposit being made on the child's fifth birthday and the last deposit being made on the 15th birthday. Then, starting on the child's 18th birthday, the withdrawals as shown will be made. If the effective annual interest rate is 4% this period of time, what are the annual deposits (A) in years 5 through 15? Please round your answer to...
Suppose that the parents of a young child decide to make account, with the first deposit being made on the child's fifth being made on the 15th birthday. Then, starting on the c annual deposits into a saving hild's 18th birthday (EOY), four withdrawals will be made. The sequence of the amounts o f withdrawals is $2000, $2400, $2800, and $3200. If the effecti ve annual interest rate is8% during this period, what are the annual deposits in years 5...
Please choose one answer A,B,C or D thank you. Suppose that a young couple has just had their first baby and they wish to insure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 9%. The parents deposit S2 300 on their daughter's first birthday...
Suppose that the parents of a young child decide to make annual deposits into a savings account, with the first deposit being made on the child's fifth birthday and the last deposit being made on the 15th birthday. Then, starting on the child's 18th birthday, the withdrawals as shown on the diagram below will be made. If the effective annual interest rate is 6% during this period of time, what are the annual deposits in years 5 through 15? Use...
On the day his baby is born, a father decides to establish a savings account for the child’s college education. Any money that is put into the account will earn an interest rate of 9% compounded annually. The father will make a series of annual deposits in equal amounts on each of his child´s birthdays from the 1st through the 18th so that the child can make four annual withdrawals from the account in the amount of $35,000 on each...
Score: 0 of 1 pt | 4 of 7 (5 complete) HW Score: 66.67%, & Problem 4-81 (algorithmic) Question H Suppose that the parents of a young child decide to make annual deposits into a savings account, with the first deposit being made on the child's fifth birthday and the last deposit being made on the 15th birthday. Then, starting on the child's 18th birthday, the withdrawals as shown on the diagram below will be made. If the effective annual...
Suppose that a young couple has just had their first baby and they wish to insure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 9%. The parents deposit $2400 on their daughter's first birthday. After 10 payments, they increase the annual amount to $4,000....
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 %
QUESTION 6 Suppose that a young couple has just had their first baby and they wish to insure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 9%. The parents deposit $2400 on their daughter's first birthday and plan to increase the size of their...
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