Prepare a master budget for the three-month period ending June 30, include the following detailed budgets: 1.a. A sales budget by month and in total. b. A schedule of expected cash collections from sales, by month and in total.
4. A budget balance sheet as a June 30

Cash budget.

April may june total

sales 20,000 30,000 40,000 90,000

cash coll 17,000 25,500 34,000 76,500
say 85%

net diff 3,000 4,500 6,000 13,500
__________________________________________________ __

simple balance sheet.

Tot assets 120,000 140,000 160,000 420,000

tot liabs 100,000 120,000 140,000 360,000

net assets. 20,000 20,000 20,000 60,000

equity 20,000 20,000 20,000 60,000