Financial Modeling with Excel Training for Corporate
Details
Target Audience:
BFSI Professionals, Financial Research Analysts, Freshly Qualified CAs and MBAs (Finance). Finance BPO Professionals those who are in to core finance activities, planning, analysis, decision making etc.
Key Learning:
Prepare end-to-end interlinked integrated model for Business ventures, Franchisee Investments, Project Finance, Company financials, CMA Reports.
Outline
Do’s and Dont’s in Financial Modeling
Accuracy, flexibility, User-friendliness
Structural standards
Iteration, Circular Errors, the #REF! problem
Factual checks, Rational checks, Structural checks,
Model Stress Testing, Proofreading
Documentation & Preparing for Handoff
Financial modeling Functions
Different ways of summing and counting: SUM; SUMIF;SUMPRODUCT; COUNT; COUNTA; COUNTBLANK; COUNTIF.
IF(ThisIsTrue, DoThis, ElseoThis)
Alternative ways to using IF function: AND; OR; MAX; MIN; CHOOSE
Error trapping: ISERROR; ISNUMBER; ISTEXT
Controlling appearance of numbers and text: TEXT; CONCATENATE; ROUND; ROUNDUP; ROUNDDOWN; CEILING; FLOOR; INT;TRUNC; MOD
Dates: YEAR; MONTH; DAY; DATE; DAYS360
Lookup and reference: CHOOSE; OFFSET; INDEX; MATCH; HLOOKUP; VLOOKUP
Discounting on uneven periods: NPV; XNPV; IRR; XIRR
Data validation; Text to column
Function keys: F2, F4, F5, F9, F2 + F4, F2 + F9
Pivot tables
Sensitivity and scenario analysis
Modeling for financial and operational planning for a business unit
A working capital management model
A capital budgeting model
An inventory policy model
A plant opening/closing model
Case Study
Financial modeling for valuation of mergers and acquisitions
Additional Analysis in Financial Modeling
- Debt repayment
o Modeling based on seniority of debt obligations
- Book Depreciation and Tax Depreciation and modeling deferred tax asset/liability
o Modeling Asset Sales.
Credit Perspective
Capital Structure
Leverage Ratios
Interest Coverage
Working Capital
Operating Results
Liquidity Ratios
Capital Structure Analysis
Existing Debt
Bank Revolver
Senior Bank Term "A"
Senior Bank Term "B"
Other Long-Term Debt
Senior Subordinated Debt
Junior Subordinated Debt
Seller Note
Preferred Stock
Book Capitalization
Total Debt
Book Equity
Borrowing Base
Revolver Debt
Valuation models using Discounted Cash Flow Analysis
- Free Cash Flow to Firm
- Free Cash Flow to Equity
- Single stage and multi stage models
- Principles of financial analysis using NPV, IRR, PBP and other measures
- Discounted Cash Flow Analysis
- Relative Valuation
- Hybrid of DCF and relative valuation
- Conducting reality check on results
Cost of Capital Modeling
Modeling for corporate finance transaction
Evaluation of Newly built financial model and an existing model
Objectives
Assumptions
Logical flow
Key inputs
Interrelationships among inputs
Expected output
Factual checks, Rational checks, Structural checks
Apart from Advanced Excel , we do cater our training service on Professional PowerPoint, Excel VBA, MS Access with VBA, MS Project, Finance Modeling with Excel, Finance for Non-Finance etc. ...