Newman Medical Clinic has budgeted the following cash flows. Cash receipts Cash payments For inventory purchases January February March $101,000 $107,000 $127,000 90,500 72,500 85,500 For S&A expenses 31,500 32,500 27,500 Newman Medical had a cash balance of $8,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. 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.) Cash Budget Cash available Less: Cash payments Total budgeted payments Payments minus receipts Financing Activity January February March
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Manji
![Newman Medical Clinic has budgeted the following cash flows.
Cash receipts
Cash payments
For inventory
purchases
January February March
$101,000 $107,000 $127,000
90,500 72,500 85,500
For S&A expenses 31,500 32,500 27,500
Newman Medical had a cash balance of $8,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. 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.)
Cash Budget
Cash available
Less: Cash payments
Total budgeted payments
Payments minus receipts
Financing Activity
January
February
March](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd51efe94-46c4-4530-b613-4c0103568544%2F819183c8-e2d4-44f6-9d61-350a8317f927%2F63ga5b7_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)