Time Value of Money - Future Value of Uneven Cash Flows
The tutorial is about calculating the future value of uneven cash flows using two methods. Future value can be determined by either manually calculating the future value of each cash flow and then summing them up or by first calculating the net present value (NPV) and then converting it to future value. In the manual method, the future value of each cash flow is calculated individually using the future value formula: FV = PV * (1 + r)^n, where PV is the present value of the cash flow, r is the interest rate, and n is the number of periods. This method is an example where cash flows are invested at the end of each year and calculates the future value after four years. In the Excel method, the presenter shows how to calculate the NPV of all cash flows at year zero using the NPV function. Then, the NPV is converted to future value using the FV function, considering the desired number of periods. This method is advantageous for complex scenarios involving multiple cash flows over various ...