Maximize Investment Returns Analysis
Budget: $30 – $250 USD
Prepare a 10-year annual project finance model (in Excel) and a brief executive summary (memo or max 3 slides) that answers the following:
Financial Outputs:
What are the projected 10-year financials (Income Statement, Cash Flow Waterfall) for the "Base Case"?
Key Ratios:
What is the Base Case Project IRR, Equity IRR, and NPV (use a 12% discount rate)?
Bankability Ratios:
What is the minimum and average DSCR?
Based on these ratios, is the project "bankable" in its Base Case? How long should tenor be to make this project bankable?
Sensitivity & Recommendation:
Show a 2-variable sensitivity analysis on Equity IRR based on:
Power Cost (OpEx): Low (-20%), Base, High (+20%)
Hosting Price (Revenue): Low (-20%), Base, High (+20%)
What is your final recommendation to the DEMA Investment Committee? Should we proceed, and what are the key risks to mitigate
Financial Outputs:
What are the projected 10-year financials (Income Statement, Cash Flow Waterfall) for the "Base Case"?
Key Ratios:
What is the Base Case Project IRR, Equity IRR, and NPV (use a 12% discount rate)?
Bankability Ratios:
What is the minimum and average DSCR?
Based on these ratios, is the project "bankable" in its Base Case? How long should tenor be to make this project bankable?
Sensitivity & Recommendation:
Show a 2-variable sensitivity analysis on Equity IRR based on:
Power Cost (OpEx): Low (-20%), Base, High (+20%)
Hosting Price (Revenue): Low (-20%), Base, High (+20%)
What is your final recommendation to the DEMA Investment Committee? Should we proceed, and what are the key risks to mitigate