Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ABC Corporation - Balance Sheet Common Size Common Size Common Size ASSETS 2020 2021 2022 2023E Cash $ 2,500,000 9.8% $ 3,500,000 13.3% $ 2,496,145
ABC Corporation - Balance Sheet | ||||||||||||
Common Size | Common Size | Common Size | ||||||||||
ASSETS | 2020 | 2021 | 2022 | 2023E | ||||||||
Cash | $ 2,500,000 | 9.8% | $ 3,500,000 | 13.3% | $ 2,496,145 | 1 | $ 5,051,828 | 1 | ||||
A/R, net | 1,400,000 | 5.5% | 1,550,000 | 5.9% | 2,197,000 | 1 | 2,746,250 | 1 | ||||
Inventory | 1,400,000 | 5.5% | 1,625,000 | 6.2% | 2,112,500 | 1 | 2,448,185 | 1 | ||||
Pre-paid expenses | 700,000 | 2.7% | 700,000 | 2.7% | 500,000 | 1 | 500,000 | 1 | ||||
Total Current Assets | 6,000,000 | 23.5% | 7,375,000 | 28.0% | 7,305,645 | 1 | 10,746,262 | 1 | ||||
Building and Improvements | 15,000,000 | 58.8% | 15,000,000 | 56.9% | 17,500,000 | 1 | 17,500,000 | 1 | ||||
Equipment | 5,000,000 | 19.6% | 5,000,000 | 19.0% | 5,000,000 | 1 | 5,000,000 | 1 | ||||
Property Plant & Equimpent | 20,000,000 | 78.4% | 20,000,000 | 75.8% | 22,500,000 | 1 | 22,500,000 | 1 | ||||
Depreciation (accumulated) | 500,000 | 2.0% | 1,000,000 | 3.8% | 1,750,000 | 1 | 2,500,000 | 1 | ||||
Net PP&E | 19,500,000 | 76.5% | 19,000,000 | 72.0% | 20,750,000 | 1 | 20,000,000 | 1 | ||||
Total Assets | 25,500,000 | 100.0% | 26,375,000 | 100.0% | 28,055,645 | 1 | 30,746,262 | 1 | ||||
11 | 11 | |||||||||||
LIABILITIES | ||||||||||||
Accounts Payable | 600,000 | 2.4% | 775,000 | 2.9% | 1,053,786 | 1 | 1,263,465 | 1 | ||||
Notes Payable | 900,000 | 3.5% | 1,100,000 | 4.2% | 1,500,000 | 1 | 1,500,000 | 1 | ||||
Current portion of LTD | 1,000,000 | 3.9% | 1,000,000 | 3.8% | 1,000,000 | 1 | 1,000,000 | 1 | ||||
Accrued Liabilities | 500,000 | 2.0% | 500,000 | 1.9% | 500,000 | 1 | 500,000 | 1 | ||||
Total Current Liabilities | 3,000,000 | 11.8% | 3,375,000 | 12.8% | 4,053,786 | 1 | 4,263,465 | 1 | ||||
Long-Term Debt | 10,000,000 | 39.2% | 10,000,000 | 37.9% | 9,000,000 | 1 | 8,000,000 | 1 | ||||
Stockholder's Equity | ||||||||||||
Common Stock at Par | 100,000 | 0.4% | 100,000 | 0.4% | 100,000 | 1 | 100,000 | 1 | ||||
Paid in Capital | 10,900,000 | 42.7% | 10,900,000 | 41.3% | 10,900,000 | 1 | 10,900,000 | 1 | ||||
Retained Earnings | 1,500,000 | 5.9% | 2,000,000 | 7.6% | 4,001,860 | 1 | 7,482,798 | 1 | ||||
Total Stockholder's Equity | 12,500,000 | 49.0% | 13,000,000 | 49.3% | 15,001,860 | 1 | 18,482,798 | 1 | ||||
Total Liabilities + Equity | 25,500,000 | 100.0% | 26,375,000 | 100.0% | 28,055,646 | 1 | 30,746,262 | 1 | ||||
11 | 11 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started