please complete all 1-5 problems using excel. Please show forumulas or explain fully. Thanks!

Problem 1 - 10 points Determine the rate of return for the following cash flow. Year Net cash flow 12348000090004000070000 Problem 2-10 points If 200,000 is available for investment and 60,000 is invested at 20% per year with the remainder is invested at 12% per year. What is the overall rate of return on the 200,000 ? Problem 3-10 points Company B must choose one of two methods for its validation activity. Based on the information below, perform a incremental rate of return analysis and make recommendation. MARR = 12% MethodlaitialCostAnnualOperationCostincreasingby5000X100,00030,000inyearoneY250000SalvageValue20,000cachyear0060,0006 Problem 410 points Company C is seeking for help to decide this option to choose to upgrade their current bottleneck equipment or they should stay with the current equipment (without improvement) There are two vendors and one rental option. The cost details are shown in the table below. All the options will have four-year life time. OptionlaitialCostA3100029000345004900041000BCDEE Annual Operation 1600019300152001200015300 Cost Make your recommendation based on MARR =6% per year compounded monthly. Problem 5 - 10 points Company D needs to decide which option to choose for their pipeline routings. Anaual Operation Cost 30,000,000 6,000,000 Maintenance cost per 50,000,00030,000,000 every 20 years Estimated Life in Year Infinite Infinite Which option would you recommend? MARR =7%