Question
Compute the future value and present value of Cash Flows You need to use the functions built in in excel to answer the question. Manually
Compute the future value and present value of Cash Flows | |||||||
You need to use the functions built in in excel to answer the question. Manually fill in the answer will receive 0 point | |||||||
a) What is the future value of these cash flows at the end of year 9 (Assume CFs occur at the end of each year)? |
Year | CF |
1 | 15,000 |
2 | 17,000 |
3 | 21,040 |
4 | 22,987 |
5 | 24,000 |
6 | 35,800 |
7 | 21,900 |
8 | 15,890 |
9 | 24,000 |
Interest rate = | 6% |
b) Compute the present value of the CFs in part a) |
c) Repeat part a and b with the cash flows occur at the beginning of the period instead. |
Year | CF |
1 | 15,000 |
2 | 35,000 |
3 | 24,000 |
4 | 17,000 |
5 | 12,500 |
6 | 35,800 |
7 | 24,000 |
8 | 15,890 |
9 | 20,000 |
Step by Step Solution
3.40 Rating (144 Votes )
There are 3 Steps involved in it
Step: 1
Step1 A We need to calculate the future value of cash flows So we will use the FV function in excel to calculate this answer Just type FV in any cell ...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 StartedRecommended Textbook for
Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
8th Edition
1285190904, 978-1305176348, 1305176340, 978-1285190907
Students also viewed these Finance questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App