|
|
|
Home >
Business Tools
"Business Tools" are reporting and analytical
methods designed
to improve business performance or to reduce risk. You can use
many business tools with Excel.
 |
 |
 |
 |
|
|
|
FINANCIAL RATIOS
To
be honest, this item has no direct connection with Excel. But it certainly describes
an issue that many Excel users will recognize.As far as that goes, the style will
be familiar if you've ever read Kipling.
You might find it worth your time.
|
|
|
FINANCIAL RATIOS
Is your company growing faster than it can afford? Are you
continually scrambling to increase your debt-to-equity ratio? Sell stock?
Liquidate assets? Or take more drastic measures to finance your growth?
Business life doesn't have to be like that. The Sustainable Growth Rate can help you
manage your
company's financial ability to grow.
|
|
|
FINANCIAL RATIOS
Some managers feel buried under a mountain of debt. Others smile and say, "Debt is my friend!"
The difference between these two attitudes is simple: One manager is
making money on borrowed cash; the other isn't.
The EOA ratio compares directly to the interest rate on your
debt. When your EOA exceeds your interest rate, you're
making money from your debt.
|
|
|
FINANCIAL
MANAGEMENT
Unless you're a public accountant, you probably haven't experimented with Benford's Law.Auditors sometimes use this fascinating statistical insight to
uncover fraudulent accounting data. But it might
reveal a useful strategy for investing in the stock market. And it might
help you to improve the accuracy of your budgets and forecasts.
Excel 97-2003
version
Excel 2007
version
|
|
|
FINANCIAL ANALYSIS
A visitor asks,
"How do I calculate cumulative principle and interest for term loans?"
This is an interesting question. It touches on standard
amortizing loans, and it even involves a bright young student
who grew up to become a well-known mathematician. We provide the
Excel formulas.
|
|
 FINANCIAL
MANAGEMENT
If you knew that a business partner might go
bankrupt in the next year or two, you could better protect
yourself. But how can you predict whether a business is likely to
go bankrupt? Excel can help to find an answer. |
|
|
STRATEGIC DIRECTIONS
Because Excel can report data from any
number sources it
can reveal problems invisible
to other software.
|
 |
|
FINANCIAL MANAGEMENT
Are you making money or losing money on the
cash you borrow? Here's how to decide. |
|
|
|
|
|
SPREADSHEET ERRORS
The Chair of the European Spreadsheet Risk
Interest Group suggests ways to reduce spreadsheet errors. |
 |
|
STRATEGIC DIRECTIONS
Peter Drucker's recent advice could make
life difficult for overworked Excel users. |
|
|
|
|
|
FINANCIAL MANAGEMENT
By using the sustainable-growth-rate
formula, you can measure your company's financial ability to
grow. |
 |
|
FAILING SCORECARDS
Most implementations of balanced scorecards
may be failing. What's the solution? |
|
|
|
|
|
INTRODUCING BUSINESS TOOLS
New business techniques and ideas tend to
bring new and costly software. But Excel can offer a better
solution. |
 |
|
INTRODUCING TOOLS
Bain & Co. offers many techniques used to
make a business more successful.
|
|
|
|
|
|
|
|
|
|
| |
 |
ExcelUser, Inc.
http://www.ExcelUser.com
Copyright © 2004 - 2008
by Charles W. Kyd, all rights
reserved. Content, graphics, and HTML code are protected by
US and International Copyright Laws, and may not be copied,
reprinted, published, translated, hosted,
or otherwise distributed by any means without explicit permission.
Terms of Use | Privacy Policy | Earnings Policy. |
 |
 |
 |