TO & D E F G =SUM(C22*0.06) B C D 16,000 12,000 14,000 F22 , X v fx A 13 Insurance 14 Audit & Tax Preparation 15 Attorney and Legal Fees 16 Maintenance 17 Street Repair 18 Street Cleaning 19 Snow Removal 20 Property Signage 21 Miscellaneous Total Expenditures 23 Net Income 24 Cash on Hand 25 Reserves 26 Ending Cash Balance 2,700 1,582 550 4,985 3,000 $ 174,817 I $ 10,489 $ 47,583 16,701 23,000 16,701 23,000 $ 87,284 30 Student Name 31 Due: April 30 There is 6% increase in Income and 8% increse in Expenditures in the next Year Budget. Instructions Association Budget + Ready N14 x fix A B C D E F G H For the Association Budget Project (see the Association Budget sheet): I J K * Complete the Next Year budget calculation (2020) based on 6% increase for Income and 8% increase for the Expenditures of 2019. The figures under the 2020 column must be all shown with the same format like in 2019 column. * Make sure to have all formulas where needed. Missing any single formula will cost you points. 7 8