1. Adjust the Cash Balance We obtain the following 2020 forecasts of selected financial statement line items for Journey Company. $ millions 2019 Actual 2020 Est. Net Sales $535,667 $559,772 Marketable securities 50,725 46,945 Long-term debt 261,998 233,178 Treasury stock (deducted from equity) 38,688 38,688 Cash generated by operations 43,618 Cash used for investing (11,270) Cash used for financing (41,323) Total net change in cash (8,975) Cash at beginning of period 38,663 Cash at end of period $29,688 Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. a. Does forecasted cash deviate from the normal level for this company? Calculate the company's normal cash level as a percentage of sales. Normal cash as a % of sales= 6.8% Using the answer above, compute what should be the normal cash balance for FY2020. Normal cash balance for FY2020??? b. Is the deviation in part a large enough to require adjustment? Explain. c. Identify three ways to adjust the forecasted cash balance. Which option would least likely be used to adjust the cash balance??? d. Complete the following statement of cash flows assuming long-term debt is used to adjust the forecasted cash balance. Statement of Cash Flows : Cash generated by operations ? Cash used for investing ? Cash used for financing ? Total change in cash ? Cash at beginning of period ? Cash at end of period ? e. Complete the following statement of cash flows assuming marketable securities are used to adjust the forecasted cash balance. Statement of Cash Flows : Cash generated by operations ? Cash used for investing ? Cash used for financing ? Total change in cash ? Cash at beginning of period ? Cash at end of period ?