At the end of the current month, Gipit company expects to have a cash balance of 25,000.For the next three months, it expects to generate sales as follows:

April88,000

May95,000

June74,000

The company sells its goods on cash basis only.Aside from its income from the sale of goods, the company also earns rental income of 20,000 per month from the commercial spaces that it lets to a number of tenants.

Gipit's operating expenses amount to 40% of its gross revenue.All expenses are paid in the month they are incurred.Non-cash expenses such as depreciation and amortization amount to 30,000 per month.

1. Required:Prepare Gipit Company's cash budget for the quarter ended June 30, with details shown for each month.

2.