Question: Question 1 please in excel format if possible. The firm collects 60% of its sales immediately, 40% one month after the sale. Wages and benefits
The firm collects 60% of its sales immediately, 40% one month after the sale. Wages and benefits paid to clerical personnel are expected to be $7,000 per month while commissions to sales associates are 25% of total cash receipts each month. The sales commissions are paid one month after the cash is actually collected, based on total cash receipts. The two key partners are paid $5,000 per month. Rent expense for their office space is $3,500 per month, and monthly lease expenses for their office equipment is $800. Utilities average $250 per month, except in May and June when they average only $150. The ending cash balance in December 201 was $12,000. The firm is required to maintain a minimum cash balance of $10,000 every month. 1) Create a Cash Budget for January to June 202
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
