Mô tả

In this course, you will learn

1.Introduction

2.Approach to Financial Modelling - Bottom-up and Top-Down

3. Deep Dive into the Construction Phase - Forecasting Revenue, Costs, Working Capital, Debt & Interest

4. Guidelines for Creating an Effective Financial Model

5. Scenario Analysis and Sensitivity

6 Financial Modeling—Real Life Case Studies - Alibaba IPO, Facebook IPO, Uber Valuation, Startup Funding, Hotel Project Appraisal, Financial Modeling for Mergers & Acquisitions, Financial Model for Covid 19, Financial Model for Project Financing

After the successful completion of this course, participants should be able to:

Design and build a comprehensive financial model

Create dashboards using those financial models

Use financial models in business valuation

Plan and take decision by analysing models

Bạn sẽ học được gì

Financial Modeling & Valuation,Understanding business, Preparing financial statements - Income Statement, Balance Sheet and Cash Flows

Discounted Cash Flow (DCF), Scenario and Sensitivity Analysis, Financial Modeling for M & A , Private Equity and Startup Valuation

Case Studies for Uber, Facebook, Hotel Valuation, Manufacturing Company, Covid19 Tracker,

Practical Insights on Valuation

Yêu cầu

  • Basic MS-Excel

Nội dung khoá học

8 sections

Introduction

2 lectures
Introduction
10:41
The Three Financial Statements
10:48

Elements of a Financial Model - Case Study of Hospital Project Financing

9 lectures
Assumptions
09:10
Calculating Revenue, Costs and EBITDA
04:42
Working Capital Module
02:38
Calculating Depreciation
04:24
Calculating Interest and Borrowings Schedule
05:21
Calculating Taxation
01:27
Preparing Cash Flow Statement
07:29
Preparing Balance Sheet
02:56
Calculating Debt Service Coverage Ratios, Net Debt/EBITDA and Net Debt to Equity
03:55

Section 2 - Approach to Financial Modeling

1 lectures
Scenario Analysis
06:48

Leveraged Buyout Transaction

2 lectures
Case Study - Modelling for Leveraged Buyout Transaction (LBO)
08:20
Solution - LBO Case Study
29:40

Modelling Returns for a Micro VC Fund

1 lectures
Modelling Returns for a Micro VC Fund
07:08

Financial Modeling for Startups

8 lectures
Financial Modeling for EdTech
13:12
Financial Modeling for Manufacturing
12:11
Financial Modeling for Information Technology_Artificial Intelligence
13:46
Financial Modeling for Healthcare Diagnostic Chain
14:02
Financial Modeling for D2C Startup
15:13
Financial Modeling for E-Commerce
12:08
Financial Modeling for Agritech
13:53
Investment Appraisal for UK based Waste to Electricity Project
13:25

Application of Financial Models

14 lectures
Financial Modeling for Multiplex Business | PVR Cinema Case Study
33:28
Financial Model for Project Appraisal
29:34
Preparing 3 Year Business Plan
28:54
Discounted Cash Flow Model
12:22
Financial Modeling—Investment Banks and Startups
10:27
Financial Model for Hotel with M&A Option
23:53
Case Study- FInancial Model for Hotel project
37:23
Case Study_Facebook IPO
17:45
Case Study_Alibaba IPO
14:45
Case Study_Uber
08:50
Case Study_Covid19 Model
13:00
Case Study_Manufacturing Startup
11:16
Quiz to test your understanding
17 questions
Business Valuation: Overview & Key Issues from a Practioner's Perspective
47:19

Practice Material

1 lectures
Practice Material
00:51

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.