Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
| 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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Fundamentals of Cost Accounting
Authors: William Lanen, Shannon Anderson, Michael Maher
3rd Edition
9780078025525, 9780077517359, 77517350, 978-0077398194
