Question: Please fix the wrong answer in the table! ( red cross) ine Cash Balance and Consider Capital Structure sider the following actual FY2019 data and

ine Cash Balance and Consider Capital Structure sider the following actual FY2019 data and a forecast or FY2020 selected balance sheet and income statement numbers Smillions FY2019 Actual FY2020 Est. et sales $29.009 $32.102 talasses 14.592 16.051 tal liabilities 8755 9,923 waluty 5.837 6.128 sh 2,918 4.378 Marketable securities 730 230 reasury Mock 12.1899 02.627) Calculate the company's normal cash level as a percentage of sales ound answer to one decimal place (ex 0.2345 -23.5% 10.1 Determine the amount of adjustment needed to return cash to a normal level is an adjustment warranted? If an adjustment is not warranted, enter vero as the amount needed to return cash co a normal level of the adjustment is a decrease use a negative sign with your answer. Round answer to the nearest whole number, if applicable 11.136) c. Compute the abilities to equity ratio for both years, Round answers to two decimal places FY2019 Actual 15 FY2020 EM C What affect does this have on the forecasted liabilities to equity ratio AU F2020 1.62 d. Adjust marketable securities so the forecasted cash balance 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 abilities to equity ratio? 1. 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? B 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 abito-equity ratio, Clint Use Goal Seek under the "What Analysis in Excel to determine the proportion of long-term debt versus treasury stock needed to ensure the forecasted liabilities-to-equity catio remains at its storical love) 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 abilities to equity ratio, in Use Golek under the "What It Analysis in Excel to determine the proportion of long term debt versus treasury stock needed to ensure the forecasted abilities 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 abilities to equity ratios to two decimal places Debt and Debt and Marketable Treasury Marketable Treasury Smillions Securities e Debt Stock securities stock Totalanes 3 16.05TS149151 14915 15.347 14015 Total 90 IL 9.923 9155 3,957 6128 6:128 4.392 6.128 5958 M Ch 3.242 2242 3.242 222 2242 Marbleres 1.866 730 730 1,162 730 Treasury stod 2.627 3,763 2.627 2,797 Labtest equity 1.62 143 1.5 Totally Check
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
