GST Cash flow budget

Calculate GST payable based on cash flow statement in Financial Information PDF file.

16/17

The GST amount payable each quarter is the difference between the GST collected from sales and the GST paid format as per policy and procedures.

Calculate the GST for the following

CASH FLOW ANALYSIS GST	2016/17
GST Collected	x,xxx
Less GST Paid	x,xxx
GST Payable	Calculation

Statement of Financial Performance Previous Year Actual Budget ACTIVITY 1 $ $ $ Budget Revised Budget Actual Year 15-16 Year 16-17 Year 16-17 Year 16-17 550,000.00 $ 623,561.00 $ 660,974.66 $ 680,804.00 360,000.00 $ 389,632.00 $ 395,476.48$ 387,567.00 290,000.00 $ 356,986.00 $ 364,125.72 $ 371,408.00 1,200,000.00 $ 1,370,179.00 $ 1,420,576.86 $ 1,439,779.00 $ $ $ $ 458,418.45 $ 254,783.23 $ 375,000.00 $ 235,000.00 $ 610,000.00 $ 590,000.00 $ 436,589.00 $ 248,569.00 $ 685,158.00 685,021.00 481,339.00 270,070.00 751,409.00 688,370.00 $ $ 713201.68 $ 707375.19 $ $ $ $ $ $ 60,000.00 $ 50,000.00 $ 10,000.00 $ 700.00 $ 60,000.00 $ 72,000.00 $ 10,000.00 $ 850.00 $ 62,016.00 69,840.00 10,200.00 876.00 Income Food sales Beverage sales Catering fees Total Income Cost of Sales Food purchases Beverage purchases Total cost of sales Gross Profit Expenses Marketing Depreciation expense Insurance Other Expenses Employment expenses Superannuation Wages and salaries Other employer expenses Total employment expenses Rent Telephone Services Electricity Gas Water Total Expenses Operating Profit Other Expenses Interest Expense Training Total other expenses Net Profit /(Loss) $ $ $ $ $ $ $ $ $ $ $ Year 13-14 Year 14-15 445,280.00 $ 484,000.00 $ 298,080.00 $ 324,000.00 $ 239,888.00 $ 255,200.00 $ 983,248.00 $ 1,063,200.00 $ $ 327,750.00 $ 345,000.00 $ 214,273.00 $ 220,900.00 $ 542,023.00 $ 565,900.00 $ 441,225.00 $ 497,300.00 $ $ 14,400.00 $ 24,000.00 $ 50,000.00 $ 50,000.00 $ 10,000.00 $ 10,000.00 $ 567.00 $ 630.00 $ $ 9,747.00 $ 10,260.00 $ 102,600.00 $ 108,000.00 $ 4,860.00 $ 5,400.00 $ 117,207.00 $ 123,660.00 $ 120,000.00 $ 120,000.00 $ 952.00 $ 1,008.00 $ $ 5,185.69 $ 5,636.62 $ 5,414.40 $ 5,760.00 $ 4,289.00 $ 4,688.00 $ 328,015.09 $ 345,382.62 $ 113,209.91 $ 151,917.38 $ $ 11,856.00 $ 16,800.00 $ 10,869.00 $ 12,475.00 $ 22,725.00 $ 29,275.00 $ 90,484.91 $ 122,642.38 $ 11,400.00 $ 120,000.00 $ 6,000.00 $ 137,400.00 $ 120,000.00 $ 1,200.00 $ 12,975.96 $ 136,589.00 $ 6,423.00 $ 155,987.96 $ 120,000.00 $ 60,800.00 $ 69,840.00 $ 10,200.00 $ 850.00 $ $ 13,433.32 $ 141,403.40 $ 6,423.00 $ 161,259.72 $ 120,000.00 $ 1,345.00 $ $ 6,013.95 $ 6,043.40 $ 4,722.80 $ 441,074.84 $ 266,300.35 $ 13,404.90 141,104.20 6,487.00 160,996.10 120,000.00 1,345.00 1,345.00 $ 6,000.00 $ 6,000.00 $ 4,800.00 $ 396,100.00 $ 193,900.00 $ 5,896.00 $ 5,896.00 $ 4,653.00 $ 435,777.96 $ 249,243.05 $ 6,134.00 6,164.00 4,685.00 442,256.10 246,113.90 $ $ $ $ $ $ $ 24,000.00 $ 14,400.00 $ 38,400.00 $ 155,500.00 $ 26,549.00 $ 18,000.00 $ 44,549.00 S 204,694.05 $ 28,411.54 $ 17,046.92 $ 45,458.46 $ 220,841.89 $ 26,549.00 18,000.00 44,549.00 201,564.90 Statement of Financial Performance Previous Year Actual Budget ACTIVITY 1 $ $ $ Budget Revised Budget Actual Year 15-16 Year 16-17 Year 16-17 Year 16-17 550,000.00 $ 623,561.00 $ 660,974.66 $ 680,804.00 360,000.00 $ 389,632.00 $ 395,476.48$ 387,567.00 290,000.00 $ 356,986.00 $ 364,125.72 $ 371,408.00 1,200,000.00 $ 1,370,179.00 $ 1,420,576.86 $ 1,439,779.00 $ $ $ $ 458,418.45 $ 254,783.23 $ 375,000.00 $ 235,000.00 $ 610,000.00 $ 590,000.00 $ 436,589.00 $ 248,569.00 $ 685,158.00 685,021.00 481,339.00 270,070.00 751,409.00 688,370.00 $ $ 713201.68 $ 707375.19 $ $ $ $ $ $ 60,000.00 $ 50,000.00 $ 10,000.00 $ 700.00 $ 60,000.00 $ 72,000.00 $ 10,000.00 $ 850.00 $ 62,016.00 69,840.00 10,200.00 876.00 Income Food sales Beverage sales Catering fees Total Income Cost of Sales Food purchases Beverage purchases Total cost of sales Gross Profit Expenses Marketing Depreciation expense Insurance Other Expenses Employment expenses Superannuation Wages and salaries Other employer expenses Total employment expenses Rent Telephone Services Electricity Gas Water Total Expenses Operating Profit Other Expenses Interest Expense Training Total other expenses Net Profit /(Loss) $ $ $ $ $ $ $ $ $ $ $ Year 13-14 Year 14-15 445,280.00 $ 484,000.00 $ 298,080.00 $ 324,000.00 $ 239,888.00 $ 255,200.00 $ 983,248.00 $ 1,063,200.00 $ $ 327,750.00 $ 345,000.00 $ 214,273.00 $ 220,900.00 $ 542,023.00 $ 565,900.00 $ 441,225.00 $ 497,300.00 $ $ 14,400.00 $ 24,000.00 $ 50,000.00 $ 50,000.00 $ 10,000.00 $ 10,000.00 $ 567.00 $ 630.00 $ $ 9,747.00 $ 10,260.00 $ 102,600.00 $ 108,000.00 $ 4,860.00 $ 5,400.00 $ 117,207.00 $ 123,660.00 $ 120,000.00 $ 120,000.00 $ 952.00 $ 1,008.00 $ $ 5,185.69 $ 5,636.62 $ 5,414.40 $ 5,760.00 $ 4,289.00 $ 4,688.00 $ 328,015.09 $ 345,382.62 $ 113,209.91 $ 151,917.38 $ $ 11,856.00 $ 16,800.00 $ 10,869.00 $ 12,475.00 $ 22,725.00 $ 29,275.00 $ 90,484.91 $ 122,642.38 $ 11,400.00 $ 120,000.00 $ 6,000.00 $ 137,400.00 $ 120,000.00 $ 1,200.00 $ 12,975.96 $ 136,589.00 $ 6,423.00 $ 155,987.96 $ 120,000.00 $ 60,800.00 $ 69,840.00 $ 10,200.00 $ 850.00 $ $ 13,433.32 $ 141,403.40 $ 6,423.00 $ 161,259.72 $ 120,000.00 $ 1,345.00 $ $ 6,013.95 $ 6,043.40 $ 4,722.80 $ 441,074.84 $ 266,300.35 $ 13,404.90 141,104.20 6,487.00 160,996.10 120,000.00 1,345.00 1,345.00 $ 6,000.00 $ 6,000.00 $ 4,800.00 $ 396,100.00 $ 193,900.00 $ 5,896.00 $ 5,896.00 $ 4,653.00 $ 435,777.96 $ 249,243.05 $ 6,134.00 6,164.00 4,685.00 442,256.10 246,113.90 $ $ $ $ $ $ $ 24,000.00 $ 14,400.00 $ 38,400.00 $ 155,500.00 $ 26,549.00 $ 18,000.00 $ 44,549.00 S 204,694.05 $ 28,411.54 $ 17,046.92 $ 45,458.46 $ 220,841.89 $ 26,549.00 18,000.00 44,549.00 201,564.90