BettyLou'sBudgetAssignment1

.xlsx

School

Rutgers University *

*We aren’t endorsed by this school

Course

BUS419

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

11

Uploaded by CountSalmonPerson703

Report
Fall Semester Spring Semester Summer Fall Semester Months 4.5 4.5 3 4.5 Revenues Kennedy School Grant $5,000.00 $5,000.00 $0.00 $5,000.00 Subsidized Stafford Loan $4,250.00 $4,250.00 $0.00 $4,250.00 Unsubsidized Stafford Loans $6,000.00 $6,000.00 $0.00 $6,000.00 Perkins Loan $1,500.00 $1,500.00 $0.00 $1,500.00 Grad PLUS Loan $7,500.00 $7,500.00 $0.00 $7,500.00 Course Assistant $0.00 $0.00 $0.00 $4,050.00 Summer Internship $0.00 $0.00 $4,000.00 $0.00 Savings $5,000.00 $0.00 $0.00 $0.00 Scholarship for books and suppli $964.00 $964.00 $0.00 $964.00 Total Revenue $30,214.00 $25,214.00 $4,000.00 $29,264.00 Expenditures Months 4.5 4.5 3 4.5 Rent $3,150.00 $3,150.00 $2,100.00 $3,150.00 Cell Phone $270.00 $270.00 $180.00 $270.00 Groceries $1,125.00 $1,125.00 $750.00 $1,125.00 Allergy Meds $180.00 $180.00 $120.00 $180.00 DVD rental by Mail $54.00 $54.00 $36.00 $54.00 Television $360.00 $360.00 $240.00 $360.00 Newspaper subscription $45.00 $45.00 $30.00 $45.00 Tuition $18,788.00 $18,788.00 $0.00 $18,788.00 Activity Fee $75.00 $75.00 $0.00 $75.00 Emergency Health Service Fee $563.00 $563.00 $0.00 $563.00 Health/Hospital Insurance $857.00 $857.00 $0.00 $857.00 Personal/Travel $1,777.13 $1,777.13 $1,184.75 $1,777.13 Books and Supplies $964.00 $964.00 $0.00 $964.00 Utilities $165.00 $165.00 $110.00 $165.00 Rentals Insurance $99.00 $99.00 $66.00 $99.00 Spring Break $0.00 $0.00 $0.00 $0.00 Total Expenditures $28,472.13 $28,472.13 $4,816.75 $28,472.13 Deficit/Surplus $1,741.88 ($3,258.13) ($816.75) $791.88
Spring Semester Total BettyLou'sBudget 4.5 24 $5,000.00 $20,000.00 $4,250.00 $17,000.00 $6,000.00 $24,000.00 $1,500.00 $6,000.00 $7,500.00 $30,000.00 $4,050.00 $8,100.00 $0.00 $4,000.00 $0.00 $5,000.00 $964.00 $3,856.00 $29,264.00 $117,956.00 4.5 24 $3,150.00 $14,700.00 $270.00 $1,260.00 $1,125.00 $5,250.00 $180.00 $840.00 $54.00 $252.00 $360.00 $1,680.00 $45.00 $210.00 $18,788.00 $75,152.00 $75.00 $300.00 $563.00 $2,252.00 $857.00 $3,428.00 $1,777.13 $8,293.25 $964.00 $3,856.00 $165.00 $770.00 $99.00 $462.00 $0.00 $0.00 $28,472.13 $118,705.25 $791.88 ($749.25)
Revenues Kennedy School Grant Subsidized Stafford Loan Unsubsidized Stafford Loans Perkins Loan Grad PLUS Loan Course Assistant Summer Internship Savings Scholarship for books and supplies Expenditures Rent Cell Phone Groceries Allergy Meds DVD rental by Mail Television Newspaper subscription Tuition Activity Fee Emergency Health Service Fee Health/Hospital Insurance Personal/Travel Books and Supplies Heat/Hot Water Rentals Insurance Asia Spring break and January term trips
She will be getting $15 an hour for 15 hours a week. 52 weeks in a year divided by 12 times 4.5 times 15 times 15 She had $8,000 in savings before she spent $3,000 in Asia and had a remaining of $5,000. Since she is not in a deficit during h $2100 divided by 3 for the other roomates is 700 a month times 4.5 for the semester and times 3 for the summer $122 a month divided by 3 for her roomates times 4.5 $22 a month divided by 3 for her roomates times 4.5 Spent $3,000 on her trip to Asia I took them out of the budget to see if she can afford school before going on vacation.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help