WEEK 1 HW

Alexsandra2496
CopyofFinanceHomework3.xlsx

Sheet1

A B C D E
Part A 25 Points
Problem Set - Fill in each of the missing cells for all the firms listed below.
ROS 0.00% 0.00% 0.00% 0.00% 0.00%
ROA 0.00% 0.00% 0.00% 0.00% 0.00%
ROE 0.00% 0.00% 0.00% 0.00% 0.00%
Leverage 0.00 0.00 0.00 0.00 0.00
Current Ratio 0.00 0.00 0.00 0.00 0.00
Quick Ratio 0.00 0.00 0.00 0.00 0.00
SG&A % 0.00% 0.00% 0.00% 0.00% 0.00%
Contrib. Margin % 0.00% 0.00% 0.00% 0.00% 0.00%
Break-even $0 $0 $0 $0 $0
Balance Sheet Survey (000) A B C D E
Cash $13,283 $21,087 $14,914 $0 $82,227
Accounts Receivable $34,178 $6,510 $19,029 $15,420 $31,037
Inventory $25,532 $12,330 $122,374 $16,340 $33,270
Total Current Assets $72,992 $39,927 $156,318 $31,760 $146,533
Plant and equipment $368,900 $108,600 $265,620 $67,800 $422,600
Accumulated Depreciation ($182,593) ($68,053) ($156,531) ($52,520) ($165,900)
Total Fixed Assets $186,307 $40,547 $109,089 $15,280 $256,700
Total Assets $259,299 $80,474 $265,407 $47,040 $403,233
Accounts Payable $6,950 $3,845 $14,363 $5,191 $18,625
Current Debt $0 $0 $0 $14,033 $49,337
Long Term Debt $70,539 $0 $59,486 $9,600 $121,165
Total Liabilities $77,489 $3,845 $73,849 $28,824 $189,127
Common Stock $90,120 $23,360 $48,360 $32,048 $44,951
Retained Earnings $91,690 $53,269 $143,199 ($13,833) $169,155
Total Equity $181,810 $76,629 $191,558 $18,215 $214,106
Total Liabilities & Owners' Equity $259,299 $80,474 $265,407 $47,040 $403,233
Income Statement Survey (000) A B C D E
Sales $204,507 $79,202 $231,525 $93,804 $377,615
Variable Costs (Labor, Material, Carry) $98,929 $39,511 $161,995 $69,970 $197,325
Depreciation $24,593 $7,240 $17,708 $4,520 $28,173
SGA (R&D, Promo, Sales, Admin) $23,152 $12,555 $23,381 $19,533 $17,262
Other (Fees, Writeoffs, TQM, Bonuses) ($2,412) $12,000 $0 $1,504 $2,547
EBIT $60,245 $7,897 $28,441 ($1,724) $132,308
Interest (Short term, Long term) $9,292 $0 $7,217 $3,480 $23,143
Taxes $17,833 $2,764 $7,429 ($1,822) $38,208
Profit Sharing $662 $103 $276 $0 $1,419
Net Profit $32,457 $5,030 $13,520 ($3,383) $69,538
Part B. 25 points
Write a one page paper explaining which firm is the best firm from a financial analysis perspective.