This is a generic manufacturing project finance model based on a generic manufacturing business. It is best suited for analyzing debt capacity and for performing 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 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.