Financial modeling for making business decisions and plans

——   Created by Hotel Management School

Share this course:

NEW
Course
17
Lessons
3h 27m
Lesson time
all
Skill levels

More about this course

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

The 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

- How do we make assumptions

- What inputs are required for making decisions.

- How we model decision flow into excel model.

- 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 ability to project how much you need.

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

17 Lessons

0:03:21
Introduction to the business process
free preview
0:07:31
What is financial modeling
free preview
0:04:06
Starting point of a financial model
0:09:57
Key features of clear financial model and how to get started
0:06:55
First steps before starting to create financial model and linking business model
0:12:45
Starting with end in mind comparative p&l
0:15:31
Customer acquisition model
0:22:03
Revenue and cost models
0:20:38
Adding product and modelling labour and other costs
0:10:18
Modeling capital investments and roi calc
0:16:53
Detailed customer acquisition model and revenue model
0:07:37
Cost of sale model
0:07:28
Modeling labour cost
0:14:03
Modeling other operating expenses
0:27:11
Modeling income statement and cash flows
View more lessons +
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 3h 27m of on-demand video
  • 2 downloadable files
  • 1 peer to work with
  • Have a coupon?

About the instructor

Hotel management school was established a year ago by young and professional hoteliers having a combined experience of over 20 years. 

Instructors have worked in prestigious hotel chains such as Shangri-La, Intercontinental in finance, operations, sales & marketing at director levels.

Classes were taught first in physical environment to test contents and take feedback …

View full profile

For super learners, get unlimited access for $15 per month

Start your 14 day free trial. Cancel at any time.

Join Today Learn More