(a) Prepare an income statement for last year (2016) for the Gruberfamily.

Assume that they had no taxes owing or refunded.

(b) Prepare a balance sheet as of the end of last year (2016) for the Gruber family.

(c) Prepare a monthly cash budget for the period of January to December of this year (2017).

State clearly any assumptions you make.

The Gruber family have come to you for advice and have provided you with the following information:

i. John is a production manager in a small manufacturing firm.

His annual salary is $79,000. His net bi-weekly pay afterpayroll deductions is $2,910.

Julie has a part-time job as a legal secretary and makes about $300 a week after deductions. Her gross annual salary is $18,700.

ii. The younger child stays in a home day care in the neighbourhood, at a cost of $105 per week.

iii. They have a chequing account which is used to pay all their household bills and from which draw their pocket money. The balance in the account at the end of December is $400.

Their savings account has a balance of $4,100, and pays interest of approximately 1% p.a., on the minimum monthly balance.

iv. John gets a performance bonus and salary review on the anniversary of his employment.

He thinks he will get a 5% increase this year (2017).

v. Monthly mortgage payments on their $101,000 mortgage are $1,310.

vi. Monthly life insurance premiums for John are $170. As of December 31, the policy had a cash surrender value of $2,200.

vii. Monthly car loan payments are $510. Licence fees of $90 are due in February and September.

viii. As one of the beneficiaries of her grandmother's estate, Julieexpects to get about $40,000 by the end of June.

ix. Their average utility bills are:

o $250 for gas, bi-monthly beginning in January

o $ 80 for telephone, monthly (includes long distance)

o $100 for hydro, bi-monthly (February, April, etc.)

x. John has a car valued at $16,100 with an $8,900 loan outstanding (originally taken out for a four-year term). Julie's car is three years old and fully paid for with an estimated value of $10,000. Gasoline and parking cost $250 a month for both of them together, and repairs cost $1,500 last year.

xi. Insurance premiums are paid annually for the house and vehicles. House insurance will be $1,200 in October, car insurance total for both cars will be $1,500 in November.

xii. They spend about $190 per week on food, drugs and toiletries.

xiii. John figures he spends about $240 per month for lunches and coffee at work.

xiv. They think they can go through $50 a week on miscellaneous expenditures.

xv. Julie has a balance of $750 owing on her Visa card and Johnowes $250 on his charge card.

xvi. There are other costs that must be covered clothes, gifts, miscellaneous household items, etc.

John says: Thank goodness for credit cards. We have tried budgets before, but it is

impossible to stick to them. I guess you could say that I am a little sceptical that a budget will work for us.

xvii. John owns listed shares of a company worth $17,000 that paid $800 in dividends last year. The first dividend was paid in February.

xviii. Julie has $9,500 in her RRSPs.

xix. Household contents would cost about $60,000 to replace, according to the insurance agent.

They feel that they could get about $410,000 for their house, before real estate commissions, legal fees and moving expenses.

This year's property taxes will increase 2% over last year's taxes of $3,000 and they are due in equal installments in February, March, April, June, August, and September.

xx. Assume that half of their mortgage payments and half of their loan payments are comprised of principal, and half of interest.