US $19.97

Spreadsheet Models: Pricing, Cashflow and Investment Analysis

——   Created by Ross Maynard

Usi good spreadsheet modelling practice to build three types of spreadsheet model

Share this course:

2h 12m
Lesson time
Skill levels

More about this course

In this course, we use good spreadsheet modelling practice to build three types of spreadsheet model - a pricing decision model; a cashflow statement; and a project lifecycle analysis using discounted cashflows.

This course is a companion to my course Building a Spreadsheet Forecasting Model which covers the structure for building a spreadsheet forecasting or planning model. You do not need to have completed that course to undertake this course. The focus of this course - Spreadsheet Models: Cashflow, Net Present Value and Pricing - is practical examples of some of the most important spreadsheet models. 

There are many types of financial model that can be built using Microsoft Excel. These include:

· A Project Finance Model. Large projects will use a financial model as a basis for budgeting and to forecast outcomes, including cashflows to match debt repayment.

· A Pricing Model. The price charged for products or services is part of the “marketing mix” for the operation. Pricing has a significant impact on demand and, therefore, profitability.

· A Cashflow Model and Integrated Financial Statements. A financial model can be built to integrate the cashflow, profit and loss and balance sheet statements. These models can easily become very complex, and the challenge is to keep to the principle of keeping it simple and flexible.

· A Valuation Model. A valuation model will be built to assess the value of a business or business unit, or potential new business opportunity. In the case of a business acquisition, the seller will present a model that maximises the value of the business; and the potential buyer will critically analyse that model to determine its feasibility and to establish their own valuation. The model may also be required to illustrate how debt raised for the purchase will be serviced.

Spreadsheet Models: Cashflow, Net Present Value and Pricing will provide learners with the skills they need to develop a flexible spreadsheet models for all of these scenarios.

This course assumes a good basic knowledge of Microsoft Excel, but advanced knowledge is not necessary and, as with the previous course, Macros and visual basic are avoided.

20 Lessons

8 mins
Guiding Principles of Spreadsheet Modelling
free preview
6 mins
Types of Financial Model
12 mins
Getting Started with Spreadsheet Model Building
8 mins
Exercise: Getting Started with a Model
7 mins
Building a Pricing Model
6 mins
Pricing Example 1: New Product Pricing
6 mins
Pricing Example 2: Cresswell's Biscuits
6 mins
Pricing Example 3: Caraway's Takeaway
11 mins
Exercise: Trumpton Town Cafe
6 mins
The Cashflow Model
5 mins
Example: Cashflow Model
2 mins
Considerations when creating an Income Statement and Balance Sheet
13 mins
Exercise: Cashflow Model with Income Statement and Balance Sheet
9 mins
Spreadsheet Models for the Project Lifecycle
8 mins
Selecting a Discount Rate for Net Present Value
View more lessons +

About the instructor

Ross Maynard
Ross Maynard
  • 2 reviews
  • 24 courses

I am a Fellow of the Chartered Institute of Management Accountants specialising in process improvement. I have nearly 30 years experience in consultancy, facilitation and …

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
  • 2h 12m of on-demand video
  • 1 downloadable file
  • Have a coupon?
  • Checkout