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.

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

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
Transcribed Image Text: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
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.
Transcribed Image Text: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.
Expert Solution
steps

Step by step

Solved in 3 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
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