Principles of Managerial Finance (14th Edition) (Pearson Series in Finance)
14th Edition
ISBN: 9780133507690
Author: Lawrence J. Gitman, Chad J. Zutter
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 4.8P
Learning Goal 4
P4-9 Cash disbursements schedule Maris Brothers Inc. needs a cash disbursement schedule for the months of April, May, and June. Use the format of Table 4.9 and the following information in its preparation.
Sales: February = $500,000; March = $500,000; April = $560,000;
May = $610,000; June = $650,000; July = $650,000
Purchases: Purchases are calculated as 60% of the next month's sales, 10% of purchases are made in cash, 50% of purchases are paid for 1 month after purchase, and the remaining 40% of purchases are paid for 2 months after purchase.
Rent: The firm pays rent of $8,000 per month.
Wages and salaries: Base wage and salary costs are fixed at $6,000 per month plus a variable cost of 7% of the current month’s sales.
Taxes: A tax payment of $54,500 is due in June.
Fixed asset outlays: New equipment costing $75,000 will be bought and paid for in April.
Interest payments: An interest payment of$30,000 is due in June.
Cash dividends: Dividends of $12,500 will be paid in April.
Principal repayments and retirements: No principal repayments or retirements are due during these months.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
* CengageNOWv2 | Online teachin x
.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress%3false
Cash Budget
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:
May
June
July
Sales
$146,000 $185,000 $248,000
Manufacturing costs
61,000
80,000
89,000
Selling and administrative expenses
42,000
50,000
55,000
Capital expenditures
60,000
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second
month following sale). Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual
property taxes are paid in November. Of the remainder of the manufacturing costs, 85% are expected to be…
b.
a.
Prepare a schedule of cash payments for Fein Company for
the month of August.
OBJECTIVE 3
C.
Exercise 9-45 Cash Budget
The owner of a building supply company has requested a
cash budget for June. After examining the records of the
company, you find the following:
Cash balance on June 1 is R7,360.
b. Actual sales for April and May are as follows:
d.
F.
a.
April
May
Cash sales
R180,000
Credit sales
to 00
R530,000
Total sales
R389,000
c. Credit sales are collected over a three-month period: R
40% in the month of sale, 30% in the second month, and
20% in the third month. The sales collected in the third
month are subject to a 2% late fee, which is paid by those
customers in addition to what they owe. The remaining
sales are uncollectible.
d. Inventory purchases average 64% of a month's total B
sales. Of those purchases, 20% are paid for in the month
of purchase. The remaining 80% are paid for in the
following month.
Salaries and wages total R117,500 per month, including a
R45,000…
Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases
for June through September:
April (actual)
May (actual)
June (forecast)
July (forecast)
August (forecast)
September (forecast)
Sales
$ 370,000
350,000
325,000
325,000
340,000
380,000
Purchases
$ 155,000
145,000
145,000
205,000
225,000
220,000
The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the
month after the sale and 50 percent are collected two months later. Archer pays for 20 percent of its purchases in the month after
purchase and 80 percent two months after.
Labor expense equals 15 percent of the current month's sales. Overhead expense equals $12,500 per month. Interest payments of
$32,500 are due in June and September. A cash dividend of $52,500 is scheduled to be paid in June. Tax payments of $25,500 are
due in June and September. There is a scheduled capital outlay of…
Chapter 4 Solutions
Principles of Managerial Finance (14th Edition) (Pearson Series in Finance)
Ch. 4.1 - Briefly describe the first four modified...Ch. 4.1 - Describe the overall cash flow through the firm in...Ch. 4.1 - Prob. 4.3RQCh. 4.1 - 4-B Why is depreciation (as well as amortization...Ch. 4.1 - Prob. 4.5RQCh. 4.1 - Prob. 4.6RQCh. 4.1 - Prob. 4.7RQCh. 4.2 - Prob. 4.8RQCh. 4.2 - Prob. 4.9RQCh. 4.3 - Prob. 4.10RQ
Ch. 4.3 - Prob. 4.11RQCh. 4.3 - Prob. 4.12RQCh. 4.3 - What is the cause of uncertainty in the cash...Ch. 4.4 - Prob. 4.14RQCh. 4.5 - Prob. 4.15RQCh. 4.5 - Prob. 4.16RQCh. 4.6 - Prob. 4.17RQCh. 4.6 - What is the significance of the plug figure,...Ch. 4.7 - Prob. 4.19RQCh. 4.7 - Prob. 4.20RQCh. 4 - Opener-in-Review The chapter opener described a...Ch. 4 - Learning Goals 2, 3 ST4-1 Depreciation and cash...Ch. 4 - Prob. 4.2STPCh. 4 - Prob. 4.3STPCh. 4 - Prob. 4.1WUECh. 4 - Prob. 4.2WUECh. 4 - Learning Goal 3 E4-3 Determine the operating cash...Ch. 4 - Prob. 4.4WUECh. 4 - Prob. 4.5WUECh. 4 - Prob. 4.1PCh. 4 - Prob. 4.2PCh. 4 - Prob. 4.3PCh. 4 - Learning Goals 2, 3 P4-4 Depreciation and...Ch. 4 - Learning Goal 3 P4-5 Classifying inflows and...Ch. 4 - Prob. 4.6PCh. 4 - Learning Goal 4 P4-8 Cash receipts A firm has...Ch. 4 - Learning Goal 4 P4-9 Cash disbursements schedule...Ch. 4 - Learning Goal 4 P4-10 Cash budget: Basic Grenoble...Ch. 4 - Prob. 4.10PCh. 4 - Prob. 4.11PCh. 4 - Prob. 4.12PCh. 4 - Prob. 4.13PCh. 4 - Learning Goal 4 P4-15 Multiple cash budgets:...Ch. 4 - Prob. 4.15PCh. 4 - Prob. 4.16PCh. 4 - Prob. 4.17PCh. 4 - Prob. 4.18PCh. 4 - Prob. 4.19PCh. 4 - Prob. 4.20PCh. 4 - Prob. 4.21PCh. 4 - Prob. 1SE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- eBook Show Me How Question Content Area Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $290,000 June 350,000 July 530,000 All sales are on account. 56 percent of sales are expected to be collected in the month of the sale, 34% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May, June, and July. May June July May sales on account: Collected in May fill in the blank 1 Collected in June fill in the blank 2 Collected in July fill in the blank 3 June sales on account: Collected in June fill in the blank 4 Collected in July fill in the blank 5 July sales on account: Collected in July fill in the blank 6 Total cash collected $fill in the…arrow_forwardlesson 9 quiz - financial planning tools and concepts pt. 2 gerry jacobs, a financial analyst for best value supermarkets, has prepared the following sales and cash disbursement estimates for the period of august through december of the current year. month sales cash disbursements august 400 300 september 500 500 october 500 700 november 600 400 december 700 500 90% of sales are for cash, the remaining 10% are collected one month later. all disbursements are on a cash basis. the firm wishes to maintain a minimum cash balance of 50. the beginning cash balance in september is 25. prepare a cash budget for the months of october, november, and december, noting any needed financing or excess cash available.arrow_forwardDesiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance pad the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $35,000, $37,000, and $39,000, respectively.arrow_forward
- Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $22,000, $25,000, and $23,000 respectively.arrow_forwardWhat would be the cash disbursements for month 3? Description Month 1 Month 2 Month 3 Month 4 Material Purchases $ 175,000.00 $ 185,000.00 $ 215,000.00 $ 190,000.00 Amount paid in month of purchase 65.00% Amount paid in month after purchase 30.00% Amount paid two months after purchase 5.00% Discounts in month of purchase 3.50% Discount in month after purchase 1.00% Total Cash disbursements in month 3 Show your work below Description Month 1 Month 2 Month 3arrow_forwardQuestion ANSWER B ONLY AND CALCULATE TOTAL The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows:Month Cash Sales Sales on Account PurchasesAugust $85,000 $640,000 $420,000September 70,000 550,000 550,000October 88,550 600,000 500,000 November 77,160 800,000 600,000December 174,870 500,000 450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50%…arrow_forward
- Need to used in formulas Expected cash collections: March cash collections March collections on accounts: January sales February sales March sales Total cash collections Payments to suppliers: Accounts payable for inventory purchase, beginning balance March purchase Total cash payments S & P Enterprises Cash Budget For the Month of March Cash balance, March 1 Add cash receipts: Collections from customers Total cash available before current financing Less disbursement: Payments to suppliers Selling and administrative expenses Equipment purchases Dividends paid Total disbursement Excess (deficiency) of cash available over disbursement Financing: Borrowings Repayments Interest Total financing Cash balancing, March 31arrow_forwardSchedule of expected cash collections Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year. These peak sales are shown in the company's sales budget for the second quarter given below: April $300,000 May June Total eted Sales $500,000 $200,000 $1,000,000 From past experience, the company has learned that 15% of the company's sales are for cash. Credit sales are collected as follows: 20% are collected in the month of sale, another 70% are collected in the month following the sale, and the remaining 10% are collected in the second month following the sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. A. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. B. Assume that the company will prepare a budgeted balance sheet as of June 30. Compute the accounts receivable as of that date.arrow_forwardPreparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $374,400 May 411,100 June 416,700 Wight typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forward
- ⒸPR 22-5A Cash Budget Obj. 5 The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: Sales Manufacturing costs Selling and administrative expenses Capital expenditures September $250,000 150,000 42,000 October $300,000 180,000 48,000 Answer Check Figure: November deficiency, $(8,500) 2. November $315,000 185,000 51,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the…arrow_forwardstimated finished goods inventory balance at the end of July? 13. What is the estimated cost of goods sold and gross margin for July? 14. What is the estimated total selling and administrative expense for July? 15. What is the estimated net operating income for July? Connect EXERCISE 8-1 Schedule of Expected Cash Collections LO8-2 Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below- April May June Total Budgeted sales (all on account) $300,000 $500,000 $200,000 $1,000,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. Required: Using Schedule 1 as…arrow_forwardSELF-DEVELOPMENT E-LIBRARY ZAIN HANDBOOKS Morgan Manufacturing is preparing its cash budget for the second quarter. The following amounts are budgeted for materials purchases: April $62.880 May $44,960 June $47.360 Morgan pays for 20% of its purchases in the month of purchase, 60% in the month following purchase, and 20% in the second month after purchase. What are Morgan's budgeted cash payments for purchases in June? O a. $93,120 Ob. $9,472 Oc. $39,552 O d. $49.024 Help Navt nan 10:06 AM РОСОРНONЕ 11/3/202 SHOT ON POCOPHONE F1arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
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
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY