Reference no: EM132198535

Case Study

To be completed on Excel

Requirement #1

Given the following information for Jawa Corp. prepare a full cash budget for the months of April, May, and June.

Feb Mar Apr May June July

Sales in Units 10,000 12,000 15,100 16,250 16,675 16,000

All units are sold at a price of $24.75, with a per unit cost of $13.50. Sales are collected as follows: 60% month of sale, 30% month after sale and remainder 2nd month after sale. Purchases of materials, which account for 50% of the product cost(remainder of the product cost is Factory worker wages) are paid for 75% month of purchase and 25% month after purchase. Materials are purchased a month in advance.

In addition the following are paid monthly: Building Lease $21,750, Office salaries $10,500, Management Salaries $20,000, Trash removal $1,500, Utilities based on a rate of 20 cents per unit, Payroll taxes at the rate of 7.65% (paid on all wages), Equipment maintenance based on a rate of 35 cents per unit.

The company will also be making the following payments: May Insurance payment for the months of May-July $15,000, In April Income tax deposit of $30,000, the company will declare a quarterly dividend in May to be paid June 15th of $25,000, Employee first aid training at a cost of $2,500 is planned for July.

Depreciation is $21,265 per month based on straight line and Income taxes are based on an average effective tax rate of 11.50%.

At the start of April the company had a cash balance of $35,450.

Requirement #2

Based on the previous information prepare a traditional income statement (in proper format) for the month of June.

Requirement #3

The company likes to maintain a cash balance of $30,000 at all times. They are considering purchasing new machinery at the beginning of July at a cost of $175,000. Do they have a sufficient amount of cash on hand to make this purchase or would they need to make arrangements for any financing?

Requirement #4

Given that the company has the following dividend policy:

Dividends are paid quarterly based on the annual rate of $2.00 per share.

How many shares of stock are currently outstanding?