Manufacturer Business Model (DEMO)
Originally published: 16/07/2019 13:02
Last version published: 31/10/2019 09:59
Publication number: ELQ-31449-8
View all versions & Certificate
certified

Manufacturer Business Model (DEMO)

Allows Manufacturer to input business drivers for 3 business units, and generate integrated financials & exhibits

Description
NOTE: An UNLOCKED version of this model can be purchased at:
https://www.eloquens.com/tool/pV4dslpy/excelmodels/manufacturer-business-model-unlocked

● Integrated financials for multiple business units & consolidated rollup
● Business drivers, debt, KPIs, WACC, DCF & peer group valuations

This model contains:
● Integrated Financial Statements, Business Drivers, and debt schedule for manufacturing company with multiple Operating Units and one for Corporate overhead
● 5-year historicals and 5-year forecast of financials and free cash flow for each Operating Unit
● Two-pronged Valuation- Discounted Cash Flow (DCF) and EV/EBITDA multiple Valuation using a 7-company Peer Group
● Bottom-up Cost of Capital (WACC) calculation
● 15-slide pre-populated summary Presentation, with side-by-side analysis of Share Price, Book Value, and both intrinsic Valuations

As with all models at ExcelModels, this workbook contains separate tabs containing integrated financial statements: Income Statement, Balance Sheet, and Cash Flow Statement. All checks and balances are in-place, highlighting areas (such as a negative cash balance) where the user needs to adjust assumptions elsewhere.

This template contains clearly-labeled input cells. All other cells are locked for calculation, labeling, or other use. This focuses the user on the Key Assumptions they have control over, and prompts an accurate forecast.

We also provide model customization and build-out on an hourly or project basis. Please contact us for more information. Thanks.

This Best Practice includes
1 Excel file

ExcelModels offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.8 / 5 (39 votes)

please wait...