Sam Jones has 2 years of historical sales data for his company. He is applying for a business loan and must supply his projections of sales, by month, for the next 2 years to the bank.

A. Using the data from table 6-12, provide a regression forecast for the time periods, 25 through 48.

B. Does Sam's sales data show a seasonal pattern?

sting and Pro Forma Financial Statements TABLE 612 Twenty-four Months of Actual Data Month Actual Sales 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 345 350 355 360 365 360 358 352 348 353 362 370 375 382 390 380 375 368 363 373 380 391 397 408 Using the data from Table 612, provide a regression forecast for periods 25 through 48. Does Sam's sales data show a seasonal pattern? ur projected sales for the first 3 months of next year are as follo uary, $15,000; February, $20,000; and March, $25,000. Based r's data, cash sales are 20 percent of total sales for each month. ounts receivable, 60 percent are collected in the month after t percent are collected in the second month following the sale. vember of the current year are $15,000 and for December are u have the following estimated payments: January, $4,500; Fe 500; and March, $5,200. Using the format from the pro forma cash budget in Table 6-8, monthly cash budget for January, February, and March? What will your accounts receivable be for the beginning of Apr Will your company have any 11