Inventory value at the end of 2025 = $712,938.46 x 1.08 + $760,000 - $760,000 / 1.08 = $826,269.83
Here is the completed table to calculate the inventory value at the end of 2024 and 2025 using the dollar-value LIFO method:
Year Inventory Value
2024 $712,938.46
2025 $826,269.83
To calculate the inventory value at the end of 2024, use the following formula:
Inventory value at the end of 2024 = Base-year inventory x Cost index for 2024 + Ending inventory at year-end cost for 2024 - Ending inventory at year-end cost for 2024 / Cost index for 2024
Inventory value at the end of 2024 = $660,000 x 1.04 + $690,000 - $690,000 / 1.04 = $712,938.46
To calculate the inventory value at the end of 2025, use the following formula:
Inventory value at the end of 2025 = Inventory value at the end of 2024 * Cost index for 2025 + Ending inventory at year-end cost for 2025 - Ending inventory at year-end cost for 2025 / Cost index for 2025
Inventory value at the end of 2025 = $712,938.46 x 1.08 + $760,000 - $760,000 / 1.08 = $826,269.83