Hello!

This assignemt needs to be done in excel. I cnanot figure it out:( If I could just get a link or an attatchment to the excel workbook that would be great. Thank you!

P22A-45A Preparing a financial budget schedule of cash receipts, schedule cash payments, cash budget Knobbles Company's budget committee provides the following information: December 31, 2015, account balances: Cash 23,000 20,000 Accounts Receivable Merchandise Inventory 20,000 11,500 Accounts Payable 2,850 Salaries and Commissions Payable February Budgeted amounts for 2016: January Sales 80,000 81,600 41,000 Purchases 40,200 4,000 Commissions Expense 4,080 7,000 7,000 Salaries Expense 2,000 2,000 Rent Expense Depreciation Expense 600 600 400 400 Insurance Expense 2,200 2,200 Income Tax Expense