0% found this document useful (0 votes)
7 views4 pages

Equity Investor Project Financial Model

Uploaded by

James B Mickey
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
7 views4 pages

Equity Investor Project Financial Model

Uploaded by

James B Mickey
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Background

build a model from scratch and take the view of an equity investor/buyer,

Task

You are going to build this project Financial Model bases on these inputs:

 You are the investor/buyer and are evaluating whether you should
buy this project. You are considering buying 100% of the project’s
levered cash flows (i.e., you are just buying the equity shares, which
means debt stays on).

You are the investor/buyer and are evaluating whether you should buy this
project. You are considering buying 100% of the project’s levered cash flows
(i.e., you are just buying the equity shares, which means debt stays on).

You are considering buying this project at COD (i.e., after construction ends),
so when calculating your purchase price, you are looking at cash flows
starting in year 1 (vs year 0).

Use the following inputs:

Project Information

• Nameplate capacity: 205 MW

• Useful life: 40 years

• Project capex: $1.20/W

Production

• P50 Capacity factor: 26.57%

• P99 Capacity factor: 23.92%

• Availability: 98.00%

• Curtailment (years 1-5): 2.50%


• Curtailment (years 6-40): 0.50%

PPA

• PPA price: $45.00/MWh

• PPA tenor: 15 years

• PPA escalator: 1.50%

RECs (separate from PPA)

• REC price: $3.50/MWh

• REC tenor: 15 years, no merchant RECs after, assume 0

• REC escalator: 0.00%

Merchant

• Merchant price: $80.00/MWh

• Merchant escalator: 2.00%

• Add “basis risk” only during merchant period: $1.50/MWh, no escalation

O&M

• Fixed O&M: $30,000/MW (2.00% escalation)

• Variable O&M: $2.00/MWh (2.00% escalation)

Debt

• Tenor: same as PPA

• P50 DSCR: 1.30x

• P99 DSCR: 1.00x

• Interest Rate: 4.00%


• Max debt sizing covenant: 85.00% of capex

Investor M&A inputs

• Investor unlevered equity discount rate: 7.00%

• Investor levered equity discount rate: 8.00%

• Terminal value (TV): $450/kW

• TV discount rate: 12.00%

Investor Sensitivities for the presentation

• Add merchant “haircut” sensitivity: 20%

• 2-way data table: investor purchase price based on levered discount rate
and TV. Use ranges you think are appropriate.

• 2-way data table: Investor IRR based on merchant price and basis risk. Use
ranges you think are appropriate.

Deliverables / Submission Criteria

• The submission for the final project model will be in one (1) excel file. •
Please make sure your final model is formatted well and presented in a
simple and easy to follow fashion. When in doubt, follow the best practices
we have covered in Module 1. Be sure to include a formatting legend.
Grading Criteria • Grading will take into account a) the right numerical
answer, (b) usage of correct formulas or the methodology of getting to the
answer, (c) formatting and best practices. • Show your work in full by setting
up the inputs, flags, formulas, calculations, and outputs neatly and
separately.
2. Put together a 5-10 slide PPT presentation and present it in a 5-10 minute video.
Your goal is to present the facts of the project, walk through the sensitivities you
ran, and convince your Investment Committee to invest in this project.

1. Create a PPT presentation (max 10 slides)


2. At the very least, help Investment Committee answer the following
questions.
1. What inputs and assumptions did you use?
2. What valuation methodology did you use?
3. Should we invest in this project?
4. What is our expected IRR? Does it hit our hurdle rate?
5. What is our expected MOIC? Does it hit our MOIC threshold
(assume 8.0x)?
6. What sensitivities did you run?
7. What is the worst-case scenario?
8. Do you think seller’s assumptions are realistic?
9. What unforeseen risks may cause us lower returns?
10. How can we mitigate those risks?

Common questions

Powered by AI

To determine if the project's expected IRR meets the investor's hurdle rate, an investor can calculate IRR based on the project's estimated cash flows, leveraging a discounted cash flow (DCF) analysis. In the context provided, if the expected IRR surpasses the hurdle rate of 8%, the project is considered viable . This involves careful integration of cash flow projections, adjustments for discount rates, and sensitivity analysis to account for different scenarios.

The presence of basis risk during a merchant period affects the predictability of cash flows from energy sales, which can impact the investment's risk profile. Basis risk is introduced at $1.50/MWh with no escalation during the merchant period . This reduces certainty in expected revenues outside PPAs, potentially leading to lowered return expectations and requiring investment committees to consider risk mitigating strategies or risk-adjusted return thresholds before proceeding.

Debt Service Coverage Ratio (DSCR) metrics are crucial because they assess a project's ability to service its debt from its cash flows. A P50 DSCR of 1.30x and a P99 DSCR of 1.00x indicate baseline and stressed conditions to ensure sufficient cash flow for debt servicing under expected and worst-case production scenarios. These ratios help prevent default risks and ensure that even in pessimistic scenarios, the project remains financially viable, aiding in lender confidence.

RECs (Renewable Energy Credits) provide additional revenue streams for power projects by certifying renewable energy production. In this scenario, RECs are priced at $3.50/MWh for a 15-year tenor with no post-tenor merchant sales . This provides a significant yet time-limited boost to project revenues, enhancing project attractiveness under environmental sustainability standards, and potentially increasing investor interest through enhanced project credentials and monetization opportunities.

PPA pricing and escalators directly impact the revenue stream of an energy project, influencing financial viability. With a PPA price of $45.00/MWh and an escalator of 1.50% , these terms determine the stability and growth potential of project income. A well-structured PPA with favorable prices and escalators gives predictable cash flows that support debt obligations and investment returns, while mitigating market price risks.

To mitigate unforeseen risks, such as market volatility or operational inefficiencies, an investor might diversify revenue streams, invest in advanced forecasting tools, establish robust contractual guarantees (like PPA terms), and incorporate contingency reserves. Ensuring stringent operational management and maintenance schedules can prevent unexpected downtimes, while financial hedging instruments can safeguard against price risks, supporting stable returns despite potential challenges .

Including a 'merchant haircut' sensitivity analysis, where hypothetical reductions in revenue during merchant operations are simulated, aids in understanding financial stability by quantifying how lower-than-expected energy prices impact returns. With a 20% haircut sensitivity , the analysis assesses the robustness of projected cash flows against market volatility, assisting investors in preparing contingency measures and making informed decisions on whether the risk-adjusted returns align with investment thresholds.

An investor should consider the project capacity, useful life, market conditions, future cash flows, and discount rate when evaluating the terminal value (TV) of a project. In the given model, the terminal value is calculated at $450/kW and is further evaluated using a discount rate of 12.00% . Assessments of the market prospects and technological viability at the end of the project are critical as well.

You might also like