Could I have some help getting it started on this one please.

B C D E F G G H K L M N 0 P Q 2020 2021 15,000 $100,000 $10,000 $3 100 10 500 $20,000 2000 2000 $20,000 $400,000 $400,000 $500,000 2022 15,100 $103,000 $10,200 $3 100 500 $20,000 2000 $20,000 $400,000 $410,000 $510,000 2023 15,200 $106,000 $10,400 $4 100 100 500 $20,000 20,00 2000 2000 $20,000 $400,000 $420,000 $520,000 2024 15,300 $109,000 $10,600 $4 100 500 $20,000 2000 2000 $20.000 $400,000 $430,000 $530,000 2025 15,400 $112,000 $10,800 $4 100 500 $20,000 . 2000 $20,000 $400,000 $440,000 $540,000 2026 15.500 $115,000 $11,000 $4 100 10 500 $20.000 2000 $20.000 $500,000 $450,000 $550,000 2027 15,600 $118,000 $11,200 $5 100 500 $20,000 -0.00 2000 2009 $20.000 $500,000 $460,000 $560,000 2028 15,700 $121,000 $11,400 $5 100 500 $20.000 2000 $20,000 $500,000 $470,000 $570,000 2029 15,800 $124,000 $11,600 $5 100 500 $20.000 20,00 2000 $20,000 $500,000 $480,000 $580,000 2030 15,900 $127,000 $11,800 $5 100 500 $20.000 20,00 2000 $20.000 $500.000 $490,000 $590,000 2031 16,000 $130,000 $12,000 $6 100 500 $20,000 w 2000 $20,000 $500,000 $500,000 $600,000 2032 16.000 $133,000 $12,200 $6 100 500 $20,000 2000 $20,000 $600,000 $510,000 $610,000 2033 16,000 $136,000 $12,400 $6 100 500 $20,000 $20,000 2000 $20,000 $600,000 $520,000 $620,000 2034 16,000 $139,000 $12,600 $6 100 500 $20,000 2000 $20,000 $600,000 $530,000 $630,000 2035 16,000 $142,000 $12,800 $7 100 500 $20,000 2000 $20.000 $600,000 $540,000 $640,000 2 M N N 3% 12 3,000 $55 2020 2 3 3 CONSTANTS 4. Number of full time students 5 Cost of assistant basketball coach 6 Luxury box rental fee 7 Concession income per fan 8 Expected volleyball and gymnastics attendance 9 Pro basketball attendance per game enesen 10 Pro basketball rental . 11 Women's football attendance per game 12 Women's football rental 12 mens 100 13 Naming rights revenue 14 Expected miscellaneous income 15 Expected utilities and maintenance cost 16 - 17 INPUTS 18 Basketball Recruiting Effort (1=Same, 2=More, 3=Max) . 19 Added Student Fee (L=Low, M=Medium, O=Outrageous) * 20 Do the Women's Football League? (Y/N) 21 Expected bond interest rate (annual) ) 22 Number of concerts in year 23 Average concert attendance 24 Average concert ticket price 25 26 CALCULATIONS 27 Construction bond payments in year 28 Number of assistant basketball coaches 29 Cost of assistant basketball coaches 30 Other added basketball program cost 31 Potential change in basketball wins 32 Expected number of basketball wins 33 Increase in season tickets sold 34 Number of basketball season tickets sold 35 Cost of season basketball ticket 36 Season ticket revenue 37 Added student fee 38 Student fee revenue w 39 Walkup basketball tickets sold 40 Cost of walkup ticket 41 Walkup ticket revenue 42 Luxury boxes rented 43 Luxury Box Tevenue 44 Luxury box expense 45 College basketball concession income 46 Volleyball and gymnastics concession income 47 Pro basketball concession income 48 Women's football concession income 49 Concert revenue 50 Concert organizer fee 51 Advertising revenue 13 500 $200 2021 $4,972,188 4 $400,000 $250,000 1 14 50 550 $204 $224,400 $20 $300,000 750 $16 $312,000 2 $20,000 $11,000 1,0 $101,400 $101,400 $7,800 $30,000 www. $0 $1,980,000 $780,000 $252,000 2022 $4,972,188 4 $412,000 $250,000 1 1 15 100 650 $208 $270,400 $20 $302,000 900 $17 $397,800 4 $40,800 $17,000 $130,975 130,12 $8,450 $32,500 $0 su $1,980,000 $780,000 $252,000 2023 $4,972,188 4 $424,000 $250,000 1 16 150 800 $212 $339,200 $20 $304,000 1,100 $18 $514,800 6 $62,400 $23,000 $172.900 $112,90 $9,100 $35,000 sou $0 $1.980,000 $780,000 $252,000 2024 $4,972,188 4 $436,000 $250,000 1 17 200 1,000 $216 $432,000 $20 $306,000 1,350 $19 $666,900 8 8 $84.800 $29,000 $ $229,125 $9,750 $ $37,500 $0 $1,980,000 $780,000 $252,000 2025 $4,972,188 4 $448,000 $250,000 1 18 250 1,250 $220 $550,000 $20 $308,000 1,650 $20 $858,000 10 $108,000 $35,000 5,000 $301,600 301,600 $10,400 $40,000 $0 $1,980,000 $780,000 $252,000 2026 $4,972,188 4 $460,000 $250,000 1 19 300 1,550 $224 $694,400 $20 $310,000 2,000 $21 $1,092,000 12 12 $132,000 24,00 $41,000 $392,275 $11.050 1,050 $42.500 $0 $1,980,000 $780,000 $252,000 2027 $4,972,188 4 $472,000 $250,000 1 20 350 1,900 $228 $866,400 $20 $312,000 2,400 $22 $1,372,800 14 $156,800 156,800 $47,000 $503,100 $11,700 $ $45,000 $0 $1,980,000 $780,000 $252,000 2028 $4,972,188 4 $484,000 $250,000 1 21 400 2,300 $233 $1,071,800 $20 $314,000 2,500 $23 $1,495,000 10 16 $182,400 $53,000 $592,800 224,00 $12.350 12,334 $47,500 $0 su $1,980,000 $780,000 $252,000 2029 $4,972,188 4 4 $496,000 $250,000 1 22 450 2,500 $238 $1,190,000 $20 $316,000 2,500 $24 $1,560,000 17 $197,200 $56,000 $650,000 SO50,000 $13,000 $ $50,000 0, $0 $1.980,000 $780,000 $252,000 2030 $4,972,188 4 $508,000 $250,000 1 23 500 2,500 $243 $1,215,000 $20 $318,000 2,500 $25 $1,625,000 17 $200,600 $56.000 30,00 $682,500 004,500 $13,650 2031 $4,972,188 4 $520,000 $250,000 1 24 550 2,500 $248 $1,240,000 $20 $320,000 2,500 $25 $1,625,000 17 $204,000 $56,000 $715,000 $14,300 119,00 $55,000 $0 $1,980,000 $780,000 $252,000 2032 $4,972,188 4 $532,000 $250,000 1 25 600 2,500 $253 $1,265,000 $20 $320,000 2,500 $25 $1,625,000 17 $207,400 $207,400 $56,000 $747,500 $14,950 $57,500 $0 $1,980,000 $780,000 $252,000 2033 $4,972,188 4 $544,000 $250,000 1 25 650 2,500 $258 $1,290,000 $20 $320,000 2,500 $25 $1,625,000 17 $210,800 $56,000 $780,000 $15,600 $15,000 $60,000 300,000 $0 $1,980,000 $780,000 $252,000 2034 $4,972,188 4 $556,000 $250,000 1 1 25 650 2,500 $263 $1,315,000 $20 $320,000 2,500 $25 $1,625,000 17 $214,200 $56,000 $50,000 $812,500 2012,500 $16.250 $10,250 $62,500 304,500 $0 $1,980,000 $780,000 $252,000 2035 $4,972,188 4 $568,000 $250,000 1 1 25 650 2,500 $268 $1,340,000 $20 $320,000 2,500 $25 $1,625,000 17 $217,600 $56,000 $845,000 $16.900 $10,900 $65,000 $0 $1.980,000 $780,000 $252,000 650 $15 $52,50 $0 $1,980,000 $780,000 $252,000 D56 B R S S T T U V $312,000 2 $20,000 $11,000 $ $101,400 $7,800 $30,000 $0 $1,980,000 $780,000 $252,000 D $397,800 4 $40,800 $17,000 $130,975 BACO $8,450 $32,500 $0 $1,980,000 non $780,000 $252,000 E $514,800 6 6 $62,400 $23,000 $172,900 $9,100 0100 *** $35,000 $0 $1,980,000 $780,000 $252,000 $ F $666,900 8 $84,800 $29,000 $229,125 $9,750 $37,500 Canon $0 $1,980,000 $780,000 $252,000 G $858,000 10 $108,000 $35,000 $301,600 $10,400 $40,000 $0 $1,980,000 $780,000 $252,000 H $1,092,000 12 $132,000 $41,000 $392,275 $11,050 1 $1,372,800 14 $156,800 $47,000 $503,100 $11.700 $45,000 $0 $1,980,000 $780,000 $252,000 $1,495,000 16 $182,400 $53,000 $592,800 $12,350 $47,500 $0 non $1,980,000 $780,000 $252,000 K $1,560,000 17 $197,200 $56,000 $650,000 $13,000 $50,000 $0 $1,980,000 $780,000 $252,000 $1,625,000 17 $200,600 $56,000 $682,500 $13,650 $52,500 $0 $1,980,000 $780,000 $252,000 M $1,625,000 17 $204,000 $56,000 $715,000 $14,300 $55,000 $0 $1,980,000 $780,000 $252,000 N $1,625,000 17 $207,400 $56,000 $747,500 $14.950 ce $57,500 $0 $1,980,000 $780,000 $252,000 0 $1,625,000 17 $210,800 $56,000 $780,000 $15,600 $60,000 $0 $1,980,000 $780,000 $252,000 P $1,625,000 17 $214,200 $56,000 $812.500 $16,250 $62,500 $0 non $1,980,000 $780,000 $252,000 Q $1,625,000 17 $217,600 $56,000 $845,000 $16,900 $65,000 $0 $1,980,000 $780,000 $252,000 $42 $0 $1,980,000 $780,000 $252,000 $ 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 O 41 Walkup ticket revenue 42 Luxury boxes rented 43 Luxury box revenue 44 Luxury box expense 45 College basketball concession income 46 Volleyball and gymnastics concession income 47 Pro basketball concession income Mattha 48 Women's football concession income 49 Concert revenue 50 Concert organizer fee 51 Advertising revenue 52 53 CASH FLOW STATEMENT 54 Revenue: 55 Men's and women's basketball 56 Concessions 57 Student fee uue 58 Luxury boxes 59 Concerts 60 Advertising 61 Pro basketball rental an 62 Women's football rental 63 . Naming rights 64 Miscellaneous income 65 Total revenue 66 Costs and expenses: 67 Utilities and maintenance 68 co Added basketball coaches 69 Other added basketball cost 70 70 Luxury box expense 71 22 Concert organizer fee 72 Total costs and expenses 73 Arena net income (operating activities) 74 75 Arena net income (or loss) after bond payment 76 Accumulated 15-year net income (or loss) after bond -- 77 78 79 80 81 82 83 84 85 86 ARENA CONSTRICTION DECISION KERRII hal IN CALON 1 www 03-11 IT- we w W H VA 2 IN M !} - 1 2 a ! 4 !!!!! a - } 4 u 1 1 1 20 BES!! - a FE