For business users of Microsoft Excel.
For business users of Microsoft Excel.

 Home              
 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" are reporting and analytical methods designed
to improve business performance or to reduce risk. You can use
many business tools 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.
 


FINANCIAL MANAGEMENT

Predict Business Bankruptcy

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

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 - 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.

 


What's your greatest Excel challenge?