l need help with my excel

EXCEL MINI PROJECT

Attached Files:

Create a “Personal Monthly Budget”, similar to the “Sample Budget” posted this week, that covers your financial resources and expenses.

Instructions:

  • Use the Sample Budget, the PDF file that is posted in the Weekly Content area and Week 13: April 16 link to frame your personal budget spreadsheet. A copy of this PDF file is attached for your convenience.
  • Note that the Sample Budget is set for one year and your Mini Project is for one month! (Pay attention to the difference) – 25 points
  • Add as many expense items as possible so you can have a good scenario for the What-If Analysis part.
  • In the end, show your savings or your extra income/shortage that you need to balance your monthly budget. – 25 point
  • Finally, perform a What-if Analysis (Goal Seek) of the amount of Saving based on your own scenario. – 10 points
  • You should have 2 Sheet tabs in your spreadsheet file. Rename Sheet1 to “Original Personal Budget” to save your original budget sheet and Sheet2 to “Personal Budget Analysis” to save a copy of your budget sheet and perform the What-if Analysis (Goal Seek) in this one.
  • Make sure to have all formulas where needed. Missing any single formula will cost you points. – 40 points
  • Upload your Excel file into Bb for grading by the next session (April 23)
 

"Is this question part of your assignment? We Can Help!"

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp