use excel sheet and show all work please!

M8 Activity 1: High Flyers High Flyers is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows: Initial Investment( for 2 balloons) $500,000o Useful life 5 years Salvage Value Annual net income generated from additional flights Cost of Capital for High Flyers Help High Flyers evaluate this project by calculating $150,000o $60,000 11% 1. Net Present Value( the long way- see p. 355 for example 2. Net Present Value (using the excel formula NPV) 3. Recalculate NPV with cost of capital@15% 4. Based on your calculation of NPV, what would you estimate your project's internal rate of return to be? 5 Use excel's IRR function to determine the IRR. Was your estimate close? 6. Payback Period 7. Simple Rate of Return 8. Assume that High Flyers has the following quidelines for its screening preferences .Cost of Capital 11% . IRR of 12% . Payback period of 5 years or less Simple rate of return-10% Based on these guidelines, would this project "make the cut"? Explain