Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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.xlsxStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started