Financial Analysis Module - For Use With 3 Years Data
Financial Analysis Module - For Use With 3 Years Data
Financial Analysis Module - For Use With 3 Years Data
Revenue component 1 $ - $ - $ -
Revenue component 2
Revenue component 3
Revenue component 4
Total Revenues or Sales - - -
Cost of Goods Sold
Operating Income - - -
Selling Expenses
General & Administrative
Earnings Before Interest, Taxes,
Depreciation & Amortization
(EBITDA) - - -
Depreciation and Amortization
$1 $1
$1 $1
$1 $1
$1 $1
$1 $1
$1 $1
$0 $0
$0 $0
$0 $0
$0 $0
$- $-
2009 2010 2011 2009 2010 2011
Company Name Here
Assets
Cash & Cash Equivalents
Accounts Receivable
Inventory
Prepaid Expenses & Deposits
Other Current Assets
Total Current Assets - - -
Land and Buildings
Furniture and Equipment
Other Fixed Assets
Total Fixed Assets - - -
Total Assets - - -
Stockholder's Equity
Common Stock
Retained Earnings
Additional Paid-in Capital
Other Equity
Total Stockholder's Equity - - -
Working Capital
(Current Assets
- Current Liabilities) $ - $ - $ -
Company Name Here
Financial Analysis
Financial Analysis
Financial Analysis
12.00
Discussion
80
9.
Quick Ratio 2009 2010 2011 .40
8
Total Current 00
7.
Assets - 60
Inventories - - - 5.
.20
4
÷ Total Current 80
2.
Liabilities - - - 40
1.
-
2009 2010 2011
= Quick Ratio #DIV/0! #DIV/0! #DIV/0!
Discussion
Inventory to Net
Working Capital 60
2009 2010 2011 9.
40
8.
20
7.
Inventory - - - .00
6
.80
4
÷ Current Assets - 3.60
Current Liabilities - - - 40
2.
20
1.
Inventory to Net -
= Working Capital #DIV/0! #DIV/0! #DIV/0! 2009 2010 2011
Discussion
Company Name Here
Financial Analysis
Inventory 12.00
COGS - - - 6.00
4.00
÷
Inventory - - - 2.00
= -
Inventory
2009 2010 2011
Turnover #DIV/0! #DIV/0! #DIV/0!
Discussion
12.00
Total-Asset
Turnover 2009 2010 2011 10.00
8.00
6.00
Sales - - -
4.00
÷ 2.00
Total Assets - - -
-
= Total Asset 2009 2010 2011
Turnover #DIV/0! #DIV/0! #DIV/0!
Discussion
8.00
A/R - - -
6.00
Discussion
Company Name Here
Financial Analysis
Debt-to-Assets 12.00
= -
Debt-to-Assets
2009 2010 2011
Ratio #DIV/0! #DIV/0! #DIV/0!
Discussion
12.00
Debt-to-Equity
Ratio 2009 2010 2011 10.00
8.00
6.00
Total Debt - - -
4.00
÷ 2.00
Total Equity - - -
-
= Debt-to-Equity 2009 2010 2011
Ratio #DIV/0! #DIV/0! #DIV/0!
Discussion
12.00
Times Interest
Earned (TIE) or 10.00
6.00
EBIT - - -
4.00
÷ 2.00
Interest Expense - - -
-
= Times Interest 2009 2010 2011
Earned #DIV/0! #DIV/0! #DIV/0!
Discussion
Company Name Here
Financial Analysis
12.00
10.00
Net Profit Margin 2009 2010 2011
8.00
6.00
NIAT - - - 4.00
2.00
÷ Sales - - -
-
2009 2010 2011
= Net Profit Margin #DIV/0! #DIV/0! #DIV/0!
Discussion
12.00
Discussion
12.00
Discussion
The following two ratios are much less useful to a strategist because they do not use NIAT in the numerator:
12.00
12.00
Discussion
Company Name Here
Financial Analysis
Financial Analysis
The company has been well managed, has performed well, and is in strong financial condition. All supporting
indicators are P's, not N (see below).
In the table below, indicate up to seven financial indicators and their values as of the most recent year that
support your conclusion. All indicators chosen should somehow support the chosen conclusion. If you find
that, in fact, they support a different conclusion, then click on that one. Overwrite the examples shown with
support for your conclusion.
Based upon the conclusion chosen above, all indicators chosen should show strong performance to
support your conclusion. Indicate P or N for Positive or Negative in the column labeled "P/N."
NIAT NIAT increased 35.93% last year This is astounding growth rate. P
Debt/Equity Ratio D/E is 0.33, well below danger value of 2.0 Good indication of strong leverage. P