7,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. Repa

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
100%

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.)

Rooney Medical Clinic has budgeted the following cash flows.
January February March
$113,000 $119,000 $139,000
Cash receipts
Cash payments
For inventory purchases
For S&A expenses
96,500 78,500 91,500
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.)
Cash Budget
January
February
March
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
$
$
9,000 $
102,000
111,000
91,000
32,000
1,200
124,200
(13,200)
21,000
7,800 $
7,800 $
10,800
18,600
73,000
33,000
1,830
107,830
(89,230)
(970)
(90,200)
(90,200)
12,800
(77,400)
86,000
28,000
1,801
115,801
(193,201)
(12,199)
$ (205,400)
Transcribed Image Text:Rooney Medical Clinic has budgeted the following cash flows. January February March $113,000 $119,000 $139,000 Cash receipts Cash payments For inventory purchases For S&A expenses 96,500 78,500 91,500 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.) Cash Budget January February March 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 $ $ 9,000 $ 102,000 111,000 91,000 32,000 1,200 124,200 (13,200) 21,000 7,800 $ 7,800 $ 10,800 18,600 73,000 33,000 1,830 107,830 (89,230) (970) (90,200) (90,200) 12,800 (77,400) 86,000 28,000 1,801 115,801 (193,201) (12,199) $ (205,400)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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
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