Chapter 7 Homework Question 7 of 7 - 12 Current Attempt in Progress Sheridan Company expects to havea cash balance of $55,200 on January 1, 2025. These are the relevant monthly budget data for the firsttwo months of 2025. Collections from customers: January $85,200 and February $175,200. Payments tosuppliers: January $48,000 and February $90,000. Wages: January $36,000 and February $48,000.Wages are paid in the month they are incurred. Administrative expenses: January $25,200 and February $28,800. These costs include depreciation of $1,200 per month. All other costs are paid as incurred. Sellingexpenses: January $18,000 and February $24,000. These costs are exclusive of depreciation. They are paidas incurred. Sales of short-term investments in January are expected to realize $14,400in cash. Sheridanhas a line of credit at a local bank that enables it to borrow up to $30,000. The company wants to maintaina minimum monthly cash balance of $24,000. Prepare a cash budget for January and February. (List itemsthat increase cash balance first.) SHERIDAN COMPANY Cash Budget

The objective of this question is to prepare a cash budget for Sheridan Company for the months of…

Answered: Chapter 7 Homework Question 7 of 7 - 12…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Cash Budget Brindle Arts had the following Cash Budget for Quarter 1, 2022. The company requires a minimum cash balance of $ 50,000 Fill in the missing values: **If a cell has a value of 0, type the 0. A blank cell will be marked as incorrect. January February March Quarter 1 Beginning Cash balance $ 50,000 $ 166,756 $ 50,000 Add cash collections Total cash available $ 662,638 $ 673,643 $ 812,693 $ 1,931,075 Less total cash disbursements: Purchases $ 185,078 $ 189,439 Direct labor $ 86,875 $ 82,875 $ 249,750 Variable manufacturing OH $ 65,156 $ 62,156 $ 187,313 Fixed manufacturing OH $ 83,333 $ 83,333 Variable S&A $ 38,750 $ 43,750 $ 125,000 Fixed S&A $ 38,333 $ 38,333 Equipment $ 150,000 $…
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February⚫ March Cash Receipts Cash payments $ 521,000 408,000 457,000 $ 467,800 354,800 522,000 Kayak requires a minimum cash balance of $50,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $50,000 is used to repay loans at month-end. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of the year (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1) January February March $280,000 $300,000 $270,000 Cash receipts Cash disbursements 260,000 340,000 280,000 The expected cash balance at January 1, is $62,000. Brewster wants to maintain a cash balance at the end of each month of at least $60,000. Short-term borrowings at 1% interest per month will be used to accomplish this, if necessary. Borrowings (in multiples of $1,000) will be made at the beginning of the month in which they are needed, with interest for that month paid at the end of the month. Prepare a cash budget for the quarter ended March 31. Brewster Corporation Cash Budget for the Quarter Ended March 31 January Beginning cash balance Cash receipts Short-term borrowings Cash available Cash disbursements Interest payment Total…
Exercises 1: Questions for discussion 1. Describe the items reflected in the sales budget. 2. List the items included in the production budget 3. Identify the items that comprise the operating budget Exercises 2: Word Problems Roel Trading Company presents the actual sales for the first three months of year 2019 in its own products as follows: Product B P 540,000 P 567,000 P 595,350 Product A Total Sales Janaury February March P 880,000 P 941,000 P 1,006,750 The business expects that the trends for the past three months will P 340,000 P 374,000 P 411400 continue in April and May 2019. Required: Determined the projected sales for April and May 2019 for the two products. Round the amounts to thousand pesos.
Tomo, Inc. has prepared its third quarter budget and provided the following data: Jul $49,000 Aug $39,800 Sep $47,900 Cash collections Cash payments: Purchases of direct materials Operating expenses Capital expenditures 17,900 11,100 0 The cash balance on June 30 is projected to be $4,600. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 5%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash. Calculate the final projected cash balance at the end of August taking into consideration all the financing transactions. 31,000 12,100 13,700 O A. $46600 OB. $-8842 OC. $15000 O D. $6158 21,800 8,700 24,900
Management Accounting Course Project – Part 1, B Group The Terranova Company is preparing information to complete its master budget for the quarter ending December 31, 2020. The company intends to make unit sales in the related months as follows: September 5,000 October 9,750 November 11,700 December 14,625 Units are to be sold for $10 each. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following the sale. *Required: 1) Prepare a sales budget for Terranova for the quarter ending December 31, 2020. Show activity by month and in total. (Hint: a quarter = 3 months.) 2) Complete a schedule of expected cash collections for the quarter ending December 31, 2020. Show activity by month and in total.
The Foress Antique Mall budgeted credit sales in the first quarter of 2021 to be as follows: January February March $188,800 200,600 214,000 Credit sales in December 2020 are expected to be $236,000. The company expects to collect 70 percent of a month's sales in the month of sale and 30 percent in the following month. Estimate cash receipts for each month of the first quarter of 2021. Collection of credit sales Collection of December sales $ Collection of January sales Collection of February sales Collection of March sales $ January $ $ February $ $ March Ac Go
189 Exercise 5-11 William Go is the owner and manager of the Kentucky Company. He is in the process of preparing a budget for the first six months of 2021, Income statement estimates for each month are given below: Jan. Feb. May March P92,000 P82,000 P102,000 P146,000 P172,000 P188,000 P50,000 P46,000 P56,000 P68,000 P88,000 April June Sales Cost of sales P96,000 28,000 Expenses Depreciation Total 16,000 8,000 P74,000 P68,000 P80,000 P18,000 P14,000 14,000 8,000 16,000 8,000 24,000 10,000 P98,000 P122,000 P134,000 22,000 8,000 10,000 Net income P22,000 P48,000 P50,000 P54,000 in certain balance sheet accounts during each month. (decreases) are given below: During the six-month period, William anticipates the following changes The increases and March Accounts receivableP(6,000) P4,000 P12,000 Jan. Feb. May P(4,000) P6,000 P(8,000) (10,000) 16,000 (4,000) (4,600) April June Inventories 8,000 (8,000) 14,000 (6,000 ) Accounts payable 2,000 2,000 The cash balance on January 1, 2021 is…
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.
Problem 6 Tomtom store seeks your assistance to develop cash and other budget information for May, June, and July 2009. On April 30, 2009, the company had cash balance of Php5,500. The budget is based on the following assumptions: A. Sales 1. Each month's sales are billed on the last day of the month 2. Customers are allowed 3% discount if payment is made within 10 days after the billing date. Accounts receivable are booked gross. 3. Sixty percent of the billings are collected within the discount period, 25% are collected by the end of the month where discount period is allowed, 9% are collected by the end of the end second month, and 6% prove uncollectible. B. Purchases 1. 54% of all purchases of materials and selling, general and administrative expenses are paid at the month purchased and the remainder in the following month. 2. Each month's unit of ending inventory is equal to 130% of the month's units of sales. 3. The cost of each unit of inventory is P20. 4. Selling, general and…
eBook Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: January February March Sales $148,000 $179,000 $238,000 Manufacturing costs 62,000 77,000 86,000 Selling and administrative expenses 43,000 48,000 52,000 Capital expenditures _ _ 57,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 65% are expected to be collected in full in the month following the sale and the remainder the following month. Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in June, and the annual property taxes are paid in October. Of the remainder of the manufacturing costs, 85% are expected to be paid in the month in which they are incurred and the balance in the following month. All sales and administrative…
Newman Medical Clinic has budgeted the following cash flows. January February March $109,000 $115,000 $135,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $12,500 on January 1. The company desires to maintain a cash cushion of $8,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) 94,500 76,500 89,500 35,500 36,500 31,500 Cash Budget Cash available Less: Cash payments Total budgeted payments Payments minus receipts Financing Activity $ EA January 0 0…

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS