US $19.97

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

4 mins
Introduction to the business process
free preview
8 mins
What is financial modeling
free preview
5 mins
Starting point of a financial model
10 mins
Key features of clear financial model and how to get started
7 mins
First steps before starting to create financial model and linking business model
13 mins
Starting with end in mind comparative p&l
16 mins
Customer acquisition model
23 mins
Revenue and cost models
21 mins
Adding product and modelling labour and other costs
11 mins
Modeling capital investments and roi calc
17 mins
Detailed customer acquisition model and revenue model
8 mins
Cost of sale model
8 mins
Modeling labour cost
15 mins
Modeling other operating expenses
28 mins
Modeling income statement and cash flows
View more lessons +

About the instructor

Hotel Management School

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 …

Read more
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?
  • Checkout