Managerial Accounting
Managerial Accounting
7th Edition
ISBN: 9781260247886
Author: Wild
Publisher: MCG
bartleby

Concept explainers

Question
Book Icon
Chapter 7, Problem 31E
To determine

Cash Budget:

It is the prediction of cash inflows and outflows for an entity over a period of time. It is helpful in assessing that the entity has enough cash to operate.

To prepare: Monthly cash budget for the month of April, May, June.

Expert Solution & Answer
Check Mark

Explanation of Solution

Company C
Cash Budget
Particulars April Amount ($) May Amount ($) June Amount ($)
Beginning cash balance 12,000 12,000 12,279
Add: Cash receipts (Working Note 1) 28,000 36,000 32,000
Total cash available 40,000 48,000 44,279
Less: Cash disbursement (Working Note 2) 32,040 29,600 28,080
Interest expense (working note 3) 20 61 -
Preliminary cash balance 7,940 18,339 16,199
Less: Required ending cash balance 12,000 12,000 12,000
Surplus (4,060) 6,339 4,199
Beginning balance of loan 2,000 6,060 0
Add: Additional loan from bank 4,060 0 0
Less: Repayment of loan 0 6,060 0
Ending loan balance 6,060 0 0
Ending cash balance carried forward next month 12,000 12,279 16,199
Table (1)

Working note:

Company C
Cash Receipts
Particulars April Amount ($) May Amount ($) June Amount ($)
Sales 32,000 40,000 24,000
Cash collection:
Previous sale (50%) 12,000 16,000 20,000
Current sale (50%) 16,000 20,000 12,000
Total 28,000 36,000 32,000
Table (2)

Working note:

Company C
Cash Disbursements
Particulars April Amount ($) May Amount ($) June Amount ($)
Cash payments for merchandise 20,200 16,800 17,200
Sales commission ( sales×10% ) 3,200 4,000 2,400
Shipping ( sales×2% ) 640 800 480
Salaries 5,000 5,000 5,000
Rent 3,000 3,000 3,000
Total 32,040 29,600 28,080
Table (3)

Working note:

Formula to calculate interest expense for the month,

    Interest expense=Beginning balance of loan×1% 

For April

Given,
Beginning balance of loan is $2,000.

Substitute $2,000 for beginning balance.

    Interest expense=$2,000×1% =$20

For May,

Beginning balance of loan $6,060 (calculated).

Substitute $6,060 for beginning balance.

    Interest expense=$6,060×1% =$61

For June,

Beginning balance of loan $0 (calculated).

Substitute $0 for beginning balance.

    Interest expense=$0×1% =$0

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 7 Solutions

Managerial Accounting

Ch. 7 - How does budgeting help management coordinate and...Ch. 7 - Why is the sales budget so important to the...Ch. 7 - What is the selling expense budget? What is the...Ch. 7 - Prob. 9DQCh. 7 - GOOGLE Google prepares a cash budget. What is a...Ch. 7 - Prob. 11DQCh. 7 - Prob. 12DQCh. 7 - Prob. 13DQCh. 7 - Prob. 14DQCh. 7 - Coca-cola recently redesigned its bottle to reduce...Ch. 7 - Activity-based budgeting is a budget system based...Ch. 7 - Budget motivation C1 For each of the following...Ch. 7 - Budgeting benefits C1 For each of the following...Ch. 7 - Prob. 3QSCh. 7 - Prob. 4QSCh. 7 - Prob. 5QSCh. 7 - Prob. 6QSCh. 7 - Prob. 7QSCh. 7 - Prob. 8QSCh. 7 - Prob. 9QSCh. 7 - Prob. 10QSCh. 7 - Prob. 11QSCh. 7 - Prob. 12QSCh. 7 - Prob. 13QSCh. 7 - Prob. 14QSCh. 7 - Prob. 15QSCh. 7 - Manufacturing: Production budget P1 Atlantic Surf...Ch. 7 - Prob. 17QSCh. 7 - Prob. 18QSCh. 7 - Prob. 19QSCh. 7 - Cash receipts, with uncollectible accounts P2 The...Ch. 7 - Cash receipts, with uncollectible accounts P2 Well...Ch. 7 - Prob. 22QSCh. 7 - Budgeted loan activity P2 Santos Co. is preparing...Ch. 7 - Prob. 24QSCh. 7 - Prob. 25QSCh. 7 - Prob. 26QSCh. 7 - Prob. 27QSCh. 7 - Prob. 28QSCh. 7 - Prob. 29QSCh. 7 - Prob. 30QSCh. 7 - Prob. 31QSCh. 7 - Prob. 1ECh. 7 - Prob. 2ECh. 7 - Prob. 3ECh. 7 - Prob. 4ECh. 7 - Exercise 20-5 Manufacturing: Direct labor budget...Ch. 7 - Prob. 6ECh. 7 - Prob. 7ECh. 7 - Prob. 8ECh. 7 - Prob. 9ECh. 7 - Prob. 10ECh. 7 - Prob. 11ECh. 7 - Prob. 12ECh. 7 - Prob. 13ECh. 7 - Prob. 14ECh. 7 - Prob. 15ECh. 7 - Prob. 16ECh. 7 - Prob. 17ECh. 7 - Prob. 18ECh. 7 - Prob. 19ECh. 7 - Prob. 20ECh. 7 - Prob. 21ECh. 7 - Prob. 22ECh. 7 - Prob. 23ECh. 7 - Prob. 24ECh. 7 - Prob. 25ECh. 7 - Prob. 26ECh. 7 - Prob. 27ECh. 7 - Prob. 28ECh. 7 - Prob. 29ECh. 7 - Prob. 30ECh. 7 - Prob. 31ECh. 7 - Prob. 32ECh. 7 - Prob. 33ECh. 7 - Prob. 34ECh. 7 - Prob. 35ECh. 7 - Prob. 1PSACh. 7 - Prob. 2PSACh. 7 - Prob. 3PSACh. 7 - Prob. 4PSACh. 7 - Prob. 5PSACh. 7 - Prob. 6PSACh. 7 - Prob. 7PSACh. 7 - Prob. 8PSACh. 7 - Prob. 1PSBCh. 7 - Prob. 2PSBCh. 7 - Prob. 3PSBCh. 7 - Prob. 4PSBCh. 7 - Prob. 5PSBCh. 7 - Prob. 6PSBCh. 7 - Prob. 7PSBCh. 7 - Prob. 8PSBCh. 7 - Prob. 7SPCh. 7 - Prob. 1AACh. 7 - Prob. 2AACh. 7 - Prob. 3AACh. 7 - ETHICS CHALLENGE C1 BTN 20-3 Both the budget...Ch. 7 - Prob. 2BTNCh. 7 - Prob. 3BTNCh. 7 - Prob. 4BTNCh. 7 - Prob. 5BTNCh. 7 - Prob. 6BTN
Knowledge Booster
Background pattern image
Accounting
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.
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education