Monthly Budget

The numbers for the project must be made-up.

Use Excel to setup a Monthly Budget that includes at least the
following categories.

Monthly Income (Source)
Other Income (Source)
Total Monthly Income (A + B)
Housing Expense
Food Expense
Credit Card Expense
Total Expenses
Savings (C G)

Attached is a step-by-step guide to create a budget sheet, if you
would like to use it as a reference point.

After you have set up the MONTHLY Income, use autofill to create the
Income Statement for the rest of the year.
Use the Sum function to create a yearly total for all of these numbers.
After you have created a yearly total, create a Pie chart or Column
Chart to display your yearly budget graphically. Add Data Labels
indicating the Amount and Percentage of these data.
Copy and Paste this information into a Word Document and answer the
following questions based on your number. I dont want just bullet
points of data. I can get that from the Excel part. I want you to
write at least three paragraph based on YOUR data. a. Based on the
income statement, how good are you at saving money? Be honest. The
answer has to fit the numbers you showed.

You may save money to buy a bike, car, downpayment for a home; or you
may not want to have any savings based on the lifestyle or earnings.

After you have completed your Word Document, create a PowerPoint that
incorporates your graph from the Excel part, the decisions you made in
the Word Part, and a picture of the car (or scooter, or bike, or
whatever).

Add a title slide with the title, your name, and the class name (CMS 200)
LINK the CHART in PowerPoint so that if I make changes in Excel, the
up date automatically in PowerPoint.
When the Chart displays, make the chart animate by category.
Add a custom transition between each slide.
Make sure each slide has a title
The slide with the car and the slide with the data should have a
hyperlink to show where you got the information.
Finally, Save the PowerPoint as both a PowerPoint and a Windows Movie File.

Last Completed Projects