A new business opportunity has presented itself. The business venture is expected to last for ten…

A new business opportunity has presented itself. The business venture is expected to last for ten years. For the first four years, negative cash flows of $35,000 per year are expected at the end of each year. No net cash flow is expected at the end of year five. A positive cash flow of $37,000 is anticipated at the end of year six. A positive cash flow of $49,000 is expected at the end of years seven through t?n. At the end of year ten, the business will be sold for $300,000. What is the present value of all of the future cash flows, assuming a 18% annual cost of capital? HINT: Use a timeline. If the business venture will cost you $183,000 to establish today, what is the net present value of the business venture? Should you pursue it? Then using Excel, prepare an amortization table for the mortgage. Obtain the results for the first fifteen periods and include the results with your completed assignment. On the same page, show the overall sums for the relevant columns over the full period of the mortgage.