Come and join us on Aug 11, 12 2018
Time: 9:30 AM – 5:00 PM
Mumbai: Saki Naka, Andheri
Email: [email protected]
Mumbai: Sakinaka, Andheri East
Date: Aug 11, 12 2018| Time: 09:30 AM – 5:00 PM
Fees: INR 9,800 including Service Tax (Lunch incl.)
Excel Foundation for Financial Modeling – 0.5 day
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).
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
Specific areas which require attention and will be covered as a part of the model:
2.Building automated timeline (FY)
3.Timing and Event activation Flags (True/False)
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)
9.Waterfall Structure of funding
10.Incorporating Revolver Balance & Minimum Cash Balances
11.Debt schedules & repayment
12.Working Capital schedule & Linkages
13.Building iterative calculation for Interest
14.Others: IRR, NPV, Ratios, What If Analysis, Relevant Shortcuts
1.Participants are expected to have prior knowledge of –
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
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.
This workshop is Jointly conducted by