This course is designed for existing users of Excel or similar spreadsheet programs needing to vastly increase their modelling & analytical skills especially in the disciplinary areas of Finance, Accounting, Management & Procurement. It is designed to improve the Excel modelling & analytical skills of finance professionals for the forecast, analysis & presentation of business & financial information
Accuracy, flexibility, User-friendliness
Structural standards
Iteration, Circular Errors, the #REF! problem
Factual checks, Rational checks, Structural checks,
Model Stress Testing, Proofreading
Different ways of summing and counting: SUM; SUMIF;
SUMPRODUCT; COUNT; COUNTA; COUNTBLANK; COUNTIF and IF functions
ROUND; ROUNDUP; ROUNDDOWN; CEILING; FLOOR; INT;
TRUNC; MOD
HLOOKUP; VLOOKUP
Discounting on uneven periods: NPV; XNPV; IRR; XIRR
Data validation; Text to column
Pivot tables, what if analysis and data tables
Sensitivity and scenario analysis
A working capital management model
A capital budgeting model
An inventory policy model
A plant opening/closing model
Debt repayment
Modeling based on seniority of debt obligations
Book Depreciation and Tax Depreciation and modeling deferred tax
Asset/liability
Modeling Asset Sales
Capital Structure
Leverage Ratios
Interest Coverage
Working Capital
Operating Results
Liquidity Ratios
Existing Debt
Bank Revolver
Other Long-Term Debt
Preferred Stock
Book Capitalization
Total Debt
Book Equity
Borrowing Base
Revolver Debt
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
Objectives
Assumptions
Logical flow
Key inputs
Interrelationships among inputs
Expected output
Factual checks, Rational checks, Structural checks
Creating professional charts in Microsoft Excel
Working with large amounts of data
Understanding Accounting and Bookkeeping principles
Building a company’s financial statements
Performing Financial Statement Analysis
Understanding importance of timing in terms of revenue and cost recognition
Calculating Liquidity, Solvency, Profitability, and Growth ratios
Assessing project feasibility
Calculating a complete loan schedule
Understanding the difference between variable and fixed interest rates
Performing industry analysis
Understanding drives, a company’s value
Analyzing a business
Find subjects you're passionate about by browsing our online course categories. Start
learning with top courses Built With Industry Experts.