Lawn Master Company, a manufacturer of riding lawn mowers, has a projected income for 2013 as follows: Sales $ 46,000,000.00 Operating Expenses:...

$ 1,100,000.00

1. What is the the total of budgeted cash collections For December?

2. How much is the book value of accounts receivable at the end of December?

3. How much is the income (loss) before income taxes for December?

4. What is the projected balance in inventory on December 31st, 2013?

5. What are budgeted purchases for December?

6. What is the projected balance in accounts payable on December 31st, 2013?

This must be completed on excel spreadsheet and breakdown of answer shown.