Question

In: Finance

1-20 years 5 turbines Average hourly power output per turbine: 0.31 MWh Operational days per year...

1-20 years

5 turbines

Average hourly power output per turbine: 0.31 MWh

Operational days per year 363.00 days

Capital expenditure per turbine $3,000,000.00

Life 20.00 years (Turbines will be dismantled at end of 20 years if not overhauling.)

Salvage per turbine $200,000.00 (Market value at end of 20 years.)

Expected price per MWh of power in first year $80.00 (Price per MWh is then expected to increase at inflation.)

Expected price per MWh of renewable energy certificate in first year $70.00 (For each MWh generated by the wind turbines, SAI will be issued with a renewable energy certificate which it can sell to electricity retailers who have sold renewable energy to customers. Price of certificates is then expected to increase at inflation.)

Expected operating expenses per turbine in first year $100,000.00 (Annual operating expenses then expected to increase by inflation.)

Depreciation method- Straight Line

Working capital- $0 (Given service agreements, there is no working capital requirement)

Inflation Rate (p.a.) 0.026

Tax Rate 0.30 (Tax payment occurs at the same year as income)

Discount Rate 0.10

Additional Information to extend life to 40 years

Overhaul cost at end of 20th year per turbine $1,500,000.00

Life of overhaul 20.00 years

Salvage $0

Depreciation method of overhaul cost Straight Line (Overhaul expense is capitalised and then depreciated over extended life.)

Treatment of existing capital expenditure (e.g. original outlay) $0 (Remaining book value of original capital expenditure written down to zero in year 20.)

Calculate EBITDA, depreciation and gain/loss of sale for the extended life

Solutions

Expert Solution

EBITDA Calculations

Assumptions relevant for EBITDA calculation:

EBITDA calculation for 1st 20 Years:

EBITDA calculation only for extended Life [Years 21- 40]:

Depreciation Calculations

Concept 1- The book value of each turbine is assumed to be written down to 0 at the end of 20 Years, so irrespective of Market Value or Salvage Value, the original capital expenditure of the turbine is 100% depreciated in 20 Years or 5% per year

Concept 2 - The overhaul expenditure for each turbine is capitalised in the 20th year and then is taken to 0 by the 40th year, so again the depreciation is 100% in 20 years or 5% each year

Depreciation and Asset Value [Year 1 - 20]

Depreciation and Asset Value [Year 21 to 40]

Gain/Loss for Sale

We shall consider 2 cases here :

1) where there is no overhaul expenditure and the turbines are sold post 20 years to get salvage value of US$ 200,000 per turbine

2) Where there is capital expenditure on overhaul and then the turbines' run for another 20 years but there is no salvage value at the end of 40 years    

The Discount Factors are calculated as

Where the Discount Rate is given to be 10% and n = period of discounting (in effect the year of discounting)

So, as can be seen , the Overhaul case has a better NPV than the no overhaul case (though both are still negative) and it makes sense to spend the capex on overhauling the turbines rather than selling them at the end of 20 Years.


Related Solutions

1-20 years Average hourly power output per turbine                                 0.31 MWh
1-20 years Average hourly power output per turbine                                 0.31 MWh Operational days per year                             363.00 days Capital expenditure per turbine                  3,000,000.00 $ Life                               20.00 years Turbines will be dismantled at end of 20 years if not overhauling. Salvage per turbine                     200,000.00 $ Market value at end of 20 years. Expected price per MWh of power in first year                               80.00 $ Price per MWh is then expected to increase at inflation. Expected price per MWh...
If on average I receive 5 emails per day, how many days of the year do...
If on average I receive 5 emails per day, how many days of the year do I expect not to receive any email, and on how many days do I expect to receive 10 emails?
$800 per year for 10 years at 10%. $   $400 per year for 5 years at...
$800 per year for 10 years at 10%. $   $400 per year for 5 years at 5%. $   $800 per year for 5 years at 0%. $   Now rework parts a, b, and c assuming that payments are made at the beginning of each year; that is, they are annuities due. Present value of $800 per year for 10 years at 10%: $   Present value of $400 per year for 5 years at 5%: $   Present value of $800 per...
The average life a manufacturer's blender is 5 years, with a standard deviation of 1 year.
  The average life a manufacturer's blender is 5 years, with a standard deviation of 1 year. Assuming that the lives of these blenders follow approximately a normal distribution, find the probability that the mean life a random sample of 9 such blenders falls between 4.5 and 5.1 years. The answer is 0.5511
Estimate the generating cost per unit supplied from a power plant having data: Output per year...
Estimate the generating cost per unit supplied from a power plant having data: Output per year = 4 × 108 kWh, Load factor = 50%, Annual fixed charges = Rs. 40 per kW, Annual running charges = 4 paisa per kWh
how much more (or less) output will the average american have next year of the $20...
how much more (or less) output will the average american have next year of the $20 trillion gdp grows (or contracts) by: Assume a population of 340 million. if the economy contracts, be sure to put a (-) in front of your answers. a. 2 percent? b. 5 percent? c. -1 percent? d. 1.5 percent ? e. 4 percent ? f. 2.5 percent ?
An investment pays $1,950 per year for the first 5 years, $3,900 per year for the...
An investment pays $1,950 per year for the first 5 years, $3,900 per year for the next 6 years, and $5,850 per year the following 10 years (all payments are at the end of each year). If the discount rate is 10.95% compounding quarterly, what is the fair price of this investment? Work with 4 decimal places and round your answer to two decimal places. For example, if your answer is $345.667 round as 345.67 and if your answer is...
The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime...
The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime rate fluctuates with the day of week, so the number of the police officers required each day depends on which day of the week it is: Monday, 11; Tuesday, 12; Wednesday, 14; Thursday, 15; Friday, 14; Saturday, 18; Sunday;8. The Police Station wants to schedule police officers to maximize the number of the officers whose days off are consecutive. Formulate LP and solve the...
The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime...
The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime rate fluctuates with the day of week, so the number of the police officers required each day depends on which day of the week it is: Monday, 11; Tuesday, 12; Wednesday, 14; Thursday, 15; Friday, 14; Saturday, 18; Sunday;8. The Police Station wants to schedule police officers to maximize the number of the officers whose days off are consecutive. Formulate LP and solve the...
Problem 1: A. 10 equal annual end-of-the-year payments of $82,500 per year beginning in 20 years...
Problem 1: A. 10 equal annual end-of-the-year payments of $82,500 per year beginning in 20 years will be received B. One lump-sum of $1,000,000 in 30 years will be received C. One payment of $200,000 in 10 years, a second payment of $200,000 in 20 years, and a third payment of $200,000 in 30 years will be received Question: What is the present value of the policies at a discount rate of 4 percent? Please show all work in excel...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT