How to solve these? Question 3 Canadian Bacon Inc. financial statements are pres
ID: 2775938 • Letter: H
Question
How to solve these?
Question 3
Canadian Bacon Inc. financial statements are presented in the table below.
Based on the information in the table, calculate the firm’s the net-working capital – to-sales ratio.
Round the answers to two decimal places in percentage form. (Write the percentage sign in the "units" box).
Balance Sheet December 31, 2015
Cash and marketable securities
$187,000
Accounts payable
$217,000
Accounts receivable
$498,000
Notes payable
$51,500
Inventories
$799,000
Accrued expenses
$58,300
Prepaid expenses
$19,300
Total current liabilities
$326,800
Total current assets
$1,503,300
Long-term debt
$215,400
Gross fixed assets
$1,978,000
Par value and paid-in-capital
$128,000
Less: accumulated depreciation
$478,000
Retained Earnings
$2,333,100
Net fixed assets
$1,500,000
Common Equity
2,461,100
Total assets
$3,003,300
Total liabilities and owner’s equity
$3,003,300
Income Statement, Year of 2015
Net sales (all credit)
$5,386,600.00
Less: Cost of goods sold
$3,716,754.00
Selling and administrative expenses
$329,000.00
Depreciation expense
$138,000.00
EBIT
$1,202,846.00
Interest expense
$39,600.00
Earnings before taxes
$1,163,246.00
Income taxes
$465,298.40
Net income
$697,947.60
Answer:
(21.84)
(%)
Gross Profit Margin
Question 4
Canadian Bacon Inc. financial statements are presented in the table below.
Based on the information in the table, calculate the firm’s gross profit margin.
Round the answers to two decimal places in percentage form. (Write the percentage sign in the "units" box).
Balance Sheet December 31, 2011
Cash and marketable securities
$143,000
Accounts payable
$278,000
Accounts receivable
$354,000
Notes payable
$87,000
Inventories
$672,000
Accrued expenses
$65,000
Prepaid expenses
$12,500
Total current liabilities
$430,000
Total current assets
$1,181,500
Long-term debt
$284,000
Gross fixed assets
$1,675,000
Par value and paid-in-capital
$228,000
Less: accumulated depreciation
$500,000
Retained Earnings
$1,414,500
Net fixed assets
$1,175,000
Common Equity
1,642,500
Total assets
$2,356,500
Total liabilities and owner’s equity
$2,356,500
Income Statement Year of 2011
Net sales (all credit)
$3,136,600.00
Less: Cost of goods sold
$2,195,620.00
Selling and administrative expenses
$345,000.00
Depreciation expense
$146,000.00
EBIT
$449,980.00
Interest expense
$45,300.00
Earnings before taxes
$404,680.00
Income taxes
$161,872.00
Net income
$242,808.00
Answer:
(30.00)
(%)
Operating Profit Margin
Question 5
Canadian Bacon Inc. financial statements are presented in the table below.
Based on the information in the table, calculate the firm’s the operating profit margin.
Round the answers to two decimal places in percentage form. (Write the percentage sign in the "units" box).
Balance Sheet December 31, 2012
Cash and marketable securities
$198,000
Accounts payable
$288,000
Accounts receivable
$469,000
Notes payable
$65,000
Inventories
$577,000
Accrued expenses
$84,000
Prepaid expenses
$15,700
Total current liabilities
$437,000
Total current assets
$1,259,700
Long-term debt
$237,000
Gross fixed assets
$1,954,000
Par value and paid-in-capital
$199,000
Less: accumulated depreciation
$476,000
Retained Earnings
$1,864,700
Net fixed assets
$1,478,000
Common Equity
2,063,700
Total assets
$2,737,700
Total liabilities and owner’s equity
$2,737,700
Income Statement, Year of 2012
Net sales (all credit)
$7,546,600.00
Less: Cost of goods sold
$6,112,746.00
Selling and administrative expenses
$349,000.00
Depreciation expense
$145,000.00
EBIT
$939,854.00
Interest expense
$49,500.00
Earnings before taxes
$890,354.00
Income taxes
$356,141.60
Net income
$534,212.40
Answer:
(12.45)
(%)
Net Profit Margin
Question 6
Canadian Bacon Inc. financial statements are presented in the table below.
Based on the information in the table, calculate the firm’s net profit margin.
Round the answers to two decimal places in percentage form. (Write the percentage sign in the "units" box).
Balance Sheet December 31, 2013
Cash and marketable securities
$112,000
Accounts payable
$211,000
Accounts receivable
$325,000
Notes payable
$51,500
Inventories
$426,000
Accrued expenses
$50,100
Prepaid expenses
$10,700
Total current liabilities
$312,600
Total current assets
$873,700
Long-term debt
$225,000
Gross fixed assets
$1,514,000
Par value and paid-in-capital
$117,000
Less: accumulated depreciation
$315,000
Retained Earnings
$1,418,100
Net fixed assets
$1,199,000
Common Equity
1,535,100
Total assets
$2,072,700
Total liabilities and owner’s equity
$2,072,700
Income Statement, Year of 2013
Net sales (all credit)
$3,256,600.00
Less: Cost of goods sold
$2,572,714.00
Selling and administrative expenses
$323,000.00
Depreciation expense
$115,000.00
EBIT
$245,886.00
Interest expense
$29,600.00
Earnings before taxes
$216,286.00
Income taxes
$86,514.40
Net income
$129,771.60
Answer:
(3.98)
(%)
Question 3
Explanation / Answer
Answer for question no.3:
Net working capital = Current assets - Current liabiities.
$1,503,300 - $326,800 =$1,176,500.
Sales =$5,386,600.
Net working capital to sales ratio = Net working capital/Sales *100
=21.84%.
Answer for question no.4:
Gross profit = Sales - Cost of goods sold
=3136600 -2195620
=940980
Gross profit margin = Gross profit/Net sales *100
=$940,980/$3,136,600
=30%
Answer for question no.5:
Operating profit = Income before interest and taxes.
Operating profit = EBIT.
Formula for operating profit margin = (Operating profit/Sales) *100.
Given EBIT=$939,584.
Sales =$7,546,600
Operating profit margin =($939,584./$7,546,600)*100
=12.45%
Answer for question no.6:
Net profit margin = Net profit/Sales *100
Net profit = Earnings after interest and taxes.
=$129,771.60.
Sales =$3,256,600
Net profit margin = ($129,771.60./$3,256,600)*100
=3.98%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.