Autosave D () Home Insert Draw [ 2 Page Layout Formulas Data viA A GV A L'I\\" & Calibri (Body) V[ @~ Paste =5 2 B I U Review View o 4 ExPrep 01 - financial statement basics and analysis (Empty) v Automate oo {o s Q Tellme Wrap Text v Merge & Center v 0 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Number $v% 9 HEH v Conditional Format Formatting as Table & Insert v jv Cell Styles X Delete v Format v T o s Find & Select v Sort & Filter () Comments Sensitivity Analyze Data | Check for Updates | Al B fx Fillin the orange cells in the financial statements and the yellow cells in the questions section. Use end of year stock variables to compute any measures that involve a flow and stock. For "word" answers, makes ure to v A B 82 83 84 c D Firm A 85 | What was the asset turnover ratio for the noted firm & year? Firm A 2023A Firm 8 2023A Did Firm A's asset turnover ratio become more or less preferred between 2018 and 2023, a else equal? Write more| 86 orless in the highlighted cell to indicate your answer. Which firm does the asset turnover ratio suggest was in a more preferable position with respect to efficiency in 2023, all else equal? Write more in the highlighted cell for the firm with more preferred position and less in the 87 | highlighted cellfor the other firm. 88 89 | What was the PP&E turnover ratio for the noted firm & year? Did Firm A's PP&E turnover ratio become more or less preferred between 2018 and 2023, al else equal? Write 90| more orless in the highlighted cell to indicate your answer. Which firm does the PP&E turnover ratio suggest was in a more preferable position with respect to efficiency in 2023, all else equal? Write more in the highlighted cell for the firm with more preferred position and less in the 91 highlighted cell for the other firm. 92 93 9 Firm A 2018A 95 What was the accounts receivable turnover ratio for the noted firm & year? Firm A FITETy Firm 8 2023A 96 What were accounts receivable days for the noted firm & year? Did Firm A's efficiency measures based on accounts receivable become more or less preferred between 2018 and 97 2023, all else equal? Write more or less in the highlighted cellto indicate your answer. Which firm do the efficiency measures based on accounts receivable suggest was in a more preferable position with respect to efficiency in 2023, all else equal? Write more in the highlighted cell for the firm with more preferred 98 | position and less in the highlighted cell for the other firm. 99 100 What was the inventory turnover ratio for the noted firm & year? 101 |What were inventory days for the noted firm & year? Did Firm A's efficiency measures based on inventory become more or less preferred between 2018 and 2023, all 102 | else equal? Write more or less in the highlighted cellto indicate your answer. Which firm do the efficiency measures based on inventory suggest was in a more preferable position with respect to efficiency in 2023, all else equal? Write more in the highlighted cellfor the firm with more preferred position and 103 less in the highlighted cell for the other firm. 104 105 |What was the accounts payable turnover ratio for the noted firm & year? 106 | What were accounts payable days for the noted firm & year? Did Firm A's efficiency measures based on accounts payable become more or less preferred between 2018 and 107 2023, all else equal? Write more or less in the highlighted cell to indicate your answer. Which firm do the efficiency measures based on accounts payable suggest was in a more preferable position with respect to efficiency in 2023, all else equal? Write more in the highlighted cellfor the firm with more preferred 108 | position and less in the highlighted cell for the other firm. 109 110 What was the working capital funding gap for the noted firm & year? Did Firm A's working capital funding gap become more or less preferred between 2018 and 2023, all else equal? 111 Write more or less in the highlighted cel to indicate your answer. Which firm had a more preferable working capital funding gap in 2023, allelse equal? Write more in the highlighted 112 cell for the firm with more preferred position and less in the highlighted cell for the other firm. 13 G 114 Select destination and press ENTER or choose Paste e X3 Firm8. Paste S 2 Zv v p S % v @~ A X Delete v 1] v L] Paste v v v &l v v 9