Wholesale Investment Excel Calculator
Originally published: 29/04/2019 15:44
Publication number: ELQ-44174-1
View all versions & Certificate

Wholesale Investment Excel Calculator

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

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

Acquire business license for $19.00

Add to cart

Add to bookmarks



  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Andrew Grigolyunovich, CFA, CFM, FMVA

See all

Any questions on Wholesale Investment Excel Calculator?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...