Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EXHIBIT 1 : COMMON - SIZE BALANCE SHEET ( % ) table [ [ Company , A , B , C , D ,

EXHIBIT 1: COMMON-SIZE BALANCE SHEET (%)
\table[[Company,A,B,C,D,E,F,G,H,I,J],[Current Assets],[Cash and Cash Equivalents,11.57,3.84,16.02,4.47,7.50,1.48,0.78,3.96,1.13,22.80],[Other Short-Term Investments,,3.56,8.40,-,5.44,-,5.09,42.74,3.10,5.01],[Accounts Receivable,9.29,28.55,9.24,6.36,4.60,9.71,4.95,10.30,4.17,33.97],[Inventory,0.25,3.32,9.10,0.00,3.91,49.39,7.21,0.72,17.96,0.00],[Prepaid Asset,2.60,0.11,-,1.96,2.18,1.91,-,-,1.55,-],[Other Current Assets,2.87,0.04,-,-,-,-,1.57,3.54,0.44,1.79],[Non-Current Assets],[Net Property, Plant, and Equipment,34.64,59.65,43.44,57.24,12.55,11.60,8.34,15.30,56.76,0.93],[Goodwill,10.13,-,8.35,15.16,19.41,0.50,35.02,14.67,8.10,1.91],[Other Intangible Assets,4.66,0.64,-,8.00,11.58,20.61,21.12,2.70,3.30,-],[Investments and Advances,5.24,-,-,-,23.01,0.26,10.23,0.92,-,25.04],[Other Non-Current Assets,10.21,0.29,5.45,6.82,7.03,4.54,2.66,5.14,3.50,-],[Other Investment,8.55,-,-,-,2.79,-,3.05,-,-,8.55],[Total Assets,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00],[Current Liabilities],[Accounts Payables,9.00,-,35.35,12.47,12.39,32.61,4.36,5.25,15.90,56.06],[Pension and Post-Retirement Benefits,4.26,-,-,-,1.18,-,1.62,2.38,0.00,8.89],[Current Debt,8.11,1.39,-,3.54,17.65,10.57,9.67,1.92,8.28,1.47],[Other Current Liabilities,8.08,1.70,3.64,15.30,0.00,0.00,6.62,14.66,13.27,8.60],[Non-Current Liabilities],[Long-Term Debt,192.33,11.56,10.39,13.75,31.85,3.54,21.47,23.26,31.67,13.17],[Long-Term Capital Lease Obligation,13.57,2.63,17.67,9.44,0.00,0.00,7.24,12.49,0.00,1.57],[Other Non-Current Liabilities,17.87,1.24,5.40,23.94,12.46,5.66,11.14,4.31,10.33,0.87],[Total Equity,-153.24,81.47,27.55,23.80,24.42,47.63,37.88,35.71,20.55,9.38],[Total Liability and Equity,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00]]
Note: -= not separately disclosed
Source: Financial information for each company (A to J) compiled by the case authors with information from Yahoo! Finance; for the purposes of this exercise, detailed reference information was omitted to avoid revealing the 10 company names.
EXHIBIT 2: COMMON-SIZE INCOME STATEMENT (%)
\table[[Company,A,B,C,D,E,F,G,H,I,J],[Total Revenue,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00],[Cost of Goods Sold,36.63,42.30,73.35,77.91,39.23,74.06,19.75,34.10,78.32,18.88],[Gross Profit,63.37,57.70,26.65,22.09,60.77,25.94,80.25,65.90,21.68,81.12],[Operating Expenses,12.07,3.14,21.46,8.01,32.51,24.07,53.35,31.76,19.52,37.76],[Selling, General, and Administrative,12.07,2.96,8.58,4.24,32.48,20.83,27.73,18.35,17.49,41.13],[Research and Development,-,0.17,12.81,-,-,-,16.71,13.41,2.03,-],[Other Operating Expenses,-,0.01,0.07,3.77,0.03,3.24,8.91,-,-,-3.36],[Operating Income,51.30,54.56,5.19,14.08,28.26,1.87,26.90,34.14,2.16,43.36],[Non-Operating Interest Expenses,

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_2

Step: 3

blur-text-image_3

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

Investment Analysis and Portfolio Management

Authors: Frank K. Reilly, Keith C. Brown

10th Edition

538482109, 1133711774, 538482389, 9780538482103, 9781133711773, 978-0538482387

More Books

Students also viewed these Finance questions

Question

Describe the main aims and phases of the CRISP-DM model.

Answered: 1 week ago

Question

What is an interface? What keyword is used to define one?

Answered: 1 week ago