Thornton Medical Clinic has budgeted the following cash flows January $ 116,000 Cash receipts Cash payments For inventory purchases For S&A expenses 98,000 39,000 February $ 122,000 80,000 40,000 March $ 142,000 93,000 35,000 Thornton Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash balance of $9,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 2 percent per month. Repayments may be made in any amount available. Thornton 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 Note: Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign.

Thornton Medical Clinic has budgeted the following cash flows January $ 116,000 Cash receipts Cash payments For inventory purchases For S&A expenses 98,000 39,000 February $ 122,000 80,000 40,000 March $ 142,000 93,000 35,000 Thornton Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash balance of $9,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 2 percent per month. Repayments may be made in any amount available. Thornton 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 Note: Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign.

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.
2
The treasurer of Gateway Co. has accumulated the following budget information for the first two months of the coming year: March $450,000 290,000 41,400 250,000 45,000 51,000 121,500 April $520,000 350,000 46,400 Sales Inventory costs Operating expenses Capital expenditures March 1 Cash balance Accounts Receivables-March 1 Accounts Payable-March 1 ($102,000 for inventory purchases and $19,500 for operating expenses) The company expects to sell about 35% of sales for cash. Of sales on account, 80% are expected to be collected in full in the month of the sale and the remainder in the month following the sale. One fourth of the inventory costs are expected to be paid in the month in which they are incurred and the other three fourths in the month following. Depreciation, insurance, and property taxes represent $6,400 of the total budgeted monthly operating expenses. Insurance is paid in February and a $40,000 installment on property taxes is expected to be paid in April. Of the remainder…
A Company is preparing a cash budget for June The company has $83,750 cash at the beginning of June and anticipates $102,930 in cash receipts and $116,870 in cash disbursements during June. This company has an agreement with its bank to maintain a cash balance of at least $81 250. As of May 31. the company owes $30,000 to the bank To maintain the $81.250 required balance, during June the company must O Borrow $11 440 O Repay $13,940 O Borrow $30 000 Repay $30,000 O Repay $11,440
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…
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 $ 200,000 $ 350,000 $ 230,000 $250,000 $274,000 $244,000 $234,000 $ 254,000 Total cash receipts Total cash disbursements The company's beginning cash balance for the upcoming fiscal year will be $24,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.)
Fayette Medical Clinic has budgeted the following cash flows. February $232,000 January March Cash receipts Cash payments For inventory purchases For S&A expenses $240,000 $272,000 220,000 62,000 164,000 64,000 190,000 54,000 Fayette Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $2,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. Fayette pays its vendors on the last day of the month also. The company had a monthly $80,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 intermediate and final answers to the nearest whole dollar amounts.) X Answer is not complete. Cash Budget January February March Section 1: Cash receipts Beginning cash…
Beginning cash balance as on March 1, P80,000. Cash receipts from sales P400,000 Budgeted cash disbursements for purchases 250,000. Budgeted cash disbursements for salaries 90,000. Cash repayment of bank loan 30,000. Prepare a cash budget for the month ended on March 31 for Spars Corp.
Foyert Corporation requires a minimum $7,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $7,000 is used to repay loans at month-end. The cash balance on October 1 is $7,000, and the company has an outstanding loan of $3,000. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. (please see picture for other info) October November December Cash receipts $ 23,000 $ 17,000 $ 21,000 Cash payments 25,500 16,000 15,000 Prepare a cash budget for October, November, and December.
Garden Depot is a retaller 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 $ 280,000 $ 344,888 Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest 2nd Quarter $ 480,000 $ 314,000 The company's beginning cash balance for the upcoming fiscal year will be $45,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. Total financing Ending cash balance Required:…
Give me correct answer and explanation.
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…