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.

Reviews Add a review
No reviews yet

More From smarthelping

Browse our top rated business templates. See All
Stock / Crypto Fund Portfolio Tracker: Multi-member Capable
This tool was designed for a multi-member fund to keep track of trading activity, the resulting distributions to investors, and…
Volume Discounts: Sensitivity Analysis
Any business that wants to offer discounts for higher volume purchases will benefit from this volume discount template. Simply enter…
Retirement Planning Financial Model
This is a retirement planner based on expected investments and the cash flow that produces against expected expenses (including taxes)…
Job Costing Tracker for Managers
This is a job costing tracker for any business that wants to see weekly and monthly total number of hours…
PPC Advertising Financial Calculator and Sensitivity Analysis
This is a sensitivity analysis calculator to help anyone who is doing PPC (pay per click) direct marketing or PPC…
IRR Target Investment Calculator
Investors can be confused with terminology that is used on deals and in offerings. The difference between IRR and ROI…
See All