FINANCIAL ACCOUNTING UDEL W/ACCESS >IB
8th Edition
ISBN: 9781119268444
Author: Kimmel
Publisher: WILEY C
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 7, Problem 7.7AP
To determine
To prepare: Cash budget of Incorporation M for the month of April to know the amount required to be borrowed to maintain desired minimum balance of $9,000
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:
Current assets as of March 31:
Cash
Accounts receivable
Inventory
Building and equipment, net
Accounts payable
Common stock
Retained earnings
a. The gross margin is 25% of sales.
b. Actual and budgeted sales data:
March (actual)
April
May
June
July
c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March
31 are a result of March credit sales.
$ 63,000
$ 79,000
$ 84,000
d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold.
e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The
accounts payable at March 31 are the result of March purchases of inventory.
f. Monthly expenses are as follows: commissions, 12% of sales; rent, $3,600 per month; other expenses (excluding…
You are provided with the following information taken from Sage Hill Inc's March 31, 2027, balance sheet.
Cash
Accounts receivable
Inventory
Property, plant, and equipment, net of depreciation
Accounts payable
Common stock
Retained earnings
1
2
3.
5.
6.
7.
Additional information concerning Sage Hill Inc. is as follows.
Gross profit is 24% of sales.
Actual and budgeted sales data:
March (actual)
April (budgeted)
March
April
$18.840
$47.100
$62460
$12,280
72.700
23.120
37,100
123,400
22,910
Sales are both cash and credit, Cash collections expected in April are:
152.900
12.320
(40% of $47.100)
(60% of $72,700)
Half of a month's purchases are paid for in the month of purchase and half in the following month Cash disbursements expecte
Purchases March
Purchases April
$22,910
28,910
$51820
Cash operating costs are anticipated to be $12,110 for the month of April.
Equipment costing $2,530 will be purchased for cash in April.
The company wishes to maintain a minimum cash balance of $12,240. An…
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:
Current assets as of March 31:
Cash
Accounts receivable
Inventory
Building and equipment, net
Accounts payable
Common stock
Retained earnings.
a. The gross margin is 25% of sales.
b. Actual and budgeted sales data:
March (actual)
April
May
June
July
Required:
Using the preceding data:
c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March
31 are a result of March credit sales.
d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold.
e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The
accounts payable at March 31 are the result of March purchases of inventory.
f. Monthly expenses are as follows: commissions, 12% of sales; rent, $4,000 per month; other expenses (excluding…
Chapter 7 Solutions
FINANCIAL ACCOUNTING UDEL W/ACCESS >IB
Ch. 7 - A local hank reported that it lost 150,000 as the...Ch. 7 - Prob. 2QCh. 7 - Prob. 3QCh. 7 - Prob. 4QCh. 7 - Prob. 5QCh. 7 - Prob. 6QCh. 7 - Prob. 7QCh. 7 - Prob. 8QCh. 7 - Prob. 9QCh. 7 - Prob. 10Q
Ch. 7 - Prob. 11QCh. 7 - Prob. 12QCh. 7 - Prob. 13QCh. 7 - Prob. 14QCh. 7 - Prob. 15QCh. 7 - Prob. 16QCh. 7 - Prob. 17QCh. 7 - Prob. 18QCh. 7 - Prob. 19QCh. 7 - Prob. 20QCh. 7 - Prob. 21QCh. 7 - Prob. 22QCh. 7 - Prob. 23QCh. 7 - Prob. 24QCh. 7 - Prob. 25QCh. 7 - Prob. 26QCh. 7 - Prob. 27QCh. 7 - Prob. 28QCh. 7 - Match each situation with the fraud triangle...Ch. 7 - Prob. 7.2BECh. 7 - Prob. 7.3BECh. 7 - Prob. 7.4BECh. 7 - While examining cash receipts information, the...Ch. 7 - Prob. 7.6BECh. 7 - Luke Rove is uncertain about the control features...Ch. 7 - Prob. 7.8BECh. 7 - Prob. 7.9BECh. 7 - Prob. 7.10BECh. 7 - Prob. 7.11BECh. 7 - Prob. 7.12BECh. 7 - Prob. 7.13BECh. 7 - Prob. 7.14BECh. 7 - Prob. 7.1DIECh. 7 - Prob. 7.2DIECh. 7 - Prob. 7.3DIECh. 7 - Prob. 7.4ADIECh. 7 - Prob. 7.4BDIECh. 7 - Prob. 7.1ECh. 7 - Prob. 7.2ECh. 7 - Prob. 7.3ECh. 7 - Prob. 7.4ECh. 7 - Prob. 7.5ECh. 7 - Prob. 7.6ECh. 7 - Prob. 7.7ECh. 7 - Prob. 7.8ECh. 7 - Prob. 7.9ECh. 7 - Prob. 7.10ECh. 7 - Prob. 7.11ECh. 7 - Prob. 7.12ECh. 7 - Prob. 7.13ECh. 7 - Prob. 7.14ECh. 7 - Prob. 7.15ECh. 7 - Prob. 7.16ECh. 7 - Prob. 7.1APCh. 7 - Prob. 7.2APCh. 7 - Prob. 7.3APCh. 7 - Prob. 7.4APCh. 7 - Prob. 7.5APCh. 7 - Prob. 7.6APCh. 7 - Prob. 7.7APCh. 7 - Prob. 7.8APCh. 7 - Prob. 7CCCPCh. 7 - Prob. 7.1EYCTCh. 7 - Prob. 7.2EYCTCh. 7 - Prob. 7.3EYCTCh. 7 - Prob. 7.4EYCTCh. 7 - Prob. 7.5EYCTCh. 7 - Prob. 7.6EYCTCh. 7 - Prob. 7.7EYCTCh. 7 - Prob. 7.8EYCTCh. 7 - Prob. 7.9EYCTCh. 7 - Prob. 7.10EYCTCh. 7 - Prob. 7.1IFRSCh. 7 - Prob. 7.2IFRS
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.Similar questions
- Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?arrow_forwardNonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?arrow_forwardEarthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?arrow_forward
- My Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?arrow_forwardAmusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?arrow_forwardBeech's managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. 3. Each month's ending inventory must equal 25% of the cost of next month's sales. The cost of goods sold is 75% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July. 4. Monthly selling and administrative expenses are always $52,000. Each month $5,000 of this total amount is depreciation expense and the remaining $47,000 relates to expenses that are paid in the month they are incurred. 5. The…arrow_forward
- You are provided with the following information taken from Wildhorse Inc.'s March 31, 2025, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1. 2. 3. 4. 5. Additional information concerning Wildhorse Inc. is as follows. 6. 7. Gross profit is 25% of sales. Actual and budgeted sales data: March (actual) April (budgeted) March April Purchases March $48,200 $19,280 42,420 $61,700 Purchases April $11,600 70,700 20,180 36,010 Sales are both cash and credit. Cash collections expected in April are: (40% of $48,200) (60% of $70,700) 120,800 22,560 154,500 11.680 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expecte $22,560 28,320 $50,880 Cash operating costs are anticipated to be $12,630 for the month of April. Equipment costing $2,560 will be purchased for cash in April. The company wishes to maintain a minimum cash balance…arrow_forwardJasper Company has 62% of its sales on credit and 38% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $522,000 for April, $532,000 for May, and $557,000 for June. Total sales for March are $304,900. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Accounts receivable Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April 522,000 May 532,000 June 557,000arrow_forwardThe table contains the Sales estimates for the next year. The Purchases are 55% of Sales. Purchases are paid in the following month. The administrative expenses of $11,550 are paid each month Tax expenses of $16,458 are paid in March, June, September, and December each year. Rent expenses of $47,735 are paid in June and December. What is the cash outflow for March? Month Sales $ Month Sales $ Jan 87,400 July 21,931 Feb 89,751 Aug 78,038 Mar 78,038 Sep 87,400 Apr 21,931 Oct 78,038 May 87,400 Nov 89,751 June 89,751 Dec 21,931arrow_forward
- Assume that your credit sales for March was $16,288,for April was $33,301 and May was $29,261. If credit sales are collected 55% during the month of sale, 25% the month following the sale, and 15% in the second month following the sale, what is the total expected cash collections to be received in May? Round your answer to one dollar.arrow_forwardJasper Company has 57% of its sales on credit and 43% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $525,000 for April, $535,000 for May, and $560,000 for June. Total sales for March are $295,800. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April 525,000 May 535,000 June 560,000arrow_forwardJasper Company has 57% of its sales on credit and 43% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $518,000 for April, $528,000 for May, and $553,000 for June. Total sales for March are $293,600. Prepare a schedule of cash receipts from sales for April, May, and June. JASPER COMPANY Schedule of Cash Receipts from Sales April May June Sales 518,000 528,000 553,000 Cash receipts from: Total cash receiptsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
The management of receivables Introduction - ACCA Financial Management (FM); Author: OpenTuition;https://www.youtube.com/watch?v=tLmePnbC3ZQ;License: Standard YouTube License, CC-BY