As requested by our teacher, we opened a coffee shop in Thailand, this is our Depreciation and Income Statement.

Depreciation year1: 1,105,720 y2: 316,285 y3: 316,285 y4: 316,285 y5: 316,285

Income Statement

Food Year1: 3,168,000 Year2: 3,484,800 Year3: 3,833,280 Year4: 4,216,608 Year5: 4,638,269

Bevarage Year1: 24,480,000 Year2: 26,928,000 Year3: 29,620,800 Year4: 32,582,880 Year5: 35,841,168

Total Income Year1: 27,648,000 Year2: 30,412,800 Year3: 33,454,080 Year4: 36,799,488 Year5: 40,479,437

Expenses Total Expenses Year1: 18,454,800 Year2: 20,323,800 Year3: 22,062,900 Year4: 23,975,910 Year5: 26,080,221

a) From the above figures, please help me calculate EBITDA, Operating Income, Income Before Tax, Interest Paid, Income Tax, Net Income. b) From the above figures, please help me calculate Cash Flow from Operations, Working Capital, Free Cash Flow. Cash = ((1/12)*The year revenues)+((1/12)*The following year expenses)

And show it in Excel for me, with the formula to calculate it, thanks a lot