CBUS 206 Management Information Systems Assignment2 - Working with EXCEL Riverdale Property Management, Inc. is a small property management business in Atlanta, GA, consisting of four duplex units, three rent houses, and three commercial buildings. To satisfactorily complete this case, students should will prepare a standard cash flow templet (Figure 1) that summarizes each rental property's income and expenses, a summary worksheet that summarizes the business's income and expenses from all the rental properties, and external cell references, use the AVERAGE, MAX, MIN, and SUM Functions, Apply appropriate cell and worksheet formatting, and generate two charts: (Pie - Figure2 and Column - Figure 3). Innome and Eunanes hur Darnarter After you complete the worksheet with above data, you should answer the questions. For each worksheet, you should change worksheet name Sheet Name Sheet 1 Summery Sheet 2 Income comparisen chart Sheet 30 verall Unit Expense Comparison Sheet 4 Answers for Questions 1. Report date is Now() Function 2. Over cash flow = RENT Total Expenses by property 3. Operating Income for each property = Total revenue - Total Expense YOU MUST USE FOMULA TO FIND THE ASNWER ON WORKSHEET. YOU WILL GET "0" FOR NO FORMUAL File Naming convention - name your file firstinitiallastname_assign2. For example: jyoo_assign2. (If you do not follow instruction, there is penalty) Submitting file - Your completed file should be uploaded to the assignment page in the CANVAS. If you submit your assignment to jkyoo a cau.edu, I will not accept your assignment. Remember to click the submit button after you have attached the file. Question. Q1. What was the rental income from all units 2017? Q2. On average, how much was spent in each expense category 2017 ? Q3. What are total revenues by property type? Q4. What are total expense by property type? Figure 1 . \begin{tabular}{lll} \hline \end{tabular} Figure 2. Figure 3. Overalduez fuserve Cowcated that litititian tits a the CBUS 206 Management Information Systems Assignment2 - Working with EXCEL Riverdale Property Management, Inc. is a small property management business in Atlanta, GA, consisting of four duplex units, three rent houses, and three commercial buildings. To satisfactorily complete this case, students should will prepare a standard cash flow templet (Figure 1) that summarizes each rental property's income and expenses, a summary worksheet that summarizes the business's income and expenses from all the rental properties, and external cell references, use the AVERAGE, MAX, MIN, and SUM Functions, Apply appropriate cell and worksheet formatting, and generate two charts: (Pie - Figure2 and Column - Figure 3). Innome and Eunanes hur Darnarter After you complete the worksheet with above data, you should answer the questions. For each worksheet, you should change worksheet name Sheet Name Sheet 1 Summery Sheet 2 Income comparisen chart Sheet 30 verall Unit Expense Comparison Sheet 4 Answers for Questions 1. Report date is Now() Function 2. Over cash flow = RENT Total Expenses by property 3. Operating Income for each property = Total revenue - Total Expense YOU MUST USE FOMULA TO FIND THE ASNWER ON WORKSHEET. YOU WILL GET "0" FOR NO FORMUAL File Naming convention - name your file firstinitiallastname_assign2. For example: jyoo_assign2. (If you do not follow instruction, there is penalty) Submitting file - Your completed file should be uploaded to the assignment page in the CANVAS. If you submit your assignment to jkyoo a cau.edu, I will not accept your assignment. Remember to click the submit button after you have attached the file. Question. Q1. What was the rental income from all units 2017? Q2. On average, how much was spent in each expense category 2017 ? Q3. What are total revenues by property type? Q4. What are total expense by property type? Figure 1 . \begin{tabular}{lll} \hline \end{tabular} Figure 2. Figure 3. Overalduez fuserve Cowcated that litititian tits a the