Retail Investment Excel Calculator
Originally published: 18/04/2019 13:38
Publication number: ELQ-52704-1
View all versions & Certificate

Retail Investment Excel Calculator

This is a calculator for retail companies that plan to open a new shop and want to work out their Return on Investment.

This is an ROI calculator for retail companies that plan to open a new shop and want to calculate their return on investment with given assumptions and breakeven sales volume.

It is an extremely useful tool for those who which to understand the profitability of opening a new store.

This worksheet contains key assumptions that are needed to calculate current costs and sales in the “NPV plan” worksheet.

It is presented in an easily understandable MS Excel document, ready-to-use, and instantly downloadable.

This calculator has 5 tabs, these include:

- Assumptions; Fill your data on assumptions that include sq ft area, rent, rent %, public utilities, marketing fees, # of employees, average gross squares, interest rate per anum, employment taxes and benefits, sales growth rate.
- Scenarios; Allows for four different scenarios, worst case, base case, optimistic case, and a break-even case.
- NVP plan; Net Present Value and ROI calculations are made here.
- NVP Chart; showing calculation in a visual manner
- Solver; solve mathematical problems

If you have any questions, or queries, surrounding this tool, you’re able to either start a discussion below or contact us directly via private message via our Eloquens author account!

Enjoyed this tool? Show your appreciation by leaving a review and a rating.

This Best Practice includes
2 Excel Spreadsheets

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 Retail Investment Excel Calculator?

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

0.0 / 5 (0 votes)

please wait...