Suppose you are required to analyse the financing cash flows for UQ solar farm in Warwick....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
B3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these economics questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Your team of four people form a financial analysis team at Aussie Finance Consulting (AFC), a renowned financial institution. The executive management of AFC has assigned you a task to carry out a...
-
50 successes in 200 trials when p = 0.2. For the binomial experiments find the normal approximation for the probability of
-
Describe what a Chinese Wall is and which U.S. regulator would be concerned with issues involving the wall.
-
A woman on a dock is pulling in a rope fastened to the bow of a small boast. If the women's hands are 10 feet higher than the point where the rope is attached to the boat and if she is retrieving the...
-
What is a minute order?
-
Open a general journal form like the one in Exhibit 2-4, and label it Page 10. After opening the form, record the following transactions in the journal: Dec.14 Purchased equipment for $6,000, paying...
-
It is often said that the Fama French three factor model is a risk model. Explain why this might be the case. 15. Explain why the beta of a portfolio (or stock) doesn't matter under the Fama French...
-
Campbell Manufacturing Company (CMC) was started when it acquired $80,000 by issuing common stock. During the first year of operations, the company incurred specifically identifiable product costs...
-
An elastic sphere of 0.5-m diameter contains a gas at 115 kPa. Heating of the sphere causes it to increase to 0.62 m, and during this process the pressure is proportional to the sphere diameter....
-
1. How does the fast pace of markets impact make or buy decisions? 2. What role does marketing play in the NPD process? What are marketings responsibilities? 3. How are the attitude and culture of...
-
Succession planning Does Apple have a succession plan to replace the CEO if necessary? What details are provided about the succession plan? H. Executive pay Are executives paid with a mix of cash,...
-
If a person can jump a maximum horizontal distance of 3.0 m on the Earth, how far could that person jump on the Moon, where the acceleration due to gravity is g/6, where g = 9.80 m/s? Repeat for...
-
Wichita, Incorporated reported the following amounts on its financial statements prepared as of the end of the current accounting period: Revenues Expenses $230,000 219,600 $ 10,400 Net Income...
-
A constant force, F = (4.03, -2.10, 3.59) N, acts on an object of mass 18.1 kg, causing a displacement of that object by 7 == (3.95, 3.91, (expression error)) m. What is the total work done by this...
-
At the end of two years, the cash flow is $13,800. The discount (interest) rate in year one is 5%, and in year 2 is 10%. What is the net present value of that cash flow? Provide two significant...
-
The 2017 financial statements of the U.S. government are available at: https://www.fiscal.treasury.gov/fsreports/rpt/finrep/fr/fr_index.htm Use these to answer the following questions: a. Statement...
-
Walter, a single taxpayer, purchased a limited partnership interest in a tax shelter in 1985. He also acquired a rental house in 2012, which he actively manages. During 2012, Walter's share of the...
-
Please answer the following questions regarding the taxability of Social Security: a. A 68-year-old taxpayer has $20,000 in Social Security income and $100,000 in tax-free municipal bond income. Does...
-
In 2012, Michael has net short-term capital losses of $2,000, a net long-term capital loss of $45,000, and other ordinary taxable income of $45,000. a. Calculate the amount of Michael's deduction for...
-
Describe one occasion where you have been influenced to buy a product or engage in an activity as a direct result of an item of corporate communication, eg social media update; and explain what that...
-
What are the elements of a master budget?
-
Discuss the potential conflict between using a budget as a motivational device and as a means of control.
Study smarter with the SolutionInn App