Problem 7-6A You are provided with the following information taken from Washburne Inc.'s March 31, 2012, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings Additional information concerning Washburne Inc. is as follows. 1. Gross profit is 26% of sales. 2. 3. 4. Actual and budgeted sales data: March (actual) April (budgeted) $ 11,649 22,752 36,764 122,364 22,584 151,220 12,470 Cash collections expected in April are: March April $46,909 73,145 $18,764 (40% of $46,909) 43,887 (60% of $73,145) $62,651 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expected in April are: Purchases March $22,584 Purchases April 28,451 $51,035 Cash operating costs are anticipated to be $11,624 for the month of April. Equipment costing $2,754 will be purchased for cash in April. 5. 6. 7. The company wishes to maintain a minimum cash balance of $12,101. An open line of credit is available at the bank. All borrowing is done at the beginning of the month, and all repayments are made at the end of the month. The interest rate is 13% per year, and interest expense is accrued at the end of the month and paid in the following month. Prepare a cash budget for the month of April. Determine how much cash Washburne Inc. must borrow, or can repay, in April.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

Please do not give solution in image format thanku 

Problem 7-6A
You are provided with the following information taken from Washburne Inc.'s March 31, 2012, balance sheet.
Cash
Accounts receivable
Inventory
Property, plant, and equipment, net of
depreciation
Accounts payable
Common stock
Retained earnings
Additional information concerning Washburne Inc. is as follows.
1. Gross profit is 26% of sales.
2. Actual and budgeted sales data:
March (actual)
April (budgeted)
3.
4.
5.
6.
7.
$ 11,649
22,752
36,764
122,364
22,584
151,220
12,470
Cash collections expected in April are:
March
April
$46,909
73,145
$18,764 (40% of $46,909)
43,887 (60% of $73,145)
$62,651
Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expected in April are:
Purchases March
$22,584
Purchases April
28,451
$51,035
Cash operating costs are anticipated to be $11,624 for the month of April.
Equipment costing $2,754 will be purchased for cash in April.
The company wishes to maintain a minimum cash balance of $12,101. An open line of credit is available at the bank. All borrowing is done at the beginning of the month, and all repayments are made at the end of the month.
The interest rate is 13% per year, and interest expense is accrued at the end of the month and paid in the following month.
Prepare a cash budget for the month of April. Determine how much cash Washburne Inc. must borrow, or can repay, in April.
Transcribed Image Text:Problem 7-6A You are provided with the following information taken from Washburne Inc.'s March 31, 2012, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings Additional information concerning Washburne Inc. is as follows. 1. Gross profit is 26% of sales. 2. Actual and budgeted sales data: March (actual) April (budgeted) 3. 4. 5. 6. 7. $ 11,649 22,752 36,764 122,364 22,584 151,220 12,470 Cash collections expected in April are: March April $46,909 73,145 $18,764 (40% of $46,909) 43,887 (60% of $73,145) $62,651 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expected in April are: Purchases March $22,584 Purchases April 28,451 $51,035 Cash operating costs are anticipated to be $11,624 for the month of April. Equipment costing $2,754 will be purchased for cash in April. The company wishes to maintain a minimum cash balance of $12,101. An open line of credit is available at the bank. All borrowing is done at the beginning of the month, and all repayments are made at the end of the month. The interest rate is 13% per year, and interest expense is accrued at the end of the month and paid in the following month. Prepare a cash budget for the month of April. Determine how much cash Washburne Inc. must borrow, or can repay, in April.
Prepare a cash budget for the month of April. Determine how much cash Washburne Inc. must borrow, or can repay, in April.
Beginning cash balance
Add:
WASHBURNE INC.
Cash Budget
For the Month Ending April 30, 2012
Less: Payment of March purchases
Cash operating costs
Equipment purchase
Add:
Less:
Transcribed Image Text:Prepare a cash budget for the month of April. Determine how much cash Washburne Inc. must borrow, or can repay, in April. Beginning cash balance Add: WASHBURNE INC. Cash Budget For the Month Ending April 30, 2012 Less: Payment of March purchases Cash operating costs Equipment purchase Add: Less:
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Financial Statements
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education