Where would I put purchases including Fittings & Equipment, Goodwill, Capital contributed by owners and Bank Loan after an Acquisition in the budget.

XI 32010_03_Attachment_2 v3 - Excel (Product Activation Failed) FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in Wrap Text General Insert X Delete AY A Paste B I U Merge & Center % .00 Conditional Format as Cell Sort & Find & Formatting Table - Styles - Format- Filter Select - Clipboard Font Alignment Number Styles Cells Editing G38 A B C D E H S 1 Attachment 2 RIVERSIDE COFFEE PTY LIMITED Actual data Jul - Sep Oct - Dec Jan - Mar ! Apr - Jun TOTAL 4 REVENUE Sales - Coffee Shop 166,868 178,235 171,696 i 181,147 697,946 6 Sales - Wholesale Coffee 52,510 64,838 66,042 72,692 256,082 219,378 243,074 237,738 1 253,839 954,028 10 Cost of Sales - Coffee Shop 39,047 41,875 44,348 46,852 172, 122 11 Cost of Sales - Wholesale Coffee 14,414 17.959 20, 138 70,822 53,462 59.834 62,658 66,990 242,944 14 GROSS PROFIT 165,916 183,240 175,079 186.849 711,084 PERSONNEL EXPENSES 17 Cafe - Permanent Staff Wages 18,400 18,400 18,7501 18,750 74,300 18 Cafe - Permanent Staff Super 1,750 1,750 1,800 1,800 7,10 19 Cafe - Casual Staff Wages 37,250 41,650 39,490 37,290 155,680 20 Cafe - Casual Staff Super 2,600 3,380 3,255 3,395 12,630 Other Staff Wage 11, 100 11,800 11,900 12,150 46,95 22 Other Staff Super 1,050 23 72,150 78,100 76,325 74,535 301,110 24 25 OCCUPANCY EXPENSES 26 Rent 7,421 7,755 7,650 7,941 30,768 27 Electricity 10,627 10,103 10,454 i 12,711 43,896 PROFIT & LOSS CASH FLOW READY 79% O Type here to search EM Ei e x ] ENG 7:36 AM 28/11/2018XI 32010_03_Attachment_2 v3 - Excel (Product Activation Failed) FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in Wrap Text General Insert X Delete AY A Paste B I U Merge & Center % .00 Conditional Format as Cell Sort & Find & Formatting Table - Styles - Format- Filter Select - Clipboard Font Alignment Number Styles Cells Editing 538 A B C D F H S 27 Electricity 10,627 10,103 10,454 12,711 43,896 28 Depreciation - Equipment 6,000 8,000 8,000 8,000 30,000 29 Other Overheads 3,485 3,120 2,605 2,785 11,995 30 27,533 28,978 28,709 31,437 116,659 31 32 MARKETING AND EXPENSES 33 Advertising 7,500 7,500 7,500 7,500 30,000 34 Agent's Commission 2,574 2.921 3,269 11,709 35 10,074 10,421 10,769 41,709 37 FINANCIAL EXPENSES 38 Discount Allowed 700 794 801 889 3,185 39 Bad Debts 583 899 741 2,654 40 |Interest Expense 4,200 4,000 3,800 3,600 15,600 4,783 4,662 4,468 4.341 18,254 42 43 TOTAL EXPENSES 114,541 122,161 119,947 121,082 477,732 45 NET PROFIT BEFORE DIRECTOR'S FEES 51,375 61,078 55, 132 1 65,767 233,352 9t 47 DIRECTOR'S FEES 38,000 38.000 35.000 1 40,000 151,000 49 NET PROFIT (LOSS 13,375 23.078 20,132 1 25,767 82,352 50 51 52 53 PROFIT & LOSS CASH FLOW + READY 79% EM O Type here to search Ei e M x ] ENG 7:38 AM 28/11/2018