- Window Help 6 Excel Exercises Pre Ces Tam D 4 Revise Your Worksheet To Reflect These Updated Assumptions And Then Answe 1 (31.95 KiB) Viewed 11 times
Window Help #6 Excel Exercises Pre ces tam D 4 Revise your worksheet to reflect these updated assumptions and then answer the
questions t Current Previous $78,000 $68,000 48,000 53,000 30,000 163,000 C Cash Accounts receivable Inventory Long-tere assets Total assets Current Liabilities Long-ters liabilities Total liabilities Stackholders equity Total liabilities and stockholders equity fet sales Cost of goods sold Operating expenses Interest expense Income tax expense Net Incone 30 380 Rabio Receivaties move to Average collection period Inventory turver R F 5 V Required: 1. Use your spreadsheet to recalculate the ratios and enter your results here Round your answers T G 6 108,000 256,600 $450,000 $372,000 B > Current $440,000 235,000 40,000 12,00 25,649 $99.000 < Prev en OPEREEN 7 day H 37 N 8 Current Previous 108,000 $78,000 J 136,000 224,000 265,600 160.000 $490,000 $372,000 M 126,000 204,000 Next > 9 O 1 0