The table shows Fiona’s weekly budget:
Find the value of:
A
B
Fiona saves any money that she has not spent. How much does Fiona save each week?
| Income | Expenses | ||
|---|---|---|---|
| \text{Wages} | \$80 | \text{Phone} | \$8.50 |
| \text{Umpiring} | \$25 | \text{Bus ticket} | \$13 |
| \text{Entertainment} | B | ||
| \text{Food} | \$45.25 | ||
| \text{Total} | A | \text{Total} | \$91.15 |
A weekly budget is shown in the table:
Calculate the weekly expenses.
Calculate the weekly savings.
Calculate the percentage of income saved, correct to two decimal places.
Calculate the percentage of income spent on mortgage payments, correct to two decimal places.
Calculate the amount paid on the mortgage in one year.
| Income | Expenses | ||
|---|---|---|---|
| \text{Earnings} | \$505 | \text{Mortgage} | \$147 |
| \text{Electricity} | \$23 | ||
| \text{Food} | \$64 | ||
| \text{Council Rates} | \$22 | ||
| \text{Insurance} | \$20 | ||
| \text{Water} | \$64 | ||
| \text{Clothing} | \$46 | ||
| \text{Entertainment} | \$56 |
Amelia earns a weekly salary of \$723 and receives income from other sources of \$126. Her weekly expenses are: rent \$199, groceries \$51, petrol \$33, electricity \$33, telephone \$23, magazines \$13 and clothes \$62. Calculate:
Her weekly income
Her weekly expenses
Her weekly savings
Her annual savings
James's monthly expenses include: rent, food, cable TV, travel, insurance, clothing, repairs.
Determine whether the following expenses are fixed:
Cable TV
Travel
Insurance
Clothing
Repairs
Rent
Determine whether the following expenses are variable:
Cable TV
Travel
Insurance
Clothing
Repairs
Rent
Amerie pays rent of \$239 per week, and must budget for electricity and water costs of \$533 per quarter. How much should she put aside each week to cover these expenses?
Sally earns \$610 per week. Her weekly work related expenses are \$185 on travel and \$86 on lunch. What percentage of her weekly income goes towards work related expenses? Round your answer to two decimal places.
Last month, Neil saved \$235, which was 15\% of his income. Calculate his income last month.
Sally earns a weekly salary of \$1195 and receives income from other sources of \$181. Her weekly expenses are on the right. Calculate:
The percentage of income saved, correct to two decimal places.
The percentage of income spent on magazines and clothes, correct to two decimal places.
The amount of rent paid annually.
The number of full weeks needed to accumulate enough savings to pay for a holiday that costs \$3800.
Rent \$122
Groceries \$97
Petrol \$60
Electricity \$46
Telephone \$28
Magazines \$10
Clothes \$79
Luke’s weekly expenses vary slightly from week to week. His expenses in the first 3 weeks are \$225, \$218 and \$208. If he can only afford to have an average weekly expense of \$221 every four weeks, calculate the maximum expense he can have in the fourth week.
Amelia earns a gross annual salary of \$34\,500. She wants to put aside equal monthly amounts towards starting her own business. If she must pay income tax of 24\% and other expenses adding up to \$19\,650 per annum, how much does she have left to set aside each month?
A company’s advertising cost is 2 times its technology cost, and production cost is 8 times the advertising cost. If advertising, technology and production cost \$142\,000 in total, calculate the cost of advertising.
Christa’s expenses currently represent 30\% of her \$920 weekly income. If her expenses increase by 5\%, what percentage of her income will expenses take up?
Tina wants to take out a car loan, making regular monthly repayments. She expects the other costs to be:
\$50 per week for petrol
\$110 per month for insurance
\$40 per annum for the renewal of her driver's license
\$310 every six months for servicing
\$750 per annum for her Green Slip
\$600 per annum for registration
Calculate the equivalent annual cost of the following:
Petrol
Insurance
License
Servicing
Green Slip
Registration
What is the total annual cost of running the car?
If Tina has an annual income of \$59\,000, and can spend 19\% of it on buying and running the car, calculate the maximum monthly repayment she can afford to make.
Buzz’s current income of \$327 is to increase by \$6.54, but his current expenses of \$114.45 are also set to increase by 4\%.
What percentage of his income is currently consumed by expenses?
Calcuate the percentage of income consumed by expenses after the increases. Give your answer to two decimal places if necessary.
Calculate the change in percentage of his income consumed by expenses.
The following shows Tracey's bank statement for the month of January:
| Date | Item | Credit | Debit | Balance |
|---|---|---|---|---|
| 01/01/15 | \text{Opening balance} | \$55.40 | ||
| 06/01/15 | \text{Groceries} | \$40.00 | \$ | |
| 10/01/15 | \text{Salary} | \$ | \$144.50 | |
| 17/01/15 | \text{Train ticket} | \$18.70 | \$ | |
| 20/01/15 | \text{Socks} | \$ | \$123.10 | |
| 31/01/15 | \text{Magazine} | \$6.15 | \$ |
Complete the given table.
What is the new bank balance at the end of January?
Marge used a spreadsheet program to create her weekly personal budget, as shown below. She has separate tables for income and expenses and she can see at a glance how much she has each week in savings:
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | \text{Personal budget (weekly)} | |||||
| 2 | ||||||
| 3 | \text{Income} | \text{Expenses} | ||||
| 4 | \text{Earnings} | \$950.00 | \text{Rent} | \$272.00 | ||
| 5 | \text{Electricity and gas} | \$51.00 | ||||
| 6 | \text{Food} | \$135.00 | ||||
| 7 | \text{Internet} | \$29.00 | ||||
| 8 | \text{Gym membership} | \$22.00 | ||||
| 9 | \text{Public transport} | \$76.00 | ||||
| 10 | \text{Phone} | \$50.00 | ||||
| 11 | \text{Clothing} | \$80.00 | ||||
| 12 | \text{Entertainment} | \$85.00 | ||||
| 13 | \text{Total} | \$950.00 | \text{Total} | \$600.00 | ||
| 14 | ||||||
| 15 | \text{Savings} | \$350.00 |
What spreadsheet formula did Marge use in cell \text{F13}?
What spreadsheet formula did Marge use in \text{C15}?
Valerie uses a personal budget to help her save money for a holiday she plans to take in one years time. The spreadsheet below summarizes her weekly personal budget:
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | \text{Personal budget (weekly)} | |||||
| 2 | ||||||
| 3 | \text{Income} | \text{Expenses} | ||||
| 4 | \text{Earnings} | \$650.00 | \text{Rent} | \$180.00 | ||
| 5 | \text{Electricity and gas} | \$54.00 | ||||
| 6 | \text{Food} | \$100.00 | ||||
| 7 | \text{Internet} | \$16.00 | ||||
| 8 | \text{Fitness club} | \$25.00 | ||||
| 9 | \text{Public transport} | \$25.00 | ||||
| 10 | \text{Phone} | \$10.00 | ||||
| 11 | \text{Clothing} | \$85.00 | ||||
| 12 | \text{Subscriptions} | \$15.00 | ||||
| 13 | \text{Total} | \$650.00 | \text{Total} | \$510.00 | ||
| 14 | ||||||
| 15 | \text{Savings} | \$140.00 |
She decides to put \$125 of her savings each week towards the holiday and allocate the remaining \$15 of her savings towards a fund for emergency expenses. How much will Valerie have saved to spend on her holiday after one year? Assume there are 52 weeks in a year.
How much will Valerie have in her emergency fund after one year if she allocates \$15 of her savings each week? Assume there are 52 weeks in a year.
During the year, Valerie's washing machine breaks down and she has to buy a new machine for \$555 using money from her emergency fund. How much would be left in her emergency fund at the end of the year?
Valerie also makes an emergency visit to the dentist during the year. She is charged \$375 in dentistry fees. If she uses her remaining emergency fund to put towards the dentistry fees, how much extra will she need to pay for the dentist?
Valerie reduces her spending on clothing for four weeks to pay for the remaining dentist fees. During this time, how much can she afford to spend on clothes per week?