I need help learning how to put this into an excel worksheet. A company uses the dollar$-$value LIFO method of computing inventory. An external price index is used to convert ending inventory to base year. The company began operations on January $1,2024,$ with an inventory of $$150,000.$ Year$-$end inventories at year$-$end costs and cost indexes for its one inventory pool were as follows:

Year Ended December $31$

Ending Inventory at Year$-$End Costs

Cost Index $($Relative to Base Year$)$

$2024$

$$200,000$

$1\mathrm{.}08$

$2025$

$245,700$

$1\mathrm{.}17$

$2026$

$235,980$

$1\mathrm{.}14$

$2027$

$228,800$

$1\mathrm{.}10$

Required:

Calculate inventory amounts at the end of each year.