Fluent Essays

Create three monthly budgets using Excel for a      financial analysis. Summarize the change in expenditures between budgets. Show the findings of your personal financial analysis      using appropriate graphs/charts in Excel. Explain how the chosen graphs/charts help someone to      better understand the presented financial data better than other potential      graphs/charts. Discuss the results of financial analysis including      overall progress towards saving goals, potential changes in budget that      can be made in the future, possible economic/life impacts that may affect      their budget in the coming year. Reflect on what your financial analysis might      reasonably look like in a year taking into account income growth and      inflation of consumer prices.Explain how the process of digital evidence is similar to the process of traditional crime scene evidence.-- Levels of Achievement: Unacceptable 0 (0.00\%) points Did not submit or explain how the process of digital evidence is similar to the process of traditional crime scene evidence. Needs Improvement 9.1 (13.00\%) points Insufficiently explained how the process of digital evidence is similar to the process of traditional crime scene evidence. Satisfactory 10.5 (15.00\%) points Partially explained how the process of digital evidence is similar to the process of traditional crime scene evidence. Competent 11.9 (17.00\%) points Satisfactorily explained how the process of digital evidence is similar to the process of traditional crime scene evidence. Exemplary 14 (20.00\%) points Thoroughly explained how the process of digital evidence is similar to the process of traditional crime scene evidence. Identify some of the best sources of digital evidence for child abuse and exploitation, domestic violence, and gambling according to the National Institute of Justice.-- Levels of Achievement: Unacceptable 0 (0.00\%) points Did not submit or identify some of the best sources of digital evidence for child abuse and exploitation, domestic violence, and gambling according to the National Institute of Justice. Needs Improvement 11.375 (16.25\%) points Insufficiently identified some of the best sources of digital evidence for child abuse and exploitation, domestic violence, and gambling according to the National Institute of Justice. Satisfactory 13.125 (18.75\%) points Partially identified some of the best sources of digital evidence for child abuse and exploitation, domestic violence, and gambling according to the National Institute of Justice. Competent 14.875 (21.25\%) points Satisfactorily identified some of the best sources of digital evidence for child abuse and exploitation, domestic violence, and gambling according to the National Institute of Justice. Exemplary 17.5 (25.00\%) points Thoroughly identified some of the best sources of digital evidence for child abuse and exploitation, domestic violence, and gambling according to the National Institute of Justice. Summarize a criminal case in which a smartphone was a critical component in obtaining a conviction focusing on how the digital forensics from the phone was utilized in the case.-- Levels of Achievement: Unacceptable 0 (0.00\%) points Did not submit or summarize a criminal case in which a smartphone was a critical component in obtaining a conviction focusing on how the digital forensics from the phone was utilized in the case. Needs Improvement 9.1 (13.00\%) points Insufficiently summarized a criminal case in which a smartphone was a critical component in obtaining a conviction focusing on how the digital forensics from the phone was utilized in the case. Satisfactory 10.5 (15.00\%) points Partially summarized a criminal case in which a smartphone was a critical component in obtaining a conviction focECO110 Assignment 3 Financial Analysis Explanation Word Template While writing responses to the prompts below, you may need to refer back to the budgets and graphs you created in the Assignment 3 Financial Analysis Graphs Excel Template. Make sure you have completed your budget before completing this portion of the assignment. Questions 1. Explain why you chose these particular graphs or charts. How do the graphs or charts you created help someone understand the financial data? [Write your response to Question 1 here.] 2. Discuss the results of your financial analysis, including overall progress toward savings goals, potential changes in your budget that can be made in the future, and possible economic or life impacts that may affect your budget in the coming year. [Write your response to Question 2 here.] 3. Reflect on what your financial analysis might reasonably look like in a year, taking into account income growth and inflation of consumer prices. a. What economic trends might you want try to account for when making your projection? b. How could you try to plan for unexpected expenses when making your projection? [Write your response to Question 3 here.] 1Assignment 3 Assignment 3 Financial Analysis Graphs Excel Template Month 1 Budget Month 2 Budget Month 3 Budget Financial Goal Savings Progress Dollars Percent Dollars Percent Dollars Percent Savings Overall Savings Amount Remaining to Save Income - Income $ - 0 - Income $ - 0 - Month 1 0 Expenditures Expenditures Expenditures Month 2 0 Housing Housing Housing Month 3 0 Food Food Food Transportation Transportation Transportation Education Education Education Utilities Utilities Utilities Taxes Taxes Taxes Health Care Health Care $ 400 Health Care Family Care Family Care Family Care Miscellaneous Miscellaneous Miscellaneous $ 100 Savings Savings Savings Total Total Total Assignment 3 Excel Instructions: In this assignment, you will make three monthly budgets. Your income increases each month using embedded formulas, as shown in the tables above. Additionally, in Months 2 and 3, some cells have been filled in with a formula to represent an unexpected expense in that expenditure category for the month. You will need to reallocate your budget around these expenses. 1. Fill in the Month 1 Budget based on your annual budget from Assignment 2. Remember that Assignment 2 was looking at your annual budget. So, to get the number for your monthly budget, you will need to divide by 12. 2. Notice that your income for Month 2 and Month 3 have been auto-calculated. Use these income numbers to plan your budgets in these months. Also, as noted in the instructions, notice that your “Health Care” costs for Month 2 and your “Miscellaneous” costs for Month 3 have auto-calculated. Do not change these numbers. You will need to plan around them. 3. For Month 2 and Month 3, fill in the cells for each category for how you are choosing to allocate your income in each of those months. 4. Use formulas to calculate the sum for your total in the “Dollars” columns, and fill in the “Percent” columns for each monthly budget. 5. Now produce a graphic for each of these three budgets to show the spending allocation. You could use a pie chart, bar chart, or other graphic from Excel. You will end up with three graphics, one for each month. Each graphic should show how you have allocated your income among the various categories. 6. Complete the Financial Goal Savings Progress table by entering in the “Savings” amount from each of your three monthly budgets. Use a formula to calculate how much you have left to save using the dollar amount of your chosen savings goal from Assignment 2. 7. Create a graphic that shows your progress toward your savings goal based on the information you input into the Financial Goal Savings Progress table. Select the type of graphic that you think would best illustrate your progress. 8. Put the graphics in the space below on this spreadsheet. Pla