This is a recycling financial model. The timeline can be set for up to 10 years with monthly and annual summaries as well as final return metrics including IRR and a DCF Analysis / NPV and total ROI of the project. The main output this model solves for is minimum equity needed to launch (including debt financing).
The logic is pretty simple. You can model up to 15 material types that all have configurations for start month, acquisition cost per unit, selling price per unit, and count of unit sales per month in each of the 10 years. The acquisition cost could also be thought of as the processing cost per unit depending on the exact type of operation.
There is a fixed cost schedule to account for general overheads and this is configured based on line item description, start month, monthly cost in each year.
Includes comprehensive visuals and a final Executive Summary (annual periods) with key return metrics.
There is terminal value configurations if desired. This allows the user to set an exit multiple based on annualized EBITDA or revenue.