Question: I am having trouble figuring out this problem, I have to use excel but I am not experienced with Excel. If anyone can please help!

I am having trouble figuring out this problem, I have to use excel but I am not experienced with Excel. If anyone can please help! Thank you.

I am having trouble figuring out this problem, I have to use

For this discussion task we are going to use the attached excel template to calculate four TVM questions. We are going to use your age for a few of the calculations. If you don't want to use you age, pick a random number between 20 and 30 and use that. For FV, assume a wealth aunt gave you $1,000 savings bond at birth. Assume the interest rate you got on the bond was (100/YourAge)%. How much is the bond currently worth? For PV, the government announces a new retirement program- everybody will get $1,000,000 when they turn 65. If you discount that money at (100/YourAge)%, what is that money worth to you today? For Rate, you know your aunt gave you a $1,000 savings bond when you were born. It is now worth $4,000. What was the interest rate earned on the investment? In the NPER, you just deposited $20,000 in a savings account. You are earning (100/YourAge)% interest. How long will it take for your money to double? In your response, please submit the age you used and the answers you got the four variables. Please also attach your spreadsheet (rename it to include your name) with the last calculation inputs you used. 3 TVM Ch 5.xlsx

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!