Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Schrodinger Science Store operates a retail store in a local shopping mall. The results of operations for the fourth quarter of 2014 are as
The Schrodinger Science Store operates a retail store in a local shopping mall. The results of operations for the fourth quarter of 2014 are as follows: Sales $350,000 Less cost of sales 210,000 Gross margin 140,000 Less selling, general, and administrative expenses 45,500 Income before taxes 94,500 Less income taxes 37,800 Net income $ 56,700 Additional information: Sales are expected to increase by 10 percent and cost of sales are expected to increase by 12 percent, in each of the next two quarters. 80 percent of sales are collected in the quarter of sale, and 20 percent are collected in the quarter following sale. The balance in accounts receivable at the end of 2014 relates to sales in the fourth quarter of 2014. Inventory purchases in the fourth quarter of 2014 are $180,000. The balance in accounts payable at the end of 2014 relates to purchases in the fourth quarter of 2014. Inventory at the end of 2014 is $150,000. For 2015, the company plans to hold ending inventory equal to 65 percent of subsequent quarter cost of sales. Selling and administrative expenses are expected to increase by $7,300 due to increases in advertising and salaries. All other expenses in this category are expected to remain constant. 40 percent of inventory purchases are paid in the quarter of purchase, and 60 percent are paid in the following quarter. All other expenses, including taxes, are paid in the quarter incurred. Selling, general, and administrative expense includes $2,100 of depreciation related to furniture and fixtures with a book value (net of accumulated depreciation) of $50,000 at the end of 2014. The tax rate is expected to remain at 40 percent. The cash balance at the end of 2014 is $45,000. Common stock at the end of 2014 is $72,000 and retained earnings is $135,000. 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. Prepare a budgeted income statement for the first quarter of 2015. Schrodinger Science Store Budgeted Income Statement for the Quarter Ended March 31, 2015 Sales $ 385000 Less: Cost of sales 235200 Gross margin 149800 Less: Selling, general and administrative expenses 52800 Income before taxes 97000 Less: Income taxes 38800 Net Income $ 58200 Prepare a cash budget for the first quarter of 2015. Schrodinger Science Store Cash Budget for the Quarter Ended March 31, 2015 Cash Receipts Collections of sales: 20% of Quarter 4, 2014 sales $ 70000 80% of Quarter 1, 2015 sales 308000 Total cash receipts $ 378000 Cash Disbursements Payment for inventory purchases 60% of Quarter 1, 2015 purchases 40% of Quarter 4, 2014 purchases Income taxes 38800 Selling, general and adm. expenses Total disbursements 300070 Excess of receipts over disbursements 77929,24 Add: Beginning cash balance 45000 Ending Cash balance $ 122929,76 Prepare a budgeted balance sheet as of the end of the first quarter of 2015. Schrodinger Science Store Budgeted Balance Sheet March 31, 2015. Assets Cash Accounts Receivable Inventory Furniture and Fixtures Liabilities and Stockholder's equity Liabilities Accounts Payable Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity /span>
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