Guided solutions for financial analysis with mIcrosoft excel 6th edition for Chapter 3 P3

Camp and fevurly financial Planners have forecasted revenues for the first six months of 2012, as shown in the following table. The firm 60% of its sales immediately, 39% one month after the sale. and 1% are written off as bad debts two months after the sale. The firm assumes that wages and benefit paid to clerical personnel will be $ 7000 per month while commissions to sales associates average 25% of collectable sales, Each of the two partners is paid $ 5000 per month or 20% of net sales, whichever is greater, commissions and partner salaries are paid one month after the revenue is earned. Camp and fevurly financial Planners have forecasted revenues for the first six months of 2012, as shown in the following table. The firm 60% of its sales immediately, 39% one month after the sale. and 1% are written off as bad debts two months after the sale. The firm assumes that wages and benefit paid to clerical personnel will be $ 7000 per month while commissions to sales associates average 25% of collectable sales, Each of the two partners is paid $ 5000 per month or 20% of net sales, whichever is greater, commissions and partner salaries are paid one month after the revenue is earned