need it within 12 hours (final)

apurba
FIN600appendixlayout-Blankv3.xls
Home>Business & Finance homework help>Management homework help>need it within 12 hours (final)

Profitability Ratios

Profitability and Market Ratios - COMPANY ASX CODE
YYYY YYYY Average for Industry Industry average to be provided by facilitator
Return on Assets Profit / Average total assets Profit / ((Year 1 Total A + Year 2 Total A)/2) Profit /Year 2 Total A
0 0
0.00% 0.00% result %
Return on Equity Profit / Average equity Profit / ((Year 1 OE + Year 2 OE)/2) Profit /Year 2 OE
0 0
0.00% 0.00%
Net Profit Margin Net profit / Sales or revenue NP/ Revenue NP/ Revenue
0 0
0% 0% result %
Gross Profit Margin Gross profit / Sales or revenue GP/ Sales GP/ Sales
0 0
0% 0% result %
Net Interest Income Net Interest Income / Average Earning Assets NII / ((Year 1 earning A + Year 2 earning A)/2) NII / Year 2 earning A
for banks only 0 0
0.00% 0.00% result %
Expense ratio Expenses (excluding tax) / Net sales Exp / Revenue Exp / Revenue
(using operating expenses/operating income) 0 0
0% 0% result %
Cash return on sales Net cash flow from operating activity / Sales or Revenue $ op activities / REV $ op activities / REV
0 0
0% 0 result %
Earnings per share Profit for shareholders / Number of ordinary shares $xx per share $xx per share
EPS taken from annual report
Price earnings ratio Share price 30 June / Earnings per share $XX / EPS $XX / EPS
share price 30 June taken from annual report 0.0000 0.0000
XX times XX times result times
Earnings yield EPS / Share price 30 June EPS / $XX EPS / $XX
share price 30 June taken from annual report 0 0
0.00% 0.00% result %
Dividends per share Dividends - Special dividends/ No of shares $XX per share $XX per share $xx per share
(determined) DPS taken from annual report

Efficiency Ratios

Efficiency Ratios - COMPANY ASX CODE
YYYY YYYY Average for Industry Industry average to be provided by facilitator
Asset turnover Sales / Average total assets revenue / ((Year 1 Total A + Year 2 Total A)/2) revenue / Year 2 Total A
0 0
xx times xx times result times
Cashflow return on assets Net cash from op activities / Average total assets $ op activities/ A $ op activities/ A
0 0
result times result times result times
Fixed-Asset Turnover Ratio Sales / Total non current assets revenue / Total NCA revenue / Total NCA
0 0
xx times xx times result times

Liquidity Ratios

Liquidity Ratios - COMPANY ASX CODE
YYYY YYYY Average for Industry Industry average to be provided by facilitator
Current Ratio Total current assets / Total current liabilities CA / CL CA / CL
0 0
XX:1 XX:1 XX:1
Quick Ratio (Total current assets - Inventory) / Total current liabilities (CA - INV) / CL (CA - INV) / CL
0 0
result:1 result:1 XX:1
Receiveables turnover Credit sales rev / Avg receivables (Credit sales rev/ ((Year 1 Acc rec + Year 2 Acc rec)/2)/100) *365 (Credit sales rev/Acc rec)/100*366
(can only calculate if credit sales specified or provided) 0 0
result days result days result days
Average collection period Average receiveables x 365 / Net credit sales rev (Acc rec *365) / Rev (Acc rec *365) / Rev
(can only calculate if credit sales specified or provided) 0 0
xx days xx days result days

Gearing Ratios

Gearing Ratios - COMPANY ASX CODE
YYYY YYYY Average for Industry Industry average to be provided by facilitator
Debt to Equity Total debt / Total equity or Total liabilities / Total equity Debt / Equity Debt / Equity
or Actual debt / Total equity 0 0
- 0 - 0 result%
Debt ratio Total debt / Total assets Debt / Total Assets Debt / Total Assets
0 0
0% 0% result%
Equity Ratio Total equity / Total assets OE / A OE / A
0 0
0% 0% result%
Cash debt coverage Avg total liabilities / $$ from op activities ((Year 1 Total L + Year 2 Total L)/2) / $ operating activities Year 2 Total L / $ operating activities
0 0
0% 0% result%
Interest coverage ratio EBIT / Interest expense EBIT / Interest Exp EBIT / Interest Exp
0 0
xx times xx times result times