Portland State University Moving to A New Apartment Budget Worksheet.
Now you’re ready to try developing your own spreadsheet from scratch. For this project, it may
be helpful to draft out your design on paper and run it by your instructor before you begin your
work in Excel.
Project Setting: You have just moved into a new apartment and will be furnishing it with new
furniture. Your kitchen has a stove, oven, and refrigerator; and your apartment complex has a
laundry room. You will need to furnish your kitchen/dining area, living room, and bedroom.
You have a total budget of $5,000 dollars. Using shopping sites located on the internet, find
items you would like to purchase for each of your rooms.
Spreadsheet Requirements: For this project, you must create a sheet for each room. In each
sheet, you need to make a table with the following information for each item you are
purchasing: item name, description, website, number of items, cost per item, and total cost.
Each table should have at least 10 items. The table should be sorted by item name and needs to
include a total row that shows the total number of items for each room and the total spent.
When you have completed the sheets for the rooms, create a summary sheet that shows the
total spent in each room (use a 3-D formula for this!), the grand total for all the rooms, how
much money you have left, and an IF statement that shows if you spent too much or not. You
will be borrowing the entire $5,000 and will be paying it off over a period of 5 years. You are
borrowing at an annual interest rate of 3%. Write a formula to calculate what your monthly
payment will be. In addition, make a pie chart that shows how much money you spent in each
Things to remember:
• Create sheets that are easy to read and understand. Use appropriate fonts,
styles, alignment, and format to highlight key pieces of data.
• Appropriate titles and headings must be used in all sheets.
• All dollar amounts should include two decimal places.
• Name your spreadsheet tabs.
• Use functions and cell addresses in all calculations. When using the PMT
function, remember to convert to a monthly interest rate.
• Pie charts need appropriate titles, legends, and data labels.