In the month of February Concord Airlines expects a total cash receipt of 118 and a total cash disbursements (payments) of 550. The ending cash balanceof January was 59. The company will take a loan in case the minimum desired cash balance of 500 BD is not met. Based on this information what is theloan amount for the month of February.

Given information: For the month of February: Opening balance : 59 Cash receipts : 118 Cash…

Answered: In the month of February Concord…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 9PA: Fitbands estimated sales are: What are the balances in accounts receivable for January, February,...

See similar textbooks

Similar questions

Prime Products hopes to borrow $73,000 on April 1 and repay it plus interest of $1,080 on June 30. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $41,800. Accounts receivable on April 1 will total $182,000, of which $156,000 will be collected during April and $20,800 will be collected during May. The remainder will be uncollectible. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three-month period follow: April May June Sales (all on account) $316,000 $575,000 $264,000 Merchandise purchases $214,000 $193,000 $ 151,500 Payroll $ 34,200 $ 34,200 $27,300 Lease payments $31,600 $31,600 $ 31,600 Advertising $ 74,000 $ 74,000 $ 43,000 Equipment purchases $70,500 Depreciation…
Prime Products hopes to borrow $87,000 on April 1 and repay it plus interest of $1,220 on June 30. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $39,000. Accounts receivable on April 1 will total $170,800, of which $146,400 will be collected during April and $19,520 will be collected during May. The remainder will be uncollectible. b. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation Required 1 Required 2 April $ 242,000 $ 213,000 $ 19,600 $ 29,200 $ 62,600 - Beginning cash balance Add receipts: Collections from customers May $…
A company has expected sales for January through April of $9,800, 59, 500, $13, 800, and $9,500, respectively. Assume each month has 30 days and the accounts receivable period is 36 days. How much does the company expect to collect in the month of May?
Z Corporation has a cash balance of 500,000 at the beginning of the month. Based on its forecast for the month, cash collections will be 2,170,000 while cash disbursements will be 2,430,000. If Z Corporation is contractually obligated to maintain a cash balance of 600,000 by the end of the month, how much should Z borrow
crane company management wants to maintain a minimum monthly cash balance of $26,500. At the begining of April, the cash balance is $26,500, expected cash receipts for April are $259,700, and cash disbursements are expected to be $270,300. How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance ?
Melody Inc. had a November ending cash balance of $15,000. As well, it had sales of $10,000 in November, $20,000 in December, and projects sales of $25,000 for January, $30,000 for February, and $35,000 for March. The firm collects its receivables in the month after the sale. Given this information, calculate its cash balance at the end of March. Assume that every month has 30 days. $75,000 $80,000 $90,000 $100,000 $110,000
Bruno Industries expects credit sales for January, February, and March to be $200,000, $260,000, and $300,000, respectively. It is expected that 55% of the sales will be collected in the month of sale, 35% will be collected in the following month, and 10% will be collected in the second month after the sales. How much will the closing balance of Accounts Receivable at the end of March be? 3. In the beginning of the period, XYZ Ltd. expects to sell 15,000 units for $10 each. Its standard cost card shows the total cost of production per unit is $8. At the end of the period, the company reported actual sales revenue at $120,000 for 16,000 units sold. What was the sale price variance?
Assume receivables of $20,000 at the start of the January are all collected during the month; if sales for January and February are $400,000 and $300,000 respectively; the company typically receives payment from 20% of its customers within the same month, 60% the following month, and the remaining 20% by the end of the second following month, how much would accounts receivable be at the end of February?
Al Bahr Corporation, a wholesaler, provided the following informationMonthSalesJanuary64000February59000March42000April48000Customers pay 60% of their balances in the month of sale, 30% in the month following sale, and 10% in the second month following sale.Required: Determine the expected cash collection during March.
Ind
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 $ 517,000 409,500 480,000 $ 459,400 351,900 524,000 Kayak requires a minimum cash balance of $40,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 $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,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.) Answer is complete but not entirely correct. KAYAK COMPANY Beginning cash balance Add: Cash receipts Cash Budget January February March SA 40,000 $ 40,000 $ 74,168 517,000 409,500 480,000 557,000 449,500…
Harrah Company provided the following information for the month of October: Beginning cash balance $ 35,000 Cash receipts 460,000 Cash disbursements 485,000 Harrah's policy is to keep a minimum end of the month cash balance of $30,000. How much will Harrah's need to borrow during October?

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS