Question: Example 5: Future Value of Multiple Unequal Cash Flows Unfortunately, Excel does not have a function to calculate the future value of multiple cash flows

 Example 5: Future Value of Multiple Unequal Cash Flows Unfortunately, Excel

Example 5: Future Value of Multiple Unequal Cash Flows Unfortunately, Excel does not have a function to calculate the future value of multiple cash flows when the cash flows are of different amounts. However, we can calculate the t 1 2 Cash flow $ 10,000 15,000 2,000 19,000 16,500 3 4 5 Interest rat 10% What is the future value of these cash flows? We can set up a table to find the future value of each cash flow and sum the future values. Since we want the future value at year 5, we t Future value 1 2 3 4 5 Total: $

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!