Question

1 Lake Athletics sells two distinct product lines: Apparel and Equipment. 2 The income statement for each product line appear9 Required: 0 1. Use appropriate Excel formulas to perform vertical analysis and complete the Percent columns 1 for both pr

  1. Compute and interpret financial ratios that managers use to assess liquidity.
  2. Compute and interpret financial ratios that managers use for asset management purposes.
  3. Compute and interpret financial ratios that managers use for debt management purposes.
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Lake Athletics
Income Statement:
Apparel Equipment
Amount$ Percent Amount$ Percent
Net Sales 3150000 100% 5550000 100%
COGS 1400000 44.44 2720000 49.01
Gross profit 1750000 55.56 2830000 50.99
Operating exp. 800000 25.40 875000 15.77
Operating income 950000 30.16 1955000 35.23
Other income 20000 0.63 10000 0.18
Income before tax 970000 30.79 1965000 35.41
Income tax exp.' 241250 7.66 491000 8.85
Net Income 728750 23.13 1474000 26.56
Highest Gross Profit % = Apparel with 55.56%
Highest Net Income % = Equipment with 26.56%
To calculation analysis ratios please provide the Balance Sheet figures.
Add a comment
Know the answer?
Add Answer to:
Compute and interpret financial ratios that managers use to assess liquidity. Compute and interpret financial ratios...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • use vertical analysis to cimpare profitability (all information shoukd be added as a formula) 1 1...

    use vertical analysis to cimpare profitability (all information shoukd be added as a formula) 1 1 FILE HOME INSERT PAGE LAYOUT Perform Vertical Analysis - Excel FORMULAS DATA REVIEW X VIEW Calibri - AA Sign in % Paste BIU M 10 points Alignment Number Conditional Format as Cell Formatting Table Styles Clipboard Cels Editing Font Skipped A1 f Lake Athletics sells two distinct product lines Apparel and Equipment A B 1 Lake Athletics sells two distinct product lines: Apparel and...

  • Chapter 13 Excel Simulations 1 Saved Help Jiyn. TUNIVIULAJ HUIVIE IIVJERT THUL LATOUI KEVIEVV VIEVY A...

    Chapter 13 Excel Simulations 1 Saved Help Jiyn. TUNIVIULAJ HUIVIE IIVJERT THUL LATOUI KEVIEVV VIEVY A A Calibri 11 1 Conditional Format as Cll Formatting Table Styles в IU- Paste Alignment Number Cells Editing Clipboard Font Styles C9 fx 30 points 1 Lake Athletics sells two distinct product lines: Apparel and Equipment. Skipped 2 The income statement for each product line appears below. LAKE ATHLETICS Income Statement eBook For the Year Ended December 31, 20X1 Apparel Equipment Amount Percent Amount...

  • 1. Use ratios to analyze a company's liquidity and solvency Calculate Select Ratios Excel 2 points FILE HOME INSERTP DATA PAGE LAYOUT FORMULAS REVIEW VIEW 6Calibri ED A Alignment Number Conditi...

    1. Use ratios to analyze a company's liquidity and solvency Calculate Select Ratios Excel 2 points FILE HOME INSERTP DATA PAGE LAYOUT FORMULAS REVIEW VIEW 6Calibri ED A Alignment Number Conditional Format as Cel l Editing Paste B 1 u· B-2-. Clipboard A1 N Formatting Table Styles eBook Styles Font VXfCondensed financial statements for Games Galore are summarized below: Ask 3 Balance Sheet 4 Cash 5 Accounts Receivable, Net 6 Inventory 7 Prepaid Insurance 8 Total Current Assets 9 Property...

  • SOVO Excel SIM: Selected Financial Ratios 1. Compute and interpret financial ratios that managers use to...

    SOVO Excel SIM: Selected Financial Ratios 1. Compute and interpret financial ratios that managers use to assess liquidity 2. Compute and interpret financial ratios that managers use for asset management purposes. 3. Compute and interpret financial ratios that managers use for debt management purposes S. FILE HOME INSERT PAGE LAYOUT Selected Financial Ratios - Excel FORMULAS DATA REVIEW 26 ? Caliber x VIEW ! Paste 10 A - 6 Sign in À Alignment Number BIU- B A Coboard Fort Conditional...

  • Excel SIM: Selected Financial Ratios 1. Compute and interpret financial ratios that managers use to assess...

    Excel SIM: Selected Financial Ratios 1. Compute and interpret financial ratios that managers use to assess liquidity. 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for debt management purposes. points SS.fi FILE HOME INSERT ? X Selected Financial Ratios - Excel FORMULAS DATA REVIEW - Sign In eBook PAGE LAYOUT VIEW Print * Calibri -110 A À = % D D References Paste B I U...

  • Excel SIM: Selected Financial Ratios 1. Compute and interpret financial rates that managers use to assess...

    Excel SIM: Selected Financial Ratios 1. Compute and interpret financial rates that managers use to assess day 2. Compute and pret financial restos that managers use for asset management purposes 3. Come and werpret financial rates the managers use for det management purposes. D. PI HOME Selected Financial Ratios. El FORMULAS DATA REVIEW 7 X INSERT PAGE LAYOUT VIEW Sign In Paste 10- - A Alignment Number Conditional Formats Cell Cells Editing Formatting. The Styles Font Styles X Recent financial...

  • Lake Athletics has provided you with the Income Statements for two of its product lines for...

    Lake Athletics has provided you with the Income Statements for two of its product lines for the year ended December 31. The Controller has asked you to perform the vertical analysis of the product lines and compare the two products. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in...

  • 7. Personal financial ratios Ratios are calculations that help you understand and interpret financial data. Ratio...

    7. Personal financial ratios Ratios are calculations that help you understand and interpret financial data. Ratio analysis is a tool that can help you measure your financial health. Indicate whether each of the following statements about ratio analysis is true or false. True False Personal financial ratios can be used to show how your income, savings, and debt are related 0 0 Financial ratios should only be used for a business's financial statements, not individual financial statements Personal financial ratios...

  • Use ratios to analyze a company's liquidity and solvency. 1 Condensed financial statements for Games Galore...

    Use ratios to analyze a company's liquidity and solvency. 1 Condensed financial statements for Games Galore are summarized below: 2 3 Balance Sheet 4 Cash 2016 2015 185,000 $ 143,000 5 Accounts Receivable, Net 6 Inventory 7 Prepaid Insurance 80,000 59,000 134,000 104,000 11,900 5,880 Total Current Assets 380,900 341,880 9 Property and Equipment, Net 514,500 407,000 895,400 $ 10 Total Assets 748,880 11 12 Current Liabilities 85,300 $ 96,800 13 Long-term Liabilities 284,000 224,000 14 Total Liabilities 369,300 320,800...

  • Compute and Interpret Cash Flow Ratios Use the following information to compute and interpret cash flow...

    Compute and Interpret Cash Flow Ratios Use the following information to compute and interpret cash flow ratios. Company Operating Cash Flow Average Current Liabilities CAPEX a ........ b. $2,106 5,668 3,702 2,700 $6,581 2,181 3,365 5,192 $2,425 1,007 1,220 1,984 d...... Required a. Compute the operating cash flow to current liabilities ratio. Compared to the average of 0.5 for large public companies, assess each company's liquidity as low, medium, or high (i.e., its ability to settle liabilities as they come...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT