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