In: Accounting
E7-8 Evaluating the Effects of Inventory Methods on Income from Operations, Income Taxes, and Net Income (Periodic) [LO 7-3]
|
Courtney Company uses a periodic inventory system. The following data were available: beginning inventory, 1,800 units at $40; purchases, 4,200 units at $42; operating expenses (excluding income taxes), $95,500; ending inventory per physical count at December 31, 1,150 units; sales price per unit, $80; and average income tax rate, 30%. |
| Required: |
| 1. |
Prepare income statements under the FIFO, LIFO, and weighted average costing methods. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) |
| 2-a. |
Between FIFO and LIFO, which method is preferable in terms of maximizing income from operations, if costs are rising? |
|
| 2-b. |
Between FIFO and LIFO, which method is preferable in terms of minimizing income taxes, if costs are rising? |
|
| 3-a. |
Between FIFO and LIFO, which method is preferable in terms of maximizing income from operations, if costs are falling? |
||||
|
| 3-b. |
Between FIFO and LIFO, which method is preferable in terms of minimizing income taxes, if costs are falling? |
||||
|
| Req 1 | |||||||||
| STATEMENT SHOWING INVENTORY RECORD UNDER PERIODIC FIFO METHOD | |||||||||
| RECIEPTS | COST OF GOODS SOLD | BALANCE | |||||||
| DATE | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ |
| Balance Oct1 | 1800 | 40 | 72000 | 1800 | 40 | 72000 | |||
| Purchasse | 4200 | 42 | 176400 | 3050 | 42 | 128100 | 1150 | 42 | 48300 |
| TOTAL | 6000 | 248400 | 4850 | 200100 | 1150 | 48300 | |||
| STATEMENT SHOWING INVENTORY RECORD UNDER PERIODIC LIFO METHOD | |||||||||
| RECIEPTS | COST OF GOODS SOLD | BALANCE | |||||||
| DATE | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ |
| Balance Oct1 | 1800 | 40 | 72000 | 650 | 40 | 26000 | 1150 | 40 | 46000 |
| Purchasse | 4200 | 42 | 176400 | 4200 | 42 | 176400 | |||
| TOTAL | 6000 | 248400 | 4850 | 202400 | 1150 | 46000 | |||
| STATEMENT SHOWING INVENTORY RECORD UNDER PERIODIC WEIGHTED AVERAGE METHOD | |||||||||
| RECIEPTS | COST OF GOODS SOLD | BALANCE | |||||||
| DATE | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ |
| Balance Oct1 | 1800 | 40 | 72000 | ||||||
| Purchasse | 4200 | 42 | 176400 | ||||||
| TOTAL | 6000 | 41.4 | 248400 | 4850 | 41.4 | 200790 | 1150 | 41.4 | 47610 |
| Income Statement | |||||||||
| FIFO | LIFO | Average | |||||||
| Sales revenue (4850 units @ 80) | 388000 | 388000 | 388000 | ||||||
| Less: Cost of Goods sold | 200100 | 202400 | 200790 | ||||||
| Gross margin | 187900 | 185600 | 187210 | ||||||
| Less: Operating expense | 95500 | 95500 | 95500 | ||||||
| Net income | 92400 | 90100 | 91710 | ||||||
| Less: Income tax | 27720 | 27030 | 27513 | ||||||
| Net income after tax | 64680 | 63070 | 64197 | ||||||
| req 2-a | |||||||||
| FIFO increase income from operations | |||||||||
| Req 2-b: | |||||||||
| LIFO minimize income tax. | |||||||||
| Req 3-a: | |||||||||
| LIFO increase income from operations. | |||||||||
| Req 3-b: | |||||||||
| FIFO minimize income tax | |||||||||