Stew and Brew have decided to lease a new restaurant. Rent for the building will be $3,000 a month to be paid on the first day of each month. They initially invested $225,000 of their own money, which was used in part to purchase:

Furniture and equipment $180,000

China, glass, and silverware 25,200

Food inventory 9,000

Use straight-line depreciation over five years for furniture and equipment (no residual value). China, glass, and silverware are to be fully depreciated in year one. Sales are forecasted as follows for the first three months after opening:

Month 1: $48,000 Month 2: $66,000 Month 3: $84,000

Sales will be 80 percent cash and 20 percent credit with the maximum credit period allowed of 30 days. Food cost of sales is expected to average 30 percent and all purchases will be cash. Wages and salaries will be $15,000 a month. However, in any month when sales exceed $60,000, additional staff will have to be hired, and the extra wage cost is estimated to be 20 percent of any excess sales. All salaries and wages will be paid in the month during which they were earned. Other operating costs are expected to be 10 percent of sales and will be paid in the following month. At the end of month 3, Stew and Brew plan to pay themselves back part of their initial investment. This payment will be from any cash in excess of $15,000 at that time. In other words, they wish to leave only $15,000 in the restaurants cash account at the end of each 3 months operating quarter.

Prepare

a. A forecasted income statement for each of the three months.

b. A cash budget for each of the three months.

c. A condensed balance sheet for the first quarter at the end of month three.