Examplar: Practical Financial Management

How to produce a cash flow forecast and apply break-even analysis, including examples from small business

Break Even Analysis

May Va Ltd have applied breakeven analysis to their Home delivery of Chinese Food in the following Microsoft Excel application/s:


Break-even-data (2019)


Break-even-chart (2019)


Break-even-spread-sheet-formulae (2019)
Newer Post Older Post Home

Contents:

  • Fact-sheet Intro.
  • Seasonality / trends
  • Profit & Loss Spread-sheet
  • Cash Flow Forecast
  • Break-even-analysis
  • Advertising budget
  • Bibliography
  • Linked: Unit 29: LO:3
  • Home page

Techniques

  • Budget forecating
  • Sensitivity analysis
  • Variance analysis
  • "What if" analysis
  • Moving average
  • Ratio analysis

Simulation Model

  • Budget-Forecast
  • Cash-Flow-Forecast
  • Profit-Loss-Forecast

Lesson Plan

  • Page 1
  • Page 2
  • PDF

About Me

My photo
Mr David Hilton
View my complete profile
Simple theme. Powered by Blogger.