Question 2 Partially correct Mark 0.19 out of 2.50 Refine Cash Balance and Consider Capital Structure Consider the following actual FY2019 data and a forecast of FY2020 selected balance sheet and income statement numbers. $ millions FY2019 Actual FY2020 Est. Net sales $29,009 $32,102 Total assets 14,592 16,051 Total liabilities 8,755 9,923 Total equity 5,837 6,128 2,918 4,378 Marketable securities Treasury stock (2,189) (2,627) Cash 730 730 a. Calculate the company's normal cash level as a percentage of sales. Round answer to one decimal place (ex: 0.2345 = 23.5%) 10.1 %6 b. Determine the amount of adjustment needed to return cash to a normal level. Is an adjustment warranted? If an adjustment is not warranted, enter zero as the amount needed to return cash to a normal level. If the adjustment is a decrease, use a negative sign with your answer. Round answer to the nearest whole number, if applicable. $ 1,124 X C. Compute the liabilities-to-equity ratio for both years. Round answers to two decimal places. FY2019 Actual 1.5 FY2020 Est. 1.62 d. Adjust marketable securities so the forecasted cash balance is at its normal level. What affect does this have on the forecasted liabilities-to- equity ratio? e. Adjust long-term debt so the forecasted cash balance is at its normal level. What effect does this have on the forecasted liabilities-to-equity ratio? f. Adjust treasury stock so the forecasted cash balance is at its normal level. What effect does this have on the forecasted liabilities-to-equity ratio? f. Adjust treasury stock so the forecasted cash balance is at its normal level. What effect does this have on the forecasted liabilities-to-equity ratio? g. Adjust both long-term debt and marketable securities so as to adjust the forecasted cash balance. In so doing, make sure we preserve the company's liabilities-to-equity ratio. (Hint: Use "Goal Seek" under the "What-lf Analysis" in Excel to determine the proportion of long-term debt versus treasury stock needed to ensure the forecasted liabilities-to-equity ratio remains at its historical level.) h. Adjust both long-term debt and treasury stock so as to adjust the forecasted cash balance. In so doing, make sure we preserve the company's liabilities-to-equity ratio. (Hint: Use "Goal Seek" under the "What-lf Analysis" in Excel to determine the proportion of long-term debt versus treasury stock needed to ensure the forecasted liabilities-to-equity ratio remains at its historical level. For parts d through h, complete the table below. Do not use any negative signs with your answers. Round liabilities to equity ratios to two decimal places. d. Marketable Securities $ 0 x $ $ $ millions Total assets Total liabilities Total equity Cash Marketable securities Treasury stock Liabilities to equity ratio g. Debt and h. Debt and f. Treasury Marketable Treasury e. Debt Stock securities stock Ox $ 0X $ 0X $ Ox 0 x 0X OX 0X OX 0 x 0 x OX 0 x 0 X 0 x 0 x 0 x 0 X OX 0X 0 x 0X 0 x 0X 0 OX 0 X 0 X 0 x OX Partially correct Marks for this submission: 0.19/2.50. Question 2 Partially correct Mark 0.19 out of 2.50 Refine Cash Balance and Consider Capital Structure Consider the following actual FY2019 data and a forecast of FY2020 selected balance sheet and income statement numbers. $ millions FY2019 Actual FY2020 Est. Net sales $29,009 $32,102 Total assets 14,592 16,051 Total liabilities 8,755 9,923 Total equity 5,837 6,128 2,918 4,378 Marketable securities Treasury stock (2,189) (2,627) Cash 730 730 a. Calculate the company's normal cash level as a percentage of sales. Round answer to one decimal place (ex: 0.2345 = 23.5%) 10.1 %6 b. Determine the amount of adjustment needed to return cash to a normal level. Is an adjustment warranted? If an adjustment is not warranted, enter zero as the amount needed to return cash to a normal level. If the adjustment is a decrease, use a negative sign with your answer. Round answer to the nearest whole number, if applicable. $ 1,124 X C. Compute the liabilities-to-equity ratio for both years. Round answers to two decimal places. FY2019 Actual 1.5 FY2020 Est. 1.62 d. Adjust marketable securities so the forecasted cash balance is at its normal level. What affect does this have on the forecasted liabilities-to- equity ratio? e. Adjust long-term debt so the forecasted cash balance is at its normal level. What effect does this have on the forecasted liabilities-to-equity ratio? f. Adjust treasury stock so the forecasted cash balance is at its normal level. What effect does this have on the forecasted liabilities-to-equity ratio? f. Adjust treasury stock so the forecasted cash balance is at its normal level. What effect does this have on the forecasted liabilities-to-equity ratio? g. Adjust both long-term debt and marketable securities so as to adjust the forecasted cash balance. In so doing, make sure we preserve the company's liabilities-to-equity ratio. (Hint: Use "Goal Seek" under the "What-lf Analysis" in Excel to determine the proportion of long-term debt versus treasury stock needed to ensure the forecasted liabilities-to-equity ratio remains at its historical level.) h. Adjust both long-term debt and treasury stock so as to adjust the forecasted cash balance. In so doing, make sure we preserve the company's liabilities-to-equity ratio. (Hint: Use "Goal Seek" under the "What-lf Analysis" in Excel to determine the proportion of long-term debt versus treasury stock needed to ensure the forecasted liabilities-to-equity ratio remains at its historical level. For parts d through h, complete the table below. Do not use any negative signs with your answers. Round liabilities to equity ratios to two decimal places. d. Marketable Securities $ 0 x $ $ $ millions Total assets Total liabilities Total equity Cash Marketable securities Treasury stock Liabilities to equity ratio g. Debt and h. Debt and f. Treasury Marketable Treasury e. Debt Stock securities stock Ox $ 0X $ 0X $ Ox 0 x 0X OX 0X OX 0 x 0 x OX 0 x 0 X 0 x 0 x 0 x 0 X OX 0X 0 x 0X 0 x 0X 0 OX 0 X 0 X 0 x OX Partially correct Marks for this submission: 0.19/2.50
