Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel LTD. Balance Sheet December 31, 2022 Assets Liabilities and Shareholders Equity Current assets: Current liabilities: Cash 20,000.00 Accounts payable 100,000 Marketable securities 85,000.00 Bank
Excel LTD. Balance Sheet December 31, 2022 | |||
Assets | Liabilities and Shareholders Equity | ||
Current assets: | Current liabilities: | ||
Cash | 20,000.00 | Accounts payable | 100,000 |
Marketable securities | 85,000.00 | Bank loans | 125,000 |
Accounts receivable (net) | 100,000.00 | Accrued expenses | 5,000 |
Inventory | 375,000.00 | ||
Total current liabilities | 230,000 | ||
Total current assets | 580,000.00 | Long-term liabilities: | |
Net plant and equipment | 600,000.00 | Bonds payable* | 500,000 |
Total liabilities | 730,000 | ||
Shareholders equity: | |||
Common stock | 350,000 | ||
Retained earnings | 100,000 | ||
Total shareholders equity | 450,000 | ||
Total assets | 1,180,000.00 | Total liabilities and shareholders equity | 1,180,000 |
*Sinking fund provision of $50,000 a year. |
Excel LTD. Income Statement Year ending December 31, 20XX | ||
Sales (on credit) | 3,900,000.00 | |
Less: cost of goods sold | 3,465,000.00 | |
Gross profit | 435,000.00 | |
Selling and administrative expenses | 250,000.00 | |
Operating profit (EBIT) | 185,000.00 | |
Interest expense | 94,000.00 | |
Earnings before taxes (EBT) | 91,000.00 | |
Taxes (20%) | 18,200.00 | |
Earnings after taxes (EAT) | 72,800.00 |
What are ratios you will calculate if you are a Shareholder of the company?
Calculate the relevant ratios and comment if the shareholders will be satisfied
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