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. |
Compute and interpret financial ratios that managers use to assess liquidity. Compute and interpret financial ratios...
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 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 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 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 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 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 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 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 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 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...