i need help with numbers snd formulas please!

MASTER Student Name => Section Number => A B 6 Data Section: 7 8 Actual and Budgeted Unit Sales: 9 April 10 May 11 June 12 July 13 August 14 September 15 16 Balance Shoot, May 31, 19X5 17 Cash 18 Accounts receivable 19 Merchandise inventory 20 Fixed assets (net) 21 22 Total assets 23 24 Accounts payable (merchandise) 25 Owner's equity 26 1,500 1,000 1,600 1,400 1,500 1,200 $8,000 107,800 52,800 130,000 ******** $74,800 223,800 D |-| 26 27 Total liabilities & equity 28 29 30 Average selling price 31 Average purchase cost per unit 32 Desired ending inventory 33 (% of next month's unit sales) 34 Collections from customers: 35 Collected in month of sale 36 Collected in month after sale 37 Collected two months after sale 38 Projected cash payments: 39 Variable expenses 40 Fixed expenses (per month) 41 Depreciation per month 42 43 44 Answer Section: 45 46 47 48 49 Units 50 Dollars 51 52 53 Sales Budget Unit Purchases Budget ******** 590 60% 20% 60% 20% 30% of sales $10,000 $1,000 June FORMULA FORMULA July 0 0 August www. Unit Purchases Budget 52 53 54 55 56 Desired ending inventory 57 Current month's unit sales 58 59 Total units needed 60 Beginning inventory 61 62 Purchases (units) 63 64 Purchases (dollars) 65 66 67 68 69 70 71 Cash balance, beginning 72 Cash receipts: 73 Collections from customers: 74 From April sales 75 From May sales 76 From June sales 77 From July sales 78 From August sales MASTER A Cash Budget June FORMULA FORMULA www. FORMULA FORMULA 0 ***** FORMULA 0 0 *************** *** FORMULA $0 $0 ******* ******* June July August $8,000 $42,760 ******** 29,400 58,800 19,600 31,360 94,080 31,360 27,440 82,320 29,400 July August 0 0 ***** 077 From July sales From August sales 178 79 3 80 Total cash available 81 Cash disbursements: 5 82 Merchandise 83 Variable expenses 784 Fixed expenses Interest paid 85 86 U 87 Total disbursements 1 88 2 89 Cash balance before financing 390 Less: Desired ending balance 4 91 5 92 Excess (deficit) of cash over needs 6 93 7 94 Financing 0 95 Borrowing 9 Repayment 96 097 198 Total effects of financing 1299 03 ### Cash balance, ending 14 www 05 ### www Forecasted Income Statement For Questended LOND 27,440 82,320 29,400 ***** ****************** $74,800 FORMULA $0 0 41,160 44,100 P 10,000 0 10,000 0 0 0 $54,800 $41,160 $54,100 ******** $42,760 ##********** 8,000 8,000 8,000 $34,760 ****** ******** $0 $0 0 $0 0 0 ******* ****** $0 $0 $42,760 ####*********** ======== ======== ===== # Forecasted Income Statement For Quarter Ended August 31, 19X5 Sales Cost of goods sold Gross profit Expenses: Variable expenses Depreciation expense Interest expense Total expenses #Fixed expenses # # #Net income = Forecasted Balance Sheet August 31, 19x5 Assets: Cash Accounts receivable Merchandise inventory Fixed assets (net) FORMULA16 FORMULA17 ***** FORMULA18 FORMULA19 FORMULA20 FORMULA21 FORMULA22 $0 $0 FORMULA23 FORMULA24 FORMULA25 FORMULA26 A ### ### ### Forecasted Balance Sheet August 31, 19X5 *** ### Assets: ### Cash ### Accounts receivable ### Merchandise inventory ### Fixed assets (net) *** ### Total assets ### ### Liabilities & equity: ### Accounts payable ### Loans payable ### Owner's equity ### ### Total liabilities & equity ### ### ======= FORMULA23 FORMULA24 FORMULA25 FORMULA26 $0 FORMULA27 0 FORMULA28 $0