project for fina

profileVIK1299
BudgetCaseStudy.xlsx
Home>Business & Finance homework help>Accounting homework help>project for fina

Intro

FINA 2330 Budget Case Study
Cells that require your input are blue.
Name: BHAVIK
ID#: *******2720
1) Determine annual gross income.
Last digit of ID Annual Gross Income
0 $40,000
1 $45,000
2 $50,000
3 $55,000
4 $60,000
5 $65,000
6 $70,000
7 $75,000
8 $80,000
9 $85,000
10 $90,000
2) Create spending categories.
Use whatever categories you choose, but please limit it to no more than 15.
Spending Category
3) Build a monthly budget on "Monthly Budget" sheet.
4) Revise monthly budget based on the "Revised Monthly Budget" sheet.
5) Once you are done, submit your assignment.
Grading Rubric
Categories 40 points Did you forget something big like food or health insurance?
Allocations 20 points Are your amounts reasonable?
Contingencies 15points Can you handle any unforeseen expenses?
Redo 25 points How well did you adapt to the forced change?
General 25 points Did you follow instructions? Did you spell correctly?

Monthly Budget

Annual Income
Monthly Income $0.00
Expenses Amount Percent of Income
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
0 ERROR:#DIV/0!
Totals $0.00 ERROR:#DIV/0!

Revised Monthly Budget

Second to last digit of ID Annual Income Change
0 plus $4,000
1 minus $4,000
2 plus $8,000
3 minus $8,000
4 plus $6,000
5 minus $6,000
6 plus $10,000
7 minus $10,000
8 plus $9,000
9 minus $9,000
Original Amount Revised Amount
Annual Income $0.00
Monthly Income $0.00 $0.00
Expenses
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
0 $0.00 ERROR:#DIV/0! ERROR:#DIV/0!
Totals $0.00 ERROR:#DIV/0! $0.00 ERROR:#DIV/0!