Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 5-B.FINANCIAL BUDGET Wally Merchandising is located in a small town in Cebu province. Data regarding the store's operations follow: Sales are budgeted at P260,000

image text in transcribed

image text in transcribedimage text in transcribed
Problem 5-B.FINANCIAL BUDGET Wally Merchandising is located in a small town in Cebu province. Data regarding the store's operations follow: Sales are budgeted at P260,000 for November, P230,000 for December, and P210,000 for January.Collections are expected to be 55% in the month of sale, 40% in the month following the sale, and 5% uncollectible. The cost of goods sold is 80% of sales. . The company purchases 50% of its merchandise in the month prior to the month of sale and 50% in the month of sale. Payment for merchandise is made in the month following the purchase. . Other monthly expenses to be paid in cash are P21,700. . Monthly depreciation is P17,000. . Ignore taxes. . Additional data as of October 31, 2020 is as follows Assets: Cash P28,000 Accounts Receivable (net of allowance) 78,000 Inventory 104,000 Equipment (net of P640,000, depreciation) 1,132,000 Liabilities and Equity Accounts Payable P200,000 Common Stock 800,000 Retained Earnings 342,000 Requirement: Prepare the following Operating and Financial budget and the necessary supporting schedule: 1. Cash Collection - November and December 2. Cash Payments - November and December 3. Ending Inventory Budget - November and December 4. Income Statement Budget - November and December 5. Cash Budget - November and December 6. Budgeted Balance Sheet - December

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Practical Approach

Authors: Jeffrey Slater, Mike Deschamps

14th Edition

0134729315, 978-0134729312

More Books

Students also viewed these Accounting questions

Question

Describe ERP and how it can create efficiency within a business

Answered: 1 week ago

Question

Wear as little as possible

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago