Solutions and training for business users of Microsoft Excel.
Solutions and training for business users of Microsoft Excel.

 Excel User's Home
 ExcelUser Blog      
 Site Map              
 Contact              
 Excel for Business
 Excel Dashboards   
 Excel Solutions   
 Exploring Excel   
 BI for Excel    
  Business Tools
 Excel Catalog   
 Affiliate Program   
 Excel Help Portal  
 
   
     
   
     

Home > Business Tools

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 MANAGEMENT

Control Your Cost Lag Loop
To Help Survive the Recession

The world's economy is in recession, with no end in sight. Some companies are in desperate shape. Others are merely hurting.

Whatever your company's condition, it's a good idea to take stock of your business to figure out what you can do now to make your company healthy even if business gets worse.

You'll survive the downturn more easily if you master the cost-lag loop.


FINANCIAL MANAGEMENT

Predict Business Bankruptcy
Using Z Scores with Excel

Are Ford and GM heading for bankruptcy?

Prof. Edward Altman says they are. He's the man who invented Z-Scores, the best-known analytical tool for predicting the likelihood of business bankruptcy.

More to the point, is your largest customer heading for bankruptcy? Your most important vendors? Your own employer?

We show you how to calculate Z-Scores with Excel.


FINANCIAL RATIOS

Cash Trap

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

How Fast Is Too Fast?

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

Weighing Your Debt Load

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

Use Benford's Law to Help Planning

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

Calculate Term Loan Information

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.
 


STRATEGIC DIRECTIONS

Management Alerts

Because Excel can report data from any number sources it
can reveal problems invisible
to other software.

 
FINANCIAL MANAGEMENT

Weighing Debt

Are you making money or losing money on the cash you borrow? Here's how to decide.




SPREADSHEET ERRORS

Agile Spreadsheets

The Chair of the European Spreadsheet Risk Interest Group suggests ways to reduce spreadsheet errors.

STRATEGIC DIRECTIONS

A Guru's Advice

Peter Drucker's recent advice could make life difficult for overworked Excel users.




FINANCIAL MANAGEMENT

How Fast Is Too Fast?

By using the sustainable-growth-rate formula, you can measure your company's financial ability to grow.

FAILING SCORECARDS

Metric Madness

Most implementations of balanced scorecards may be failing. What's the solution?




INTRODUCING BUSINESS TOOLS

A World of Tools

New business techniques and ideas tend to bring new and costly software. But Excel can offer a better solution.

INTRODUCING TOOLS

Bain's Tools

Bain & Co. offers many techniques used to make a business more successful.





 
 
 

 


ExcelUser, Inc.
http://www.ExcelUser.com

Copyright © 2004 - 2012 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.


 


What's your greatest Excel challenge?