Practice Total Projected Income

Please prepare a Projected Income and Expense Statement for the months of August of 2023 as well as September and October of 2023. Your Projected Income & Expense Statement should include the following:

Projected Income for August 2023

Projected Income for September 2023

Projected Income for October 2023

Projected Expenses for August 2023

Projected Expenses for September 2023

Projected Expenses for October 2023

Income should consist of money received from employment, birthdays, graduation gifts, loans, scholarships, stimulus, unemployment, etc. The next task is for you to project your expenses over the next three months as well. This should be fairly easy as you have been keeping track of your expenditures over the past few months. After you have done this, you should either show a net worth or deficit. This assignment should be submitted on an excel spreadsheet or better yet, if you have a program that you are familiar with that track’s income and expenses, you are welcome to use it. For a more accurate illustration of what the 100 points will consist of see below:

Summary – 33 (11 Points for each month’s summary) – Summaries for each month will consist of an explanation of your income and expense, particularly those expenses that represent a huge amount. You should have a clear idea of what they will be as we have been tracking expenses all semester.

Format – 33 (11 Points for each month’s format) – The document should be submitted in an excel spreadsheet or similar.

Content – 33 (11 Points for each month’s format) – This is the actual information with regards to income and expenses that you will show. See the example below:

December 2021 Projected Income

Gifts – $1,000

New Job Salary – $5,000

Total Projected Income – $6,000

December 2021 Projected Expenses

New Apartment Security Deposit – $200

Down Payment New Car – $1,000

Keep in mind I’ve only provided an example. Some of you will have more monthly expenses.
Total Projected Expenses – $1,200

Projected Net Worth – $4,800

The above illustration should be done for all months (August, September, and October).