1 / 24

Applying financial skills to real situations

Applying financial skills to real situations. Overview. Position fix Exploding the strategic model Examples of detailed projections Organising information The two big issues (Sales and Cost of Sales) Using the data collection “Template” Projections application demo Practice.

rusk
Download Presentation

Applying financial skills to real situations

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Applying financial skills to real situations Overview Position fix Exploding the strategic model Examples of detailed projections Organising information The two big issues (Sales and Cost of Sales) Using the data collection “Template” Projections application demo Practice

  2. Position Fix Business Plan This is the move from big picture strategy to detailed tactics. We need to explode our summary model to the multiple sales, expenses, assets and liabilities expected in business plans. (See next slide) We will need to use a suitable financial modelling application to deal with the added detail – a spread sheet or one of the many financial modelling applications available. We use one called ProfitScout for the exercises in this element. But We have already covered all the financial concepts, terms and skills we will need.

  3. Expanding the Strategic Model The strategic financial model expands in depth and width for detailed projections. Month by month to capture extremes such as the maximum cash needed and into multiple sales drivers, costs, loans etc. to provide the precision needed for accurate operation planning. Product/service 1; Product/service 2…Product/service n Salaries, Rent, Telephones, Light Heat & Power etc. Multiple bank loans, Directors loans, Financial Leases Land & Buildings, Plant & Equipment, Patents, Vehicles,

  4. Examples of the expanded plan – sales f’cast

  5. Examples of the expanded plan – P & L (O/Hs)

  6. Examples of the expanded plan – monthly cash flow

  7. Examples of the expanded plan – Annual B. Sheet

  8. The Sales Forecast Issue The sales forecast is the foundation of the financial model. If you have only one or a few products/services it is easy to include them all in the forecast. But what about businesses with very large product/service ranges. Using all products may be too cumbersome: too few will limit its usefulness. Time to collaborate with your accountant The area of identifying the right product range, pricing, forecasting and reviewing sales performance can be immensely complex. In business colour can differentiate products: in terms of financial projections products with the same price/cost structure are identical www.fabeducation.com

  9. Adapting product ranges for forecasting Guidance Match the range in the model to the range you use for practical sales forecasting in the day-to-day running of the business . Common work-rounds are: breaking the range into categories or using the 80/20 rule consigning the less important to a catch-all “others” category.

  10. The Sales Forecast – Evidence You will need evidence to support the assumptions underlying all aspects of your plan and particularly to back up the sales forecast. See p162 for a checklist of the sources of evidence required www.fabeducation.com

  11. The “Cost of Sales” Issue The second defining issue for your financial model will be the detail required for the cost structure of the model. Time to collaborate with your accountant Obviously the issue does not arise in Service plans and Retail plans have a simple purchase price/selling price for each product in the forecast. But, manufacturing firms can have extensive product cost structures that take great time and effort to build into a model and can quickly swamp it in detail. Such detail may be justified In large corporations with specialist staff and integrated MRP systems but is not justified in 99% of business plans.

  12. Adapting cost structures for forecasting Unless you can be sure that the extra effort to include detailed cost structures in the model is justified use the “Retail” format. Keep the detailed workings/cost sheets on which the summary cost is based as part of the EVIDENCE supporting the model assumptions. Template We will use the “Retail” format for the Template and Exercise Exercise If you need a data collection template for a detailed manufacturing plan contact: info@fabeducation.com Contact us

  13. Organising the information Be systematic - use the data collection template to organise the information needed for the plan. Template Product information Credit phasing Opening balances (Interest, Vat, bank) Overhead expenses projections Fixed Asset details Financial Leases and Loans Share Capital, Revenue Grants and other income Be able to produce evidence to support the data in each of the seven areas!

  14. Template 1. Product information Get reliable information/evidence Think through the issues

  15. Template 2. Credit phasing Get reliable information/evidence Think through the issues

  16. Template 3. Opening balances Get reliable information/evidence Think through the issues

  17. Template 4. Overheads expenses projections Get reliable information/evidence Think through the issues

  18. Template 5. Fixed assets details Get reliable information/evidence Think through the issues

  19. Template 6. Financial leases and Loans Get reliable information/evidence Think through the issues

  20. Template 7. Share Capital, Revenue Grants, and Other Income Get reliable information/evidence Think through the issues

  21. Demo Walk through the detailed financial forecasting application to be made available for the exercise e.g. A programmed spread sheet ProfitScout ® (download from www.profitscoutsoftware.com ) Another planning application

  22. Exercise 6 – WB Bikes Limited Exercise 6 Explodes our summary model to the multiple sales, expenses, assets and liabilities expected in business plans. Projects the business model over twelve months to produce detailed financial projections and examines new issues raised by this three dimensional financial model • A programmed spread sheet • ProfitScout • Another planning application If you need exercises for other settings including detailed manufacturing plans contact: info@fabeducation.com Contact us

  23. Practice 11 – Preparing your own Financial Model & Projections Practice 11 Use the Templates to capture the data needed for your business or study project. Time to collaborate with your accountant Build the financial model on a spread sheet, ProfitScout or other application if that is appropriate or collaborate with your accountant/course leader on theirs. Use your knowledge of the Business/Financial model relationship to test What-ifs? and explore, explore and explore until you have the best possible plan.

  24. Good luck If you have followed FaBeducation’s course to here you are well prepared to hold fluent conversations in the language of business and make financially smart decisions Please contact us at: info@fabeducation.com if you have any suggestions for changes or additions to the programme or If you need further information and assistance. Best of luck with you business career.

More Related