Project Finance & Modeling Workshop

Excel Foundation for Financial Modeling – 0.5 day
For More Details: https://yodalearning.com/workshops/

Essential Shortcuts:
Sheets and Data Navigation
Show all formulas
Using $
Go To (Special)
Entering values
Copy Pasting formulas
Logic Building Formulas: IF, AND, OR, MAX and MIN
Scenario Building Formulas: INDEX, VLOOKUP, MATCH, CHOOSE, OFFSET

What if Analysis Switches: Spin Button, Drop Down list, Scroll Bar

Calculation Formulas: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, SUMPRODUCT, SMALL, LARGE, SUMIF, COUNTIF, MROUND
Excel based Financial Modeling (Greenfield Solar Power Project) – 2.0 days

FAST™ Modelling Standard: www.fast-standard.org – a set of rules on the structure and detailed design of spreadsheet based models. (Flexible, Structured, Appropriate and Transparent).

General Flow:

DAY 1: Mini-case lets will be used to explain the concept of Flags, Circularity Switch, scenario building formulas and logic building Excel functions

DAY 1: One case study will be taken up to explain the general linkages between Assumptions, Working Schedules, Income Statement, Balance Sheet and Cash Flow Statement. This will ensure that the model is correctly integrated.

DAY 1 & DAY 2: A full blown Financial Model (Greenfield Solar Power Project) will be taken up

PROJECT FINANCE & MODELING (DAY 2)
Specific areas which require attention and will be covered as a part of the model:

1.Assumptions build-up (Project Start Date, Gestation Period, Project Commissioning Date etc.)Assumption sheet

Accommodating project delays
Upfront capex in a phased manner
2.Building automated timeline (FY)

3.Timing and Event activation Flags (True/False)

Operation Start Flag
Operation Continued Flag
Operational Year sequence counter
Loan Repayment Flag
4.Revenue Buildup (PPA / Merchant Sale) with YoY escalation in prices

5.Capex Schedule (The journey from Capex CWIP PPE or Gross Fixed Assets)

6.Use of BASE Analysis (Beginning, Addition, Subtraction, Ending)

7.Amortization/Depreciation schedule

Building depreciation calculations that stops after the book balance is fully depreciated
8.Interest during Construction (IDC) – to be capitalizedincome statement

Hard Capex vs. Soft Capex (IDC)
Dividing Interest accrued between IDC and P/L in the year of start of operation
9.Waterfall Structure of funding

Equity drawdown, followed by Debt and Grants
10.Incorporating Revolver Balance & Minimum Cash Balances

11.Debt schedules & repayment

12.Working Capital schedule & Linkages

13.Building iterative calculation for Interest

Incorporating circularity switch to build a failsafe mechanism in case iteration leads to irreversible errors
14.Others: IRR, NPV, Ratios, What If Analysis, Relevant Shortcuts

PRE-REQUISITE:
1.Participants are expected to have prior knowledge of –

Sort & Filter; SUM(), MAX(), MIN(), AVERAGE(), UPPER(), PROPER(), LOWER(); Basic VLookup
Freeze Panes, Add/Delete Rows/Columns/WorkSheets
2.Program not meant for participants seeking basic knowledge of Excel

3.Participants can carry own Laptop (Excel v. 2007/2010/2013) – else 1 practice laptop shall be provided at the venue.

4.Snacks, Tea and Handbook will be provided. Lunch has to be arranged by participant.

5.Address: Knowledge Village, Block 2, Ground Floor G05A, UAE

INSTRUCTOR
Instructor: CA. Rishabh Pugaliarishabh pugalia

He has worked with KPMG & J. P Morgan before he founded Excel Next. He has trained 9,500+ professionals on Advanced Excel, PowerPoint Presentations & Financial Modeling. He has conducted LIVE webcast at the Institute of Chartered Accountants of India (ICAI) and has co-authored a technical guide on how to use Excel for “Continuous Controls Monitoring”, which was published by ICAI.