Please help me with show all calculation thanku Duffy Corp. has provided a part of its budget for the second quarter:AprMay$40,00 $40,00 $40,00000Cash collectionsCash payments:Purchases of directmaterials$42,000$56,90060006000$85,40072007900Operating expensesCapital expenditures010,0000The cash balance on April 1 is $14,000. Assume that there will be no financing transactions or costs during the quarter.Calculate the projected cash balance at the end of April.$54,000Jun45007000

The projected cash balance refers to an estimate or forecast of the expected cash position of a…

Duffy Corp. has provided a part of its budget for the second quarter: Apr May Jun $40,00 $40,00 $40,00 0 0 0 Cash collections Cash payments: Purchases of direct materials 7200 Operating expenses 7900 Capital expenditures 0 10,000 0 The cash balance on April 1 is $14,000. Assume that there will be no financing transactions or costs during the quarter. Calculate the projected cash balance at the end of April. $54,000 $42,000 $56,900 $85,400 6000 6000 4500 7000

Duffy Corp. has provided a part of its budget for the second quarter: Apr May Jun $40,00 $40,00 $40,00 0 0 0 Cash collections Cash payments: Purchases of direct materials 7200 Operating expenses 7900 Capital expenditures 0 10,000 0 The cash balance on April 1 is $14,000. Assume that there will be no financing transactions or costs during the quarter. Calculate the projected cash balance at the end of April. $54,000 $42,000 $56,900 $85,400 6000 6000 4500 7000

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

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
Tomo, Inc. has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $52,000 $39,600 $47,200 Cash payments: Purchases of direct materials 31,000 21,200 17,800 Operating expenses 12,500 8900 11,400 Capital expenditures 13,100 24,900 0 The cash balance on June 30 is projected to be $4300. 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 4%. 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.
Delbert, Inc. has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $49,000 $39,500 $46,000 Cash payments: Purchases of direct materials 30,000 22,100 17,600 Operating expenses 12.400 8,500 11,400 Capital expenditures 13,300 24,200 0 The cash balance on June 30 is projected to be $5,300. 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 4%. 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. How much will the company have to borrow at the end of July? OA. $15,000 OB. $10,000 OC. $5,000 OD. $0
Duffy Corp. has provided a part of its budget for the second quarter. Apr $40,000 Cash collections Cash payments: Purchases of direct materials OA. $42,000 OB. $71,000 O C. $53,000 O D. $61,000 5,000 6,000 Operating expenses 6,000 6,000 Capital expenditures 10,000 20,000 The cash balance on April 1 is $13,000. Assume that there will be no financing transactions or costs during the quarter. Calculate the projected cash balance at the end of April. 4 May $40,000 5,000 6,000 0 Jun $42,000 D
ladeo Corp. has provided a part of its budget for the second quarter Apr $43,000 Jun $42,000 Cash collections Cash payments: Purchases of direct materials Operating expenses Capital expenditures The cash balance on April 1 is $13,000. Assume that there will be no financing transactions or costs during the quarter. Calculate the projected cash balance at the end of May OA. $56,000 OB. $54,900 O C. $87,500 OD. $32,600 May $43,000 4,500 7,000 0 7,000 5,600 20,000 5,000 4,500 10,000 HELHE
Tadeo Corp. has provided a part of its budget for the second quarter: Apr May Jun Cash collections $40,000 $45,000 $45,000 Cash payments: Purchases of direct materials 5,000 7,000 7,000 Operating expenses 7,000 7,000 7,000 Capital expenditures 20,000 5,000 0 The cash balance on April 1 is $13,000. Assume that there will be no financing transactions or costs during the quarter. Calculate the projected cash balance at the end of May. A. $53,000 B. $19,000 C. $47,000 D. $66,000
cash balance of $10,000 will be maintained throughout the cash budget period. Prepare a monthly cash budget for January and February and answer the following: How much surplus (or loan) is expected at the end of February? A $1,900 B. $200 C. $1,400 D. $3,100 E. none of the other choices is correct
Carol's Chocolate Company has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $49,000 $39,700 $47,000 Cash payments: Purchases of direct materials 31,000 21,400 17,000 Operating expenses 12,200 8,700 11,700 Capital expenditures 13,100 24,400 0 The cash balance on June 30 is projected to be $5,500. 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 4%. 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 ending projected cash balance before financing for August.
The following information was taken from Bonita Industries's cash budget for the month of July: Beginning cash balance $440000 Cash receipts 404000 Cash disbursements 558000 If the company's policy is to maintain a minimum end of the month cash balance of $430000, the amount the company would have to borrow in July is $286000. $144000. $10000. $26000.
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.
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 $ 521,000 $ 466,700 February 404,000 349,700 March 467,000 523,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.)
The company provides the following information regarding the cash budget for next year: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Beginning cash balance $5,000 $5,000 $5,000 $5,000 Excess (Deficiency) ($3,000) $2,000 ($2,500) $1,000 The company's policy is to start each quarter with a cash balance of $5,000.The company has access to a line of credit in the amount of $50,000 for any short term borrowing needs and pays the loans off as quickly as possible.The company assumes the cash budget for the year will begins with no loans.What is the expected loan balance at the end of Quarter 2 (ignore interest)?