Need help asap, if you could show the answer/formula in Excel then it would be a great help. Thanks

Reformulating Financial Statements For Warranty Expense Income statement data for Whirlpool Industries from the company's 2016 financial statements follow. Use these data to reformulate the income statement for 2014, 2015, a 2016 under the assumption that warranty expense is a constant percentage of revenue across all three years. Specifically, compute the adjustments to: warranty expense, incom tax expense, and net income. The company's tax rate is 30%. Compute the average warranty expense to net sales rate over the past three years. Round answer to two decimal places (ex: 0.02345=2.35% ) % Using your rounded answer, compute the adjusted warranty expense for each year. - Round answers to one decimal place. - Use a negative sign to indicate if the adjustment decreases an account balance