Question

In: Finance

You are a financial adviser and the following information is an extract of data you gathered...

You are a financial adviser and the following information is an extract of data you gathered as part of fact finding during an initial client consultation for married couple Janet and Steven Blake. Janet works as a Teacher and Steven works as town planner at the local government. The have two children who are aged 12 and 14.

Janet and Steven would like to know how much money they will receive after paying tax and expenses for the year ended 30th June 2018. They would like advice on how to reduce their tax liability in the future.

The Blake’s have diversified their investments by investing equally in a bank savings account, a fund and some Macquarie Group Ltd Shares. Their risk profile is equivalent to that of a growth investor. They have come to you understand how they should invest in the future.

The Blake’s life goal has been to buy a property in the country and live the quiet life 10 years from now. They need to save a $200,000 deposit to achieve this dream. They have $60,000 invested now and they estimate they can save $5000 p.a. for 5 years and then $10,000 p.a. for the 5 years following this. They have come to you see if they can achieve this goal.

Income for year ended 30th June 2018:

Income type

Amount

Gross Salary- Janet

$70,000

Gross Salary- Steven

$54,000

Vanguard Bond Fund- Distribution 3.85% (Janet)

$770

NAB Savings Account Janet- Interest 1.15%- Janet

$230

Macquarie Group Limited- Dividend $2.05 per share- Steven

$410

(partial franking credit $80)

Estimated annual expenses

Item

Amount

Rent (650 per week)….………………………………..

33,800

Electricity/Water/Gas ………………………………….

3,000

Telephone/Mobile ……………………………………..

2,200

Pay television/Internet …………………………………

1,100

Insurance –contents …………………………….

1,200

Insurance – car..………………………………………

3,000

Credit cards repayment ($500 a month for 12 months).

6,000

Car loans repayment ($8000 a year for 5 year term).….

8,000

Petrol/maintenance …………………………………….

6,000

Car registration ………………………………………...

800

Public transport ………………………………………..

2,800

Other expenses

Food ……………………………………………………    

12,500

Clothing/Haircuts/Beauty ……………………………..

5,500

Medical/Dental ………………………………………...

2,500

Entertainment/Dinners ………………………………...

6,000

Teacher Union Membership (Janet)………………….…………

1,000

Gifts - Birthdays/Christmas ……………………………

3,000

Total …………………………………………………..

98,400

Current Assets and Liabilities

Assets (Ownership)

Current valuation

$

Liability (Ownership)

Current valuation $

Home Contents (Joint)

20,000

Credit cards (Joint)

Includes the annual interest cost

6,000

Car (Joint)

35,000

Car loan (Joint)

5 year term at 12%

30,000

Bank Account:

Cheque Account (Joint)

8,000

Investments:

NAB savings Account (Janet)

Vanguard Bond Fund (Janet)

Macquarie Group Ltd Shares (Steven)

20,000

20,000

20,000

Calculate the future value of the investment portfolio 10 years from now assuming it will earn a 5% p.a. after tax. In this calculation you should include the FV of the current investments and the FV of the contributions that Blake’s estimate that they make over the next 10 years. Assume that contributions are made at the end of the year and that the first contribution will be made 365 days from now. Finally, explain one strategy that Janet and Steven could reach their goal more quickly and show the influence that this will have. If assumptions are made, these assumptions must be clearly stated.

Financial Formulae   

Savings ratio = savings (or cash surplus)/net income after tax

Future value FV = PV(1 + i)n   

Annuity (Future value) FV = PMT[((1 + i)n – 1)]/i

Solutions

Expert Solution

Assumptions:
1 Salary increase @ 5%
2 Car Registration - as one time expenses. It will not recurr from Year 2
3 No Car loan from year 6
4 Income tax rate at 25%
5 Expenses to go up by 2% Year on year
6 No education expenses on Kids.
7 Additional Saving invested in Vanguard fund which fetches 3.85% returns
8 Assuming Income Tax rate remains same in the next 10 years

The Investment at the end of year 10 is still short by 58250. Since there is surplus savings from year 3, investment should be accelerated and also should find ways for additional income or reduction of expenditure year on year to achieve the goal.


Related Solutions

