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 $ 0 0 February $ 108,000 73,000 33,000 $ February 0 $ 0 $ 0 0 March $ 128,000 0 86,000 28,000 $ March 0 0 0 0 0

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Baird Medical Clinic has budgeted the following cash flows.

**Table: Cash Receipts and Cash Payments**
- **January**
  - Cash receipts: $102,000
  - Cash payments:
    - For inventory purchases: $91,000
    - For S&A expenses: $32,000

- **February**
  - Cash receipts: $108,000
  - Cash payments:
    - For inventory purchases: $73,000
    - For S&A expenses: $33,000

- **March**
  - Cash receipts: $128,000
  - Cash payments:
    - For inventory purchases: $86,000
    - For S&A expenses: $28,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.

**Diagram: Cash Budget Template**

- **Section 1: Cash Receipts**
  - January: $0
  - February: $0
  - March: $0

- **Total Cash Available**
  - January: $0
  - February: $0
  - March: $0

- **Section 2: Cash Payments**
  - January: $0
  - February: $0
  - March: $0

- **Total Budgeted Disbursements**
  - January: $0
  - February: $0
  - March: $0

- **Section 3: Financing Activities**
  - January: $0
  - February: $0
  - March: $0

All entries in the budget template are initially $0 and need to be calculated as per financial instructions.
Transcribed Image Text:Baird Medical Clinic has budgeted the following cash flows. **Table: Cash Receipts and Cash Payments** - **January** - Cash receipts: $102,000 - Cash payments: - For inventory purchases: $91,000 - For S&A expenses: $32,000 - **February** - Cash receipts: $108,000 - Cash payments: - For inventory purchases: $73,000 - For S&A expenses: $33,000 - **March** - Cash receipts: $128,000 - Cash payments: - For inventory purchases: $86,000 - For S&A expenses: $28,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. **Diagram: Cash Budget Template** - **Section 1: Cash Receipts** - January: $0 - February: $0 - March: $0 - **Total Cash Available** - January: $0 - February: $0 - March: $0 - **Section 2: Cash Payments** - January: $0 - February: $0 - March: $0 - **Total Budgeted Disbursements** - January: $0 - February: $0 - March: $0 - **Section 3: Financing Activities** - January: $0 - February: $0 - March: $0 All entries in the budget template are initially $0 and need to be calculated as per financial instructions.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education