Watch Future Value of Uneven Cash Flows; then, answer the fo…
Watch Future Value of Uneven Cash Flows; then, answer the following questions: Using Excel, determine the future value of this series of expected unequal receipts five years from now if each payment is received at the end of each year, beginning one year from now, and the interest rate is 6% compounded annually. End of year 1: $3,800 End of year 2: $4,400 End of year 3: $5,100 End of year 4: $5,800 Note: Since the last payment is at the end of year 4, this is the start of year 5, so no compounding is needed for this cash flow. 2. When using Excel’s built-in Future Value function, why does Dr. Konners enter dollar amounts as negative numbers?