You are a financial adviser and the following information is an extract of data you gathered...
You are a financial adviser and the following information is an extract of data you gathered as part of fact finding during an initial client consultation for married couple Janet and Steven Blake. Janet works as a Teacher and Steven works as town planner at the local government. The have two children who are aged 12 and 14. The Blake’s have diversified their investments by investing equally in a bank savings account, a fund and some Macquarie Group Ltd Shares....
Your financial adviser provided you with the following data about combinations of a Technology and a...
Your financial adviser provided you with the following data about combinations of a Technology and a Utility fund: E(r) σ weight invested in Technology fund weight invested in Utility fund ORP 12 30 50 50 MVP 6 24 70 30 Your risk aversion coefficient is A=4 and the risk free rate is 2%. If you have $1000, how much money do you need to invest in the Technology fund to maximize your utility?
As an analyst, you have gathered the following information on a company you are tracking. The...
As an analyst, you have gathered the following information on a company you are tracking. The current dividend is $0.75. Dividends are expected to grow at a rate of 12% over the next three years, decline linearly to 4% over the next six years, and then remain at a long-term equilibrium growth rate of 4% in perpetuity. The required return is 9%. The value of the company is closest to:             a) $20.25. b) $23.2056 c) $78.25 d) $15.76 e)...
summarize the data gathered during the financial expert interview.
summarize the data gathered during the financial expert interview.
To try and determine what type of virus it is, you gathered the following information: The...
To try and determine what type of virus it is, you gathered the following information: The capsid is surrounded by a plasma membrane that resembles that of an animal cell. After its genetic material is released into a host cell, the genetic information is used to produce mRNA through a process called transcription. From this mRNA, proteins are being produced making further use of the host's resources. When the assembled virus particles leave the cell, they destroy it. What type...
The following extract appeared in the financial statements of Sihle Limited: Sihle Limited Extract from the...
The following extract appeared in the financial statements of Sihle Limited: Sihle Limited Extract from the Statement of Comprehensive Income for the year ended 31 December 2019: R Sales 4 140 000 Cost of sales (3 490 000) Opening inventory 710 000 Purchases 3 630 000 Gross profit 650 000 Operating expenses (429 000) Operating profit 221 000 Interest  expense (35 000) Profit before tax 186 000 Taxation (52 800) Profit after tax 133 200 Additional information: Dividends paid during the...
The following information has been extracted from the financial statements of YDI Limited: Extract of Statement...
The following information has been extracted from the financial statements of YDI Limited: Extract of Statement of Comprehensive Income for the year ended 31 December 2019 2018 R R Sales 2 000 000 1 600 000 Cost of sales 940 000 800 000 Operating profit 600 000 520 000 Profit before tax 520 000 450 000 Profit after tax 364 000 315 000 Extract of Statement of Financial Position as at 31 December Assets 2019 2018 R R Non-current assets...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019 Current Assets 409,500 292,500 Non-current Assets 2,275,000 1,768,000 Current Liabilities 221,000 169,000 Non-current Liabilities 764,400 670,800 Total Revenue 728,000 624,000 Total Expenses 500,500 455,000 a)    Calculate the following ratios for both 2019 and 2020. 2020 2019 Profit Margin (Correct your answer to 0.01%) Current Ratio (Correct your answer to 0.1) Debt to Total Assets Ratio (Correct your answer to 0.01%) b)    Comment on the...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019 Current Assets 409,500 292,500 Non-current Assets 2,275,000 1,768,000 Current Liabilities 221,000 169,000 Non-current Liabilities 764,400 670,800 Total Revenue 728,000 624,000 Total Expenses 500,500 455,000 Required: Answer the following questions in the spaces provided below: a)    Calculate the following ratios for both 2019 and 2020. 2020 2019 Profit Margin (Correct your answer to 0.01%) Current Ratio (Correct your answer to 0.1) Debt to Total Assets...
You are a financial adviser at ‘MY Financial Consultants’ (MYFC). Jeremy Seymour has come to you...
You are a financial adviser at ‘MY Financial Consultants’ (MYFC). Jeremy Seymour has come to you for advice after inheriting $1.6 million from his late grandfather. Mr Seymour is looking to invest 30% of his inheritance. Mr Seymour would like to know which of the following opportunities will present him with the greatest return. • Option 1: Purchase a well-known café with an annual turnover of $420,000 and a net profit ratio of 22% • Option 2: Purchase an online...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT