Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

True Printing Company of Baltimore has applied for a loan. Its bank has requested a budgeted balance sheet at April 30, 2016 and a budgeted

True Printing Company of Baltimore has applied for a loan. Its bank has requested a budgeted balance sheet at April 30, 2016 and a budgeted statement of cash flows for April. The March 31, 2016 balance sheet follows:

True Printing Company
Balance Sheet
March 31, 2016
ASSETS
Current Assets:
Cash $ 50,300
Accounts Receivable 17,100
Merchandise Inventory 12,100
Total Current Assets $ 79,500
Property, Plant & Equipment:
Equipment and Fixtures 81,200
Less: Accumulated Depreciation - 12,200 $ 69,000
Total Assets $ 148,500
LIABILITIES
Current Liabilities:
Accounts Payable 8,300
Total Liabilities $ 8,300
STOCKHOLDERS' EQUITY
Common Stock, no par 20,000
Retained Earnings 120,200
Total Stockholders' Equity 140,200
Total Liabilities & Stockholders' Equity $ 148,500

Additional Information: As true Printing's controller, you have assembled the following additional information:

a. April dividends of $3,500 were declared and paid.

b. April capital expenditures of $16,900 budgeted for the cash purchase of equipment.

c. April depreciation expense, $200.

d. Cost of Goods Sold, 40% of sales

e. Desired ending inventory for April is $24,800

f. April selling and administrative expenses includes salaries of $39,000, 40% of whichwill be paid in cash and the remainder paid next month.

g. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April.

h. April budgeted sales, $87,000, 60% collected in April and 40% in May.

i. Apil cash payments of March 31 liabilities incurred for March purchases of inventory, $8,300.

j. April purchases of inventory, $9,900 for cash and $37,600 on account. Half the credit purchases will be paid in April and half in May. What has been solved is as follows:

Sales Budet for april

APRIL
SALES $ 87000
TOTAL $ 87000

Answer 2

The inventory, purchases, and cost of goods sold budget for April.

PARTICULARS APRIL
Cost of goods sold(40% of 87000) 34800
Desired ending inventory 24800
DESIRED INVNTORY 59600
Less: Beginning inventory 12100
Purchases $47500

Answer 3

Selling and administrative budget for April.

PARTICULARS APRIL
Selling and administrative expenses 39000
miscellaneous expenses (10% * 87000) 8700
TOTAL 47700

Answer 4

Schedule of cash receipts from customers for April.

PARTICULARS APRIL
Receipts of April ( 60%* 87000) 52200
March recepts in April ie AR 17100
TOTAL 69300

Answer 5

schedule of cash payments for selling and administrative expenses for April.

PARTICULARS APRIL
Salary (40% * 39000) 15600
miscellaneous expenses 8700
TOTAL 24300

Answer 6

PARTICULARS APRIL
Opening cash 50300
Cash collections 69300
Total cash available 119600
CASH PAYMENTS
Purchases (8300 + 9900 + (37600/2) ) 37000
Selling and administrative 24300
Capital Expenditure 16900
Total cash Payments 78200
Ending cash balace 41400

Answer 7

Budgeted income statement for April.

PARTICULARS APRIL
Sales 87000
COGS 34800
Gross Profit 52200
Less:Selling and administrative 24300
Dep 200
Operating Income 27700

Required:

1. Prepare the budgeted balance sheet at April 30, 2016.

2. Prepare the budgeted statement of cash flows for April.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting And Reporting

Authors: Mr Barry Elliott, Jamie Elliott

10th Edition

0273703641, 978-0273703648

More Books

Students also viewed these Accounting questions

Question

If the job involves a client load or caseload, what is it?

Answered: 1 week ago