Use a spreadsheet and the following excerpts from Hileah Company’s financial information to build a template that automatically calculates (A) inventory turnover and (B) number of days’ sales in inventory, for the year 2018.

Transcribed Image Text:

Cash Accounts receivable Merchandise inventory Total assets Accounts payable Common stock Retained earnings Total liabilities and equity Additional information Cost of goods sold 12/31/18 12/31/17 $10,000 $14,000 22,000 17,000 15,900 14,200 47,900 45,200 4,500 10,000 33,400 47,900 177,000 5,500 10,000 29,700 45,200