Week 09 Application Activity Part 1: Open and download needed files Open your Expense Tracker Excel file

Subject:WritingPrice:9.98 Bought3

Share With

Week 09 Application Activity

Part 1: Open and download needed files

1. Open your Expense Tracker Excel file. This is the document you downloaded in Week 04 to track your expenses the past several weeks. You will only use this sheet as a reference to complete your budget.
2. Download the Budget Template Excel file. You will not turn in your actual budget but use it to honesty answer the questions at the end of this document.

 

Part 2: Enter Income Sources and Budget Categories

1. On the budget sheet, enter the start and end dates for your budget. This is typically the first of the month to the last day of the month or payday to payday. The budget needs to span one month.
2. In column A, starting in row 10, list all your income sources for the coming month.
3. Then in column B, give your best estimate of the amount of money you expect to earn from each source.
4. Consider the list of expense categories in column D, and the categories you used in your Expense Tracker. Modify the categories to best fit your situation.
5. Once you have listed your expense categories in column D, use column E to indicate whether each is a fixed or a variable expense. Your responses may differ from those in the example.
6. Now, use your previous month’s expenses (from the Expense Tracker) to create a budget for the coming month. Enter the amount you plan to spend in each category in the appropriate cells in column F.

 

Part 3: Balance Your Budget

1. Review that the total income you expect to earn is given in cell B8 and the total expenses in cell F8. If the number in cell F8 is more than the number in B8, it means that your planned expenses exceed your total income. Your budget is not balanced.
2. Though there is likely not much you can do to adjust your fixed expenses, look over your variable expenses and make necessary adjustments until your Total Income expected (cell B8) is equal to or only slightly greater than the Total Expenses budgeted (cell F8).
   • If you can’t balance your budget by adjusting the variable expenses, you will need to consider what fixed expenses you can adjust (i.e. – reducing or cancelling services, subscriptions, etc.) or what other income you could acquire.
3. When you finish, your budget should look something like the following.

 

 

 

Part 4: Answer Questions and reflect

Answer the following questions:

1. Did you download and complete your budget? Yes ? No ?
2. Did you classify all your expenses as fixed or variable? Yes ? No ?
3. Did you adjust your budget so your expenses did not exceed your net income? Yes ? No ?
4. Comparing your old budget to your new aspirational one, what is one major difference that you notice? (Please be specific).

Click or tap here to enter your response.

 

5. Thinking back on everything that you have learned throughout this unit about wise financial stewardship, what is the primary goal of your new budget? What are you currently working toward that you perhaps weren’t before (i.e. tithes and offerings, emergency fund, eliminating debt, savings?

Click or tap here to enter your response.

 

6. How long until you reach that goal?

 

Click or tap here to enter your response.

 

7. Once that goal is met, what is the next goal you hope to achieve in terms of your budget?

Click or tap here to enter your response.

 

8. What do you think will be the hardest thing about sticking to this new budget?

Click or tap here to enter your response.

 

9. How do you plan to overcome this challenge?

Click or tap here to enter your response.

 

 

 

 Part 5: Save and Submit

After completing all the steps above, save this document to your device and follow the instructions in your course to upload it in to the assignment.

 

Complete the following steps in the coming months to continue to refine your budget

Part 6: Track Your Expenses for the Next Month

Now, continue the pattern you have started by using the Income and Expense Tracker file to track your expenses for the coming month.  You can download a new copy of the file from the 'Student Resources' module in your Course.

If we had more time in the semester, you would be required to track your expenses for the next month. Since there is no time, you are not required to; but it is highly recommended that you continue to track your expenses for the next month, then compare your actual expenditures to the goals you set for yourself.

Don’t forget to use either the digital or envelope tracking methods to help keep yourself on track. Also, don’t get discouraged if you find it impossible to stick to your aspirational budget the first few times you try. Make adjustments as necessary and keep trying. With prayer, faith, hard work, and self-control, you will become a wiser steward of your finances.

Part 7: Adjust your Budget

As the month passes, you may find that you need to spend more in one budget category than you expected.  This is when you return to your budget and decrease the amount in another category to keep your budget balanced.  Over time, you will have a better understanding of your budget needs, so this should happen less often.

You can use the ‘Actual’ columns on the budget sheet to record the actual income and expenses in each category. This will help you know where your budget needs to be adjusted.

Part 8: Implement a Long-Term Plan to Improve Your Financial Situation

As time passes, continue to monitor your budget. Consider the principles from the course as you make adjustments and council together with family as needed.