You are offered a business partnership that guarantees you cash returns of $150,000 one year from now,nothing at the end of year 2, and $350,000 at the end of year 3. After year 3, the partnership will bedissolved, and there will be no more expected returns on your investment. If you analyze this planexpecting 7% compounded annually, what is this potential deal worth to you today?

You agree to repay a loan over five years with the following stream of cash payments: $1,000; $1,100; $1,250; $1,280; and $1,300. If you wish to discount these payments to their present value today using 4%, why can you not use one annuity calculation, as seen in previous chapters?

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