I need help with this assignment, please.

The CEO, (Your assessor) has asked you to prepare some projected financial budgets for the 2017/2018 financial year as a preliminary overview of the financial year ahead. He asked you to first prepare a 12 months budget and then break it up over the four quarters. The areas he is particularly interested in seeing is: 1. Forecasted sales budget for 2017/2018 by year and quarter. (Statement of Financial Performance Aka Profit & Lossreport) 2. Forecasted Statement of Financial Position Accrual Balance Sheet for Year2017/2018 3. A cash flow budget. The cash flow result per quarter of the GST after adjusting the GST collected by the allowable GST tax credits. (GSTPaid) 4. The anticipated aged debtor's summary report - yearly and at the end of each quarter. The CEO has provided you with access to the previous year's financial data toanalyse. Using this data as well as the business plan summary you are required to prepare a budget for the year and then a quarterly budget. You will need to follow the same format as the previous year's financial reports. Statement of Financial Performance (Profit & Loss Report) -Cucina a Isola Hotel For 12 months ended 2013 2013/14 2014/15 2015/16 2016/17 2017/2018 Revenue Sales Sales 12,474,336 13,472,315 14,550,100 15,714,108 Cost of Goods Sold 6,860,901 7,409,773 8,002,555 8,799,900 Gross Profit 5,613,465 6,062,542 6,547,545 6,914,208 Expenses Accounting Fees 5,500 6,500 8,500 9,000 Interest Expense 45,000 65,000 96,508 90,508 Bank Charges 1,200 1,300 1,580 1,600 Depreciation 170,000 170,000 170,000 170,000 Insurance 12,500 12,500 12,500 12,875 Advertising 50,000 100,000 280,000 280,000 Cleaning 12,560 15,652 18,700 19,261 40,250 52,600 60,000 61,800 Repair /Maintenance Rent 2,465,000 2,465,000 2,465,000 2,538,950 Telephone 9,862 12,523 14,000 14,420 Electricity Expense 22,500 23,658 25,000 25,750 Luxury Car Tax 12,400 Fringe Benefits Tax 26,000 26,000 26,000 28,000 Superannuation 148,500 160,737 166,500 171,495 Wages & Salaries 1,649,998 1,785,965 1,850,000 1,905,500 Payroll Tax 78,375 84,833 87,875 90,511 33,000 Workers' Compensation 35,719 37,000 38,110 Total Expenses 4,770,245 5,017,987 5,331,563 5,457,780 843,220 1,044,554 1,215,982 1,456,428 Net Profit (Before Company Tax) Company/Income 252,966 313,366 364,795 436,928 Tax Net Profit after tax 590,254 731,188 851,188 1,019,499 Statement of Financial Position/ Balance Sheet Cucina a Isola Hotel Statement of Financial Position As at 30 June 2015/16 2016/17 2017/2018 Assets Current Assets Cash on Hand 50,000 55,000 Cheque Account 144,842 160,314 Deposits Paid 950,000 950,000 Trade Debtors 850,000 975,000 Merchandise Inventory 1,530,000 1,430,000 Total Current Assets Fixed Assets Motor Vehicles at Cost 500,000 500,000 Motor Vehicles Accum Dep (100,000) (125,000) Furniture & Fixtures at Cost 2,250,000 1,950,000 (650,000) Furniture & Fixtures Accum Dep (770,000) Office Equip at Cost 400,000 400,000 Office Equip Accum Dep (115,000) (90,000) 2,010,000 Total Fixed Assets 2,140,000 Total Assets 5,534,842 5,710,314