all work must be done excel. i also need to know how to out the formulas into excel to get the answers for them. thank you so much.

C The cash flow for a business is shown below. What is the estimated rate of return on this project. n Cash Flow 0 - 1600 1500 1 1500 3 4 5 -400 700 -300 600 - 150 6 7 Rate of Return = -90.625 A company is building a powerplant. It is considering three alt Rate of Return = -90.625 A company is building a powerplant. It is considering three alternatives. Based on Benefit to cost ration, determine which project should be chosen. The estimated benefits and costs are as follows 20 Initial Investment Annual Recurring benefit Annual Recurring costs Salvage value A B C 100 160 220 25 55 8 18 25 8 22 2.5 1.388888889 2.2 Select Project = B Reason: The lowest 10 Project life = 40 years Int rate = 5% A company is buying a machine that will save them in labor cost. It also has some yearly maintenance costs. See the details below. Calculate the PW and IRR of this transaction. At the given MARR, is this a good purchase? 15000 8000 Initial Investment Annual Labor savings Annual maintenance cost Salvage value 2500 2000 N = 6 yrs MARR = 15% 6 PW= 0.15 IRR = Good/Bad 7000 46.66667 GOOD hasis of rate of Consider the following two projects. Which project would you select on the basis of rate of return, assuming MARR = 15% n A1 0 1 2 -9000 900 3500 5500 3200 1200 A2 - 12000 6000 3400 2300 2800 1600 A1 A2 ($124.94) ($1,098.52) 3 4 5 Select Project = A2 Reason: Highest Rate of Return . Test 3