Rundle Medical Clinic has budgeted the following cash flows. Cash receipts Cash payments For inventory purchases For S&A expenses January $ 112,000 96,000 37,000 February $ 118,000 78,000 38,000 March $ 138,000 91,000 33,000 Rundle Medical had a cash balance of $14,000 on January 1. The company desires to maintain a cash balance of $5,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. Rundle 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.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 13EA: What is the amount of budgeted cash payments if purchases are budgeted for $420,000 and the...
icon
Related questions
icon
Concept explainers
Question

Dd.1 

 

 

 

Rundle Medical Clinic has budgeted the following cash flows.
Cash receipts
Cash payments
For inventory purchases
For S&A expenses
January
$ 112,000
96,000
37,000
February
$ 118,000
78,000
38,000
March
$ 138,000
91,000
33,000
Rundle Medical had a cash balance of $14,000 on January 1. The company desires to maintain a cash balance of $5,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. Rundle 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.
Transcribed Image Text:Rundle Medical Clinic has budgeted the following cash flows. Cash receipts Cash payments For inventory purchases For S&A expenses January $ 112,000 96,000 37,000 February $ 118,000 78,000 38,000 March $ 138,000 91,000 33,000 Rundle Medical had a cash balance of $14,000 on January 1. The company desires to maintain a cash balance of $5,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. Rundle 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 disbursements
Section 3: Financing Activities
January
February
March
Transcribed Image Text:Cash Budget Section 1: Cash Receipts Total cash available Section 2: Cash Payments Total budgeted disbursements Section 3: Financing Activities January February March
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College