Create an income statement and balance sheet for walter

Assignment Help Financial Management
Reference no: EM132051532

Walter (54) and Freya (52) live in Zermatt, Ontario. Walter is a Ski Instructor, who works at the nearby Ski Hill in the winter and runs cycling tours in the summer. Between the two jobs he earns $58,000/year (gross). He drives a 13 year old Honda which he estimates the current value to be $4,000. He has saved $25,000 in an RRSP.

Freya works as a veterinarian in the local clinic and takes home $90,000/ year (gross). She had been taking advantage of the company's RRSP matching program, but stopped contribution six months ago as she found the money was better spent paying off debt. She credits this program for helping her to grow her RRSP to a current value $415,000. The RRSP is invested 50/50 in a Canadian Equity and Global Balanced fund.

Freya still has $30,000 in student loans that she is repaying $300 per month towards. The current annual interest rate on the student debt is 7%.

They live in a home they purchased 12 years ago after first moving to Zermatt. The home was bought for $300,000 but has grown in value and is now worth $420,000. Walter and Freya are still paying off their mortgage, which has a current balance of $123,400 and a monthly payment of $1,550. The current interest rate on the mortgage is 4%.

Two years ago the couple undertook a kitchen and living room renovation. Not having the funds at the time to take on the project, they took out $85,000 from a home equity line of credit, which has a current balance of $72,500. They only need to make a minimum payment of $200 per month, but they recently increased their payments to $500 a month in the hopes of paying it off as soon as possible. The current rate of interest on the HELOC is 5% (APR), with interest compounded monthly.

In addition to the HELOC Freya has a $10,000 car loan remaining on her $40,000 vehicle. She also has a coin collection inherited from her mother, worth an estimated $12,000.

Freya & Walter have heard good things about the Tax Free Savings Account, and each opened accounts last year. They currently have $10,000 in each of their accounts and are contributing $250 per month each. The TFSA balances are invested in a high interest money market fund paying 0.75% per annum.

Freya has a developed an interest in fashion, and has been spending close to $1,000 a month on clothing. She hasn't told Walter, but she has actually built up credit card debt totalling $15,000 as a result. The annual interest rate on the credit card is 18% APR and the monthly minimum payment is $60

Walter's weak spot for spending is Ski equipment, while he hasn't spent any money on this recently, he thinks he has accumulated about 10,000 of equipment in their house. Other personal and household assets are estimated to be worth about $20,000

The couple's other expenses include the following:

Annual: Property Tax of $6,000, Professional dues of $2,000, Gifts of $3,200, Vacations of $10,000.

Monthly: Groceries $1,000, Utilities $520, Entertainment $700, Car expenses $800, Health & Hygiene $420, Life Insurance Premiums $65, Personal Trainer/Fitness $470, Cell Phones $210, Home insurance $215, Alcohol $300, Ski Pass $150. Car Loan $250

Walter also recently signed up for a coffee membership, where he gets 3lbs of freshly roasted coffee mailed to him for a monthly fee of $65. They have one joint bank account, with a balance of $2,000.

Both Freya and Walter are wanting to retire by age 65, but at this point they aren't sure of their financial ability to do so.

1 Create an Income Statement and Balance sheet for Walter & Freya

2 What is Walter & Freya's Net Worth?

3 What is Walter & Freya's monthly surplus or deficit?

Reference no: EM132051532

Questions Cloud

How much money should you put in a savings account today : Question If you want too have $265,324 in 16 years. How much money should you put in a savings account today.
What is the most expensive house that he can purchase : What is the most expensive house that he can purchase, assuming that his parents pay the required 10% downpayment, and he pays.
How much will he need to deposit into this account : He wishes to immediately deposit a sum of cash into an account paying 4 percentage per year compounded on a monthly basis.
Supposing the australian economy is heading for a recession : Supposing the Australian economy is heading for a recession, what should (or can) the current government now do to deal with this?
Create an income statement and balance sheet for walter : Create an Income Statement and Balance sheet for Walter & Freya. What is Walter & Freya's Net Worth?
Describe the likely effects of an economic crisis : Could you please help me to illustrate and describe the likely effects of an economic crisis on a country's trade performance and balance
At this point you have no idea how much cash is available : At this point you have no idea how much cash is available and you must meet a payroll of $100,000 in 2 days. Where would you start?
Explain some limitations of using gdp : Explain some limitations of using GDP as an indicator of standard of living (be sure to do some research on your own to find any alternative measures).
Calculate wandas total return on this investment : During the 12 months she owned the stock, she received $144 in dividends. Calculate Wanda's total return on this investment.

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd