Project Finance – Financial Modeling Workshop

Come and join us on Aug 10th 2019

Fees: Rs. 7,500

Time: 9:30 AM – 5:00 PM

Location: Eccosphere Coworking Pvt. Ltd. B-61, B Block, Noida Sector 67

    Enquiry For Workshop:  +91-8080042523 |  [email protected]

    Date: Aug 10, 2019| Time: 09:30 AM – 5:00 PM | Fees: INR 7,500 including Taxes (Lunch incl.)

    PROJECT FINANCE & MODELING

    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: Delhi

    Location

    Venue: Eccosphere Coworking Pvt. Ltd. B-61, B Block, Noida Sector 67
    Date: Aug, 10 2019| Time: 09:30 AM – 5:00 PM
    Fees: INR 7,500 including Taxes (Lunch incl.)

    Call: +91-8080042523 | Email: [email protected]

    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

    Fill the Form For Enquiry

    and we will get back to you.

    Call: +91-8080042523  |  Email: [email protected]

      Enquiry Form