Project Finance Model - Widget Factory (with capex, macroeconomics, cost inputs, senior and mezzanine debt, and WACC)
Originally published: 18/06/2020 17:05
Last version published: 16/09/2022 09:56
Publication number: ELQ-74699-4
View all versions & Certificate

Project Finance Model - Widget Factory (with capex, macroeconomics, cost inputs, senior and mezzanine debt, and WACC)

Project finance model based on tried and tested investment banking methodologies

This is a project finance model based on an alloy manufacturing business, best suited for analyzing debt capacity and corporate finance valuations. The business manufactures 3 types of products (A, B, and C). This can be expanded and customized to one's individual manufacturing business very easily. Each product manufactured has three main raw material metal inputs, which can also be tailor-made to any manufacturing business with relative ease. The product mix is driven by an order book, which can be toggled and customized to any alloy manufacturing business. The production plant's productivity rate per hour can also be adjusted. The model includes a capital expenditure input to model any expansion plans in future. Senior debt and mezzanine facilities have been modeled, where the mezzanine facility has a built-in cash sweep mechanism.CAPM and WACC calculations are included, as well as a valuation sheet to determine the enterprise and equity value of the business for various growth-rate assumptions.Accounting statements (income statement and balance sheet) are also included, as well as a tax and working capital sheet which can be adjusted for country-specific tax rates, and business-specific creditors/debtors days.The model also includes standard project finance debt covenant ratios such as loan-life cover ratios and debt-service cover ratios.

This Best Practice includes
1 Excel Model

Acquire business license for $99.00

Add to cart

Add to bookmarks


Further information

A customizable financial model useful for valuing a metal alloy manufacturing business,
Useful for calculating debt capacity and structuring mezzanine and senior debt,
Useful for business strength and weakness deep-dives and credit analysis, cost breakdowns and year-on-year financial comparisons

Manufacturing businesses, particularly involving metal imports and fabrication
Debt funding via investment banks and private equity
Company valuation

Non-manufacturing businesses (e.g. service industries, fast-moving consumer goods, property etc.)

4.9 / 5 (10 votes)

please wait...