Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question
• Fixed-asset outlays: Newmachinery costing PHP130,000 will be purchased and paid
for in
April.
• Interest payments: An interest payment of PHP10,000 is due in May.
• Cash dividend payments: Cash dividends of PHP20,000 will be paid in January.
• Principal payments (loans): A PHP20,000 principal payment is due in February.
• Rent payments: Rent of PHP5,000 will be paid each month.
• Wages and salaries: Fixed salaries for the year are PHP96,000, or PHPS,000 per month.
Wages are estimated as 10% of monthly sales.
• Tax payments: Taxes of PHP25,000 must be paid in April.
Jan
May
Apr
0 102,500 110,000 125,000 140,000 477,500
Feb
Mar
TOTAL
Total Payments for
Purchases
Rent Payments
Wages
Salaries
25,000
125,000
40,000
Таx Рayment
Fixed Asset Outlay
Interest Payment
Cash Dividend
Principal Payment
Total Cash Payments
A Company has a beginning cash balance of PHP80,000 and would like to maintain an
ending cash balance of PHP100,000 per month. Prepare A Company's Cash Budget for
January to May.
25,000
130,000
10,000
20,000
20,000
872,500
Jan
Feb
Mar
Apr
May
TOTAL
Cash Receipts
Less: Cash
Disbursements
Net Cash Flow
Add: Beginning Cash
Ending Cash Balance
Less: Minimum Cash
926,000
(872,500)
53,500
80,000
133,500
(100,000)
Balance
Cumulative excess cash
33,500
balance
(Cumulative required
financing)
expand button
Transcribed Image Text:• Fixed-asset outlays: Newmachinery costing PHP130,000 will be purchased and paid for in April. • Interest payments: An interest payment of PHP10,000 is due in May. • Cash dividend payments: Cash dividends of PHP20,000 will be paid in January. • Principal payments (loans): A PHP20,000 principal payment is due in February. • Rent payments: Rent of PHP5,000 will be paid each month. • Wages and salaries: Fixed salaries for the year are PHP96,000, or PHPS,000 per month. Wages are estimated as 10% of monthly sales. • Tax payments: Taxes of PHP25,000 must be paid in April. Jan May Apr 0 102,500 110,000 125,000 140,000 477,500 Feb Mar TOTAL Total Payments for Purchases Rent Payments Wages Salaries 25,000 125,000 40,000 Таx Рayment Fixed Asset Outlay Interest Payment Cash Dividend Principal Payment Total Cash Payments A Company has a beginning cash balance of PHP80,000 and would like to maintain an ending cash balance of PHP100,000 per month. Prepare A Company's Cash Budget for January to May. 25,000 130,000 10,000 20,000 20,000 872,500 Jan Feb Mar Apr May TOTAL Cash Receipts Less: Cash Disbursements Net Cash Flow Add: Beginning Cash Ending Cash Balance Less: Minimum Cash 926,000 (872,500) 53,500 80,000 133,500 (100,000) Balance Cumulative excess cash 33,500 balance (Cumulative required financing)
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Text book image
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:9781260013962
Author:BREALEY
Publisher:RENT MCG
Text book image
Financial Management: Theory & Practice
Finance
ISBN:9781337909730
Author:Brigham
Publisher:Cengage
Text book image
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education