Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Balance Sheet of Company A on December 31 last year is shown below. The company has received a large order and anticipates the need

The Balance Sheet of Company A on December 31 last year is shown below. The company has received a large order and anticipates the need to go to the bank to increase its borrowings. As a result, it has to forecaset its cash requirements for January, February and March this year. Typically, the company collects 20 per cent of its sales in the month of sale, 70 per cent in the subsequent month, and 10 per cent in the second month after the sale. All sales are credit sales. Cash 50,000 Accounts Payable 360,000 Accounts Receivable 530,000 Notes Payable 400,000 Inventories 545,000 Accrued Expenses 212,000 Current Assets 1,125,000 Current Liabilities 972,000 Long-term Liabilities 450,000 Non-Current Assets 1,836,000 Total Liabilities 1,422,000 Common Stocks 100,000 Retained Earnings 1,439,000 Total Assets 2,961,000 Total Liabilities & Shareholders' Equity 2,961,000

Purchases of raw materials to manufacture the company's products are made in the month prior to the sale and amount to 60 per cent of sales in the subsequent month. Payments for said purchases occur in the month after the purchase. Labor costs, including overtime, are expected to be P150,000 in January, P200,000 in February, and P160,000 in March. Selling, administrative, and other cash expenses are expected to be P100,000 per month for January through March. Actual Sales in November and December last year and projected sales for January through April this year are as follows:

November 500,000 February 1,000,000 December 600,000 March 650,000 January 600,000 April 750,000

Required: 1. Prepare a cash budget for the months of January, February and March taking into consideration that the firm wants to maintain a cash balance of P50,000 at all times. 2. Prepare a projected Income Statement for the months of January, February and March. 3. Prepare a projected Balance Sheet as of March 31.

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

Auditing And Assurance Services An Integrated Approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley

10th Edition

0131457349, 978-0131457348

More Books

Students also viewed these Accounting questions

Question

What are the core functions of the universitys HRM department?

Answered: 1 week ago

Question

Identify a set of competencies for tenured faculty

Answered: 1 week ago