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
Profile: ......... A level seven graduate with over 20 years' experience in the spheres of Production and Quality Assurance Engineering. Also, a former Co. Director with over 10 years’ track record of business success in the service sector. Currently a Business Lecturer / Grade 1: Maths Lecturer and Learning Technologist with over 15 years’ experience of applying Traditional and Blended learning solutions within the FE (Further Education) and HE (Higher Educational) environments.
View my complete profile
Simple theme. Powered by Blogger.