Free,
Handy, and Educational Excel Templates
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
An Extra Note:
Please write us if you find a template especially
useful, or if there is another free template that you would really like to see.
| 