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
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.)
- 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 capitalized
- 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
Fill the Form For Enquiry
and we will get back to you.
Call: +91-8080042523 | Email: [email protected]