Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A (000's) Sales: 8 United States 9 Europe 10 Canada 11 Total Sales 12 13 COGS: 14 Labor 15 Raw Materials 16 Production 17 Total

image text in transcribedimage text in transcribed

A (000's) Sales: 8 United States 9 Europe 10 Canada 11 Total Sales 12 13 COGS: 14 Labor 15 Raw Materials 16 Production 17 Total COGS 18 19 Other Expenses: 20 Selling 21 Advertising 22 Administrative 23 24 25 26 27 28 B 1234567 Total Expenses Operating Income E F G Rush Creek Monthly Results January - Current Year Actual $ LA LA LA LA 180 $ 50 $ 20 $ 250 $ 50 $ 20 80 $ 150 $ 36 $ 12 $ 24 72 ASASA $ AAAA $ $ 28 $ H Favorable or (Unfavorable) Versus: Budget Last Year $ % 20 6 3 2 (15) (7) (3) (25) 4295 15 3104 (6) -8% -12% -13% -9% 7% 9% 10% 9% 8% 8% 0% 5% -18% $ $ % 13% 14% 18% 29 13% (5) -11% (2) -11% (10) -14% (17) -16% -13% (2) -20% (2) -9% (8) -13% 4 17% I J Comments 1 2 3456 Current Year = CY Last Year = LY Liquidity Ratios 6 7 Current Ratio Quick Ratio 8 9 10 Asset Management Ratios 11 Inventory Turnover 12 Days Sales Outstanding (DSO) 13 Total Asset Turnover 14 15 Debt Management Ratios 16 Debt to Equity Ratio 17 Debt Ratio 18 Times Interest Earned 19 A/P Days 20 21 Profitability Ratios 22 Profit Margin 23 Return on Assets 24 Return on Equity 25 Return on Invested Capital 26 27 Market / Valuation Ratios 28 Earnings Per Share (EPS) 29 Price / Earnings Ratio 30 Market Capitalization 31 32 33 Total Shareholder Return 34 35 Kush Creek Company Ratio Analysis CY LY N/A D H Calculations CA / CL (CA - Inv.) / CL COGS / Inv. A/R / Avg. Daily Sales Sales / TA Debt / Equity Debt / Total Assets EBIT/ Interst Exp. A/P / Avg. Daily COGS Net Income / Sales Net Income / TA Net Income / Equity EBIT (1-TR) / Invested Capital (use total liabs & equity for invested capital) Net Income / # Shares Share Price / EPS # Shares * Share Price (Dividends + SPA) / Original Investment (spa = share price appreciation) A (000's) Sales: 8 United States 9 Europe 10 Canada 11 Total Sales 12 13 COGS: 14 Labor 15 Raw Materials 16 Production 17 Total COGS 18 19 Other Expenses: 20 Selling 21 Advertising 22 Administrative 23 24 25 26 27 28 B 1234567 Total Expenses Operating Income E F G Rush Creek Monthly Results January - Current Year Actual $ LA LA LA LA 180 $ 50 $ 20 $ 250 $ 50 $ 20 80 $ 150 $ 36 $ 12 $ 24 72 ASASA $ AAAA $ $ 28 $ H Favorable or (Unfavorable) Versus: Budget Last Year $ % 20 6 3 2 (15) (7) (3) (25) 4295 15 3104 (6) -8% -12% -13% -9% 7% 9% 10% 9% 8% 8% 0% 5% -18% $ $ % 13% 14% 18% 29 13% (5) -11% (2) -11% (10) -14% (17) -16% -13% (2) -20% (2) -9% (8) -13% 4 17% I J Comments 1 2 3456 Current Year = CY Last Year = LY Liquidity Ratios 6 7 Current Ratio Quick Ratio 8 9 10 Asset Management Ratios 11 Inventory Turnover 12 Days Sales Outstanding (DSO) 13 Total Asset Turnover 14 15 Debt Management Ratios 16 Debt to Equity Ratio 17 Debt Ratio 18 Times Interest Earned 19 A/P Days 20 21 Profitability Ratios 22 Profit Margin 23 Return on Assets 24 Return on Equity 25 Return on Invested Capital 26 27 Market / Valuation Ratios 28 Earnings Per Share (EPS) 29 Price / Earnings Ratio 30 Market Capitalization 31 32 33 Total Shareholder Return 34 35 Kush Creek Company Ratio Analysis CY LY N/A D H Calculations CA / CL (CA - Inv.) / CL COGS / Inv. A/R / Avg. Daily Sales Sales / TA Debt / Equity Debt / Total Assets EBIT/ Interst Exp. A/P / Avg. Daily COGS Net Income / Sales Net Income / TA Net Income / Equity EBIT (1-TR) / Invested Capital (use total liabs & equity for invested capital) Net Income / # Shares Share Price / EPS # Shares * Share Price (Dividends + SPA) / Original Investment (spa = share price appreciation)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Innovation And Finance

Authors: Andreas Pyka, Hans-Peter Burghof

1st Edition

ISBN: 0415696852, 978-0415696852

More Books

Students also viewed these Finance questions