Adjust the Cash Balance

We obtain the following $2020$ forecasts of selected financial statement line items for joumey Company$-$

Note: Complete the entire question in Excel using the following template: Excel Template Excel calculations should be unrounded. Format each

answer to two decimal places. Ihen 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.

Using the answer above, compute what should be the normal cash balance for $F2020.$

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 ieast likely be used to adjust the cash balince?

d$.$ Complete the following statement of cash flows assuming long$-$term debt is used to adjust the forecasted cash balance.

c$.$ Complete the folowing statement of cash flows assuming marketable securitics are used to adjust the forecasted cash balance.