Financial Modelling for Making Business decisions and plans

learn how to translate business models and strategies into financial projections via financial modelling for pitch decks

4.05 (26 reviews)
Udemy
platform
English
language
Entrepreneurship
category
instructor
3,537
students
3.5 hours
content
Dec 2020
last update
$24.99
regular price

What you will learn

How business decisions are taken in logical way

how to evaluate impact of decisions

create excel models for projecting business plans

best practices of financial modelling

creating and projecting financial statements

Description

Financial modeling, as the name suggests is to create models for making business decisions involving finance.

Financial modeling is the process of creating a summary of a company's expenses and earnings in the form of a spreadsheet that can be used to calculate the impact of a future event or decision.

The financial modeling process helps users make financial decisions and understand their impact on profit & loss statements, ROI, IRR, Cash Flow.


In this course, we will teach you key aspects of financial modeling and will be doing a live case study & demonstrating

- Best Practices in financial modeling

- How to avoid errors and spot them

- How do we make assumptions

- What inputs are required for making decisions.

- How we model decision flow into excel model.

- How to make projections

- Making 3 Financial statements (Profit & Loss Statement, cash flow, balance sheet)


This course will also take you through the process of making assumptions about projections and how to justify them and defend when potential investors may ask questions. By taking this course you will be able to

- Evaluate your revenue and cost models.

- understand what can breakeven

- calculate cash burns and the ability to project how much you need.


You will get an excel template used in the course for following along.

Content

Introduction

Introduction to the Business Process
What is Financial Modelling
Starting Point of a Financial Model
Key Features of Clear Financial Model and How to get Started
First Steps before Starting to create Financial Model and Linking Business Model

Case Study - Restaurant - Basic Model for Selecting initial Location

CS-1. Starting with end in mind-Comparative P&L
Customer Acquisition Model
CS-3. Revenue and Cost Models
CS-4. Adding Product and modelling labour and other Costs
CS-5. Modelling Capital Investments and ROI calculations

Business Planning and Financial Model

BP-1 Detailed Customer Acquisition Model and Revenue Model
BP-2 Cost of Sale Model
BP-3 Modelling Labor cost
BP-4 Modelling Other Operating Expenses
BP-5 Modelling Income Statement and Cash Flows
BP-6 Modeling Balance Sheet
BP-7. Fixing the errors in Financial Model and brief of IRR

Screenshots

Financial Modelling for Making Business decisions and plans - Screenshot_01Financial Modelling for Making Business decisions and plans - Screenshot_02Financial Modelling for Making Business decisions and plans - Screenshot_03Financial Modelling for Making Business decisions and plans - Screenshot_04

Reviews

Jessica
August 19, 2021
So far I feel like the introduction could have been more condensed. This is listed as intermediate, but we've spent 15 minutes discussing what, not how.
Devendra
March 16, 2021
Each and everything is very clear and i enjoyed to watching this. Recommend to everyone who learn in busniess strategy.

Coupons

DateDiscountStatus
12/29/202087% OFF
expired
3/16/2021100% OFF
expired

Charts

Price

Financial Modelling for Making Business decisions and plans - Price chart

Rating

Financial Modelling for Making Business decisions and plans - Ratings chart

Enrollment distribution

Financial Modelling for Making Business decisions and plans - Distribution chart
3724774
udemy ID
12/24/2020
course created date
12/29/2020
course indexed date
Bot
course submited by