00 O B B 00 C D m 11 E E 1,500 1,000 1,600 1,400 1,500 1,200 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 Sheet, May 31, 1985 17 Cash 18 Accounts receivable 2 19 Merchandise inventory 20 Fixed assets (net) 4 21 522 Total assets 6 23 724 Accounts payable (merchandise) 28 25 Owner's equity 26 30 27 Total liabilities & equity 31 28 32 29 33 30 Average selling price 34 31 Average purchase cost per unit 35 32 Desired ending inventory 36 33 (% of next month's unit sales) MASTER $8,000 107,800 52,800 130,000 $74,800 223,800 29 $98 $55 60% Select destination and press ENTER or choose Paste In Copy BIU. A ME Format Painter Clipboard Font Alignment SIGN IN TO OFFICE It looks like your stored credentials are out of date. Please sign in as sptttt**@m fx D 60% 20% 60% 20% 30% of sales $10,000 $1,000 B 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 Sales Budget 46 47 48 49 Units 50 Dollars 1 51 5 52 Unit Purchases Budget 653 -7 54 re 55 59 56 Desired ending inventory 50 57 Current month's unit sales 61 58 62 59 Total units needed 63 60 Beginning inventory June July August FORMULA FORMULA 0 0 0 0 June July August FORMULA FORMULA OO FORMULA FORMULA 0 0 61 65 62 Purchases (units) MASTER FORMULA 0 B E E FORMULA FORMULA 0 0 O o 0 1 1 ! 1 FORMULA 0 0 1 FORMULA $0 $0 == June July August - $8,000 $42,760 #*** 59 Total units needed 60 Beginning inventory 61 62 Purchases (units) 63 64 Purchases (dollars) 65 66 67 Cash Budget 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 1 78 From August sales 2 79 3 80 Total cash available 4 81 Cash disbursements: 5 82 Merchandise 56 83 Variable expenses 37 84 Fixed expenses 38 85 Interest paid 89 86 90 87 Total disbursements 91 88 MASTER 29,400 58,800 31,360 19,600 94,080 27,440 31,360 82,320 29,400 $74,800 FORMULA 0 41,160 10,000 0 0 0 $0 44,100 10,000 0 $84,800 $41,160 $54,100 GE B D E 80 Total cash available 81 Cash disbursements: 82 Merchandise $74,800 FORMULA $0 83 Variable expenses 0 41,160 44,100 84 Fixed expenses 10,000 0 10,000 85 Interest paid 0 0 0 86 87 Total disbursements $84,800 $41,160 $54,100 88 89 Cash balance before financing $42,760 #***** 3 90 Less: Desired ending balance 8,000 8,000 8,000 4 91 5 92 Excess (deficit) of cash over needs $34,760 #*********** 16 93 37 94 Financing 28 95 Borrowing $0 $0 99 96 Repayment 0 0 200 97 101 98 Total effects of financing $0 $0 $0 102 99 103 ### Cash balance, ending $42,760 104 ### 105 106 ### Forecasted Income Statement 107 ### For Quarter Ended August 31, 1935 108 #### 109 ### Sales FORMULA16 110 ### Cost of goods sold FORMULA17 111 ### 112 #### Gross profit FORMULA18 MASTER $0 EU B C D F E FORMULA16 FORMULA17 ## Sales ## Cost of goods sold ## # Gross profit BLOG FORMULA18 ## Expenses: *** Variable expenses ### Fixed expenses ### Depreciation expense ### Interest expense FORMULA19 FORMULA20 FORMULA21 FORMULA22 #*# Total expenses $0 ### Net income $0 Forecasted Balance Sheet August 31, 1935 FORMULA23 FORMULA24 FORMULA25 FORMULA26 $0 ### Assets: Cash #### Accounts receivable 1 ### Merchandise inventory 2 #### Fixed assets (net) 33 #### 4 ### Total assets 35 ### 36 ### Liabilities & equity: 37 ### Accounts payable 3 #### Loans payable MASTER Select destination and press ENTER or choose Paste Type here to search FORMULA27 0 o Forecasted Balance Sheet August 31, 1935 FORMULA23 FORMULA24 FORMULA25 FORMULA26 $0 ### Assets: ### Cash #*#* Accounts receivable 1 ***** Merchandise inventory 2 ### Fixed assets (net) 3 4 ### Total assets 35 ### 16 *** Liabilities & equity: 37 ### Accounts payable 30 ### Loans payable 39 ### Owner's equity 40 41 #### Total liabilities & equity FORMULA27 0 FORMULA28 $0 143 ### 145 146 147 148 Styles Data set #2 Inputs: Data Section: Actual and Budgeted Unit Sales: April May June July August September 1,500 1,000 1,600 1,400 1,500 1,700 Balance Sheet, May 31, 1935 Cash Accounts receivable Merchandise inventory Fixed assets (net) $8,000 107,800 52,800 130,000 Total assets $298,600 Accounts payable (merchandise) Owner's equity $74,800 223,800 Total liabilities & equity $298,600 $100 $55 Average selling price Average purchase cost per unit Desired ending inventory (% of next month's unit sales) Collections from customers: Collected in month of sale Collected in month after sale Collected to months after sale 60% 30% 60% ly Styles Paragraph August September 1,500 1,700 Balance Sheet, May 31, 1935 Cash Accounts receivable Merchandise inventory Fixed assets (net) $8,000 107,800 52,800 130,000 Total assets $298,600 Accounts payable (merchandise) Owner's equity $74,800 223,800 Total liabilities & equity $298,600 $100 $55 6096 Average selling price Average purchase cost per unit Desired ending inventory (% of next month's unit sales) Collections from customers: Collected in month of sale Collected in month after sale Collected two months after sale Projected cash payments: Variable expenses Fixed expenses (per month) Depreciation per month Check figure (Total liabilities & equity): $369,878 30% 60% 10% 25% of sales $10,000 $1,000 BI