Please complete in excel and show all the formulas so I may be able to recreate the file myself

(a) For the following independent projects (A, B, C and D), find the BCR, NPV, and IRR. The required rate of return is 11.00%.p.a. (Assume all future cash flows only occur by the end of each year). Based on your results, which project(s) should be accepted and why. 1 4 5 6 7 200 Year A B D 0 -7,500 -4,000 -6,500 -3,500 2 2,500 1200 2,000 1,600 1,000 1200 2,000 1,600 3 2,300 1200 2,000 1,600 2000 1200 2,000 1500 1200 1000 1,000 -500 (3.5 marks) (b) AAA energy company is considering a project of solar energy plant. There are two different systems (rotating system and fixed system) under consideration. These two systems come with different cost and efficiency. Rotating system is better in efficiency and lasts for 10 years with higher cost. Fixed system is less efficient, but it lasts for 12 years and the cost is lower. The company has already secured the land usage contract for the energy plant. The local government has granted the company free usage of the land as long as it operates as support for green energy and environment. The company intends to operate the project for infinite time, which means that the systems will be replaced once they reached their maximum useful life. The project team provided some estimated figures as below: Detail Purchase Price Yearly Revenue Yearly Costs Salvage Value Useful Life Grade A $510,000 $135,000 ($12,000) $10,000 10 years Grade B $360,000 $100,000 ($7,000) $9,000 12 years Assuming it's a perfect capital market that there are no taxes or inflation, so the above figures won't change in the future. The project team conducted a further analysis and provided some information below: Project beta 1.4, risk free rate 5%.p.a, and market return 12%.p.a. Please complete the analysis for AAA energy company and provide advice on the choice of system