The Schrdinger Science Store operates a retail store in a local shopping mall. The results of operations
Question:
The Schrödinger Science Store operates a retail store in a local shopping mall. The results of operations for the fourth quarter of 2011 are as follows:
Sales ........................$350,000
Less cost of sales ................... 205,000
Gross margin .................... 145,000
Less selling, general, and administrative expenses ....... 45,000
Income before taxes .................. 100,000
Less income taxes .................. 40,000
Net income ......................$ 60,000
Additional information:
1. Sales and cost of sales are expected to increase by 15 percent in each of the next two quarters.
2. Seventy percent of sales are collected in the quarter of sale, and 25 percent are collected in the quarter following sale.
3. The balance in accounts receivable at the end of 2011 relates to sales in the fourth quarter of 2011.
4. Inventory purchases in the fourth quarter of 2011 are $200,000.
5. The balance in accounts payable at the end of 2011 relates to purchases in the fourth quarter of 2011.
6. Inventory at the end of 2011 is $150,000. The company plans to hold ending inventory equal to 70 percent of subsequent quarter cost of sales.
7. Selling, general, and administrative expenses are expected to increase by $10,000 owing to increases in advertising and salaries. All other expenses in this category are expected to remain constant.
8. Fifty percent of inventory purchases are paid in the quarter of purchase, and 50 percent are paid in the following quarter. All other expenses, including taxes, are paid in the quarter incurred.
9. Selling, general, and administrative expense includes $2,000 of depreciation related to furniture and fixtures with a book value (net of accumulated depreciation) of $50,000 at the end of 2011.
10. The tax rate is expected to remain at 40 percent.
11. The cash balance at the end of 2011 is $30,000.
12. Common stock at the end of 2011 is $80,000 and retained earnings is $137,500.
13. Asset accounts are cash, accounts receivable, inventory, and furniture and fixtures. The only liability account is accounts payable. Owner’s equity accounts are common stock and retained earnings.
Required
a. Prepare a budgeted income statement for the first quarter of 2012.
b. Prepare a cash budget for the first quarter of 2012.
c. Prepare a budgeted balance sheet as of the end of the first quarter of 2012.
d. The company is discussing the possibility of opening a new store late in the first quarter of 2012. A store opening would require cash payments of $50,000. Assuming the company wants a minimum cash balance of $30,000 at the end of the first quarter; can a new store be opened without obtaining additional funds?
The ending inventory is the amount of inventory that a business is required to present on its balance sheet. It can be calculated using the ending inventory formula Ending Inventory Formula =... Common Stock
Common stock is an equity component that represents the worth of stock owned by the shareholders of the company. The common stock represents the par value of the shares outstanding at a balance sheet date. Public companies can trade their stocks on... Accounts Payable
Accounts payable (AP) are bills to be paid as part of the normal course of business.This is a standard accounting term, one of the most common liabilities, which normally appears in the balance sheet listing of liabilities. Businesses receive... Accounts Receivable
Accounts receivables are debts owed to your company, usually from sales on credit. Accounts receivable is business asset, the sum of the money owed to you by customers who haven’t paid.The standard procedure in business-to-business sales is that... Balance Sheet
Balance sheet is a statement of the financial position of a business that list all the assets, liabilities, and owner’s equity and shareholder’s equity at a particular point of time. A balance sheet is also called as a “statement of financial... Cash Budget
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment. Its primary purpose is to provide the...
Step by Step Answer:
a Schrdinger Science Store Budgeted Income Statement for the First Quarter 2012 Sales 350000 x 115 402500 Less cost of sales 205000115 235750 Gross ma...View the full answer
