Advanced Financial Management (Custom Package)
17th Edition
ISBN: 9781323539439
Author: LOYOLA UNIV.
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
(Learning Objective 5: Use the COGS model to make management decisions)Spicer Industries prepares budgets to help manage the company. Spicer is budgeting forthe fiscal year ended January 31, 2018. During the preceding year ended January 31, 2017,sales totaled $9,700 million and cost of goods sold was $6,400 million. At January 31, 2017,inventory was $1,500 million. During the upcoming 2018 year, suppose Spicer expects costof goods sold to increase by 12%. The company budgets next year’s ending inventory at$1,800 million.Requirement1. One of the most important decisions a manager makes is how much inventory to buy. Howmuch inventory should Spicer purchase during the upcoming year to reach its budget?
(Learning Objectives 4, 5: Apply GAAP for receivables and uncollectiblereceivables) Suppose Easton, Inc., reported net receivables of $2,582 million and $2,260 millionat January 31, 2019, and 2018, respectively, after subtracting allowances of $72 million and $67million at these respective dates. Easton earned total revenue of $43,333 million (all on account)and recorded uncollectible-account expense of $13 million for the year ended January 31, 2019.Requirement1. Use this information to measure the following amounts for the year ended January 31, 2019:a. Write-offs of uncollectible receivables b. Collections from customers
Pelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending Mar 31, 2022
Month 2021 - 2022
Cash Sales $
Sales on A/C $
Cash Purchases $
Purchases on A/C $
Nov 2021
138,100
480,000
345,000
Dec 2021
156,500
600,000
25,800
380,000
Jan 2022
170,975
650,000
44,625
400,000
Feb 2022
135,740
700,000
30,400
480,000
Mar 2022
226,420
800,000
55,100
540,000
1 Extracts from the sales and purchases budgets are as follows
2 An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern in accordance with the credit terms 4/30, n90
55% in the month of sale
35% in the first month…
Chapter 4 Solutions
Advanced Financial Management (Custom Package)
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
- Question 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(Learning Objective 2: Compare gross profit—FIFO vs. LIFO—falling prices)Suppose a Walmart store in Fillmore, Missouri, ended January 2018 with 900,000 units ofmerchandise that cost $5 each. Suppose the store then sold 50,000 units for $510,000 duringFebruary. Further, assume the store made two large purchases during February as follows:Feb 10 10,000 units @ $3.10 = $31,00021 25,000 units @ $2.20 = $55,000Requirements1. Calculate the store’s gross profit under both FIFO and LIFO at February 28.2. What caused the FIFO and LIFO gross profit figures to differ?arrow_forward(Learning Objective 3: Record note payable transactions) Dean Sales Companycompleted the following note payable transactions:2018Jul Purchased delivery truck costing $58,000 by issuing aone-year, 4% note payable.Dec 31 Accrued interest on the note payable.2019Jul 1 Paid the note payable at maturity.1Requirements1. How much interest expense must be accrued at December 31, 2018? (Round your answerto the nearest whole dollar.)2. Determine the amount of Dean Sales’ final payment on July 1, 2019.3. How much interest expense will Dean Sales report for 2018 and for 2019? (If needed,round your answer to the nearest whole dollar.)arrow_forward
- Question # 2 Sohrab Bicycle Co. shows the following accounting information for next four quarters of year 2016: Sohrab Bicycle Co. shows the following accounting information for next four quarters of year 2016: Quarter-1 Quarter-2 Quarter-3 Quarter-4 Sales in units 400 500 600 700 Price will remain unchanged for the whole year (i.e. Rs. 1500) Cash Collection: Cash Balance at start Rs. 1,000,000 60% cash will be collected for current quarter and 40% will be in the next quarter. Required: Sales budget for the year 2016 and Cash Budgetarrow_forwardExercise 4-54 Operating Cycle and Current Receivables a. Dither and Sly are attorneys-at-law who specialize in federal income tax law. The): complete their typical case in 6 months or less and collect from the typical client within 1 additional month. b. Johnstons Market specializes in fresh meat and fish. All merchandise must be sold within one week of purchase. Almost all sales are for cash and any receivables are generally paid by the end of the following month. c. Mortondos is a womens clothing store specializing in high-style merchandise. Merchandise spends an average of 7 months on the rack following purchase. Most sales are on credit and the typical customer pays within 1 month of sale. d. Trees Inc. grows Christmas trees and sells them to various Christmas tree lots. Most sales are for cash. It takes 6 years to grow a tree. Required: For each of the businesses described above, indicate the length of the operating cycle.arrow_forward4B. Draw up a cashbudget for Amal showing the balance at the end of each month, from the following information for the six months from July to December 2020: (a) Opening cash (including bank) balance on 1 July 2020 OMR 8000 (b) Production in units: Jan Feb March April May June July Aug Sep Oct Nov Dec 600 720 810 900 960 1,050 1,110 1,140 1,020 930 780 750 (c) Raw materials used in production cost OMR 30 per unit. Of this, 60 per cent is paid in the month of production and remaining balance in the month after production (d) Direct labour costs of OMR 15 per unit are payable in the month of production. (e) Variable expenses are OMR 5 per unit, payable 40 per cent in the same month as production and remaining balance in the month after production (f) Sales at OMR 70 per unit: Jan Feb March April May June July Aug Sep Oct Nov Dec 500 600 700 960 870 1,000 900 1,050 1,200 950 850 800 Debtors to pay…arrow_forward
- QUESTION 3: Based on the following assumptions and policies ; a) Prepare the budget for Collectables from Sales! b) Prepare the budget for Purchases! c) Prepare the budget of Cash Payment for Purchases! d) Set the company’s Cash Budget for 2021 BOARD Policies & Assumptions - Company’s projected sales for the three months as followings: Sales Forecast for 2021 January 2021 200.000 USD February 2021 220.000 USD March 2021 240.000 USD - All Sales are credited: %40 of sales are collected as in form of cash. %30 of sales are credited for 1 month and %30 of it for the next month. Rule: 40;30;30 - Accounts Receivables by quarter ending 31/12/2020 amounted to 120.000 USD a) 30.000 USD of Account Receivables belong to November Sales ( 11/2020) b) 90.000 USD of Account Receivables belong to December Sales ( 12/2020) - All purchases are credited: %50 of purchases are paid in advance and %50 of purchases are debited - Projected Inventories by the…arrow_forwardeBook Question Content Area What is the amount of budgeted cash payments if purchases are budgeted for $470,000 and the beginning and ending balances of accounts payable are $98,000 and $89,000, respectively? Cash paid $fill in the blank 1arrow_forward(Learning Objective 4: Account for warranty expense and accrued warranty payable)North Boulder USA, a tire manufacturer, guarantees its tires against defects for five years or60,000 miles, whichever comes first. Suppose North Boulder USA can expect warranty costsduring the five-year period to add up to 3% of sales. Assume that a North Boulder USA dealerin Denver, Colorado, made sales of $641,000 during 2018. North Boulder USA received cashfor 15% of the sales and took notes receivable for the remainder. Payments to satisfy customerwarranty claims totaled $18,500 during 2018.1. Record the sales, warranty expense, and warranty payments for North Boulder USA.Ignore cost of goods sold.2. Post to the Accrued Warranty Payable T-account. The beginning balance was $14,000. Atthe end of 2018, how much in accrued warranty payable does North Boulder USA owe toits customers?arrow_forward
- Question 4 Part I Advent used their historic collection percentages to budget for sales revenue for the first quarter of 2020as follows: January $100,000 February $175,000 March $250,000The company anticipates that approximately 80% of sales each month will be on credit. The historic percentages on collection are: 50% in the month of sale 40% in the month following the sale 10% two months following the sale Required: Prepare a monthly cash collections/receipts budget for the first quarter of 2020.arrow_forward(Learning Objective 6: Apply GAAP for notes receivable) Record the followingnote receivable transactions in the journal of Windham Golf. How much interest revenue didWindham earn this year? Use a 365-day year for interest computations, and round interestamounts to the nearest dollar. Windham Golf has a December 31 fiscal year-end.1 Loaned $17,000 cash to Jill Wateman on a one-year, 8% note.6 Performed service for Fairway Pro, receiving a 90-day, 10% note for$14,000.16Company.31 Accrued interest revenue for the year.Received a $5,000, six-month, 5% note on account from Paulsonarrow_forwardeBook Print Item Question Content Area Relevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,470 $211,539 Direct material purchases 115,290 120,831 Direct labor 75,200 73,300 Manufacturing overhead 25,400 25,200 Selling and administrative expenses 33,400 33,400 Depreciation included in selling and administrative 1,500 1,100 Collections from customers 215,392 240,154 Cash payments for purchases 114,300 119,252 Additional data:Capital assets were sold in January for $11,000 and $4,500 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,360 and a required minimum cash balance is $58,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quarters Quarter 1 Quarter 2 $- Select - $- Select - Add: Cash Receipts - Select - -…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
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