Reference no: EM131188731

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.