AM is a trading entity. Purchases are on credit, with 70% paid in the month following the date of purchase and 30% paid in the month after that. Sales are partly on credit and partly for cash. Customers who receive credit are given 30 days to pay. On average 60% pay within30 days, 30% pay between 30 and 60 days and 5% pay between 60 and 90 days. The balance is written off as irrecoverable. Other overheads, including salaries, are paid within the month incurred. AM plan to purchase new equipment at the end of June 2015, the expected cost of which is P250,000. The equipment will be purchases on 30 days credit, payable at the end of July. The cash balance on 1 May 2015 is P96,000. The actual/budgeted figures for the six month to July 2015 were: actual budgeted FEB P000 MAR P000 APRIL P000 MAY P000 JUNE P000 JULY P000 credit sales 100 100 110 110 120 120 cash sales 30 30 30 35 40 40 credit purchases 45 50 50 55 55 60 other overhead expenses 40 40 40 40 50 50 Required: a. Prepare a monthly cash budget for the period May to July 2015. b. Assess the likelihood of AM being able to pay for the equipment when it falls due.
AM is a trading entity. Purchases are on credit, with 70% paid in the month following the date of purchase and 30% paid in the month after that. Sales are partly on credit and partly for cash. Customers who receive credit are given 30 days to pay. On average 60% pay within30 days, 30% pay between 30 and 60 days and 5% pay between 60 and 90 days. The balance is written off as irrecoverable. Other overheads, including salaries, are paid within the month incurred. AM plan to purchase new equipment at the end of June 2015, the expected cost of which is P250,000. The equipment will be purchases on 30 days credit, payable at the end of July. The cash balance on 1 May 2015 is P96,000. The actual/budgeted figures for the six month to July 2015 were: actual budgeted FEB P000 MAR P000 APRIL P000 MAY P000 JUNE P000 JULY P000 credit sales 100 100 110 110 120 120 cash sales 30 30 30 35 40 40 credit purchases 45 50 50 55 55 60 other overhead expenses 40 40 40 40 50 50 Required: a. Prepare a monthly cash budget for the period May to July 2015. b. Assess the likelihood of AM being able to pay for the equipment when it falls due.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
AM is a trading entity. Purchases are on credit, with 70% paid in the month following the date of
purchase and 30% paid in the month after that.
Sales are partly on credit and partly for cash. Customers who receive credit are given 30 days to
pay. On average 60% pay within30 days, 30% pay between 30 and 60 days and 5% pay between
60 and 90 days. The balance is written off as irrecoverable. Other
are paid within the month incurred.
AM plan to purchase new equipment at the end of June 2015, the expected cost of which is
P250,000. The equipment will be purchases on 30 days credit, payable at the end of July.
The cash balance on 1 May 2015 is P96,000.
The actual/budgeted figures for the six month to July 2015 were:
| actual | budgeted | |||||
| FEB P000 | MAR P000 | APRIL P000 | MAY P000 | JUNE P000 | JULY P000 | |
| credit sales | 100 | 100 | 110 | 110 | 120 | 120 |
| cash sales | 30 | 30 | 30 | 35 | 40 | 40 |
| credit purchases | 45 | 50 | 50 | 55 | 55 | 60 |
| other overhead expenses | 40 | 40 | 40 | 40 | 50 | 50 |
Required:
a. Prepare a monthly
b. Assess the likelihood of AM being able to pay for the equipment when it falls due.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
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
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education