Homework Help is Here – Start Your Trial Now!
Business
Accounting
ales for November and

ales for November and

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

HELP ME ANSWER THIS TY 

Problem 5 (Preparation of Cash Budget) The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for Purple Company are as follows: Month Sales (P) November. 80,000 70,000 Actual (20X3) December Forecast (20X4) January February March 80,000 "100,000 80,000 100,000 90,000 April May The 20% of sales is in cash and the rest is on credit, payment on which is realized on the third month. The following other information are also available. a. Amount of purchase is budgeted at 60% of the sales turnover of a month and paid on the third month of purchase. b. Variable expenses is 5% of turnover – time lag of payment half month. c. Commission on credit sales at 5% is payable on the third month. d.. Rent and other expenses amounting to P3,000 paid every month. c. Payment for purchase of fixed assets amounting to P50,000 on March 20X4. f. Payment for taxes on April 20X4 amounting to P20,000. 8. There will be an opening cash balance of P25,000. Required: a. Prepare a cash budget for five months from January to May 20X4.
Transcribed Image Text:Problem 5 (Preparation of Cash Budget) The sales forecast for January to May 20X4 and actual sales for November and December 20X3 for Purple Company are as follows: Month Sales (P) November. 80,000 70,000 Actual (20X3) December Forecast (20X4) January February March 80,000 "100,000 80,000 100,000 90,000 April May The 20% of sales is in cash and the rest is on credit, payment on which is realized on the third month. The following other information are also available. a. Amount of purchase is budgeted at 60% of the sales turnover of a month and paid on the third month of purchase. b. Variable expenses is 5% of turnover – time lag of payment half month. c. Commission on credit sales at 5% is payable on the third month. d.. Rent and other expenses amounting to P3,000 paid every month. c. Payment for purchase of fixed assets amounting to P50,000 on March 20X4. f. Payment for taxes on April 20X4 amounting to P20,000. 8. There will be an opening cash balance of P25,000. Required: a. Prepare a cash budget for five months from January to May 20X4.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Administration and Procedures
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
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
SEE MORE TEXTBOOKS