Problem 2-1: Preparing Financial Statements
Information below is for Buraydah Manufacturing, Inc. for the year ended December 31, 20x1 except where beginning of year numbers indicated. All amounts in SAR unless otherwise stated. |
|
Accumulated depreciation |
2,817,000 |
Sales |
5,826,000 |
Accounts receivable |
233,000 |
Interest expense |
237,000 |
Cost of goods sold |
2,672,000 |
Short term notes payable |
195,000 |
Income taxes |
366,600 |
Inventories |
967,000 |
Common stock |
428,000 |
Dividends paid |
120,000 |
Cash |
986,500 |
Marketing, general and administrative expenses |
1,678,500 |
Long term debt |
5,844,000 |
Fixed assets (property & equipment) |
7,218,000 |
Accounts payable |
395,000 |
Other assets |
862,000 |
Depreciation expense |
422,000 |
Retained earnings at beginning of year |
419,600 |
Number of shares of common stock |
1,000 |
Using the information above: |
|
1. Prepare an income statement in good form |
|
2. Prepare end of year balance sheet in good form |
|
3. Calculate net working capital |
|
4. Calculate the debt ratio |
|
Using an additional column for each financial statement: |
|
5. Prepare a common sized income statement |
|
6. Prepare a common sized balance sheet |
|
Buraydah Manufacturing, Inc. | |
Income Statement | |
For Dec 31, 20x1 | Amount (SAR) |
sales | 5826000 |
less:cost of goods sold | -2672000 |
gross profit | 3154000 |
less:marketing expenses | -1678500 |
operating income | 1475500 |
less:depreciation expense | -422000 |
EBIT | 1053500 |
less:interest expense | -237000 |
EBT | 816500 |
less:tax | -366600 |
net profit | 449900 |
Buraydah Manufacturing, Inc. | |||||
Balance sheet | |||||
As of Dec 31, 20x1 | |||||
Liabilities | Amount (SAR) | Assets | Amount (SAR) | ||
accounts payable | 395000 | cash | 986500 | ||
short term notes payable | 195000 | accounts receivable | 233000 | ||
long term debt | 5844000 | inventories | 967000 | ||
common stock | 428000 | fixed assets | 7218000 | ||
retained earnings start | 419600 | less:depreciation | -2817000 | 4401000 | |
net profit for the year | 449900 | other assets | 1024000 | ||
less:dividend | -120000 | 749500 | |||
total | 7611500 | total | 7611500 |
working capital | total current assets - total current liabilities |
Amount (SAR) | |
current assets: | |
cash | 986500 |
accounts receivable | 233000 |
inventories | 967000 |
total current assets | 2186500 |
current liabilities: | |
accounts payable | 395000 |
short term notes payable | 195000 |
total current liabilities | 590000 |
working capital | 1596500 |
debt ratio | total liabilities / total assets |
Amount (SAR) | |
total liabilities | |
accounts payable | 395000 |
short term notes payable | 195000 |
long term debt | 5844000 |
total liabilities | 6434000 |
total assets | 761150 |
debt ratio | 8.45 |
common size
Buraydah Manufacturing, Inc. | ||
Income Statement | ||
For Dec 31, 20x1 | Amount (SAR) | common size |
sales | 5826000 | 100.00% |
less:cost of goods sold | -2672000 | -45.86% |
gross profit | 3154000 | 54.14% |
less:marketing expenses | -1678500 | -28.81% |
operating income | 1475500 | 25.33% |
less:depreciation expense | -422000 | -7.24% |
EBIT | 1053500 | 18.08% |
less:interest expense | -237000 | -4.07% |
EBT | 816500 | 14.01% |
less:tax | -366600 | -6.29% |
net profit | 449900 | 7.72% |
Buraydah Manufacturing, Inc. | ||||||
Balance sheet | ||||||
As of Dec 31, 20x1 | ||||||
Liabilities | Amount (SAR) | common size | Assets | Amount (SAR) | ||
accounts payable | 395000 | 5.19% | cash | 986500 | ||
short term notes payable | 195000 | 2.56% | accounts receivable | 233000 | ||
long term debt | 5844000 | 76.78% | inventories | 967000 | ||
common stock | 428000 | 5.62% | fixed assets | 7218000 | ||
retained earnings start | 419600 | less:depreciation | -2817000 | 4401000 | ||
net profit for the year | 449900 | other assets | 1024000 | |||
less:dividend | -120000 | 749500 | 9.85% | |||
total | 7611500 | 100.00% | total | 7611500 |
Problem 2-1: Preparing Financial Statements Information below is for Buraydah Manufacturing, Inc. for the year ended...
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...
Income Statement Year Ended 12/31/18 Balance Sheet Sales Cost of Goods Sold Operating Expenses Depreciation Expense100,000 EBIT Interest Expense EBT Taxes Net Income 12/31/2018 12/31/2017 $60,000$45,000 880,000650,000 200,000Less Acc'd Depreciation 450,000350,000 350,000 $395,000 $1.400,000 Current Assets 750,000 Gross Fixed Assets Fixed Assets 430,000 $490,000 50,000 Total Assets 50,000 00,000 Current Liabilities 120,000Long-term Debt $35,000 330,000 5,000 $50,000 270,000 5,000 70,000 $395,000 180,000 Common Stock Retained Earnings Total Liabilities & Equity $490.000 110 $395.000 a) Prepare the 2018 common-sized income statement...
Problem 2-2 Preparing Statement of Cash Flows Given the following information, prepare a statement of cash flows. Dividends 15 Increase in common stock 22 Decrease in accounts receivable 24 Increase in inventories 35 Operating income 80 Increase in accounts payable 25 Interest expense 25 Depreciation expense 12 Increase in long term debt 48 Increase in fixed assets 33 Income taxes 17 Beginning cash balance 20 Assume all amounts are in 000's SAR.
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...
Problem 5-2 Presented below are a number of balance sheet items for Sheffield, Inc. for the current year, 2020. Goodwill $128,780 Accumulated Depreciation-Equipment $292,310 Payroll Taxes Payable 181,371 Inventory 243,580 Bonds payable Rent payable (short-term) 303,780 48,780 Discount on bonds payable Income taxes payable 15,310 102,142 Cash Rent payable (long-term) Common stock, $1 par value 363,780 483,780 Land 203,780 483,780 Preferred stock, $10 par value Notes receivable 449,480 153,780 Prepaid expenses Notes payable (to banks) 268,780 91,700 493,780 Equipment Debt...
Self-Assessment Quiz Financial Statements Income Statement Sell Assessment Quiz Financial Information All values are end of year unless otherwise stated Accounts Payable 12,000 Accounts Receivable 10,000 Accruals 10,000 Accumulated Depreciation 100,000 Beginning of year Inventory 50,000 Beginning of year Retained Earnings 120.000 Cash 7.000 Common Stock 121,500 Cost of Goods Sold 200,000 Current Portion - Long Term Debt 1,500 Depreciation Expense 25,000 Dividends 40,000 Gross Property, plant, and Equipment 400,000 Interest Expense 15,000 Long Term Debt (excluding current portion) 120,000...
Suppose the following items were taken from the 2022 financial statements of Texas Instruments, Inc. (All dollars are in millions.) Common stock $2,100 Accumulated depreciation—equipment $2,890 Prepaid rent 150 Accounts payable 1,770 Equipment 6,070 Patents 2,160 Stock investments (long-term) 700 Notes payable (long-term) 710 Debt investments (short-term) 1,620 Retained earnings 7,260 Income taxes payable 140 Accounts receivable 1,900 Cash 1,200 Inventory 1,070 Prepare a classified balance sheet in good form as of December 31, 2022. (List Current Assets in order...
Financial data for Joel de Paris, Inc., for last year follow: Joel de Paris, Inc. Balance Sheet Beginning Balance Ending Balance Assets Cash $ 136,000 $ 138,000 Accounts receivable 336,000 474,000 Inventory 566,000 490,000 Plant and equipment, net 862,000 838,000 Investment in Buisson, S.A. 401,000 428,000 Land (undeveloped) 252,000 252,000 Total assets $ 2,553,000 $ 2,620,000 Liabilities and Stockholders' Equity Accounts payable $ 380,000 $ 332,000 Long-term debt 1,023,000 1,023,000 Stockholders' equity 1,150,000 1,265,000 Total liabilities and stockholders' equity $...
Suppose the following items were taken from the 2022 financial statements of Texas Instruments, Inc. (All dollars are in millions.) Common stock $2,826 Accumulated depreciation-equipment $3,547 Prepaid rent 164 Accounts payable 1.459 Equipment 6,705 Patents 2,210 Stock investments (long-term) 637 Notes payable (long-term) 810 Debt investments (short-term) 1,743 Retained earnings 6,896 Income taxes payable 128 Accounts receivable 1,823 Cash 1,182 Inventory 1,202 Prepare a classified balance sheet in good form as of December 31, 2022. (List Current Assets in order...
Suppose the following items were taken from the 2022 financial statements of Texas Instruments, Inc. (All dollars are in millions.) Common stock $2,100 Accumulated depreciation-equipment Prepaid rent 150 Accounts payable $2,890 1.770 2,160 710 Equipment 6,070 Patents Stock investments (long-term) 700 Notes payable (long-term) Retained earnings Debt investments (short-term) 7,260 1,620 140 Income taxes payable Accounts receivable 1,900 1,070 Cash 1.200 Inventory Prepare a classified balance sheet in good form as of December 31, 2022. (List Current Assets in order...