Cash receipts January February March $ 107,000 $ 113,000 $ 133,000 Cash payments For inventory purchases For S&A expenses 93,500 34,500 75,500 35,500 88,500 30,500 Franklin Medical had a cash balance of $11,500 on January 1. The company desires to maintain a cash balance 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. Franklin 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 Answer is complete but not entirely correct. January February March

Century 21 Accounting General Journal
11th Edition
ISBN:9781337680059
Author:Gilbertson
Publisher:Gilbertson
Chapter16: Financial Statements And Closing Entries For A Corporation
Section: Chapter Questions
Problem 5AP
icon
Related questions
Question
Cash receipts
Cash payments
For inventory purchases
For S&A expenses
January
$ 107,000
February
$113,000
March
$ 133,000
93,500
34,500
75,500
35,500
88,500
30,500
Franklin Medical had a cash balance of $11,500 on January 1. The company desires to maintain a cash balance 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. Franklin 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.
> Answer is complete but not entirely correct.
Cash Budget
Section 1: Cash Receipts
Beginning cash balance
January
February
March
$ 11,500 $ 6,700 $ 6,000
Add: Cash receipts
Total cash available
Section 2: Cash Payments
For inventory purchases
107,000
118,500
113,000
119,700
133,000
139,000
93,500
75,500
88,500
For S&A expenses
34,500
35,500
30,500
Interest expense per month
800
1,140
1,109
Ending cash balance
Total budgeted disbursements
128,800
112,140
120,109
Section 3: Financing Activities
Surplus (shortage)
(10,300)
Borrowing (repayment)
17,000
7,560
(1,560)
18,891
(12,891)
Ending cash balance
6,700 $
6,000 $
6,000
<Prev
1 of 2
Next >
Transcribed Image Text:Cash receipts Cash payments For inventory purchases For S&A expenses January $ 107,000 February $113,000 March $ 133,000 93,500 34,500 75,500 35,500 88,500 30,500 Franklin Medical had a cash balance of $11,500 on January 1. The company desires to maintain a cash balance 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. Franklin 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. > Answer is complete but not entirely correct. Cash Budget Section 1: Cash Receipts Beginning cash balance January February March $ 11,500 $ 6,700 $ 6,000 Add: Cash receipts Total cash available Section 2: Cash Payments For inventory purchases 107,000 118,500 113,000 119,700 133,000 139,000 93,500 75,500 88,500 For S&A expenses 34,500 35,500 30,500 Interest expense per month 800 1,140 1,109 Ending cash balance Total budgeted disbursements 128,800 112,140 120,109 Section 3: Financing Activities Surplus (shortage) (10,300) Borrowing (repayment) 17,000 7,560 (1,560) 18,891 (12,891) Ending cash balance 6,700 $ 6,000 $ 6,000 <Prev 1 of 2 Next >
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Accounting for Impairment of Assets
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
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning