Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare the following key performance indicators from the financial statements below Accounts Receivable and Inventory are both the year-end and average balances Show your work
Prepare the following key performance indicators from the financial statements below | ||||||||
Accounts Receivable and Inventory are both the year-end and average balances | ||||||||
Show your work OR use formulas in the cells | ||||||||
2. Make at least 4 meaningful observations regarding the company's 2023 performance | ||||||||
Quote a key performance indicator or another ratio in each of your observations | ||||||||
"Another ratio" can include a percentage change from 2022 to 2023 or an expense account / sales | ||||||||
2022 | 2023 | |||||||
Current Ratio | ||||||||
Days Sales Outstanding | ||||||||
Inventory Turnover | ||||||||
Sales Growth Rate - 2023 only | XXXXXXX | |||||||
Net Income Growth Rate - 2023 only | XXXXXXX | |||||||
Gross Profit Margin % | ||||||||
Operating Profit Margin % | ||||||||
Net Profit Margin % | ||||||||
Earnings per Share | ||||||||
PE Ratio | ||||||||
Balance Sheet as of December 31, | ||||||||
Current Assets | 2022 | 2023 | ||||||
Cash | 10,000 | 5,000 | ||||||
Accounts receivable (avg) | 30,000 | 42,000 | ||||||
Inventory (avg) | 25,000 | 40,000 | ||||||
Other Assets | 10,000 | 10,000 | ||||||
Current Assets | 75,000 | 97,000 | ||||||
Property Plant and Equipment | ||||||||
Equipment | 150,000 | 182,000 | ||||||
Less: Accum Depreciation | 58,000 | 68,000 | ||||||
Office equipment, Net | 92,000 | 114,000 | ||||||
Total Assets | 167,000 | 211,000 | ||||||
Current Liabilities | ||||||||
Accounts payable | 30,000 | 35,000 | ||||||
Accrued Expenses | 4,000 | 5,000 | ||||||
Other Current Liabilities | 3,000 | 3,000 | ||||||
Current Liabilities | 37,000 | 43,000 | ||||||
Notes payable, Due 2028 | 40,000 | 55,000 | ||||||
Total liabilities | 77,000 | 98,000 | ||||||
Stockholders Equity | ||||||||
Common stock | 40,000 | 40,000 | ||||||
Retained earnings | 50,000 | 73,000 | ||||||
Total equity | 90,000 | 113,000 | ||||||
Total liabilities and equity | 167,000 | 211,000 | ||||||
Income Statement For the 12 months ended December 31, | ||||||||
2022 | 2023 | |||||||
Sales revenue | 400,000 | 450,000 | ||||||
Cost of sales | 300,000 | 328,000 | ||||||
Gross Profit | 100,000 | 122,000 | ||||||
Operating Expenses | ||||||||
Salaries expense | 25,000 | 35,000 | ||||||
Marketing expense | 11,000 | 16,000 | ||||||
Technology expense | 14,000 | 15,000 | ||||||
Total Expenses | 50,000 | 66,000 | ||||||
Operating Income | 50,000 | 56,000 | ||||||
Interest expense | 5,000 | 6,000 | ||||||
Income Before Taxes | 45,000 | 50,000 | ||||||
Tax Expense | 9,000 | 12,000 | ||||||
Net Income | 36,000 | 38,000 | ||||||
Average Shares Outstanding | 10,000 | 10,000 | ||||||
Stock Price (per share) | 60 | 86 |
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