? General Accounting:Munoz Medical Clinic has budgeted the following cash flows:Cash receipts $135,000Cash paymentsFor inventory purchases - $98,000For S&A expenses - $42,000For interest expense - $950Munoz Medical had a cash balance of $14,000 on January 1. Thecompany desires to maintain a cash cushion of $9,300. Funds areassumed to be borrowed and repaid on the last day of each month.How much does the company need to borrow at the end of January tomaintain its cash cushion?

Step 1: Start with the cash balance at the beginning of JanuaryThe starting cash balance is…

Answered: General Accounting: Munoz Medical…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 20E

See similar textbooks

Similar questions

Relevant data from the operating budget of The Framers are: Other data: Capital assets were sold in quarter 1 and $8,000 was collected in quarter 1 and $500 collected in quarter 2. Dividends of $500 will be paid in May The beginning cash balance was $50,000 and a required minimum cash balance is $10,000. Prepare a cash budget for the first two quarters of the year.
What is the amount of budgeted cash payments if purchases are budgeted for $420,000 and the beginning and ending balances of accounts payable are $95,000 and $92,000, respectively?
Rooney Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 113,000 $ 119,000 $ 139,000 Cash payments For inventory purchases 96,500 78,500 91,500 For S&A expenses 37,500 38,500 33,500 Rooney Medical had a cash balance of $14,500 on January 1. The company desires to maintain a cash cushion of $6,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. Rooney 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 last year’s quarterly results. Required Prepare a cash budget. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments should be indicated with a minus sign.)
Baird Medical Clinic has budgeted the following cash flows. February $108,000 January March Cash receipts Cash payments For inventory purchases For S&A expenses $102,000 $128,000 91,000 73,000 33,000 86,000 28,000 32,000 Baird Medical had a cash balance of $9,000 on January 1. The company desires to maintain a cash cushion of $7,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 3 percent per month. Repayments may be made in any amount available. Baird 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. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign. ) Cash Budget January February March Section 1: Cash Receipts $ $ Total cash available Section 2: Cash Payments Total…
Baird Medical Clinic has budgeted the following cash flows. Cash receipts Cash payments For inventory purchases For S&A expenses Cash Budget Section 1: Cash Receipts January $ 102,000 Total cash available Section 2: Cash Payments Total budgeted disbursements Section 3: Financing Activities 91,000 32,000 Baird Medical had a cash balance of $9,000 on January 1. The company desires to maintain a cash balance of $7,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 3 percent per month. Repayments may be made in any amount available. Baird 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. January S 0 0 0 February $…
Stuart Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 115,000 $ 121,000 $ 141,000 Cash payments For inventory purchases 97,500 79,500 92,500 For S&A expenses 38,500 39,500 34,500 Stuart Medical had a cash balance of $15,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. Stuart 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.
Newman Medical Clinic has budgeted the following cash flows. January February March $11,000 $117,000 $137,000 Cash receipts Cash payments For inventory purchases For S&A expenses 36,500 95,500 77,500 90,500 37,500 32,500 Newman Medical had a cash balance of $13,500 on January 1. The company desires to maintain a cash cushion of $10,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 3 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.)
Gibson Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 108,000 $ 114,000 $ 134,000 Cash payments For inventory purchases 94,000 76,000 89,000 For S&A expenses 35,000 36,000 31,000 Gibson Medical had a cash balance of $12,000 on January 1. The company desires to maintain a cash cushion of $7,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 3 percent per month. Repayments may be made in any amount available. Gibson 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. prepare the cash budget
Fanning Medical Clinic has budgeted the following cash flows. January $105,000 February $111,000 March Cash receipts Cash payments For inventory purchases For S&A expenses $131,000 92,500 33,500 74,500 34,500 87,500 29,500 Fanning Medical had a cash balance of $10,500 on January 1. The company desires to maintain a cash cushion of $10,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 3 percent per month. Repayments may be made in any amount available. Fanning 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. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage
Manji
Gibson Medical Clinic has budgeted the following cash flows. Cash receipts January $ 108,000 February $ 114,000 March $ 134,000 Cash payments For inventory purchases. For S&A expenses 94,000 35,000 76,000 36,000 89,000 31,000 Gibson Medical had a cash balance of $12,000 on January 1. The company desires to maintain a cash balance of $7,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 3 percent per month. Repayments may be made in any amount available. Gibson 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. Cash Budget Section 1: Cash Receipts Total cash available Section 2: Cash Payments Total budgeted…
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…

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

SEE MORE TEXTBOOKS