Spreadsheet Models: Cashflow, Net Present Value and Pricing

ideas2action

• Spreadsheet Models: Cashflow, Net Present Value and Pricing 2:12:47

  • 1: Guiding Principles of Spreadsheet Modelling 07:03
  • 2: Types of Financial Model 05:44
  • 3: Getting Started with Spreadsheet Model Building 11:07
  • 4: Exercise: Getting Started with a Model 07:03
  • 5: Building a Pricing Model 06:09
  • 6: Pricing Example 1: New Product Pricing 05:16
  • 7: Pricing Example 2: Cresswells Biscuits 05:09
  • 8: Pricing Example 3: Caraways Takeaway 05:32
  • 9: Exercise: Trumpton Town Cafe 10:01
  • 10: The Cashflow Model 05:10
  • 11: Example Cashflow Model 04:20
  • 12: Considerations when Creating an Income Statement and Balance Sheet 02:00
  • 13: Exercise: Cashflow Model with Income Statement and Balance Sheet 12:11
  • 14: Spreadsheet Models for the Project Lifecycle 08:17
  • 15: Selecting a Discount Rate for Net Present Value 07:12
  • 16: Project Lifecycle Example 06:52
  • 17: Comparing Projects 03:00
  • 18: The Discounted Cashflow Valuation Model 06:08
  • 19: Valuing Camberwick Green Care Home 06:21
  • 20: Example Investment Options 08:12

This course is a companion to my course Building a Spreadsheet Forecasting Model. In that course I introduced the structure I recommend for building a spreadsheet model. I will only summarise that framework in this course. The focus of this course is practical examples of some of the most important spreadsheet models.

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

Spreadsheet Models: Cashflow, Net Present Value and Pricing will provide delegates with the skills they need to develop a flexible spreadsheet models for:

• Pricing Decisions
• Cashflow analysis including the Income Statement and Balance Sheet
• Investment analysis and project lifecycles

Key Learning Points

On completion of the course, delegates will be able to:

• Understand the guiding principles of spreadsheet model building.
• Plan the work involved in getting ready to build a spreadsheet model, including identifying stakeholders and defining the problem that the model will address.
• Develop models for pricing decisions including identifying the profit-maximising price for a business.
• Build a cashflow model to support a wide variety of business situations.
• Extend their cashflow model to include an Income Statement and Balance Sheet.
• Understand the project lifecycle
• Select an appropriate discount rate for use in Net Present Value analysis
• Compare projects using Net Present Value
• Apply the Discounted Cashflow Valuation Model to business projects
• Compare investment opportunities

Curriculum

L1 Guiding Principles of Spreadsheet Modelling

L2 Types of Financial Model

L3 Getting Started with Spreadsheet Model Building

L4 Exercise: Getting Started with a Model

L5 Building a Pricing Model

L6 Pricing Example 1: New Product Pricing

L7 Pricing Example 2: Cresswell’s Biscuits

L8 Pricing Example 3: Caraway’s Takeaway

L9 Exercise: Trumpton Town Café

L10 The Cashflow Model

L11 Example Cashflow Model

L12 Considerations when creating an Income Statement and Balance Sheet

L13 Exercise: Cashflow Model with Income Statement and Balance Sheet

L14 Spreadsheet Models for the Project Lifecycle

L15 Selecting a Discount Rate for Net Present Value

L16 Project Lifecycle Example

L17 Comparing Projects

L18 The Discounted Cashflow Valuation Model

L19 Valuing Camberwick Green Care Home

L20 Example: Investment Options

Additional Resources

The spreadsheet models that accompany this course

Spreadsheet modellers

Accountants and finance professionals

Data analysis specialists

Business managers

Students of business finance

There are no pre-course requirements

There are currently no Q&As for this course. Be the first to ask a question.