Concept explainers
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.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Principles of Managerial Finance, Student Value Edition Plus MyLab Finance with Pearson eText - Access Card Package (15th Edition) (Pearson Series in Finance)
- 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
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning