he Schrödinger Science Store operates a retail store in a local shopping mall. The results of operations for the fourth quarter of 2020 are as follows: Sales $350,000 Less cost of sales 205,000 Gross margin 145,000 Less selling, general, and administrative expenses 50,000 Income before taxes 95,000 Less taxes on income 19,000 Net income $ 76,000 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. 75 percent of sales are collected in the quarter of sale, and 25 percent are collected in the quarter following sale. The balance in accounts receivable at the end of 2020 relates to sales in the fourth quarter of 2020. Inventory purchases in the fourth quarter of 2020 are $200,000. The balance in accounts payable at the end of 2020 relates to purchases in the fourth quarter of 2020. Inventory at the end of 2020 is $150,000. For 2021, 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 $8,000 due to increases in advertising and salaries. All other expenses in this category are expected to remain constant. 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. Selling, general, and administrative expense includes $2,500 of depreciation related to furniture and fixtures with a book value (net of accumulated depreciation) of $50,000 at the end of 2020. The tax rate is expected to remain at 20 percent and taxes are paid in the quarter incurred. The cash balance at the end of 2020 is $40,000. Common stock at the end of 2020 is $80,000 and retained earnings is $147,500. 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 Prepare a budgeted income statement for the first quarter of 2021. Prepare a cash budget for the first quarter of 2021. Prepare a budgeted balance sheet as of the end of the first quarter of 2021. The company is discussing the possibility of opening a new store late in the first quarter of 2021. 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?

he Schrödinger Science Store operates a retail store in a local shopping mall. The results of operations for the fourth quarter of 2020 are as follows: Sales $350,000 Less cost of sales 205,000 Gross margin 145,000 Less selling, general, and administrative expenses 50,000 Income before taxes 95,000 Less taxes on income 19,000 Net income $ 76,000 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. 75 percent of sales are collected in the quarter of sale, and 25 percent are collected in the quarter following sale. The balance in accounts receivable at the end of 2020 relates to sales in the fourth quarter of 2020. Inventory purchases in the fourth quarter of 2020 are $200,000. The balance in accounts payable at the end of 2020 relates to purchases in the fourth quarter of 2020. Inventory at the end of 2020 is $150,000. For 2021, 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 $8,000 due to increases in advertising and salaries. All other expenses in this category are expected to remain constant. 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. Selling, general, and administrative expense includes $2,500 of depreciation related to furniture and fixtures with a book value (net of accumulated depreciation) of $50,000 at the end of 2020. The tax rate is expected to remain at 20 percent and taxes are paid in the quarter incurred. The cash balance at the end of 2020 is $40,000. Common stock at the end of 2020 is $80,000 and retained earnings is $147,500. 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 Prepare a budgeted income statement for the first quarter of 2021. Prepare a cash budget for the first quarter of 2021. Prepare a budgeted balance sheet as of the end of the first quarter of 2021. The company is discussing the possibility of opening a new store late in the first quarter of 2021. 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?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Question

100%

he Schrödinger Science Store operates a retail store in a local shopping mall. The results of operations for the fourth quarter of 2020 are as follows:

Sales	$350,000
Less cost of sales	205,000
Gross margin	145,000
Less selling, general, and administrative expenses	50,000
Income before taxes	95,000
Less taxes on income	19,000
Net income	$ 76,000

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.
75 percent of sales are collected in the quarter of sale, and 25 percent are collected in the quarter following sale.
The balance in accounts receivable at the end of 2020 relates to sales in the fourth quarter of 2020.
Inventory purchases in the fourth quarter of 2020 are $200,000.
The balance in accounts payable at the end of 2020 relates to purchases in the fourth quarter of 2020.
Inventory at the end of 2020 is $150,000. For 2021, 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 $8,000 due to increases in advertising and salaries. All other expenses in this category are expected to remain constant.
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.
Selling, general, and administrative expense includes $2,500 of depreciation related to furniture and fixtures with a book value (net of accumulated depreciation) of $50,000 at the end of 2020.
The tax rate is expected to remain at 20 percent and taxes are paid in the quarter incurred.
The cash balance at the end of 2020 is $40,000.
Common stock at the end of 2020 is $80,000 and retained earnings is $147,500.
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

Prepare a budgeted income statement for the first quarter of 2021.
Prepare a cash budget for the first quarter of 2021.
Prepare a budgeted balance sheet as of the end of the first quarter of 2021.
The company is discussing the possibility of opening a new store late in the first quarter of 2021. 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?

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here