Name: Certificate in Advanced Financial Modeling and Valuation
Rating: 5 (14368 reviews)

Certificate in advanced financial modeling and valuation by Berkeleyme. This course consist of 12 lectures for your knowledge to be a Financial Analyst..

INTRODUCTION

Hands-on practical training course to help you learn exactly what is required to do in your daily work.
Up-skill your knowledge to be a Financial Analyst.
Practical assignments, illustration spreadsheets, excel shortcuts- all included and can be downloaded at your end for self-practice.

WHO CAN DO?

Any Finance professional like:
• Financial analysts
• Venture capitalists
• Private Equity professionals
• Startup entrepreneurs
• Investment Bankers
• CFA Candidate
• Recent Graduates looking to start their career in Finance

WHAT YOU WILL LEARN

Practical applications of accounting, Excel, finance, financial modelling, valuation, presentations, and other critical skills that financial analysts need
• Forecast future financial statements of any company, Budgeting, and planning
• Analyze Cash flows of any company
• Analyse the Annual Report of any company, ratio analysis, key metrics etc.
• Common valuation techniques used in Business valuation
• Understand each valuation method and respective application across sectors
• How to evaluate any Business’s worth (whether a start-up or mature business)
• Learn how to build a three-statement model, LBO model, M&A model, business valuation model etc
• How to perform sensitivity and scenario analysis for financial modelling
• To gather inputs from various sources required for performing Valuations for any Company

COURSE STRUCTURE

Lectures	Study Units
1 & 2	• Financial analysis basics: learn how to to undertake a comprehensive financial analysis of any income statement. • Review the various components of the income statement • Conduct a comprehensive vertical and horizontal analysis of the income statement • Benchmark income statement performance against an appropriate peer group • Profitability analysis
3 & 4	• Budgeting and forecasting • Learn entire budgeting process from start to finish, the various methods for building budgets, techniques to analyze results, and how to improve organizational performance.
5	• Three statement Financial model will include: • Forecasting Income statement and balance sheet • Debt and financing schedule • Build a free cash flow statement • DCF modelling
6	• Business Valuation & modeling • Learn the skills required to perform detailed business valuation modeling using three main methods: Comps, Precedents and DCF Analysis. • Detailed and step-by-step explanation of how to value a company based on comparable companies, past M&A transactions and a Discounted Cash Flow (DCF) models.
7	• Scenario & sensitivity analysis • How to build a robust sensitivity analysis system into your Excel financial model. • Model integration, analyzing results, and presentation (Tornado charts, gravity sort table etc)
8	• M&A modeling • Build a structure for financial M&A model • Set up all the assumptions and drivers required to build out the M&A model • Calculate all the necessary adjusting entries required to create a post-transaction balance sheet • Integrate the acquirer and the target into a pro forma model
9	• LBO modeling • Learn how to build LBO model from scratch • Step by step including assumptions, financing, forecasting, DCF, IRR, excel functions & formulas
10	• Start-up financial model • learn to build a startup financial model from scratch complete with assumptions, financials, valuation, and output charts. • Perform a discounted cash flow DCF valuation of the startup business
11	• Real estate Financial Model • Learn how to build a dynamic Real Estate Financial Model to evaluate the investment return profile of a development project in Excel. • Calculate Cap Rate and Net Operating Income (NOI) • Build an interactive financial model to assess a project’s financial viability • Calculate Internal Rate of Return (IRR), Return on Sales, Return on Cost
12	• Dashboards & data presentation • Learn how to build a custom Excel dashboard using professional data visualization techniques.