Question: Prepare the common-size Income Statement and Balance Sheet for each company (vertical analysis). Format your common-size columns to Percent with two decimal places. Archer Inc.
- Prepare the common-size Income Statement and Balance Sheet for each company (vertical analysis). Format your common-size columns to Percent with two decimal places.
| Archer Inc. | Bayside Inc. | Citywide Ltd. | |
| Assets | |||
| Current Assets | |||
| Cash | 55,000 | 155,000 | 1,000,000 |
| Net Accounts Receivable | 28,000 | 105,000 | 630,000 |
| Net Inventory | 15,000 | 135,000 | 575,000 |
| Short-term Investment | 0 | 5,000 | 200,000 |
| Total Current Assets | 98,000 | 400,000 | 2,405,000 |
| Fixed Assets | |||
| Fixed Assets | 35,000 | 370,000 | 300,000 |
| Accumulated Amortization | 5,000 | 45,000 | 50,000 |
| Net Fixed Assets | 30,000 | 325,000 | 250,000 |
| Intangible Assets | |||
| Goodwill | 0 | 70,000 | 350,000 |
| Accumulated Amortization | 0 | 10,000 | 100,000 |
| Net Goodwill | 0 | 60,000 | 250,000 |
| Total Assets | 128,000 | 785,000 | 2,905,000 |
| Liabilities and Shareholders' Equity | |||
| Current Liabilities | |||
| Accounts Payable | 35,000 | 170,000 | 1,100,000 |
| Accruals | 5,000 | 30,000 | 75,000 |
| Total Current Liabilities | 40,000 | 200,000 | 1,175,000 |
| Long-Term Liabilities | |||
| Loan Payable | 15,000 | 234,000 | 250,000 |
| Total Long-Term Liabilities | 15,000 | 234,000 | 250,000 |
| Total Liabilities | 55,000 | 434,000 | 1,425,000 |
| Shareholders' Equity | |||
| Beginning Balance | 10,000 | 100,000 | 412,500 |
| Prior Retained Earnings | 48,825 | 131,960 | 647,500 |
| Net Income | 14,175 | 119,040 | 420,000 |
| Ending Balance | 73,000 | 351,000 | 1,480,000 |
| Total Liabilities and Shareholders' Equity | 128,000 | 785,000 | 2,905,000 |
| # of Shares Outstanding | 5,000 | 10,000 | 75,000 |
| Price per Share | $ 2.00 | $ 10.00 | $ 5.50 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
