Could you assist me in interpreting the instructions

32010_03_Attachment_2 v3 - Excel (Product Activation Failed) X Sign in Info Print New Copies: Open Print Save Attachment 2 RIVERSIDE COFFEE PTY LIMITED Southbank Acquisition Sav Printer Jul - Sep Oct - Dec Jan - Mar Apr - Jun TOTAL Print EPSON5DA940 (WorkForce 5... REVENUE Error: 2 documents waiting Sales- Coffee Shop 130,000 131,950 133,929 135,938 531,817 Share Printer Properties Sales- Wholesale Coffee 52,510 4,838 66,042 72,692 256,082 182,510 196,788 199,971 208,630 787,899 Export Settings Print Entire Workbook COST OF SALES Close Print the entire workbook Cost of Sales - Coffee Shop 39,047 41,875 44,348 46,852 172,122 Pages: Cost of Sales - Wholesale Coffee 14,414 17,959 18,311 20,138 70,822 53,462 59,834 62,658 66,990 242,944 Account Collated 1,2,3 1,2,3 1,2,3 GROSS PROFIT 129,0 136,955 137,313 141,640 544,955 Options Landscape Orientation PERSONNEL EXPENSES A4 210 x 297 mm Cafe - Permanent Staff Wages 18,400 18,400 18,750 18,750 74,300 21 cm x 29.7 cm Cafe - Permanent Staff Super 1,750 1,750 1,800 1,800 7,100 Normal Margins Cafe - Casual Staff Wages 37,250 41,650 39,490 37,290 155,680 Left: 1.78 cm Right: 1.78 cm Cafe - Casual Staff Super 2,600 3,380 3,255 3,395 12,630 No Scaling Other Staff Wages 11, 100 11,800 11,900 12.150 46,950 100 Print sheets at their actual size Other Staff Super 1,050 1,120 1.130 .150 Page Setup 72,150 78,100 76,325 74,535 301,110 OCCUPANCY EXPENSES Rent 12,000 12,000 12,000 12,000 48,000 Electricity 7,000 7,140 7,283 7,428 28,851 of 4 O Type here to search e x ] EM ENG 9:21 AM 4/12/201832010_03_Attachment_2 v3 - Excel (Product Activation Failed) X Sign in Info Print New Copies: Open Print Save Depreciation - Equipment 5,000 5,000 5,000 5,000 20,000 2,000 2,000 2,000 Printer Other Overheads 8,000 Sav 26,000 26,140 26,283 26,428 104,851 Print EPSON5DA940 (WorkForce 5... Error: 2 documents waiting MARKETING AND EXPENSES Share Printer Properties Advertising 2,500 2,500 2,500 2,500 10,000 Agent's Commission 2,574 2,921 2,945 3,269 11,709 Export Settings 5,074 5,421 5,445 5,769 21,709 Print Entire Workbook Close Print the entire workbook FINANCIAL EXPENSES Pages: Discount Allowed 794 801 889 3,185 741 2,654 Account Collated Bad Debts 583 1,2,3 1,2,3 1,2,3 Interest Expense 5,000 5,000 5.000 5,000 20,000 5,583 5,662 5.668 5,741 22,654 Options Landscape Orientation TOTAL EXPENSES 108,807 115,323 113,721 112,473 450,324 A4 210 x 297 mm 21 cm x 29.7 cm NET PROFIT BEFORE DIRECTOR'S FEES 20,241 21,632 23,592 29,166 94,631 Normal Margins Left: 1.78 cm Right: 1.78 cm DIRECTOR'S FEES 7,500 7,500 7,500 7,500 30,000 No Scaling 100 Print sheets at their actual size NET PROFIT (LOSS) 12,741 14,132 16,092 21,666 64,631 Page Setup of 4 O Type here to search EH e M x ] EM ENG 9:22 AM 4/12/201832010_03_Attachment_2 v3 - Excel (Product Activation Failed) X Sign in Info Print New Copies: Open Print Save Attachment 2 Sav Printer RIVERSIDE COFFEE PTY LIMITED Southbank Acquisition Print EPSON5DA940 (WorkForce 5... Jul - Sep Oct - Dec Jan - Mar Apr - Jun TOTAL Error: 2 documents waiting CASH RECEIPTS Share Printer Properties Cash Sales - Coffee Shop 160,450 171,380 163,520 174,180 669,530 Collections from Debtors - Wholesale Coffee 59,420 62,100 67,950 71.505 260,975 Export Settings Print Entire Workbook 219,870 233,480 231,470 245,685 930,505 Close Print the entire workbook Pages: CASH PAYMENTS Collated Payments to Creditors - Coffee Shop Purchases 46,980 48,750 47,250 50,890 193,870 Account 1,2,3 1,2,3 1,2,3 Payments to Creditors - Wholesale supplies 21,650 23,300 24,120 25,800 94,870 Options Salaries and Wages 2,600 3,380 3,255 3,395 12,630 Landscape Orientation Superannuation 1,050 1,120 1,130 1,150 4,450 A4 210 x 297 mm Rent 11,918 12, 132 12,180 12,309 48,538 21 cm x 29.7 cm Electricity 7,000 7,14 7,28 8,851 Normal Margins Other Overheads 2,000 2,000 2,000 2,000 8,0 Left: 1.78 cm Right: 1.78 cm Advertising 2,500 2,500 10,000 No Scaling 100 Agent's Commission 2,921 Print sheets at their actual size 11,709 15,000 15,000 60,000 Page Setup Loan Interest and Repayments 15,000 15,000 Directors Fees 7,500 7,500 7,500 7,500 30,000 120,772 125,743 125,163 131,242 502,919 of 4 O Type here to search e EM EH M x ] ENG 9:22 AM 4/12/201832010_03_Attachment_2 v3 - Excel (Product Activation Failed) X Sign in Info Print New Copies: Open Print Save NET IN CREASE IN CASH HELD 99,098 107,737 106,307 114,443 427,586 Sav Printer CASH HELD - OPEN ING BALANCE 11,800 110,898 218,636 324,943 11,800 Print EPSON5DA940 (WorkForce 5... Error: 2 documents waiting CASH HELD - CLOSING BALANCE 110,898 218,636 324,943 439,386 439,386 Share Printer Properties Export Settings Print Entire Workbook Close Print the entire workbook Pages: Account Collated 1,2,3 1,2,3 1,2,3 Options Landscape Orientation A4 210 x 297 mm 21 cm x 29.7 cm Normal Margins Left: 1.78 cm Right: 1.78 cm No Scaling 100 Print sheets at their actual size Page Setup of 4 EM O Type here to search EH e M x ] ENG 9:22 AM 4/12/201832010_03_Attachment 5 [Compatibility Mode] - Word (Product Activation Failed) X Sign in Info Print New Copies: Open Print Save Save As Printer Attachment 5 Prir EPSON5DA940 (WorkForce 5... Error: 2 documents waiting RIVERSIDE COFFEE PTY LIMITED Share Printer Properties ACQUISITION OF SOUTHBANK STORE Export Settings PURCHASE Print All Pages Close The whole thing The store is available for purchase at a cost of $650,000 and is based on: Pages: Fittings & Equipment $200,000 (to be depreciated at 10% per annum straight line) Account Print One Sided Goodwill $450,000 Only print on one side of th... The consideration amount will be funded as follows Options Collated ,2,3 1,2,3 1,2,3 Capital contributed by owners $350,000 Landscape Orientation Bank Loan $250,000 (secured over company assets, interest only at 8% per annum) * A4 210 x 297 mm Payment from operating account (opening cash balance) $ 50,000 Note: an overdraft facility of $75,000 can be obtained, if required. 21 cm x 29.7 cm Normal Margins REVENUE & RECEIPTS Left: 2.54 cm Right: 2.54 cm Coffee Shop Sales-the shop is expected to generate sales of $130,000 in the first quarter of operation increasing by 1.5% each quarter; * 1 Page Per Sheet EXPENSES & PAYMENTS Page Setup Coffee Shop Cost of Sales - the gross margin is expected to be 65% throughout the year as the company keeps prices constant with those charged by the vendors;Vendors are paid using the same settlement basis as for the current coffee shop of 2 83% + 0. O Type here to search e x ] ENG 9:23 AM 4/12/201832010_03_Attachment 5 [Compatibility Mode] - Word (Product Activation Failed) X Sign in Info Print New Copies: Open Print Save Save As Printer Personnel costs are expected to be $12,500 in each quarter; Rent will be charged at a flat rate of $3,000 per calendar month; Prir EPSON5DA940 (WorkForce 5... Error: 2 documents waiting Electricity is expected to incur a cost of $7,000 in the first quarter, rising by 2% of the previous quarter. * Share Printer Properties Depreciation - is to be calculated on fittings and equipment purchased at 10% per annum straight line, as above; Other overheads are expected to incur a cost of $2,000 per quarter; ~ Export Settings Print All Pages Advertising is to be budgeted at only $2,500 per quarter as the majority of promotion will be combined with the existing store; * Close The whole thing Initial rebranding and fitout is expected to incur a once off cost of $15,000 to be written off as an Occupancy expense in the first quarter. Pages: Directors Fees - the directors will require $7,500 per quarter to provide their additional services. * Account Print One Sided Only print on one side of th... Options Collated ,2,3 1,2,3 1,2,3 Landscape Orientation A4 210 x 297 mm 21 cm x 29.7 cm Normal Margins Left: 2.54 cm Right: 2.54 cm 1 Page Per Sheet Page Setup of 2 83% + 0 O Type here to search EH e M x ] ENG 9:23 AM 4/12/2018