Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated. Calculate the following information and ratios for years $2,3,4,$ and $5.$ Formula: Add, Divide, Subtract; Cell Referencing

Chapter $12.$ AP$12\mathrm{.}3.$ Using Excel to Perform Analytical Procedures

PROBLEM

The following information was taken from the accounting records for Aurora Manufacturing, Inc.

Industry Median

Accounts payable turnover days

Cost of goods sold to average

accounts payable

Current ratio