Comprehensive Recycling Company Financial Model & Valuation Template

Description
Model Background
The recycling business financial model template is easy to update, flexible model and interactive. The model has a dedicated monthly financial statement (Income statement, cash flow statement, and Balance sheet) tab showing the financial performance of the business monthly over the lifetime of the model. In addition to this, the model also summarizes output the financial statement outputs in a yearly format.

We have incorporated a scenario analysis in the model showing the best to worst-case scenarios. The scenario analysis is driven by sensitivities made to various inputs such as capacity utilization , plant recovery rate and prices.
Projection

• Input Sheet - Contains all necessary inputs and assumptions driving the model. Inputs around Dates, Capacity, Revenue, Cost , OPEX, Tax, Financing Assumption are all set from this sheet. Users simply need to update this to meet their business reality
• IS_WKngs - This contains all calculations driving the model
• Debt & Equity - Contains debt schedule showing debt injection, principal and interest repayment flows. Sheet also contains Equity and retained earnings schedule
• Working Capital - Shows Working Capital Assumption - Payables, Inventory and Receivable forecasts
• Monthly Statement - Shows the income Statement, Cashflow statement and Balance Sheet on a monthly basis
• Y-o-Y Fin Stat - Shows the income Statement, Cashflow statement and Balance Sheet on a yearly basis

DCF Valuation : The Model uses Discounted Cashflow Model by computing WACC and using same to discount cashflows to get the Enterprise Valuation

General Outputs:

• 7-year Annual Financial Statement
• Monthly Financial Statements
• Dashboard with IRR, Payback Period
• Financial Ratios
• DCF Valuation

Potential Users

• Professional Investors
• Entrepreneurs
• Corporate Institutions
• Other Financial Modelers/ Consultants
• Postgraduate and Undergraduate Students