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 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
Get step-by-step solutions from verified subject matter experts
