CHAPTER 4: THE CASH BUDGET1. The Right Target, Inc., a marketing research and consulting firm, is working on a cash budgetfor July to December 2017. The staff has projected the following cash collections and payments:CollectionsPaymentsCash Sales$10,000Credit Sales Purchases$20,000 $15,000JulyAugust$12,000$24,000 $18,000$28,000 $21,000September $14,000October$16,000$32,000 $24,000November$20,000$40,000December$25,000$50,000a) If the ending cash balance as of June 30, 2017 was $10,000, determine the firm's forecasted monthlycash balance.@2Wb)The staff at The Right Target, Inc. wants to know how much they would need to borrow each month ifthe minimum ending cash balance is $30,000 and the annual interest rate is 7%.c)Determine the impact on the ending cash balance if the firm uses any cash surplus above the requiredminimum cash balance to pay off its short-term borrowing monthly.SXcommand#Month320EDF3C$4gogRF4F%5V2TG6BYH&7$7,200$8,400$9,600$30,000 $12,000$37,500 $15,00044F7N*8Wages Miscellaneous Expenses$6000$1,500J11FBM(9➤➤KOV10$2,000$2,500$3,000$4,000$4,500F10PAcommandGINE.{+ 11altGoptiondel

Cash budget means an estimation of the cash flowsof a business over a specific period of timeEnding…

The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget for July to December 2017. The staff has projected the following cash collections and payments= Collections Payments Month July August September October November December Cash Sales $10,000 $12,000 $14,000 $16,000 $20,000 $25,000 Credit Sales Purchases Wages Miscellaneous Expenses $6000 $1,500 $20,000 $15,000 $24,000 $18,000 $7,200 $28,000 $21,000 $8,400 $32,000 $24,000 $9,600 $40,000 $30,000 $12,000 $50,000 $37,500 $15,000 $2,000 $2,500 $3,000 $4,000 $4,500 a) If the ending cash balance as of June 30, 2017 was $10,000, determine the firm's forecasted monthly cash balance. b) The staff at The Right Target, Inc. wants to know how much they would need to borrow each month if the minimum ending cash balance is $30,000 and the annual interest rate is 7%.

The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget for July to December 2017. The staff has projected the following cash collections and payments= Collections Payments Month July August September October November December Cash Sales $10,000 $12,000 $14,000 $16,000 $20,000 $25,000 Credit Sales Purchases Wages Miscellaneous Expenses $6000 $1,500 $20,000 $15,000 $24,000 $18,000 $7,200 $28,000 $21,000 $8,400 $32,000 $24,000 $9,600 $40,000 $30,000 $12,000 $50,000 $37,500 $15,000 $2,000 $2,500 $3,000 $4,000 $4,500 a) If the ending cash balance as of June 30, 2017 was $10,000, determine the firm's forecasted monthly cash balance. b) The staff at The Right Target, Inc. wants to know how much they would need to borrow each month if the minimum ending cash balance is $30,000 and the annual interest rate is 7%.

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

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.
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter $ 310,000 $ 438,038 $365,008 $ 335,000 Required: Prepare the company's cash budget for the upcoming fiscal year. Note: Repayments and interest should be indicated by a minus sign. The company's beginning cash balance for the upcoming fiscal year will be $25,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Beginning cash balance Total cash receipts Total cash available Total cash…
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts. Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter $ 210,000 $ 240,000 $ 281,000 $ 241,000 The company's beginning cash balance for the upcoming fiscal year will be $26,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest $360,000 $ 251,000 Required: Prepare…
S Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter $ 220,000 $ 288,000 $ 370,000 $ 258,000 3rd Quarter $ 250,000 $ 248,000 4th Quarter $ 270,000 $ 268,000 The company's beginning cash balance for the upcoming fiscal year will be $28,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for the upcoming fiscal year. (Repayments, interest, and cash deficiencies should be indicated by a minus sign.) Beginning cash…
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
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $ 260,000 $ 316,000 $ 410,000 $ 286,000 $ 290,000 $ 276,000 Total cash receipts $ 310,000 $ 296,000 Total cash disbursements The company's beginning cash balance for the upcoming fiscal year will be $36,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for the upcoming fiscal year. (Repayments, and interest, should be indicated by a minus sign.) Garden Depot Cash Budget 1st…
Garden Depot Is a retailer that provided the following budgeted cash flows for next year. 1st Quarter 2nd Quarter $410,000 $ 260,000 $ 316,000 $ 286,000 3rd Quarter $ 290,000 $ 276,000 Total cash receipts Total cash disbursements The company's beginning cash balance for next year will be $36,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly Interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume Interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, Interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing Borrowings Repayments Interest Total financing Ending cash balance…
Mi.2
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $132,000 $164,000 $210,000 Manufacturing costs 55,000 71,000 76,000 Selling and administrative expenses 38,000 44,000 46,000 Capital expenditures _ _ 111,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 65% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $8,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as…
Please answer with excel forumlas and step by step explanations. 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 $ 569,000 $ 508,000 February 455,000 425,000 March 505,000 600,000 Kayak requires a minimum cash balance of $38,000 at each month-end. Loans taken to meet this requirement charge 0.7% 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 $38,000 is used to repay loans at month-end. The company has a cash balance of $38,000 and a loan balance of $76,000 at January 1. Prepare monthly cash budgets for January, February, and March.
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter $ 300,000 $ 420,000 $ 350,000 $ 358,000 $ 328,000 $ 318,000 The company's beginning cash balance for the upcoming fiscal year will be $35,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for the upcoming fiscal year. (Repayments, interest, and cash deficiencies should be indicated by a minus sign.) Beginning cash balance Total cash receipts Total…
Tamarisk Garden Center has the following cash budget information available for the month of August: Beginning cash balance Cash receipts from sales and collections on account Collection of note receivable and interest Cash disbursements for operating expenses The company would have to $129,000 eTexthonk and Media 115,000 8,100 If the company has a policy of maintaining an end of the month cash balance of $120,000, determine the amount the company would have to borrow or the amount of excess cash it will have to invest in August. 96,400 SUPPORT