Development of a spreadsheet model

Assignment Help Financial Management
Reference no: EM131193230 , Length:

CASE STUDY: FINANCIAL MODELLING AND ETHICAL ISSUES IN FINANCE

Engie Group, a French-owned global energy company (formerly known as GDF Suez) which is the current owner and operator of the Loy Yang B power station precinct and operation located in the La Trobe Valley in South-Eastern Victoria, is assessing the feasibility of the development and operation of a new coal-fired power station in the La Trobe Valley region. The basis for this new project proposal is derived from a number of perspectives: i) the impending de-commissioning of the Loy Yang B power station at the end of its indicative 30- year operating life in 2025; ii) the availability of coal resources in the La Trobe Valley region to support ongoing coal-fired electricity generation activity; iii) the experience that the company has in the Victorian electricity market and expectation of ongoing population growth and demand for electricity provision; iv) uncertainty regarding the expected availability and sufficiency of alternative electricity generation sources at the proposed time of de- commissioning of the current Loy Yang B power station and v) perceived ongoing profitability from coal-fired electricity generation activity.

The company has completed some preliminary project development and planning work. The proposal involves the construction of the new power station in two stages, based on the following envisaged construction and operational schedule:

Table 1: Project Construction and Operation Summary

Year

Project Activity

2019

Construction begins on the project (assumed to be continuous until 2025)

2024

Commissioning of Generation Unit A

2026

Commissioning of Generation Unit B

2058

Generation Unit A ceases operation (based on a 35-year expected useful life)

2060

Generation Unit B ceased operation (based on a 35-year expected useful life)

As part of this planning the company has forecast the following specifications, requirements and parameters for the new project:

- The company would need to acquire access to land adjacent to the current coal open-cut facility it is operating to supply the Loy Yang B power station, which is owned by the State Government. The project would also need the overall approval of the State and Federal Governments to develop the project, as it would have a significant impact on electricity supply to the national electricity grid and also have major consequences for the future emission targets and objectives both locally and the overall commitment of the Australian Government to lower environmental emissions 26-28% relative to 2005 emission levels by 2030.

- Generating Units A and B would both be 250 Megawatt (MW) generating units representing self-generating energy processors functioning on coal as the primary input and incorporating a steam-to-turbine production method as the method of electricity generation. A 250MW generating unit operating at full capacity will produce 250 MW hours of electricity per hour.

- The useful life of each generating unit is 35 years.

- The average operating capacity factor of the power station is expected to be 90%.

- Expected within-station usage of 5% of the total electricity generated.

- The power station generation units are assumed to operate 24 hours a day, 365 days a year (ignoring leap years and industrial disputes).

- Due to the on-demand (base-load) nature of the electricity-generation process and the unavailability of a cost-effective storage source, 10% of the available electricity generated, on average, is not expected to be transmitted to the distribution grid or sold.

- The average tariff at which electricity can be sold to contractual customers (such as electricity retailers) or the national electricity regulator is $190.00 per Megawatt hour (in real terms). This tariff takes into account the cost and delivery of coal for operation of the power station, the replacement value of power station assets and an emission charge component.

- Operating and maintenance costs (outlined in Table 3 below) incorporate depreciation allowances on the capital construction costs, Government land charges and duties, staffing costs, inventory and supplies, and utilities costs (excluding electricity which is accessed directly from the operation of the power station).

- The company expects to have to pay company tax on profits created by operation of the power station at an average future marginal tax rate of 25%.

- The average rate of inflation over the life of the project is assumed to be 2.20% per annum.

- The estimated after-tax cost of capital (WACC) for the power station project based on the envisaged cash flow risk and target financing structure is 8.50% per annum.

- All figures are expressed in June 30, 2016 real dollars.

- All information is as at June 30, 2016.

- Note that 1 Megawatt hour represents 1,000 Kilowatt hours.

Estimated construction costs for the new power station project are as follows:

Table 2: Forecast Project Capital Construction Costs

Year

Estimated project construction costs

2019

$160.5 million

2020

$167.5 million

2021

$160.0 million

2022

$167.0 million

2023

$152.5 million

2024

$110.0 million

2025

$85.0 million

Estimated operating and maintenance costs for the new power station project are as follows:

Table 3: Forecast Annual Operating and Maintenance Costs

Year

Estimated Operating and Maintenance costs

2024

$70.0 million

2025

$95.0 million

2026

$118.5 million

2027 - 2058

$105.0 million

2059

$80.0 million

2060

$65.0 million

Engie Group has hired your consulting firm to conduct the financial modelling and capital budgeting assessment of the potential power station project, as well as to act as its adviser in dealing with the State and Federal Governments in negotiating the project approval process.

Required:

This case study requires the completion of the following tasks:

- The development of a spreadsheet model representing the cash flows associated with the power station project, and the assessment of the project using a range of capital budgeting evaluating techniques

- The completion of a risk assessment based on conducting sensitivity analysis of the project valuation focusing on key parameters impacting on the project's operation, feasibility and cash flows.

- Based on the project modelling and sensitivity analysis, a recommendation as to the feasibility of the project.

