Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to see the excel formulas you use, PLEASE. I will not learn if you don't show me the formulas. This is my third
I need to see the excel formulas you use, PLEASE. I will not learn if you don't show me the formulas. This is my third time posting this, and I keep getting answers without showing me the excel formula.
Sled Compan 20,000 3,200 64,000 87,680 3,520 274,400 452,800 Cash Notes receivable short term Accounts Receivable, net Inventory Prepaid expenses Plant and equipment, net Total assets 11,900 7,700 42,000 58,800 232,120 354,200 10 Current liabilities Mortgage payable Common stock, $10 par value Retained Earnings Total Liabilities and stockholders' equity 80,000 80,000 160,000 132,800 452,800 56,000 70,000 140,000 88,200 354,200 12 13 14 15 16 17 18 19 20 21 Data from the Current Year's Income Statement Sales Cost of goods sold Interest expense Net income 672,000 528,080 4,200 23,373 880,000 699,840 5,600 28,896 Beginning of Year Data $85,120 60,000 443,200 285,120 Inventory Accounts Receivable, net Total assets Stockholders' equity 53,200 45,000 345,800 217,000 23 24 25 26 Required: 28 29 1. Identify and total current assets (Use a formula) 2. Identify and total current liabilities (Use a formula) 3. Identify and total "quick" assets (Use a formula) 4. On the Ratio analysis tab, using only cell references and formulas, calculate the following 31 32 Working Capital Current Ratio Quick (Acid Test Ratio) Cash Ratio 35 37 38 39 5. Calculate Average Inventory (Use AVG function) 6. Calculate Gross Profit (Use a formula) 7. Calculate Average Accounts Receivable (Use AVG function) 8. On the Ratio analysis tab, using only cell references and formulas, calculate the following Inventory turnover Days sales in inventory Gross profit percentage Accounts receivable turnover ratio Days' sales in receivables (uncollected) 42 9. Identify and total liabilities (Use a formula) 10. Identify and total equity (Use a formula) 11. On the Ratio analysis tab, using only cell references and formulas, calculate the following 47 49 50 51 52 53 54 Debt Ratio Debt to Equity Ratio Times-Interest-Earned Ratio 12. Calculate Average common stockholders' equity (Use AVG function) 13. Calculate # shares outstanding (Use a formula) 14. Calculate Average total assets (Use AVG function) 15. On the Ratio analysis tab, using only cell references and formulas, calculate the following 56 57 58 59 60 Profit Margin Ratio Rate of Retun on Total Assets Asset Turnover Ratio Rate of Return on Common Stockholders' Equity Earnings Per ShareStep 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