Fly by Night

Option A Yr 10 ($) Yr 11($) Yr 12 ($) Yr 13 ($) Yr 14 ($) Yr 15 ($) Yr 16 ($) Yr 17 ($) Yr 18 ($) Yr 19 ($) Yr 20 ($) Yr 21 ($) Yr 22 ($) Yr 23 ($) Yr 24 ($)
Cost of planes 0.00 0.00 80,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Revenue 150,000,000.00 157,500,000.00 165,375,000.00 185,220,000.00 194,481,000.00 204,205,050.00 214,415,302.50 225,136,067.63 236,392,871.01 248,212,514.56 260,623,140.28 273,654,297.30 287,337,012.16 301,703,862.77 316,789,055.91 Less operating exp 132,140,000.00 138,754,000.00 144,469,740.00 155,822,627.00 162,881,016.15 171,030,884.57 178,851,101.06 187,801,097.03 196,461,659.76 206,294,288.39 215,881,896.83 226,688,271.74 237,298,685.96 249,179,459.37 260,918,483.62
Operating cash flow before tax 17,860,000.00 18,746,000.00 20,905,260.00 29,397,373.00 31,599,983.85 33,174,165.43 35,564,201.44 37,334,970.60 39,931,211.25 41,918,226.16 44,741,243.46 46,966,025.56 50,038,326.20 52,524,403.40 55,870,572.29
Less depreciation 3,000,000.00 3,000,000.00 3,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00
Taxable income 14,860,000.00 15,746,000.00 17,905,260.00 25,397,373.00 27,599,983.85 29,174,165.43 31,564,201.44 33,334,970.60 35,931,211.25 37,918,226.16 40,741,243.46 42,966,025.56 46,038,326.20 48,524,403.40 51,870,572.29 Tax payable at 50% 7,430,000.00 7,873,000.00 8,952,630.00 12,698,686.50 13,799,991.93 14,587,082.71 15,782,100.72 16,667,485.30 17,965,605.62 18,959,113.08 20,370,621.73 21,483,012.78 23,019,163.10 24,262,201.70 25,935,286.15

Operating cash flow after tax 10,430,000.00 10,873,000.00 11,952,630.00 16,698,686.50 17,799,991.93 18,587,082.71 19,782,100.72 20,667,485.30 21,965,605.62 22,959,113.08 24,370,621.73 25,483,012.78 27,019,163.10 28,262,201.70