Include formulas
Q 8 0 Thu Apr 13 8:09 PM Format Tools Data Window Help AutoSave OFF AH ? ? . C ... 3... Q AutoSave O OFF A 9 9 9 . C ... 2... AutoSave OFF MAP ? . C ... ... Q go Home Insert Draw > Tell me Comments S Home Insert Draw >> Tell me Comments Share Home Insert Draw >> Tell me Comments Share F16 4 X V fx C9 4 X V fx C9 + X V fx D E C D E B C D E submissions in .numbers format will receive a 0. 47 Answer Section: 98 95 Borrowing SO SO WN 48 Sales Budget 4 JASTER Student Name => 99 96 Repayment 49 Section Number => 50 June August 100 97 July SC SO 51 101 98 Total effects of financing B C D E 52 102 99 Units FORMULA C 103 100 Cash balance, ending $42,760 $142,720 $231,700 53 Dollars FORMULA 6 Data Section: 54 104 101 10 7 55 Unit Purchases Budget 105 102 11 8 Actual and Budgeted Unit Sales: 56 106 103 Forecasted Income Statement 12 9 April 1,500 57 107 104 For Quarter Ended August 31, 19X5 June July August 13 10 May 1,000 58 108 105 14 11 June 1,600 59 Desired ending inventory FORMULA3 109 106 Sales FORMULA16 15 12 July 1,400 60 Current month's unit sales FORMULA 110 107 Cost of goods sold FORMULA17 O 111 108 16 13 August 1,500 61 112 109 Gross profit FORMULA18 17 14 September 1,200 62 Total units needed FORMULAS 0 18 15 63 Beginning inventory FORMULA 113 110 19 16 Balance Sheet, May 31, 19X5 64 114 111 Expenses: FORMULA19 20 17 Cash $8,000 Variable expenses 65 Purchases (units) FORMULA7 115 112 21 18 Accounts receivable 107,800 66 116 113 Fixed expenses FORMULA20 FORMULA21 22 19 Merchandise inventory 52,800 67 Purchases (dollars) FORMULAS SO So 117 114 Depreciation expense FORMULA22 23 20 Fixed assets (net) 130,000 68 118 115 Interest expense 4 21 69 119 116 25 22 Total assets $298,600 70 Cash Budget 120 117 Total expenses $0 5 23 71 121 118 27 24 72 $0 Accounts payable (merchandise) $74,800 June July August 122 119 Net income 28 25 Owner's equity 223,800 73 123 120 29 26 74 Cash balance, beginning $8,000 $42,760 $142,720 124 121 30 27 Total liabilities & equity $298,600 75 Cash receipts: 125 122 Forecasted Balance Sheet 31 28 76 Collections from customers: 126 123 August 31, 19X5 32 29 77 From April sales 29,400 127 124 33 30 Average selling price $98 78 From May sales 58,800 19,60 128 125 Assets 34 31 Average purchase cost per unit $55 79 From June sales 31,360 94,080 31,360 129 126 Cash FORMULA23 35 32 Desired ending inventory 80 From July sales 27,440 82,320 130 127 Accounts receivable FORMULA24 36 33 (% of next month's unit sales) 60% 81 From August sales 29,400 131 128 Merchandise inventory FORMULA25 37 34 Collections from customers 82 132 129 Fixed assets (net) FORMULA26 38 35 Collected in month of sale 20% 83 Total cash available $127,560 $183,880 $285,800 133 130 39 36 Collected in month after sale 60% 84 Cash disbursements: 134 131 Total assets SO 40 37 Collected two months after sale 20% 85 Merchandise $74,800 FORMULAS SO 135 132 41 38 Projected cash payments: 86 Variable expenses 0 41,160 44,100 136 133 Liabilities & equity. 42 39 Variable expenses 30% of sales 87 Fixed expenses 10,000 10,000 137 134 Accounts payable FORMULA27 43 40 Fixed expenses (per month) $10,000 88 Interest paid 138 135 Loans payable 44 41 Depreciation per month $1,000 89 139 136 Owner's equity FORMULA28 45 42 90 Total disbursements $84,800 $41,160 $54,100 140 137 46 43 91 141 138 Total liabilities & equity $0 47 44 Answer Section: 2 Cash balance before financing $42,760 $142,720 $231,700 142 139 48 45 Sales Budget 93 Less: Desired ending balance 8,000 8,000 8,000 143 140 49 46 94 144 50 47 June July August 95 Excess (deficit) of cash over needs $34,760 $134,720 $223,700 145 51 48 96 146 4 MASTER + MASTER + MASTER + Ready + 101 Ready + 100% Ready 100% MacBook Pr
