Note: Format cells so each amount shows two decimal places. Do not round amounts $-$ use Increase Decimal or Decrease Decimal in Excel toolbar to adjust. Then in MBC$,$ enter the answers with two decimal places.

Calculate the company's normal cash level as a percentage of sales.

$\backslash$table$[[$Normal cash as a $\%$ of sales,$],[,]]$

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

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

$\backslash$table$[[$Statement of Cash Flows,$],[$Cash generated by operations,$],[$Cash used for investing,$],[$Cash used for financing,$],[$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.

$\backslash$table$[[$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,$]]$