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 thePDC Company ' s projected monthly operating schedules in Table 6.2. PDC ' s monthly sales for the re-mainder of 2014 are expected to be:
September $ 80,000
October $100,000
November $130,000
December $160,000
A. Prepare PDC ' s sales schedule, purchases schedule, and wages schedule for each of the last four months of 2014.
B. Prepare cash budgets for each of the last four months of 2014 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 March - December period.