11. You have a net income of $40000/year. Your expenses include the following: 。 Rent: $800/month 。 Insurance: $225/semi-annually 。 Car Payment: $315/month • Car Expenses: $1000/year 。 RRSP: $50/month 。 Entertainment: $50/week 。 Cell Phone: $75/month 。 Food: $500/month a. Create a budget. b. Modify the budget to include a savings plan of $100/week. c. You paid off your car and have decided to buy a house. Your mortgage payment is now $1050/month. Modify the budget to reflect this new financial plan.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 3R: Review the completed master budget and answer the following questions: Is Ranger Industries...
icon
Related questions
Question
None
11. You have a net income of
$40000/year. Your expenses include
the following:
。 Rent: $800/month
。 Insurance: $225/semi-annually
。 Car Payment: $315/month
• Car Expenses: $1000/year
。 RRSP: $50/month
。 Entertainment: $50/week
。 Cell Phone: $75/month
。 Food: $500/month
a. Create a budget.
b. Modify the budget to include a savings
plan of $100/week.
c. You paid off your car and have decided
to buy a house. Your mortgage payment
is now $1050/month. Modify the budget
to reflect this new financial plan.
Transcribed Image Text:11. You have a net income of $40000/year. Your expenses include the following: 。 Rent: $800/month 。 Insurance: $225/semi-annually 。 Car Payment: $315/month • Car Expenses: $1000/year 。 RRSP: $50/month 。 Entertainment: $50/week 。 Cell Phone: $75/month 。 Food: $500/month a. Create a budget. b. Modify the budget to include a savings plan of $100/week. c. You paid off your car and have decided to buy a house. Your mortgage payment is now $1050/month. Modify the budget to reflect this new financial plan.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Personal Finance
Personal Finance
Finance
ISBN:
9781337669214
Author:
GARMAN
Publisher:
Cengage