Complete the table using the Strategic Profit Model (SPM) Diagram Financial Term in SPM Value in...
Return on Assets Net Sales Gross Profit Margin Cost of Goods Operating Net Profit Before Tax PI Expense Accounts Receivable Return On Assets + Merchandise Inventory Total Current Assets Asset Turnover Cash Total Assets Fixed Assets Other Current Assets Use the charts on the following page to calculate Net Profit Margin % for each scenario: Scenario 1 Scenario 2 Income Statement Income Statement Sales Sales Gross Sales $200,000 Gross Sales $100,000 Promotional Allowances $25,000 Promotional Allowances $15,000 Customer Returns -$15,000...
Assignment 10-Strategic Profit Model A template of the strategic profit model is shown below. Given the data that follows complete the SPM. $20 $25 $90 $90 $100 $60 $25 $200 $15 Logistics Costs Cash Flxed Assets I Total Operating Costs COGS EBIT Current Assets Sales Other Operating Costs $50 Taxes $45 Inventory Assignment 10-Strategic Profit Model A template of the strategic profit model is shown below. Given the data that follows complete the SPM. $20 $25 $90 $90 $100 $60...
Calculate the ratios below given the financial data presented to your left. Answers Measures of Short-term Liquidity current assets / current liabilities quick assets / current liabilities net sales /accounts receivable 365 days/receivables turnover rate cost of goods sold/inventory current ratio quick ratico receivables turnover rate days to collect receivables inventory turnover rate Measures of Long-term Credit Risk total liabilities/total assets operating income /annual interest expense debt ratio Times Interest Earned Measures of Profitability net income / sales net income/total...
saw it's Your Turn.. Ise the Strategie Profit Model Flow Worksheets provided on the following page 1 complete the following two scenarios: Scenario 3 Scenario 4 Income Statement Sales Income Statement Sales Gross Sales $800,000 $1,400,000 Gross Sales Prmotional Allowances $75,000 Pemotional Allowances $150,000 Customer Returns -$45,000 -$110.000 Customer Returns Total Net Sales Total Net Sales Cost of Goods Sold Cost of Goods Sold COGS $850,000 $600,000 COGS Total COGS Total COGS Gross Margin Gross Margin Expenses Expenses Selling. General...
3 3. Complete the balance sheet and sales information in the table that follows J. White Industries using the following financial data: Debt ratio = 60% (Total Liabilities/Total Assets) Quick ratio = 0.95 (Current Assets-inventory)/Current Liabilities Total asset turnover = 2.00 Sales/Total Asset Days sales outstanding = 24 days (Accounts receivable/(sales÷365)) Gross profit margin = 20% (Sales – cost of goods sold)/sales Inventory turnover = 8.0 Cost of goods sold/inventory Balance Sheet Cash Accounts...
Given the financial statements for Jones Corporation and Smith Corporation: JONES CORPORATION Current Assets Liabilities Cash $ 22,000 Accounts payable $ 127,000 Accounts receivable 81,100 Bonds payable (long term) 85,600 Inventory 50,000 Long-Term Assets Stockholders' Equity Gross fixed assets $ 526,000 Common stock $ 150,000 Less: Accumulated depreciation 150,700 Paid-in capital 70,000 Net fixed assets* 375,300 Retained earnings 95,800 Total assets $ 528,400 Total liabilities and equity $ 528,400 Sales (on credit) $ 1,326,000 Cost of goods sold 790,000...
Given the financial statements for Jones Corporation and Smith Corporation: JONES CORPORATION Current Assets Liabilities Cash $ 22,000 Accounts payable $ 127,000 Accounts receivable 81,100 Bonds payable (long term) 85,600 Inventory 50,000 Long-Term Assets Stockholders' Equity Gross fixed assets $ 526,000 Common stock $ 150,000 Less: Accumulated depreciation 150,700 Paid-in capital 70,000 Net fixed assets* 375,300 Retained earnings 95,800 Total assets $ 528,400 Total liabilities and equity $ 528,400 Sales (on credit) $ 1,326,000 Cost of goods sold 790,000...
Given the financial statements for Jones Corporation and Smith Corporation JONES CORPORATION Current Assets Liabilities Cash Accounts receivable Inventory $ 25,800 Accounts payable S188,000 80,400 88,700 54,200 Bonds payable (long term) Long-Term Assets Stockholders' Equity $578,000 153,900 Gross fixed assets Common stock $150,000 70,000 104,400 $592,800 Less: Accumulated Paid-in capital 424,100 Retained earnings $592,800 Net fixed assets* Total assets Total liabilities and equity Sales (on credit) Cost of goods sold Gross profit Selling and administrative $1,717,000 782,000 $935,000 283,000 nse...
Problem # 1 (50 points) Given the Income Statement and Balance Sheet Compute: Current Ratio Acid-Test Ratio Days in Receivable Days in Inventory Operating Profit Margin Total Asset Tumover Fixed-asset turnover Debt Ratio Times Interest Earned Return on Equity Income Statement Balance Sheet Assets Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets Gross Plant and Equipment Accumulated Depreciation Net Fixed Assets Total Assets $200,000 $60,000 $100,000 $20,000 $380,000 $802,000 -$132,000 $670,000 $1,050,000 Sales (all credit) Cost of Goods Sold...
Given the financial statements for Jones Corporation and Smith Corporation: JONES CORPORATION Current Assets Liabilities Cash $ 25,900 Accounts payable $ 149,000 Accounts receivable 81,500 Bonds payable (long term) 80,300 Inventory 51,800 Long-Term Assets Stockholders' Equity Gross fixed assets $ 514,000 Common stock $ 150,000 Less: Accumulated depreciation 155,900 Paid-in capital 70,000 Net fixed assets* 358,100 Retained earnings 68,000 Total assets $ 517,300 Total liabilities and equity $ 517,300 Sales (on credit) $ 1,347,000 Cost of goods sold 790,000...