A cash budget, by quarters, is given below for a retail company. (000 omitted). The company requires a minimum cash balance of P5,000 to start each quarter. Quarter 1 4 Year Cashbalance,beginning.. P9 P ? P ? P? P? Add collectionsfromcustomers.... ? ? 125 ? 391 Totalcash available.. 85 ? ? ? ? Less disbursements: Purchaseofinventory. 40 58 ? 32 ? Operatingexpenses.. ? 42 54 ? 180 Equipmentpurchases... 10 8 8 ? 36 Dividends... 2 2 2 Totaldisbursement. ? 110 ? ? Excess (deficiency) of cash available Ordisbursements... (3) 30 ? ? Financing: Borrowings... 20 ? Repayments (including interest)*.. (?) Total financing... ? ? (?) Cash balance, ending.. P ? Р? Р? P ? P ? *Interest will total P4, 000 for the year.

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
Exercise 7 (Cash Budget Analysis)
A cash budget, by quarters, is given below for a retail company. (000 omitted).
The company requires a minimum cash balance of P5,000 to start each quarter.
Quarter
1
2
3
4
Year
Cashbalance,beginning..
P9
P ?
P ?
P?
P?
Add collectionsfromcustomers....
?
?
125
?
391
Totalcash available...
85
?
?
Less disbursements:
Purchaseofinventory.
40
58
?
32
Operatingexpenses.
42
54
?
180
Equipmentpurchases..
10
8
8
36
Dividends...
2
2
2
2
?
Totaldisbursement..
110
?
?
?
Excess (deficiency) of cash available
Ordisbursements....
(3)
30
?
?
Financing:
Borrowings..
?
20
Repayments (including interest)*..
(?)
(7)
(?)
Total financing...
?
?
(?)
(?)
Cash balance, ending....
P ?
P ?
P ?
P ?
P?
*Interest will total P4, 000 for the year.
Required:
Fill in the missing amounts in the table above.
Transcribed Image Text:Exercise 7 (Cash Budget Analysis) A cash budget, by quarters, is given below for a retail company. (000 omitted). The company requires a minimum cash balance of P5,000 to start each quarter. Quarter 1 2 3 4 Year Cashbalance,beginning.. P9 P ? P ? P? P? Add collectionsfromcustomers.... ? ? 125 ? 391 Totalcash available... 85 ? ? Less disbursements: Purchaseofinventory. 40 58 ? 32 Operatingexpenses. 42 54 ? 180 Equipmentpurchases.. 10 8 8 36 Dividends... 2 2 2 2 ? Totaldisbursement.. 110 ? ? ? Excess (deficiency) of cash available Ordisbursements.... (3) 30 ? ? Financing: Borrowings.. ? 20 Repayments (including interest)*.. (?) (7) (?) Total financing... ? ? (?) (?) Cash balance, ending.... P ? P ? P ? P ? P? *Interest will total P4, 000 for the year. Required: Fill in the missing amounts in the table above.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

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