Excel can be used!

A company has a policy of requiring a rate of return on investment of 11%. Two investment alternatives are available but the company may choose only one. Alternative 1 offers a return of $45,000 at the end of year five, $75,000 at the end of year nine and $30,000 after eleven years. Alternative 2 will return the company $800 at the end of each month for the next eleven years. Compute the present value of each alternative and determine the preferred alternative according to the discounted cash flow criterion The present value of Alternative 1 is $ (Round to the nearest dollar as needed. Round all intermediate values to six decimal places as needed.) The present value of Alternative 2 is $ (Round to the nearest dollar as needed. Round all intermediate values to six decimal places as needed.) The preferred choice is Alternative 2 C Alternative 1. ss