Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started