# Project #78037 - Time Value of Money

Problem Assignment: Time Value of Money
Use Excel Functions to correctly calculate answers to all problems below
Explain in words what you do to make each calculation
Explain in words what the answers mean
In problems with an A and B part, explain what you learn from the difference

1

Point Value Point Value 5.0%

2

Point Value Point Value 5.0%

3 a

3 b

Answer: You calculate         Point Value 10.0%

4 a

Answer: 25.55 years         Point Value 5.0%

4 b

Answer: You calculate         Point Value 10.0%

 5 a

5 b

Answer: You calculate         Point Value 10.0%

6

Point Value 7.5%

7

Point Value 7.5%

 8 a

8 b

Answer: You calculate         Point Value 10.0%

9

Year Cash Flow
2016 \$22,000
2017 \$24,000
2018 \$29,000
2019 \$30,000
2020 \$31,000
2021 \$27,000
2022 \$22,000
2023 \$15,000
2024 \$12,000

Be sure to explain what you do in words.
Also, tell what the answer means.
In problems with both part a and part b, compare the two answers.
In each case, you should be able to do part b if you can do part a. Total 100.0%

 Subject Business Due By (Pacific Time) 08/03/2015 12:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews