Training Calendar

-Trainer and trainee introduction

-Overview of financial model

-Setting expectations

-Methodology: Interactive discussion with participants

-Understanding different types of data

-Understanding different types of variables

-Working with averages, growth rates, proportions, and basis points

-Structuring workbook and worksheets

-Naming worksheets

-Delineating between input cells and formula cells

-Working with colour codes

-Working with relative reference vs absolute reference

-Working with range names and tables

-Role of ratio analysis in financial modeling

-Time series analysis for financial modeling

-Calculating ratios and growth rates

-Limitations of textbook ratios and alternatives

-Understanding the business model

-Identifying variables and relationship

-Developing model structure using reverse flow charging

-Understanding data dimensions and model architecture

-Understanding the role of business constraints in revenue modeling

-Various levels of revenue modeling

-Demand side modeling

-Production/supply side modeling

-Top-down approach to financial models

-Understanding expense categorisation in India and the resulting challenges in modeling

-Modeling operating expenses

-Modeling changes in inventory

-Understanding numerical series (arithmetic progression and geometric progression)

-Basic time value of money

-Advanced time value of money concept

-Using numerical series and TVM concepts in financial modeling

-Working with Boolean values

-Working with IF statements

-Advanced numerical functions and lookup functions

-Financial function in MS Excel

-Understanding a fixed asset schedule

-Comparison between SLM and WDV method for calculating depreciation

-Challenges in SLM modeling and alternatives

-Modeling capex

-Structure of debt schedule

-Modeling debt when limited information is available

-Modeling debt when maturity dates are debt available

-Modeling taxes

-Modeling minority interest and income from associates

-Modeling EPS and DPS

-Balance sheet line items in India and resulting challenges

-Identifying balance sheet items into (i) Fictitious asset/liability (ii) Financial assets/(liability) (iv) Operating assets and liabilities

-Modeling working capital line items

- Modeling provisions including provision for employee benefits

-Modeling equity

-Reorganising cash flow line items

-Modeling cash flow statement under indirect method

-Cash sweep statement: Alternate approach to cash flow statement

-Algebraic approach to handling circular reference in cash sweep statement

-Overview of three stage DCF model

-Factors affecting number of stages and tenure of each stage

-Projecting out years (second stage)

-Critical check lists for estimations and projections in DCF

-Calculating cost of capital

-Calculating present values and value of equity shares

-Sensitivity analysis of DCF valuation using data table

-Understand the various parts of an analytical report such as assertion, premise and conclusion

-Know the significance of presenting the various components in a structured manner to be able to persuade the reader

-Presenting the various components for deductive arguments and inductive arguments

-Understanding pyramid structure and power writing

-Presenting deductive vs inductive arguments

-Knowing the difference between top-down vs Bottom-up approach and when to use what

-Presenting an idea using top-down pyramid

-Presenting an idea using bottom-up pyramid

-Beginning with clear, concise and persuasive opening

-Using bread crumbs to retain the reader’s attention

-Using flags and sign posts

-Ending with powerful conclusion

-Writing effective paragraph/slide headings

-Using margin texts in word based reports

-Using pictographs

-Making charts and table easy to understand/interpret

-Unity of idea

-Bringing variety using different sentence structures

-Maintaining coherence of idea

-Eight rules of comma

-Rules of capitalization

-Using other punctuations such as semi-colon, colon, em-dash and en-dash

- Overview of VBA

- Understanding the VBA environment

- Understanding VBA libraries

- Overview of object, properties and methods

- Understanding subroutines and functions

- Input commands in MS Excel

- Storing input data in MS Excel or name manager

- Processing data in VBA

- Use of MS Excel functions in VBA

- Storing calculated results in MS Excel

- If.. Then.. Else construct

- Select Case construct

- For Next construct

- Do Loop Construct

- While Wend construct

- Generating code snippets using record macro feature

- Obtaining code snippets online

- Identifying the steps

- Identifying conditional steps

- Generating codes

- Modifying codes to suit the need

- External resources helpful for coding

- Understanding the concept of functions

- Private and public functions

- Calling additional functions and sub-routines

- Creating and function to work with MS Excel

- - Introduction to ActiveX controls

- Various ActiveX controls button

- Reading values in ActiveX control and accepting input using the same

- Adding elements to ActiveX controls manually and automatically

- Hiding and showing ActiveX controls

- Simple interest vs compound interest

-Understanding present values and future values

-Calculating present value, future value, rate and number of periods

-MS Excel functions for calculating PV, FV, Rate, NPer

- Fundamental equation of value

-Real world valuation vs risk neutral valuation

-Role of spot rates in asset valuation

-Valuation of bond with (i) yield to maturity (ii) with spot rates

-Working with forward rates

-Introduction to annuity

-Mathematical formula for calculating annuity

-MS Excel function to calculate annuity

-Calculating annuity when there are uncertainties

-Modeling growth annuity

-Lease accounting

-Investment and debt accounting under IFRS 9 / IndAS 109

-Impairment of assets

-Accounting for employment obigations

- Creating a consolidated debt schedule when there are several debts taken at different times at different rates and different tenure

- Creating a consolidated depreciation schedule when there are different asset purchased at different dates with different life and salvage value

-Creating debt repayment schedule based for a series of debt