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

  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