Question
Mecca Company, a retailer of specialty wall-papers, prepares a monthly master budget. Data for the September master budget are given below: a. The August 31st
Mecca Company, a retailer of specialty wall-papers, prepares a monthly master budget. Data for the September master budget are given below:
a. The August 31st balance sheet (Actual): | |||||
| cash | $15,500 | accounts payable | $53,760 |
|
| accounts receivable | 90,000 |
|
|
|
| inventory | 28,800 | capital stock | 268,000 |
|
| building and equipment (net) | 200,000 | retained earnings | 12,540 |
|
b. | Actual sales for August and budgeted sales for September, October, and November are given below: | |||
| August-Actual | $120,000 |
| |
| September | 360,000 |
| |
| October | 200,000 |
| |
| November | 180,000 |
| |
c. | Sales are 25% for cash and 75% on credit. All credit sales are collected in the month following the sale. There are no bad debts. |
d. | The gross margin percentage is 60% of sales. The desired ending inventory is equal to 20% of the following months COGS. One fifth of the purchases are paid for in the month of the purchase and the remaining 80% are purchased on account and paid in full the following month. |
e. | The monthly operating expenses are $80,000 including the monthly depreciation of $9,000 |
f. | During September, Mancini Company will purchase new office equipment for $12,000 cash. Since it was purchased on September 30, no depreciation will be charged on the new equipment in September. |
g. | Dividends of $15,500 were declared and paid in September. |
h. | The company must maintain a minimum cash balance of $25,000. A line of credit is used to maintain this balance. Borrowing will be made in increments of $1,000. All borrowing is done at the beginning of the month andrepaymentsare made at the end of the month. The annual interest rate is 12%, paid when the loan is repaid ( ignore the accrual of interest). |
Required:
Prepare a balance sheet, income statement, and cash budget for the month of September.
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