In: Finance
Category |
Prior year |
Current year |
Accounts payable |
41,400 |
45,000 |
Accounts receivable |
115,200 |
122,400 |
Accruals |
16,200 |
13,500 |
Additional paid in capital |
200,000 |
216,660 |
Cash |
??? |
??? |
Common Stock @ par value |
37,600 |
42,000 |
COGS |
131,400 |
172,399.00 |
Depreciation expense |
21,600 |
22,198.00 |
Interest expense |
16,200 |
16,520.00 |
Inventories |
111,600 |
115,200 |
Long-term debt |
135,000 |
139,799.00 |
Net fixed assets |
376,264.00 |
399,600 |
Notes payable |
59,400 |
64,800 |
Operating expenses (excl. depr.) |
50,400 |
62,655.00 |
Retained earnings |
122,400 |
136,800 |
Sales |
255,600 |
336,548.00 |
Taxes |
9,900 |
18,574.00 |
What is the firm's current year operating profit margin?
Ans:
Prior year | Current year | |||
Particulars | Debit | Credit | Debit | Credit |
Accounts payable | 41400 | 45000 | ||
Accounts receivable | 115200 | 122400 | ||
Accruals | 16200 | 13500 | ||
Additional paid in capital | 200000 | 216660 | ||
Cash | Y | Z | ||
Common stock | 37600 | 42000 | ||
COGS | 131400 | 172399 | ||
Depreciation expenses | 21600 | 22198 | ||
Interest expenses | 16200 | 16520 | ||
Inventories | 111600 | 115200 | ||
Long term debt | 135000 | 139799 | ||
Net Fixed assets | 376264 | 399600 | ||
Notes payable | 59400 | 64800 | ||
Operating expenses (excluding depreciation) | 50400 | 62655 | ||
Retained earnings | 122400 | 136800 | ||
Sales | 255600 | 336548 | ||
Taxes | 9900 | 18574 | ||
Total | 832564+Y | 867600 | 929545+Z | 995107 |
Cash for previous year (Y) = $ 867,600 - $ 832,564
= $ 35,036
Cash for current year (Z) = $ 995,107 - $ 929,545
= $ 65,561
Sales for current year = $ 336,548
Less: COGS = $ 172,399
operatin expense (exclu dep) = $ 62,655
operating profit = $ 101,494
Operating profit margin = operating profit / sales
= $ 101,494 / $ 336.548
= 30.16 %