E S US = AutoSave OFF Insert Draw MISS View Home Page Layout Formulas Data Review = ab = Calibri (Body) Blue 11 A A 2 Av Paste F22 xvfx F G H 16,000 12,000 14,000 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 22 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 $ 47,583 16,701 23,000 16,701 23,000 $ 87,284 Student Name Due: April 30 There is 6% increase in Income and 8% increse in Expenditures in the next Year Budget. Instructions Association Budget + Ready Arial AutoSave OFF S U MIS 303 Excel Projec Home Insert Draw Page Layout Formulas Data Review View Tell me 10 A A == = ab General 3 Paste BI U E VA ou say $ v % 9, N14 x v fx A B C D E F G H I J K For the Association Budget Project (see the Association Budget sheet): * Complete the Next Year budget calculation (2020) based on 6% increase for Income and 8% increase for the Expenditures of 2019. 7 * 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. * Add your full name on the lower left side of the spreadsheet as shown on in cell A30. * Upload your Excel file into Bb for grading by the next session (April 30). E S US = AutoSave OFF Insert Draw MISS View Home Page Layout Formulas Data Review = ab = Calibri (Body) Blue 11 A A 2 Av Paste F22 xvfx F G H 16,000 12,000 14,000 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 22 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 $ 47,583 16,701 23,000 16,701 23,000 $ 87,284 Student Name Due: April 30 There is 6% increase in Income and 8% increse in Expenditures in the next Year Budget. Instructions Association Budget + Ready Arial AutoSave OFF S U MIS 303 Excel Projec Home Insert Draw Page Layout Formulas Data Review View Tell me 10 A A == = ab General 3 Paste BI U E VA ou say $ v % 9, N14 x v fx A B C D E F G H I J K For the Association Budget Project (see the Association Budget sheet): * Complete the Next Year budget calculation (2020) based on 6% increase for Income and 8% increase for the Expenditures of 2019. 7 * 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. * Add your full name on the lower left side of the spreadsheet as shown on in cell A30. * Upload your Excel file into Bb for grading by the next session (April 30)
