Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: As Tune Printing Supply's controller, you have assembled the following additional information: a. April dividends of $6,000 were declared and paid. b. April capital expenditures of $16,200 budgeted for cash purchase of equipment. c. April depreciation expense, $500. d. Cost of goods sold, 45% of sales. e. Desired ending inventory for April is $22,800. f. April selling and administrative expenses include salaries of $32,000, 30% of which will be paid in cash and the remainder paid next month. g. Additional April selling and administrative expenses also include miscellaneous expenses of 15% of sales, all paid in April. h. April budgeted sales, $86,000, 50% collected in April and 50% in May. i. April cash payments of March 31 liabilities incurred for March purchases of inventory, $8,100. j. April purchases of inventory, $12,300 for cash and $37,500 on account. Half the credit purchases will be paid in April and half in May. 3RD TIME I'VE ASKED THIS QUESTION BUT ONLY GET PART ANSWERS. CAN YOU PLEASE HELP ME WITH REST OF PART 8 AND PART 9? 1. Prepare the sales budget for April. 2. Prepare the inventory, purchases, and cost of goods sold budget for April. 3. Prepare the selling and administrative expense budget for April. 4. Prepare the schedule of cash receipts from customers for April. 5. Prepare the schedule of cash payments for selling and administrative expenses for April. 6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance. 7. Prepare the budgeted income statement for April. 8. Prepare the budgeted balance sheet at April 30, 2024.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter9: Metric-analysis Of Financial Statements

Section: Chapter Questions

Problem 9.4.13P: Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of...

See similar textbooks

Related questions

Concept explainers

Question

Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for

April

2024

and budgeted balance sheet at

April

30,

2024.

The

March

31,

2024,

balance sheet follows:

Tune

Printing Supply's controller, you have assembled the following additional information:

a.	April dividends of $6,000 were declared and paid.
b.	April capital expenditures of $16,200 budgeted for cash purchase of equipment.
c.	April depreciation expense, $500.
d.	Cost of goods sold, 45% of sales.
e.	Desired ending inventory for April is $22,800.
f.	April selling and administrative expenses include salaries of $32,000, 30% of which will be paid in cash and the remainder paid next month.
g.	Additional April selling and administrative expenses also include miscellaneous expenses of 15% of sales, all paid in April.
h.	April budgeted sales, $86,000, 50% collected in April and 50% in May.
i.	April cash payments of March 31 liabilities incurred for March purchases of inventory, $8,100.
j.	April purchases of inventory, $12,300 for cash and $37,500 on account. Half the credit purchases will be paid in April and half in May.

3RD TIME I'VE ASKED THIS QUESTION BUT ONLY GET PART ANSWERS. CAN YOU PLEASE HELP ME WITH REST OF PART 8 AND PART 9?

1.	Prepare the sales budget for April.
2.	Prepare the inventory, purchases, and cost of goods sold budget for April.
3.	Prepare the selling and administrative expense budget for April.
4.	Prepare the schedule of cash receipts from customers for April.
5.	Prepare the schedule of cash payments for selling and administrative expenses for April.
6.	Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance.
7.	Prepare the budgeted income statement for April.
8.	Prepare the budgeted balance sheet at April 30, 2024.

Tune Printing Supply
Budgeted Balance Sheet
April 30, 2024
Assets
Current Assets:
Cash
$
24,350
Accounts Receivable
43,000
Merchandise Inventory
22,800
Total Current Assets
$
90,150
Property, Plant, and Equipment:
Equipment and Fixtures
97,100
Less: Accumulated Depreciation
(12,600)
84,500
$
174,650
Total Assets
Liabilities
Current Liabilities:
Accounts Payable
18,600
Salaries Payable
22,400
Total Liabilities
41,000
Stockholders' Equity
Common Stock
40,000
Retained Earnings
93,500
Total Stockholders' Equity
133,500
174,500
Total Liabilities and Stockholders' Equity

Assets
Current Assets:
Cash
51,000
Accounts Receivable
14,200
11,700
Merchandise Inventory
Total Current Assets
$
76,900
Property, Plant, and Equipment:
Equipment and Fixtures
90
(12,100)
68,800
Less: Accumulated Depreciation
$
145,700
Total Assets
Liabilities
Current Liabilities:
Accounts Payable
$
8,100
Stockholders' Equity
Common Stock, no par
$
40,000
Retained Earnings
97,600
Total Stockholders' Equity
137,600
$
145,700
Total Liabilities and Stockholders' Equity

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 2 steps with 10 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.