Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hiks Hagen a retail store seeks your assistance in preparing a budget for the 2nd quarter of the year. The cash balance for March 30,

Hiks Hagen a retail store seeks your assistance in preparing a budget for the 2nd quarter of the year. The cash balance for March 30, 2021 was P 35,000. Accounts receivable for March was P 80,000 and all accounts were collected 50% for April and another 50% for May. Accounts payable was P 50,000, and all was paid on April. The budget is to be based on the following assumptions:

Sales: Each months sales are collected 50% in the month of sale with 2% discount, 30% on the following month and 18% on the second month following the sale. The 2% prove to be uncollectible.

Purchases: Hiks Hagen takes full advantage of the 2% discount allowed on the 50% of purchases paid on the 15th of the following month. Of the balance 50% are paid on the last day of the month after the discount date, and the balance on the 3rd month after the purchases.

Selling and General expenses for the month are 10% of the purchases for the month, of which

P3,000 is depreciation.

Actual and projected sales are as follows:

January

February

March

April

May

June

Sales

P 420.000

540.000

600.000

350.000

450,000

760.000

Purchases

P 250.000

340.000

400.000

100.000

209.000

430.000

Required: Prepare a cash budget for the second quarter of 2021.

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

Personal Finance An Integrated Planning Approach

Authors: Ralph R Frasca

8th edition

136063039, 978-0136063032

More Books

Students also viewed these Finance questions

Question

Explain the benefits for embracing diversity.

Answered: 1 week ago