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 %