The ABC Ltd is considering an investment project in the renewable energy sector. The company plans to build a solar power plant at a cost of GHS 10 million. The solar panels are expected to go on sale a year from now and the project is estimated to last 10 years. The table below shows the estimated demand for the Solar panels. 1 2 3 4 5 6 7 8 9 10 YEARS DEMAND/QTY 2000 2500 2600 3000 4000 5000 6100 5000 2000 1500 The price of solar panels today is GHS 5000. This price is expected to increase by 10% every year for the next ten years. The unit cost of production is estimated at GHS 3000 today. This is also expected to increase by 10% every year. The plant, which cost GHS 10 million will be depreciated on a straight-line basis. It would be worth GHS 2 million at the end of the period. The company intends to borrow GHS 4 million of the GH10 million initial investment in the plant. The lending bank has agreed to charge an interest rate of 15% per annum on this deal. This amount will be constant over the ten years. The tax rate for projects of this nature is 25%. Investment in Networking capital is expected to be 1 million at the start of the project. This will remain a 20% of revenue for the respective years. At the end of the project's life, all investments in working capital shall be recovered. The project is estimated to have a beta of 2. The interest rate on the market portfolio is 25% and the risk-free rate is 10%. Required i. ii. 111. iv. vi. vii. viii. Prepare the Proforma Income Statement Calculate the operational cash flow for each year. Determine the net working capital investment and recovery. Compute Free Cash Flows to the firm's investors. Compute the Cost of equity for this project using the Capital Asset Pricing Model. Compute the overall cost of Capital for this project(WACC) Compute the Net Present Value (NPV) of the project. Calculate the Internal Rate of Return (IRR) of the project and evaluate its viability. (Hint: Use a rate of 35% as your second interest rate) ix. Use Excel Functions to confirm your NPV and IRR calculations. (You should use Microsoft Excel but show clearly how you arrived at your figures)