- Please Help Using Excel With A Detailed Explanation 1 (40.84 KiB) Viewed 24 times
Please help using excel, with a detailed explanation.
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Please help using excel, with a detailed explanation.
Please help using excel, with a detailed explanation.
QUESTIONS Suppose you are required to analyse the financing cash flows for UQ solar farm in Warwick. The investment cost of the project is 125 million dollars and UQ has borrowed the full amount from Commonwealth Bank at an annual interest rate of 3.5%. The loan term equals the project life of 25 years. The solar farm is estimated to generate 120,000 megawatts (1 megawatt - 1000 kilowatts) of energy each year and will be sold to the grid at a fixed Feed-in-tariff rate of 15 cents per kilowatt. Assume a 5% discount rate, the NPV of the net cash flows of UQ solar farm is $ million and the IRR IS %. If the loan interest rate will be increased by 2% p.a. starting from year 6. The NPV will be changed to $ million and the IRR will be changed to %. By using the IRR rule, UQ should (accept/reject) the project. In your answer, decompose the principal, interest and net cash flow for UQ 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 commas (,) "$" 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 UQ solar farm in Warwick. The investment cost of the project is 125 million dollars and UQ has borrowed the full amount from Commonwealth Bank at an annual interest rate of 3.5%. The loan term equals the project life of 25 years. The solar farm is estimated to generate 120,000 megawatts (1 megawatt - 1000 kilowatts) of energy each year and will be sold to the grid at a fixed Feed-in-tariff rate of 15 cents per kilowatt. Assume a 5% discount rate, the NPV of the net cash flows of UQ solar farm is $ million and the IRR IS %. If the loan interest rate will be increased by 2% p.a. starting from year 6. The NPV will be changed to $ million and the IRR will be changed to %. By using the IRR rule, UQ should (accept/reject) the project. In your answer, decompose the principal, interest and net cash flow for UQ 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 commas (,) "$" or "%" in your answers. Ensure you show all your working in your spreadsheet.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!