Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Terrorist Finance

Authors: T. Wittig

2011th Edition

0230291848, 978-0230291843

More Books

Students also viewed these Finance questions

Question

5.6 Evaluate methods used to treat phobic disorders.

Answered: 1 week ago

Question

8. Describe how cultural spaces are formed.

Answered: 1 week ago