Overview

 Simple Manufacturing Model consists of an Excel model which presents the case of a 1 page model for an already operating manufacturing company. The model generates the three financial statements (profit and loss, balance sheet, and cash flow) and performs a valuation, along with financial ratios.

So, a quick overview of the model, in the contents tab you can see the structure of the model and by clicking on any of the headlines to be redirected to the relevant cells.

On the manual tab you can feed the general information for the model such as: model name, responsible, timeline of the model and date and currency conventions.

Additionally, there is a description of the color coding of the model in the same tab. Inputs are always depicted with a yellow fill and blue letters, call up (that is direct links from other cells) are filled in light blue with blue letters while calculations are depicted with white fill and black characters. Grey cells are restricted cells which you must not change.

There is also a color coding for the various tabs of the model. Yellow tabs are mostly assumptions tabs, grey tabs are calculations tabs, blue tabs are outputs tabs (that is effectively results or graphs) and finally light blue tabs are admin tabs (for example: the cover page, and contents).

Moving on the the "Inputs - Outputs" tab, the user can amend various assumptions on the right side of the worksheet (from columns K to V). Such assumptions consist of Market and Market Share per Product, Volumes and Prices per Product, other assumptions ( interest rate, taxes, receivables, payables, discount rate, growth rate and depreciation as percentage of fixed assets).

Additionally the user is able to change the fixed costs of production, the administrative fixed costs, as well as the production costs per product. Finally the user is also able to change the materials market and share, as well as the raw materials purchase price per market.

The left side is focusing on the outputs such as the profit and loss, the balance sheet and the cash flow statement. Additionally a valuation is performed together with the main financial ratios.

On the top of the page, the checks make sure that everything is working as planned.

Finally the last tab consists of various graphs, from market size and shares, volumes sold and revenues, per ton contribution, fixed expenses split, production losses, raw materials sourcing and costs, profitability, debt and cash, as well as free cash flows to the firm and valuation.

Reviews Add a review
No reviews yet

More From Big4WallStreet

Browse our top rated business templates. See All
Dynamic Arrays in Excel
186
4
Dynamic Arrays (“DA”) allow you to work with multiple values at the same time. Dynamic Arrays are only available in…
Self Storage Financial Model (Buy Upgrade Operate Exit)
341
0
Considering investing in a self-storage facility? This might be an easier way for entry-level real estate investors to get into…
Self Storage Financial Model (Construction, Operations & Exit)
551
1
 Use our Financial Model to plan the Self-Storage construction, and subsequent rental operations for several years before exiting your investment.…
Fast Food Chain Financial Model
571
0
The financial model presents the business case of a startup fast-food chain. The model accommodates up to 20 outlets with…
Start Up Nursery School Financial Model
659
0
 Start Up Nursery School Financial Model presents the case of an investment in a nursery school and its operations. The…
Weighted Average Cost of Capital (WACC) Excel Model
740
0
 Weighted Average Cost of Capital (or WACC) is an excel tool that calculates the discount rate of a company, which…
See All