Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose you are required to analyse the financing cash flows for UQ solar farm in Gatton. The investment cost of the project is 125 million

image text in transcribed Suppose you are required to analyse the financing cash flows for UQ solar farm in Gatton. 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. Assuming a 5.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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of The Economics Of Finance

Authors: George M. Constantinides, Milton Harris, Rene M. Stulz

1st Edition

044459406X, 978-0444594068

More Books

Students also viewed these Finance questions

Question

Is there a clear hierarchy of points in my outline?

Answered: 1 week ago