Based on the information in the table, and using a 365-day year, calculate Average Credit Sales per Day. Round the answers to two decimal places Balance Sheet December 31, 2014 Cash and marketable securities $132,000 Accounts payable $399,000 Accounts receivable $311,000 Notes payable $98,500 Inventories $512,000 Accrued expenses $89,300 Prepaid expenses $11,300 Total current liabilities $586,800 Total current assets $966,300 Long-term debt $799,400 Gross fixed assets $2,104,000 Par value and paid-in-capital $298,000 Less: accumulated depreciation $398,000 Retained Earnings $988,100 Net fixed assets $1,706,000 Common Equity 1,286,100 Total assets $2,672,300 Total liabilities and owner’s equity $2,672,300 Income Statement, Year of 2014 Net sales (all credit) $4,276,600.00 Less: Cost of goods sold $3,292,982.00 Selling and administrative expenses $349,000.00 Depreciation expense $148,000.00 EBIT $486,618.00 Interest expense $49,600.00 Earnings before taxes $437,018.00 Income taxes $174,807.20 Net income $262,210.80
First we have to make a profit and loss statement and balance sheet from the given data
Balance Sheet December 31, 2014 | |||
Cash and marketable securities | 132000 | Accounts payable | 399000 |
Accounts receivable | 311000 | Notes payable | 98500 |
Inventories | 512000 | Accrued expenses | 89300 |
Prepaid expenses | 11300 | Total current liabilities | 586800 |
Total current assets | 966300 | Long-term debt | 799400 |
Gross fixed assets | 2104000 | Par value and paid-in-capital | 298000 |
Less: accumulated depreciation | 398000 | Retained Earnings | 988100 |
Net fixed assets | 1706000 | Common Equity | 12,86,100 |
Total assets | 2672300 | Total liabilities and owner’s equity | 2672300 |
Income Statement, Year of 2014 | |||
Net sales (all credit) | 4276600 | ||
Less: Cost of goods sold | 3292982 | ||
Selling and administrative expenses | 349000 | ||
Depreciation expense | 148000 | ||
EBIT | 486618 | ||
Interest expense | 49600 | ||
Earnings before taxes | 437018 | ||
Income taxes | 174807.2 | ||
Net income | 262210.8 | ||
Now we need to find Average Credit sales per day | |||
Average Credit sales per day | Total Credit Sales / No. of days in a year | ||
4276600 / 365 | |||
Answer is | = | 11716.71233 |
Based on the information in the table, and using a 365-day year, calculate Average Credit Sales...
Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in the table, and using a 365-day year, calculate operating cycle. Balance Sheet December 31, 2014 Cash and marketable securities $132,000 Accounts payable $399,000 Accounts receivable $311,000 Notes payable $98,500 Inventories $512,000 Accrued expenses $89,300 Prepaid expenses $11,300 Total current liabilities $586,800 Total current assets $966,300 Long-term debt $799,400 Gross fixed assets $2,104,000 Par value and paid-in-capital $298,000 Less: accumulated depreciation $398,000 Retained Earnings...
a) Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in the table, and using a 365-day year, calculate operating cycle. Round the answers to two decimal places Balance Sheet December 31, 2014 Cash and marketable securities $132,000 Accounts payable $399,000 Accounts receivable $311,000 Notes payable $98,500 Inventories $512,000 Accrued expenses $89,300 Prepaid expenses $11,300 Total current liabilities $586,800 Total current assets $966,300 Long-term debt $799,400 Gross fixed assets $2,104,000 Par value and paid-in-capital $298,000...
Based on the information in the table, calculate the firm's total debt-to-equity ratio. Round the answers to two decimal places in percentage form. (Write the percentage sign in the "units" box). Balance Sheet December 31, 2014 Accounts payable $399,000 Cash and marketable $132,000 securities Accounts $311,000 receivable Inventories $512,000 Prepaid expenses $11,300 Total current $966,300 assets Gross fixed assets $2,104,000 Less: accumulated $398.000 depreciation Net fixed assets $1,706,000 Notes payable $98,500 Accrued expenses $89,300 Total current $586,800 liabilities Long-term debt...
a) American Bacon Inc. financial statements are presented in the table below. Based on the information in the table, and using a 365-day year, calculate Average Credit Sales per Day. Round the answers to two decimal places Balance Sheet December 31, 2010 Cash and marketable securities $102,000 Accounts payable $287,000 Accounts receivable $299,000 Notes payable $61,200 Inventories $628,000 Accrued expenses $51,900 Prepaid expenses $10,300 Total current liabilities $400,100 Total current assets $1,039,300 Long-term debt $415,000 Gross fixed assets $1,502,000 Par value...
Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in the table, and using a 365-day year, calculate cash conversion cycle Round the answers to two decimal places 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...
a) American Bacon Inc. financial statements are presented in the table below. Based on the information in the table, and using a 365-day year, calculate Average Day’s Cost of Goods Sold. Round the answers to two decimal places Balance Sheet December 31, 2010 Cash and marketable securities $102,000 Accounts payable $287,000 Accounts receivable $299,000 Notes payable $61,200 Inventories $628,000 Accrued expenses $51,900 Prepaid expenses $10,300 Total current liabilities $400,100 Total current assets $1,039,300 Long-term debt $415,000 Gross fixed assets $1,502,000 Par...
a) Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in the table, and using cost of goods sold and a 365-day year, calculate Days of Sales in Inventory (using cost of goods sold). Round the answers to two decimal places 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...
Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in the table, and using a 365-day year, calculate the average collection period (also called Days of Sales in Receivables or Number of Days of Credit). Round the answers to two decimal places 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...
Notes Based on year-end balance sheet figures. Calculation is based on a 365-day year. SPREADSHEET PROBLEM (3-15) Analysis Start with the partial model in the file Ch03 P15 Build a Model.XIS From the textDOORS Web site. Joshua & White (J&W) Technology's financial statements are also shown here. Answer the following questions. (Note: Industry average ratios are provided in Ch03 P15 Build a Model.xlsx.) a. Has J&W's liquidity position improved or worsened? Explain. b. Has J&W's ability to manage its assets...
what is the
A) Quick ratio
B) Sales Outstanding (assume a 365-day year)
C) Total assests turnover
D) Inventory turnover rate
E) TIE
F) Total Debt to total capital ratio
G) ROA
H) ROE
I) Profit margin
J) Return invested capital
K) Operating Margin
L) EPS
M) P/E ratio
N) Book value per share
O) Equity multiplier
DO NOT ROUND INTERMEDIATE CALCULATIONS
Exhibit 4.1 The balance sheet and income statement shown below are for Koski Inc. Note that the firm...