Please help

Dpreadsheet Exercises/Problems [Note: The following activities are for students with spreadsheet software skills.] 11. Short-term financial planning for the PDC Company was described earlier in this chapter. Refer to the PDC Company's projected monthly operating schedules in Table 6.2. PDC's monthly sales for the remainder of 2020 are expected to be: A. Prepare PDC's sales schedule, purchases schedule, and wages schedule for each of the last four months of 2020. B. Prepare cash budgets for each of the last four months of 2020 for the PDC Company and describe how the forecast affects the end-of-month cash balances. C. Prepare PDC's projected monthly income statements for the August-December period. D. Prepare PDC's projected monthly balance sheets for the August-December period. E. Prepare PDC's projected monthly statements of cash flows for the August-December period. F. Compare your balance sheet at the end of December with the balance sheet in Table 6.1 and apply the balance sheet method to determine cash flows over the MarchDecember period. Table 6.2. PoC Company Operating Schadules and Cash Budict (B) PURCHASES SCHEDULE (C) WAGES AND COMMISSIONS SCHEDULE able 6.2 PDC Company Operating Schedules ard Cash Budget foomtinted (D) CASH BUDGET Dpreadsheet Exercises/Problems [Note: The following activities are for students with spreadsheet software skills.] 11. Short-term financial planning for the PDC Company was described earlier in this chapter. Refer to the PDC Company's projected monthly operating schedules in Table 6.2. PDC's monthly sales for the remainder of 2020 are expected to be: A. Prepare PDC's sales schedule, purchases schedule, and wages schedule for each of the last four months of 2020. B. Prepare cash budgets for each of the last four months of 2020 for the PDC Company and describe how the forecast affects the end-of-month cash balances. C. Prepare PDC's projected monthly income statements for the August-December period. D. Prepare PDC's projected monthly balance sheets for the August-December period. E. Prepare PDC's projected monthly statements of cash flows for the August-December period. F. Compare your balance sheet at the end of December with the balance sheet in Table 6.1 and apply the balance sheet method to determine cash flows over the MarchDecember period. Table 6.2. PoC Company Operating Schadules and Cash Budict (B) PURCHASES SCHEDULE (C) WAGES AND COMMISSIONS SCHEDULE able 6.2 PDC Company Operating Schedules ard Cash Budget foomtinted (D) CASH BUDGET