Easy Office
LCI Learning

 Events Home

Project Finance – Financial Modeling Workshop

Come and join us on May 24, 25 2019
Time: 9:30 AM – 5:00 PM
Mumbai: Saki Naka, Andheri

Call us: 088803-20003

Registration Closed

( Register before 20th May 2019 and avail special 30% discount. Coupon code: WORKSHOP30 )




Download Brochure      Download Template 

PROJECT FINANCE & MODELING (DAY 1):

Excel Foundation for Financial Modeling – 0.5 day

  • 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.)

  • 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: Saki Naka, Andheri



Location:


Mumbai: Sakinaka, Andheri East
Date: May 24, 25 2019| Time: 09:30 AM – 5:00 PM
Fees: INR 13,800 including Service Tax (Lunch incl.)
Call: 088803-20003 | Email: coaching@caclubindia.com




( Register before 20th May 2019 and avail special 30% discount. Coupon code: WORKSHOP30 )







If you have any question please call us
at 088803-20003




COURSE INSTRUCTOR

Hi I’m Zaid. Here’s something about me

  • I’ve passed all three levels for CFA Program
  • I’ve Worked in the Financial advisory unit of a top-tier consulting firm
  • I have Experience in transactions carried out in the US, UK, GCC, Singapore, India, Hong Kong
  • I’ve worked in in Banking, Retail, Real Estate, Telecommunication, Infrastructure, Agriculture sectors. Worked on company valuations, due diligence analysis, impairment tests, bankruptcy proceedings, cash flow analysis, and more.
  • Part of fund diligence in multiple investment/M&A deals with sizes ranging from $2mn to $100mn

Financial Modeling Online Course For Beginner Advanced User


Other recommended course