Ive seen the anawer already on chegg, bur i just want to know the working out to the question.

QUESTIONS Suppose you are required to analyse the financing cash flows for solar farmin Warwick. The investment cost of the project is 125 million dollars and has borrowed the amount from Commonwealth Bank at an annual interest rate of 3.5M. The loan term equals the project life of 25 years. The solar farm is estimated to generate 120,000 megawatts megawatt - 1000 kilowatts) of energy each year and will be sold to the world at a fixed feed-in-tariff rate of 15 cents per kilowatt Assume a discount rate, the NPV of the net cash flows of Ug solar farm is $ 120.00 million and the RS 13.4 M. if the loan interest rate will be increased by 2% pa, starting from year 6. The NPV will be changed to $143.62 million and the IRR will be changed to 13.84 H. By using the IR rule, UQ should accept (accept/reject the project, in your answer, decompose the principal interest and net cash flow for using a conversion factor of 100,000 Assume there are no taxes paid on this project. (hint: calculate the remaining principal owed on the remaining 20 years of the loan) Provide your answers to two decimal places. Do not include any commasc.) "" or " in your answers. Ensure you show all your working in your spreadsheet QUESTIONS Suppose you are required to analyse the financing cash flows for solar farmin Warwick. The investment cost of the project is 125 million dollars and has borrowed the amount from Commonwealth Bank at an annual interest rate of 3.5M. The loan term equals the project life of 25 years. The solar farm is estimated to generate 120,000 megawatts megawatt - 1000 kilowatts) of energy each year and will be sold to the world at a fixed feed-in-tariff rate of 15 cents per kilowatt Assume a discount rate, the NPV of the net cash flows of Ug solar farm is $ 120.00 million and the RS 13.4 M. if the loan interest rate will be increased by 2% pa, starting from year 6. The NPV will be changed to $143.62 million and the IRR will be changed to 13.84 H. By using the IR rule, UQ should accept (accept/reject the project, in your answer, decompose the principal interest and net cash flow for using a conversion factor of 100,000 Assume there are no taxes paid on this project. (hint: calculate the remaining principal owed on the remaining 20 years of the loan) Provide your answers to two decimal places. Do not include any commasc.) "" or " in your answers. Ensure you show all your working in your spreadsheet