- 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.–
Don't use plagiarized sources. Get Your Custom Essay on
Economics Assignment
Just from $13/Page
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 focusing on how the digital forensics from the phone was utilized in the case.
Competent 11.9 (17.00%) points
Satisfactorily 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.
Exemplary 14 (20.00%) points
Thoroughly 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.
Describe Brothers’ steps for forensic analysis of mobile devices.–
Levels of Achievement:
Unacceptable 0 (0.00%) points
Did not submit or describe Brothers’ steps for forensic analysis of mobile devices.
Needs Improvement 9.1 (13.00%) points
Insufficiently described Brothers’ steps for forensic analysis of mobile devices.
Satisfactory 10.5 (15.00%) points
Partially described Brothers’ steps for forensic analysis of mobile devices.
Competent 11.9 (17.00%) points
Satisfactorily described Brothers’ steps for forensic analysis of mobile devices.
Exemplary 14 (20.00%) points
Thoroughly described Brothers’ steps for forensic analysis of mobile devices.
Include four references.–
Levels of Achievement:
Unacceptable 0 (0.00%) points
No references provided.
Needs Improvement 2.275 (3.25%) points
Does not meet the required number of references; all references poor-quality choices.
Satisfactory 2.625 (3.75%) points
Does not meet the required number of references; some references poor-quality choices.
Competent 2.975 (4.25%) points
Meets number of required references; all references high-quality choices.
Exemplary 3.5 (5.00%) points
Exceeds number of required references; all references high-quality choices.
Clarity, writing mechanics, and formatting requirements.–
Levels of Achievement:
Unacceptable 0 (0.00%) points
More than eight errors present.
Needs Improvement 4.55 (6.50%) points
7–8 errors present.
Satisfactory 5.25 (7.50%) points
5–6 errors present.
Competent 5.95 (8.50%) points
3–4 errors present.
Exemplary 7 (10.00%) points
0–2 errors present.
ECO
1
10
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.]
1
Assignment 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.
|
| Place graphics here |
