Chris P. Bacon is the owner and operator of a delicatessen. Until recently, he managed the business primarily on his own however, in 2020 he began to sell organic flash frozen meats that can be shipped overnight via FedEx and his sales have grown quickly. He has had to hire several additional staff members and is considering borrowing from the bank to help him manage the company’s cash flow needs. The manager of his local bank branch has requested a projected cash budget and pro forma income statement for the six months period from July – Dec31, 2021. Chris hired you several months ago to assist him with the record keeping in the business as he has been falling further and further behind with the paperwork. As you are a Financial Services graduate from Humber College, Chris knows that you have the skills he is missing in this area.

Sales for May and June 2021 were $69,548 and $72,594 respectively and are expected to continue to grow monthly at a rate of 8.5% per month for the foreseeable future.

Cash sales each month average 12%. Of the remaining sales, half is collected in 30 days and the other half is collected in 60 days. Purchases each month total 54% of the sales and are paid in full 30 days after the purchase is made. Other monthly expenses are as follows:

salaries $23,200,

rent $3,360,

shipping and delivery fees 5% of sales,

advertising $2,230.

Chris is investing in a new computer system in September 2021 and he is expecting to pay $11,940 including installation. He is also expecting to attend a virtual organic foods conference Oct. This will cost approximately $4,800. The company’s income taxes of 32% of operating income. The company is paying quarterly installments in March, June, September and December based on every 6months’ projected income.

(HINT: COMPLETE THE CASH BUDGET AS FAR AS POSSIBLE WITHOUT THE INCOME TAX FIGURE, COMPLETE THE PRO FORMA INCOME STATEMENT TO OPERATING INCOME, AND THEN CALCULATE THE TAX)

The computer system will be depreciated at a rate of 2.5% per month. The ending bank balance in June 2021 is expected to be $9,846.

Required:

1. Prepare a cash budget for the 6 months from July 01 – December 31, 2021.

2. Prepare a pro forma income statement for July 01 – December 31, 2021.