These are postings of working Excel templates that solve business problems or demonstrate business principles.
Depending on your browser, these templates may open 'live' and functional in your browser window.
You can also copy these templates onto your own computer. In Internet Explorer, right-click your mouse button over the link name, choose 'save target as,' and follow the prompts.
Please write us if you have a request for a template on a different subject!
Forecasting Template -- Takes monthly historic data, to calculate a new-year monthly forecast with consideration for seasonality, secular trending, and the current business cycle
Price Analysis Template -- Uses test prices and corresponding test quantities sold, to estimate the highest-volume price, the highest gross-revenue price, and the highest contribution-margin price
Universal Trend Charter Template -- Takes any time-sequenced stream of readings or measurements to create a real-time chart showing data points, average line, and statistical boundaries, thus distinguishing real trends from mere noise
NPV Solution Template -- Accepts any set of investment costs, expected returns, and discount rate percentages to calculate the Net Present Value of doing any given project
Break-Even Visualizer Template -- Uses prices, costs, discount percentages, and crash-cost estimates to create a bent-line break-even chart illustrating what happens to profit when discounts and expediting occur at over-capacity volumes
Posts
No comments:
Post a Comment