- The preparation of a proposal for the respective Governments providing justification for why approval for the project should be provided.

Attachment:- spreadsheet model.xlsx

Attachment:- notes.pdf

Verified Expert

This is a 2000 words assignment which talks about the cash flows associated with the power station project and the assessment of the project using a range of capital budgeting evaluating techniques for Engie Group. The current discussion will highlight financial modelling and ethical issues in finance for a French-owned global energy company, Engie Group. The work is written in Microsoft word with incited references. It follows APA style of referencing.

Reference no: EM131193230

Questions Cloud

What is the significance of identifying your goals : What is the significance of identifying your goals and interests when conducting a search for a particular position or career? Why is it important to identify the realities of specific professions that interest you? Consider and discuss how identi..
What is the problem with the education of engineers : According to the author, members of which profession are creating this landscape? Why might our geological era be dubbed the Anthropocene? How might future generations of archaeologists identify it? What is the problem with the education of enginee..
Are these bacteria beneficial dangerous or neutral : Discuss your answer to part (a). Are these bacteria beneficial, dangerous, or neutral? What functions could they serve?
Determine the effectiveness of their leadership : A manager's decision-making ability will determine the effectiveness of their leadership. In your experience, what are some of the factors that influence a leader's decision-making process?
Development of a spreadsheet model : CASE STUDIES IN FINANCE (FIN3CSF) - The development of a spreadsheet model representing the cash flows associated with the power station project, and the assessment of the project using a range of capital budgeting evaluating techniques
Terminated for accessing adult web sites : Recently, a longtime employee was terminated for accessing adult web sites on a company computer. Though the employee claimed that while doing a job-related Web search several adult ads popped up, records show the site addresses were actually keye..
Find the velocity of the centre of mass : Two blocks of masses m, and m2 are connected by a spring of spring constant k (figure 9-E15). The blockr of mass m2 is given a sharp impulse so that it acquires a velocity v0 towards right.
Provide visual presentation of data in situational analysis : For the situational analysis you are encouraged to provide any visual presentation of data in your situational analysis and use the analysis tools from your textbook and other analysis tools you have used in your program.
Healthcare delivery in america : There can be no doubt that managed care has impacted everyone involved with healthcare delivery in America. What do you see as some of the most significant impacts of managed care for patients?

Reviews

Write a Review

Financial Management Questions & Answers

  Company pledges to increase its dividend

Nofal Corporation will pay a $4.70 per share dividend next year. The company pledges to increase its dividend by 7.25 percent per year, indefinitely. Required: If you require a return of 10 percent on your investment, how much will you pay for the co..

  Find the future value and present value

Find the future value of today's $500 in 5 years under each of the following conditions. Find the present value of today's $10,000 in 5 years under each of the following conditions.

  Calculate the effective interest rate for short-term capital

Company Soony acquires short-term financing from 90-day notes payable with a principal of $100,000 and a nominal interest rate of 4%. It will roll these notes over (re-issue) new 90-day notes payable over the course of the year. Calculate the effecti..

  What is the maximum increase in money supply

Assume that the Federal Reserve injects $2 billion into the financial system. If the reserve requirement is 18%, what is the maximum increase in money supply? Why might the maximum increase not be achieved?

  Denote return for a portfolio consists of two assets

Let R denote return for a portfolio consists of two assets R=WR1+(1-w)R2. show that in the minimum variance portfolio risk asset gets low wieght adjusted by covariance with return if this asset ? for two incorrelated assets weights of portfolio which..

  What is the expected return given the historical data

What is the expected return given the following historical data? Now, solve for the standard deviation using that same data. Remember, we must divide by n-1 since we are working with a sample of data.

  What is the present value of the perpetuity

Suppose Auburn plans to pay Coach Malzahn a perpetuity if he wins a National Championship this season. The payment will be $37,000 each year for the rest of his life. Assume a 6% real interest rate. What is the present value of the perpetuity?

  What is the value of this bond to an investor

A $1,000 bond is issued with a coupon rate of 8 percent and 20 years to maturity five years ago. If this bond pays interest semi-annually, what is the value of this bond (TODAY) to an investor who requires an 8 percent rate of return?

  What was annual percentage increase in the winners check

The winner's prize money was $150. In 2006, the winner's check was $1,225,000. What was the annual percentage increase in the winner's check over this period? If the winner's prize increases at the same rate, what will it be in 2040?

  Which option strategy would you pursue

Assume that you own 200 shares of Duke Power (DUK)), which you bought for $64.00. You want to increase your return on this investment, but unwilling to take on any unnecessary risk. Which option strategy would you pursue?

  What is the price of the bond today

Over the past year (from 1 year ago to today), the inflation rate was 5.85 percent, the risk-free rate was 7.47 percent, and the real rate of return for a bond was 9.94 percent. The bond was priced at 1,198.72 dollars one year ago, pays annual coupon..

  Security market line formula rather then dividenddiscount

Using the security market line formula rather then the dividenddiscount formula, determine the expected return on a firm's common stock when: a) beta=1.0, b) the risk free rate is 4% and, c) marketplace interest rates have hovered around 9%.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd