Unit 4 Touchstone Template Maher

xlsx

School

University of the People *

*We aren’t endorsed by this school

Course

4356

Subject

Economics

Date

Nov 24, 2024

Type

xlsx

Pages

6

Uploaded by DeaconFireBee26

Report
ECON1010 Taking Charge of Your Economic Future Name: Maher Alajaj Unit 4 Touchstone Template Date: 1-Sep-22 MONTH 1 BUDGET MONTH 2 BUD Amount Percent Income $4,167 100% Income Expenditure Expenditure Housing $750 18% Housing Food $333 8% Food Transportation $417 10% Transportation Education $333 8% Education Utilities $292 7% Utilities Taxes $250 6% Taxes Health Care $334 8% Health Care Family Care $375 9% Family Care Miscellaneous $167 4% Miscellaneous Savings $917 22% Savings Total $4,167 100% Total PART 1: ANALYZING YOUR PERSONAL FINANCES SCENARIO: Your monthly budget is going through some changes over the next three months. The g has increased because of your strong performance at work. However, health care and miscellaneou will need to reallocate your monthly budget based on these changes. The changes are represented b MONTHLY BUDGET tables above, located inside the shaded cells. STEP 1: Enter the previous values you obtained from the Unit 2 Touchstone into the MONTH 1 BUD be sure to divide each dollar amount by 12 . Remember, the Unit 2 Touchstone was an annual bas monthly basis. If you no longer have the previous values, create new ones. Remember to start by en the MONTH 1 BUDGET balances. STEP 2: Now create your MONTH 2 BUDGET and your MONTH 3 BUDGET above. Do not change Health Care in the second month or Miscellaneous in the third month. Do not modify the income in e your monthly income must equal your monthly expenditures (including savings). Look ahead to step formulas for proper balancing.
STEP 3: Your MONTH 2 BUDGET and your MONTH 3 BUDGET may or may not be balanced. To ch Enter a formula to calculate your total expenditures. Adjust your expenditures until the total equals Next, enter formulas in the percent column to calculate each expenditure as a percentage of the to STEP 4: Using the tools in Excel, make a graph for each of the three budgets to show your spending chart, column chart, bar chart, or some other graph type. Review the tutorial in Unit 1 called Data Vis refresher on graphing. If your embedded graphs block your view, move them off the work area, eithe STEP 5: Fill in the table for SAVINGS PROGRESS located at the top right of this spreadsheet: Enter your monthly savings from steps 1-4. The cumulative savings column will calculate automati Recall your total savings goal from the Unit 2 Touchstone. In the last column, record how much mo order to reach your goal. If you can't recall your savings goal, create a new one so you're able to complete the table. STEP 6: Using the tools in Excel, make a graph that shows your incremental progress toward your s in the SAVINGS PROGRESS table: Select a graph type that best illustrates your progress. Move the graph off the work area if it obstru Finally, using steps 1-6 as a reference, complete the REFLECTION QUESTIONS on the right side Sophia Learning, LLC. Copyright © 2021. All rights reserved.
DGET MONTH 3 BUDGET Amount Percent Amount Percent $4,250 100% Income $4,334 100% Expenditure $750 18% Housing $750 17% $200 5% Food $250 6% $375 9% Transportation $300 7% $333 8% Education $333 8% $290 7% Utilities $250 6% $250 6% Taxes $260 6% $734 17% Health Care $734 17% $241 6% Family Care $280 6% $160 4% Miscellaneous $260 6% $917 22% Savings $917 21% $4,250 100% Total $4,334 100% PAR good news is that your income us costs have also gone up. You by embedded formulas in the QUESTION 1: In step 4 and step 6, you created se graphs. Explain the reasons for the graph types tha selected. How will the graphs you created help read understand the financial data? DGET. Important : Before you do, sis while this Touchstone is a ntering your income and be sure QUESTION 2: Explain the results of your financial a steps 1-6 in terms of the following: Overall progress toward your savings goals Changes you might make to the budget to improv progress in the coming months Economic or life impacts that may affect your bud future the predetermined costs for either month. Remember that 3 to see how you can use QUESTION 3: Assume that your income continues but consumer prices also rise due to inflation. Deter economic factors like these might affect your financ analysis one year from now: A. What economic trends might you need to accou when making a one-year projection? B. How might you plan for unexpected expenses w making a one-year projection?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
heck, do the following: s your monthly income. otal expenditure. g allocation. You may use a pie sualization if you need a er downward or to the right. ically. ore money you need to save in savings goal based on the data ucts your view. e of this spreadsheet. MONTH 1 BUDGET Income Expenditure Expenditure Housing Expenditure Food Expenditure Transportation Expenditure Education Expenditure Utilities Expenditure Taxes Expenditure Health Care Expenditure Family Care Expenditure Miscellaneous Expenditure Savings Expenditure Total Incom Expe Expe Expe Expe Expe Expe
SAVINGS PROGRESS Monthly Savings Cumulative Savings $ to Reach Goal Month 1 $917 $917 $21,083 Month 2 $1,834 $2,751 $19,249 Month 3 $2,751 $5,502 $16,498 Note: RT 2: REFLECTION QUESTIONS To increase the height of a row , hover over the bottom border of that row in the far left margin until your cursor becomes and up-down arrow. Then click and drag the bottom border to the desired row height. If you make an error, you can use the shortcut Ctrl + Z to undo it. everal at you ders I decided to include the pie chart. This style of graph presents data using a circular graph. The "pie" is a representation of the entire sum, whereas the "slices" are pieces of it. Pie charts will help you rapidly understand the portion sizes of your food. The way it graphically depicts data as a part of a whole may be helpful to even the least experienced readers. analysis in ve dget in the I intend to save $917 per month and to do so not only every month but also for the next two years. Some changes have appeared in months two and three in health care and miscellaneous. That's why I need to cut back on spending on food, utilities, transportation, and family care in order to balance my budget. Food and health are two aspects of my life that may have an effect on my budget in the future because my mother has cancer, which has an expensive treatment regimen, and when it comes to food, I would say that the costs are rising daily and that they may have an impact on my spending. to grow, rmine how cial unt for when A. The price level depreciates money and other financial assets over a period, decreasing their true value. I consider this bad news for me because the increase in prices will make it difficult for me to adhere to my plan. Meanwhile, by lowering borrowing costs, inflationary measures increase the likelihood of unemployment and loss. My study of the financial statements will be significantly impacted by inflation because higher monthly spending budgets will result from it. B. Following the plan is what I consider to be most vital, and to do so, I should make lots of effort to save more money and set it aside for any potential emergencies. I'll do all in my power to avoid getting
MONTH 3 BUDGET Income Expenditure Expenditure Housing Expenditure Food Expenditure Transportation Expenditure Education Expenditure Utilities Expenditure Taxes Expenditure Health Care Expenditure Family Care Expenditure Miscellaneous Expenditure Savings Expenditure Total MONTH 2 BUDGET me Expenditure enditure Housing Expenditure Food enditure Transportation Expenditure Education enditure Utilities Expenditure Taxes enditure Health Care Expenditure Family Care enditure Miscellaneous Expenditure Savings enditure Total
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help