Solomon Medical Clinic has budgeted the following cash flows. Cash receipts Cash payments For inventory purchases For S&A expenses January $ 114,000 97,000 38,000 February $ 120,000 79,000 39,000 March $ 140,000 92,000 34,000 Solomon Medical had a cash balance of $15,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. Solomon 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.
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.
I need Interest expense per month for February and March, need Borrowing(repayment) for January, February, and March.
Please dont provide solution in an image format thank you
![Prepare a cash budget.
Note: Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should
with a minus sign.
Cash Budget
Section 1: Cash Receipts
Beginning cash balance
Add: Cash receipts
Total cash available
Section 2: Cash Payments
For inventory purchases
For S&A expenses
Interest expense per month
Total budgeted disbursements
Section 3: Financing Activities
Surplus (shortage)
Borrowing (repayment)
Ending cash balance
$
$
January
15,000 $
114,000
129,000
97,000
38,000
1,200
136,200
February
(7,200)
(7,200) $
(7,200) $
120,000
112,800
79,000
39,000
118,000
(5,200)
(5,200) $
March
(5,200)
140,000
134,800
92,000
34,000
126,000
8,800
8,800](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0077ec45-aeaa-4640-9340-8eb00977cfb7%2F96c1301f-5e01-468d-b2a0-e7cd779c8ae6%2Ft7rmdlq_processed.png&w=3840&q=75)
![Solomon Medical Clinic has budgeted the following cash flows.
January
$ 114,000
Cash receipts
Cash payments
For inventory purchases
For S&A expenses
97,000
38,000
Pequired
February
$ 120,000
79,000
39,000
March
$ 140,000
92,000
34,000
Solomon Medical had a cash balance of $15,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. Solomon 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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0077ec45-aeaa-4640-9340-8eb00977cfb7%2F96c1301f-5e01-468d-b2a0-e7cd779c8ae6%2Fh4dwlgm_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps
![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)