In: Finance
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 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  | 
 -  | 
 $  | 
 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  | 
 -  | 
 $  | 
|
| 
 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)  | 
 -  | 
 $  | 
 Remaining book value of original capital expenditure written down to zero in year 20.  | 
Calculate the free cash flows for the extended life of 40 years
| Inflation | 2.60% | Interest Rate | 30% | Price of MWH | 80+70 | 150 | |||
| Discount rate | 10% | Annual production | 0.31*24*363 MWH | 2700.72 | |||||
| Year | Cash outflow | Revenue | Operation cost | Depreciation | Cash before Tax | Tax | Cash after Tax | Add back Depreciation | Net free cash flow from operation | 
| 0 | -$30,00,000.00 | -$30,00,000.00 | $0.00 | $0.00 | $0.00 | -$30,00,000.00 | |||
| 1 | $4,05,108.00 | -$1,00,000.00 | -$1,40,000.00 | $1,65,108.00 | -$49,532.40 | $1,15,575.60 | $1,40,000.00 | $2,55,575.60 | |
| 2 | $4,15,640.81 | -$1,02,600.00 | -$1,40,000.00 | $1,73,040.81 | -$51,912.24 | $1,21,128.57 | $1,40,000.00 | $2,61,128.57 | |
| 3 | $4,26,447.47 | -$1,05,267.60 | -$1,40,000.00 | $1,81,179.87 | -$54,353.96 | $1,26,825.91 | $1,40,000.00 | $2,66,825.91 | |
| 4 | $4,37,535.10 | -$1,08,004.56 | -$1,40,000.00 | $1,89,530.55 | -$56,859.16 | $1,32,671.38 | $1,40,000.00 | $2,72,671.38 | |
| 5 | $4,48,911.02 | -$1,10,812.68 | -$1,40,000.00 | $1,98,098.34 | -$59,429.50 | $1,38,668.84 | $1,40,000.00 | $2,78,668.84 | |
| 6 | $4,60,582.70 | -$1,13,693.81 | -$1,40,000.00 | $2,06,888.90 | -$62,066.67 | $1,44,822.23 | $1,40,000.00 | $2,84,822.23 | |
| 7 | $4,72,557.85 | -$1,16,649.84 | -$1,40,000.00 | $2,15,908.01 | -$64,772.40 | $1,51,135.61 | $1,40,000.00 | $2,91,135.61 | |
| 8 | $4,84,844.36 | -$1,19,682.74 | -$1,40,000.00 | $2,25,161.62 | -$67,548.48 | $1,57,613.13 | $1,40,000.00 | $2,97,613.13 | |
| 9 | $4,97,450.31 | -$1,22,794.49 | -$1,40,000.00 | $2,34,655.82 | -$70,396.75 | $1,64,259.07 | $1,40,000.00 | $3,04,259.07 | |
| 10 | $5,10,384.02 | -$1,25,987.15 | -$1,40,000.00 | $2,44,396.87 | -$73,319.06 | $1,71,077.81 | $1,40,000.00 | $3,11,077.81 | |
| 11 | $5,23,654.00 | -$1,29,262.81 | -$1,40,000.00 | $2,54,391.19 | -$76,317.36 | $1,78,073.83 | $1,40,000.00 | $3,18,073.83 | |
| 12 | $5,37,269.01 | -$1,32,623.65 | -$1,40,000.00 | $2,64,645.36 | -$79,393.61 | $1,85,251.75 | $1,40,000.00 | $3,25,251.75 | |
| 13 | $5,51,238.00 | -$1,36,071.86 | -$1,40,000.00 | $2,75,166.14 | -$82,549.84 | $1,92,616.30 | $1,40,000.00 | $3,32,616.30 | |
| 14 | $5,65,570.19 | -$1,39,609.73 | -$1,40,000.00 | $2,85,960.46 | -$85,788.14 | $2,00,172.32 | $1,40,000.00 | $3,40,172.32 | |
| 15 | $5,80,275.01 | -$1,43,239.58 | -$1,40,000.00 | $2,97,035.43 | -$89,110.63 | $2,07,924.80 | $1,40,000.00 | $3,47,924.80 | |
| 16 | $5,95,362.16 | -$1,46,963.81 | -$1,40,000.00 | $3,08,398.35 | -$92,519.51 | $2,15,878.85 | $1,40,000.00 | $3,55,878.85 | |
| 17 | $6,10,841.58 | -$1,50,784.87 | -$1,40,000.00 | $3,20,056.71 | -$96,017.01 | $2,24,039.70 | $1,40,000.00 | $3,64,039.70 | |
| 18 | $6,26,723.46 | -$1,54,705.28 | -$1,40,000.00 | $3,32,018.18 | -$99,605.45 | $2,32,412.73 | $1,40,000.00 | $3,72,412.73 | |
| 19 | $6,43,018.27 | -$1,58,727.62 | -$1,40,000.00 | $3,44,290.66 | -$1,03,287.20 | $2,41,003.46 | $1,40,000.00 | $3,81,003.46 | |
| 20 | -$15,00,000.00 | $6,59,736.75 | -$1,62,854.53 | -$1,40,000.00 | -$11,43,117.79 | $3,42,935.34 | -$8,00,182.45 | $1,40,000.00 | -$6,60,182.45 | 
| 21 | $6,76,889.90 | -$1,67,088.75 | -$85,000.00 | $4,24,801.15 | -$1,27,440.34 | $2,97,360.80 | $85,000.00 | $3,82,360.80 | |
| 22 | $6,94,489.04 | -$1,71,433.06 | -$85,000.00 | $4,38,055.98 | -$1,31,416.79 | $3,06,639.19 | $85,000.00 | $3,91,639.19 | |
| 23 | $7,12,545.75 | -$1,75,890.32 | -$85,000.00 | $4,51,655.44 | -$1,35,496.63 | $3,16,158.80 | $85,000.00 | $4,01,158.80 | |
| 24 | $7,31,071.94 | -$1,80,463.47 | -$85,000.00 | $4,65,608.48 | -$1,39,682.54 | $3,25,925.93 | $85,000.00 | $4,10,925.93 | |
| 25 | $7,50,079.81 | -$1,85,155.52 | -$85,000.00 | $4,79,924.30 | -$1,43,977.29 | $3,35,947.01 | $85,000.00 | $4,20,947.01 | |
| 26 | $7,69,581.89 | -$1,89,969.56 | -$85,000.00 | $4,94,612.33 | -$1,48,383.70 | $3,46,228.63 | $85,000.00 | $4,31,228.63 | |
| 27 | $7,89,591.02 | -$1,94,908.77 | -$85,000.00 | $5,09,682.25 | -$1,52,904.67 | $3,56,777.57 | $85,000.00 | $4,41,777.57 | |
| 28 | $8,10,120.39 | -$1,99,976.40 | -$85,000.00 | $5,25,143.99 | -$1,57,543.20 | $3,67,600.79 | $85,000.00 | $4,52,600.79 | |
| 29 | $8,31,183.52 | -$2,05,175.78 | -$85,000.00 | $5,41,007.73 | -$1,62,302.32 | $3,78,705.41 | $85,000.00 | $4,63,705.41 | |
| 30 | $8,52,794.29 | -$2,10,510.35 | -$85,000.00 | $5,57,283.93 | -$1,67,185.18 | $3,90,098.75 | $85,000.00 | $4,75,098.75 | |
| 31 | $8,74,966.94 | -$2,15,983.62 | -$85,000.00 | $5,73,983.31 | -$1,72,194.99 | $4,01,788.32 | $85,000.00 | $4,86,788.32 | |
| 32 | $8,97,716.08 | -$2,21,599.20 | -$85,000.00 | $5,91,116.88 | -$1,77,335.06 | $4,13,781.82 | $85,000.00 | $4,98,781.82 | |
| 33 | $9,21,056.70 | -$2,27,360.78 | -$85,000.00 | $6,08,695.92 | -$1,82,608.78 | $4,26,087.14 | $85,000.00 | $5,11,087.14 | |
| 34 | $9,45,004.17 | -$2,33,272.16 | -$85,000.00 | $6,26,732.01 | -$1,88,019.60 | $4,38,712.41 | $85,000.00 | $5,23,712.41 | |
| 35 | $9,69,574.28 | -$2,39,337.23 | -$85,000.00 | $6,45,237.05 | -$1,93,571.11 | $4,51,665.93 | $85,000.00 | $5,36,665.93 | |
| 36 | $9,94,783.21 | -$2,45,560.00 | -$85,000.00 | $6,64,223.21 | -$1,99,266.96 | $4,64,956.25 | $85,000.00 | $5,49,956.25 | |
| 37 | $10,20,647.57 | -$2,51,944.56 | -$85,000.00 | $6,83,703.01 | -$2,05,110.90 | $4,78,592.11 | $85,000.00 | $5,63,592.11 | |
| 38 | $10,47,184.41 | -$2,58,495.12 | -$85,000.00 | $7,03,689.29 | -$2,11,106.79 | $4,92,582.50 | $85,000.00 | $5,77,582.50 | |
| 39 | $10,74,411.21 | -$2,65,215.99 | -$85,000.00 | $7,24,195.21 | -$2,17,258.56 | $5,06,936.65 | $85,000.00 | $5,91,936.65 | |
| 40 | $11,02,345.90 | -$2,72,111.61 | -$85,000.00 | $7,45,234.29 | -$2,23,570.29 | $5,21,664.00 | $85,000.00 | $6,06,664.00 |