In: Accounting
Dalton Sporting Goods adopted the dollar-value LIFO method for inventory valuation in 2016. Use the information below to determine the cumulative cost of the ending inventory at December 31, 2019 under dollar-value LIFO (in other words, what would be the inventory balance on Dalton’s Balance Sheet at 12.31.19). Inventory at Current Date Current Prices Price Index December 31, 2016 $150,000 100 December 31, 2017 $189,000 105 December 31, 2018 270,000 120 December 31, 2019 260,000 130
What is the cumulative ending inventory balance at 12.31.19? $______________________
| year | value | index | base price | change from prior year | ||
| 2016 | $1,50,000.00 | 100 | 1 | $1,50,000.00 | 0 | |
| 2017 | $1,89,000.00 | 105 | 1.05 | $1,80,000.00 | $30,000.00 | |
| 2018 | $2,70,000.00 | 120 | 1.2 | $2,25,000.00 | $45,000.00 | |
| 2019 | $2,60,000.00 | 130 | 1.3 | $2,00,000.00 | ($25,000.00) | |
| year | value | index | closing stock value | |||
| 2016 | $1,50,000.00 | 1 | $1,50,000.00 | |||
| 2017 | ||||||
| $1,50,000.00 | 1 | $1,50,000.00 | ||||
| $30,000.00 | 1.05 | $31,500.00 | ||||
| total value | $1,81,500.00 | |||||
| 2018 | ||||||
| $1,50,000.00 | 1 | $1,50,000.00 | ||||
| 75000 | 1.05 | $78,750.00 | ||||
| total value | $2,28,750.00 | |||||
| 2019 | ||||||
| $1,50,000.00 | 1 | $1,50,000.00 | ||||
| $50,000.00 | 1.05 | $52,500.00 | ||||
| total value | $2,02,500.00 | |||||