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. 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: Requirement 1. Prepare the sales budget for April. Tune Printing Supply Sales Budget For the Month Ended April 30, 2024 Total budgeted sales $86,000 Requirement 2. Prepare the inventory, purchases, and cost of goods sold budget for April. Tune Printing Supply Inventory, Purchases, and Cost of Goods Sold Budget For the Month Ended April 30, 2024 Cost of goods sold $38,700 Plus: Desired ending merchandise inventory 22,800 Total merchandise inventory required 61,500 Less: Beginning merchandise inventory 11,700 Budgeted Purchases $49,800 Requirement 3. Prepare the selling and administrative expense budget for April. Tune Printing Supply Selling and Administrative Expense Budget For the Month Ended April 30, 2024 Variable expenses: Miscellaneous expense $12,900 Fixed expenses: Salaries expense 32,000 Depreciation expense 500 Total fixed expenses 32,500 Total selling and administrative expenses $45,400 Requirement 4. Prepare the budgeted cash receipts from customers for April. Tune Printing Supply Budgeted Cash Receipts from Customers For the Month Ended April 30, 2024 Current month sales, 50% $43,000 Prior month sales, 50% 14,200 Total cash receipts $57,200 Requirement 5. Prepare the budgeted cash payments for selling and administrative expenses for April. Tune Printing Supply Budgeted Cash Payments for Selling and Administrative Expenses For the Month Ended April 30, 2024 Variable expenses: Miscellaneous expenses $12,900 Fixed expenses: 30% of current month's salaries expense 9,600 Total payments for selling and administrative expenses $22,500 Requirement 6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance. Review the budgeted cash receipts from customers you prepared above. Review the budgeted cash payments for selling and admin expenses prepared above. Tune Printing Supply Cash Budget For the Month Ended April 30, 2024 Beginning cash balance Cash receipts from customers Cash available Cash payments: Purchases of merchandise inventory Selling and administrative expenses Capital expenditures Payments for dividend Total cash payments Ending cash balance
Reporting Cash Flows
Reporting of cash flows means a statement of cash flow which is a financial statement. A cash flow statement is prepared by gathering all the data regarding inflows and outflows of a company. The cash flow statement includes cash inflows and outflows from various activities such as operating, financing, and investment. Reporting this statement is important because it is the main financial statement of the company.
Balance Sheet
A balance sheet is an integral part of the set of financial statements of an organization that reports the assets, liabilities, equity (shareholding) capital, other short and long-term debts, along with other related items. A balance sheet is one of the most critical measures of the financial performance and position of the company, and as the name suggests, the statement must balance the assets against the liabilities and equity. The assets are what the company owns, and the liabilities represent what the company owes. Equity represents the amount invested in the business, either by the promoters of the company or by external shareholders. The total assets must match total liabilities plus equity.
Financial Statements
Financial statements are written records of an organization which provide a true and real picture of business activities. It shows the financial position and the operating performance of the company. It is prepared at the end of every financial cycle. It includes three main components that are balance sheet, income statement and cash flow statement.
Owner's Capital
Before we begin to understand what Owner’s capital is and what Equity financing is to an organization, it is important to understand some basic accounting terminologies. A double-entry bookkeeping system Normal account balances are those which are expected to have either a debit balance or a credit balance, depending on the nature of the account. An asset account will have a debit balance as normal balance because an asset is a debit account. Similarly, a liability account will have the normal balance as a credit balance because it is amount owed, representing a credit account. Equity is also said to have a credit balance as its normal balance. However, sometimes the normal balances may be reversed, often due to incorrect journal or posting entries or other accounting/ clerical errors.
Tune Printing Supply
|
||
Sales Budget
|
||
For the Month Ended April 30, 2024
|
||
|
Total budgeted sales
|
$86,000
|
Tune Printing Supply
|
||
Inventory, Purchases, and Cost of Goods Sold Budget
|
||
For the Month Ended April 30, 2024
|
||
Cost of goods sold
|
$38,700
|
|
Plus:
|
Desired ending merchandise inventory
|
22,800
|
Total merchandise inventory required
|
61,500
|
|
Less:
|
Beginning merchandise inventory
|
11,700
|
Budgeted Purchases
|
$49,800
|
Tune Printing Supply
|
||
Selling and Administrative Expense Budget
|
||
For the Month Ended April 30, 2024
|
||
|
Variable expenses:
|
|
|
Miscellaneous expense
|
$12,900
|
|
Fixed expenses:
|
|
|
Salaries expense
|
32,000
|
|
Depreciation expense
|
500
|
|
Total fixed expenses
|
32,500
|
|
Total selling and administrative expenses
|
$45,400
|
Tune Printing Supply
|
Budgeted Cash Receipts from Customers
|
For the Month Ended April 30, 2024
|
Current month sales, 50%
|
$43,000
|
Prior month sales, 50%
|
14,200
|
Total cash receipts
|
$57,200
|
Tune Printing Supply
|
||
Budgeted Cash Payments for Selling and Administrative Expenses
|
||
For the Month Ended April 30, 2024
|
||
|
Variable expenses:
|
|
|
Miscellaneous expenses
|
$12,900
|
|
Fixed expenses:
|
|
|
30% of current month's salaries expense
|
9,600
|
|
Total payments for selling and administrative expenses
|
$22,500
|
Tune Printing Supply
|
Cash Budget
|
For the Month Ended April 30, 2024
|
Beginning cash balance
|
|
Cash receipts from customers
|
|
Cash available
|
|
Cash payments:
|
|
Purchases of merchandise inventory
|
|
Selling and administrative expenses
|
|
Capital expenditures
|
|
Payments for dividend
|
|
Total cash payments
|
|
Ending cash balance
|
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images