Wholesale Investment Excel Calculator

This is an ROI calculator for wholesale companies looking to invest in new product lines.

by Andrew Grigolyunovich, CFA, CFM
Founder & CEO at CFOTemplates.comFollow 114

92 views|Start the discussion!|Bookmark Add to cart - $19.00

Description
This is a Return on Investment calculator for wholesale companies looking to introduce new product lines and want to calculate their break-even sales volume and ROI with given assumptions.

Containing the key metrics specific to a wholesale company, this model comes with detailed instructions. It is ready to download and use instantly.

Within this MS Excel spreadsheet are the following worksheets:

- Assumptions: These allow input of key wholesale assumptions, such as area of warehouse premises, rent, public utilities, interest rate per annum, and employment taxes and benefits.

- Sales Structure: This worksheet shows the sales structure for each retailer

- Sales: This section allows for evaluation of four different scenarios following an investment.

- Purchases: This model evaluates facilitating the purchases for each product group.

- NPV Plan: This will give you a strong idea as to whether the project will generate a sufficient return on investment.

- NPV Chart: Shows your projected development over time and in chart-form.

- Solver

If you have any questions or queries regarding this model, don’t hesitate to reach out by either starting a discussion below or by message privately via my Eloquens author channel.

Please show your appreciation by leaving a rating and review after having used this tool!

This Best Practice includes
1 Excel Model, 1 Excel Demo version Model