True Printing Company of Baltimore has applied for a loan. Its bank has requested a...

80.2K

Verified Solution

Question

Accounting

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.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students