Question

In: Finance

For both questions, please show what you typed into the TVM solver. N: I: PV: PMT:...

For both questions, please show what you typed into the TVM solver.

N:

I:

PV:

PMT:

FV:

Time of month: End or beginning

1. Rachel, who just turned 18, deposits a $15,000 gift into an interest-bearing account earning a 7.5% annual rate of interest. How much will she have in the account when she retires at age 60, assuming all interest is reinvested at the 7.5% rate? If Rachel decided she only needed $300,000 at retirement, could she retire at 59? Explain.

2. James deposited $800 at the end of the past 16 years to purchase his granddaughter, Kali, a car, James earned 8% interest compounded annually on his investment. If the car Kali chooses costs $22,999, would she have enough money in the account to purchase the vehicle? What would be the deficit or surplus?

Solutions

Expert Solution

Q1. Basically Rachel deposits 15000, so that is a cash outflow. therefore it should be input as a negative value in the PV. She deposited it at the completion of 18 years of age and we need to calculate the FV when she completed 60 years of age.

  • N: 60-18 = 42
  • I: 7.5
  • PV: -15000
  • PMT: 0
  • FV:   $312,785.60 (computed)
  • Time of month: End
  • Algebraic calculation are as follows:
    • So the FV is  $3,12,785.60

Now as the FV is greater that 300000, we can check whether it is the same if she retires at 59, that is after 42 compounding periods,

  • N: 59-18 = 41
  • I: 7.5
  • PV: -15000
  • PMT: 0
  • FV:   $2,90,963.35 (computed)
  • Time of month: End
  • Algebraic calculation are as follows:
    • So the FV is $2,90,963.35

FV is less than 300000 so she can't retire at the age of 59

Q2. James deposited $800 at the end of the past 16 years to purchase his granddaughter, Kali, a car, James earned 8% interest compounded annually on his investment. If the car Kali chooses costs $22,999, would she have enough money in the account to purchase the vehicle? What would be the deficit or surplus?

Basically James deposits 800 annually at the end of 16 years, so that is a cash outflow. therefore it should be input as a negative value in the PMT.

  • N = 16
  • I: 8
  • PV: 0
  • PMT: -800
  • FV:    $24,259.43  (computed)
  • Time of month: End
  • Algebraic calculation are as follows:
    • So the FV is $24259.43
    • If the amount required to buy the car is 22999, then we have sufficient amount in the fund to buy the same.

Related Solutions

With respect to $3888.38 = FV (I, N, PMT, PV) in Excel, what does the $3888.38...
With respect to $3888.38 = FV (I, N, PMT, PV) in Excel, what does the $3888.38 represent? (Note: The third element is a payment.) How do I explain the $3338.38 to a colleague?
PV=7210 PMT=490 N=5 FV=7000 How would i calculate the market rate, please show work
PV=7210 PMT=490 N=5 FV=7000 How would i calculate the market rate, please show work
PV=7210 PMT=490 N=5 FV=7000 How would i calculate the market rate, please show work
PV=7210 PMT=490 N=5 FV=7000 How would i calculate the market rate, please show work
PV=7210 PMT=490 N=5 FV=7000 How would i calculate the market rate, please show work
PV=7210 PMT=490 N=5 FV=7000 How would i calculate the market rate, please show work
Please explain the variables- PV, FV, N, PMT, I/Y, C/Y, and P/Y. Can you please write...
Please explain the variables- PV, FV, N, PMT, I/Y, C/Y, and P/Y. Can you please write equations that connect these variables? Can you please write equation for the arithmetic progression annuity?
PMT = (PV)i 1 − (1 + i)−n .A loan of $250,000 is amortized over 30...
PMT = (PV)i 1 − (1 + i)−n .A loan of $250,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.3%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the...
There are five time value of money components – FV, PV, N, I, and PMT. Briefly...
There are five time value of money components – FV, PV, N, I, and PMT. Briefly describe each and create a hypothetical and realistic calculation word problem to find one of the components
Please show all of the factors used in the calculation – PV, I/Y, N, etc. –...
Please show all of the factors used in the calculation – PV, I/Y, N, etc. – NOT just the answer. If the calculation involves an annuity, please indicate if it is an ordinary annuity or an annuity due. a. On January 1, 2019 Tom Jeffers come to you, his CPA, and tells you he wants to retire in 10 years. His life expectancy is 20 years from his retirement. How much should he deposit on December 31, 2028 to be...
I need this computer typed so I can read it, and please show work. thanks! You...
I need this computer typed so I can read it, and please show work. thanks! You purchase an ABC 10%, 30 Year bond with a $100 face value for 109.72 What is the yield to maturity of the bond? What is the current yield on the bond? What is the duration of the bond? If you bought the bond today and sold it after 1 year at a YTM of 10% what is your cash flow yield? What is your...
Please use PV, FV, R, PMT, N when answering. 1. Your best friend Frank just celebrated...
Please use PV, FV, R, PMT, N when answering. 1. Your best friend Frank just celebrated his 30th birthday and wants to start saving for his anticipated retirement. Frank plans to retire in 35 years and believes that he will have 20 good years of retirement and believes that if he can withdraw $90,000 at the end of each year, he can enjoy his retirement. Assume that a reasonable rate of interest for Frank for all scenarios presented below is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT