Please explain in detail how to actually solve this in Excel. Thank you!

ABX Corporation manufactures plastic products. The company offers a one-year warranty on all products. During the year, the company recorded net sales of $6,000 million. Historically, about 8% of all sales are returned under warranty and the cost of repairing and or replacing goods under warranty is about 15% of retail value. Assume that at the start of the year the companys balance sheet included an accrued warranty liability of $7.8 million, how much was accrued warranty liability balance at the end of the year?

A) $21.3 million

B) $60.8 million

C) $18.2 million

D) $ 9.9 million

E) None of these are correct.