Perform scenario analysis on the electricity cost and present the summary of results. I'm not sure how
Fantastic news! We've Found the answer you've been seeking!
Question:
Perform scenario analysis on the electricity cost and present the summary of results. I'm not sure how to calculate IRR and if there is any other info I need. The discount rate is 7.08%.Below is the scenario summary. not sure what else I need | ||||||||||||
Ref case Year 1 | High Oil $0.0722 | Low Oil $0.0729 | High+gas $0.0718 | Low+gas $0.0730 | High res $0.0719 | $0.0000 | ||||||
Year 2 | $0.0722 | $0.0722 | $0.0733 | $0.0716 | $0.0724 | $0.0726 | n | |||||
Year 3 | $0.0728 | $0.0728 | $0.0736 | $0.0724 | $0.0716 | $0.0731 | ||||||
Year 4 | $0.0736 | $0.0736 | $0.0746 | $0.0731 | $0.0716 | $0.0739 | 10.12 | 10.67 | 11.31 | |||
Year 5 | $0.0741 | $0.0741 | $0.0751 | $0.0738 | $0.0714 | $0.0745 | 10.09 | 10.74 | 11.34 | |||
Result Cells: | 10.12 | 10.86 | 11.36 | |||||||||
Project_NPV | $344.3 Mil | $707.7 Mil | $561.8 Mil | $332.5 Mil | $157.1 Mil | $56.9 Mil | 10.22 | 11.02 | 11.49 | |||
Project_IRR | 10.26 | 11.13 | 11.52 |
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-0077398194
3rd Edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date: