Prepare a personal cash flow statement on fortnightly basis

Assignment Help Financial Management
Reference no: EM132072478

Rex and Nicole have come to see you regarding their personal financial status. They also required you to set financial goals which are important to them. Both Rex and Nicole are 45 years old. Rex is a sales manager while Nicole is an early childhood teacher.

Rex is earning an annual income of $74,000 ($2023.20 per fortnight after tax, Kiwisaver etc.) while Nicole is receiving $43,000 per annum ($1235.40 per fortnight after tax and Kiwisaver). They are both contributing 4% of their salary to Kiwisaver.

The couple had just purchased a house for $615,000 which they finance with 80% mortgage from TSB at 5.35% p.a. interest for a repayment period of 25 years. Apart from paying the mortgage, they also need to pay the council $2480.00 per annum. In addition to the house, this couple also purchased two used cars recently.

These two cars cost them $12500 and $16000 respectively. The borrowing rate for these two cars is 13.95% p.a. with repayment spread over 5 years.

The estimated household expenses for this family are as follows:

Food at $ 250 per week,

Internet and phone at 125 per month,

Insurance premium is $190 per fortnight,

Petrol expense at about $200 per month,

Cell phones are $80 per month,

Utilities estimated at $160 per month,

Car registration costs $312 per year for each car

Each car requires two wan-ants of fitness per annum which cost $60 per time,

Maintenance cost at Sl 200 per year for two cars,

Incidental expense was estimated at $300 per fortnight

Rex and Nicole have spent $8000 on a previous holiday at Europe with a newly obtained credit card. They are paying $125 per fortnight on the outstanding balance and the credit card company charges] 9.5% interest per annum on outstanding balance.

In the recent meeting, they also informed you that they have $30,000 in their current account plus household possessions at $35,000. The cars are estimated at 80% of their purchase pHce.

Their Kiwisaver have earned 5.5% retum p.a.. In addition to the 4% contribution from their income, Rex and Nicole both received 2% from their employers and $1 ,000 each from the govemment on joining (receive at the beginning of the year) and ongoing credits of $520 per year per account (receive at the end of the year).

You are required to i) Construct a personal balance sheet, ii) Prepare a personal cash flow statement on a fortnightly basis and iii) Advise the couple on three financial goals: short, medium and long term based on your analysis, show all your workings and justify your answers.

Notes:

Car and house are purchased recently.

This couple would like to retire at 65 and foresees that they need 70% of their current income excluding Kiwisaver to live a comfortable live until 90 years old. Assuming a rate of retum of 4% p.a. in your calculation.

Contribution to Kiwisaver is transferred to fund provider every three months. It is compounded at quarterly rest (assumption: your client have contributed for one year).

You are not required to calculate the credit card charges at 19.5%.

Reference no: EM132072478

Questions Cloud

How much are you willing to pay today to purchase stock : Revelation Co. just paid its annual dividend of $3 per share. The company has been reducing the dividends by 7.9 percent each year.
Concentration of methane in the atmosphere : What is the cross-sectional area of the pipe? Assume that the concentration of methane in the atmosphere is zero.
Calculate the firms working capital : After reviewing the balance sheet and income statement for Jax Capital you notice the following financial figures (in millions).
Determine the budgeted overhead rate : Patient Dwight Schuller was in the operating room 4 hours during March. Determine the budgeted (i.e., estimated) overhead rate for the operating room
Prepare a personal cash flow statement on fortnightly basis : They are paying $125 per fortnight on the outstanding balance and the credit card company charges] 9.5% interest per annum on outstanding balance.
Sucrose to be transported through the tube : How much time is required for 6.5 x 10-13 kg of sucrose to be transported through the tube?
Change in the entropy of the gas during process : What was the change in the entropy of the gas during this process?
Calculate after-tax cash flow at disposal : Reversing Rapids has a tax rate of 30%. The asset is sold at the end of year 4 for $10,339.
Prepare a monthly schedule of cash collections for Calista : Prepare a monthly schedule of cash collections for Calista Gardens for January, February and March for the first quarter of 2015

Reviews

Write a Review

Financial Management Questions & Answers

  Does put-call parity mean the put and the call option

Does put-call parity mean the put and the call option (of the same stock, with same expiration, with same strike price) have the same value/price? A European call option and a European put option on a stock both have the same strike price of $45 and ..

  What rate of return are investors expecting

Assume that the 8.6% growth rate is expected to continue forever. What rate of return are investors expecting?

  Assume annualized interest rates

Assume annualized interest rates in the U.S. and Australia are 4% and 10%, respectively,and the Australian dollar can be exchanged for $0.78.

  Vulnerability chart assist you in planning the investigation

You are an auditor for the East Ridge Food Company. How would the preparation of a vulnerability chart assist you in planning the investigation?

  Function of financial markets

In large corporation, preparation of firm financial statements would most likely be conducted by. Which of the following is not a function of financial markets?

  Bond with par value-what is the value of bond

If the annual coupon payment is 10 percent and yield of maturity is 12 percent, what is the value of bond on 30.11.2009?

  Decision to stick with both types of grass

The company has 130,000 square yards of growing space available. In the past year, the company dedicated 65,000 square yards to fescue and 65,000 square yards to Bermuda grass. What is the opportunity cost of the president's decision to stick with bo..

  Spot rate to forecast the exchange rate

If Seam decides to use the international Fisher effect rather than the spot rate to forecast the exchange rate of the U.S. dollar over the next year,

  Two projects are equally risky-risky firms existing assets

Midwest Electric Company (MEC) uses only debt and common equity. It can borrow unlimited amounts at an interest rate of rd = 9% as long as it finances at its target capital structure, which calls for 35% debt and 65% common equity. These two projects..

  Firm latest annual financial results include the numbers

Your firm's latest annual financial results include the numbers listed below. Given these, what is total asset turnover?

  Calculate the approximate equivalent annual percentage cost

As the company accountant is currently on holiday you are required, by calculating net present value, internal rate of return and payback, to advise the company which option they should take. Calculate the approximate equivalent annual percentage cos..

  What is its self-supporting growth rate

Maggie's Muffins, Inc., generated $2,000,000 in sales during 2015, and its year-end total assets were $1,700,000. Also, at year-end 2015, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and ..

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