View the video Calculate the Future Value of Uneven Cash Flows at the link below:https://www.youtube.com/embed/dgelQWX59UI 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,800End of year 2: $4,400End of year 3: $5,100End of year 4: $5,800Note: Since the last payment is at the end of year 4, this is the start of year 5 so no compounding 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?

If you invest $3,000 today, $5,000 one year from now, and $3,000 two years from now, approximately how much money will you have at the end of the third year if you invest in a fund paying 7%?

Steve purchases preferred stock in Berklee Corporation, with each share paying a $2.50 dividend. This dividend will remain constant. If the public’s required rate of return for Berklee stock is 8%, at what price should this company’s stock sell?

What is the future value of annual payments of $3,000 for 15 years at 2 percent?

What is the present value of a perpetuity of $17 per year growing at 2 percent per year with a discount rate of 10 percent?

Complete the following table by calculating the missing values: 

10. Which of the following statements is correct:

Capture13.png

Capture1.png

Capture8.png