Summarize changes in expenditures between budgets

Reference no: EM133479119

CASE SCENARIO: Three months have passed since you created your first financial plan (i.e., the Unit 2 Touchstone). In that time, your budget has gone through some changes. The good news is that your income has increased because of your strong performance at work. However, health care and miscellaneous costs have gone up along with your earnings. You will need to reallocate your monthly budget based on these changes to see how you're progressing toward your original savings goal.While you appreciate numbers and figures, you also know that a strong financial analysis needs visual information. As part of your progress check, you've committed to creating a set of graphs that you can share with your financial advisor.: This work has two parts. In part 1, you will analyze personal finance data based on the scenario described above. You'll use your problem solving and agility skills to balance three monthly budgets, and you'll use your technology skill to graph the spending allocations in each of them. Finally, you'll sharpen all three skills as you calculate and graph the progress you're making toward your original savings goal.In part 2, you will answer reflection questions about the decisions you made, identify how to create more savings opportunities, and make predictions about life and economic impacts that could affect the future of your plan.For this , you will:

Question 1: Create three monthly budgets and perform a personal financial analysis using Microsoft Excel.

Question 2: Summarize changes in expenditures between budgets.

Question 3: Show the results of the analysis using appropriate graphs in Excel.

Question 4: Explain how the graph types you have selected will help your financial advisor understand the data.

Question 5: Discuss the results of the financial analysis including savings achievements, future budget modifications, and life impacts that could derail the budget in the coming year.

Question 6: Reflect on what the analysis might reasonably look like in one year, accounting for economic factors such as inflation and the consumer price index.

Reference no: EM133479119

Questions Cloud

Discuss three key factors you believe have contributed : Based on your knowledge of "Abc Unified school district" of higher education, identify and discuss three key factors you believe have contributed

Discuss policies that provide access to education or help : discuss policies that have been put in place to help those students who choose to pursue vocational or trade-specific education after high school.

How creating a step-by-step and organized approach : Create a budget for a financial plan using Microsoft Excel, ensuring that the information is organized, accurate, and complete.

Write a short form piece you can still keep the principles : When writing a short form piece, you can still keep the principles of long form writing in mind. Long form writing usually tells a story.

Summarize changes in expenditures between budgets : Create three monthly budgets and perform a personal financial analysis using Microsoft Excel. - Summarize changes in expenditures between budgets.

Discuss the need for high availability and redundancy : Recommend a configuration for shared storage; make sure to discuss the need for high availability and redundancy for virtualization for the organization.

Additional support from criminal justice system : Discuss after taking this class, do you believe that correctional officers need additional support from the criminal justice system.

Hypothetical-what laws could sofia be protected by : Sofia Garcia, 46 year old from Puerto Rico, has relocated to Florida hurricane Maria. What laws could Sofia be protected by / What risks does AtWill have?

Examine the soviet position in the opening phases : What were the Soviet intentions with Germany and Eastern Europe - Why did they act so aggressively? What were the Soviet intentions with Germany

User Account

All Pages