Ask Basic Finance Expert

Case Study Assignment

Assessment task

Question 1: Presentation Slides

You have been asked to give a talk to the staff at the local primary school about financial planning. The Principal has specifically asked to address the following issues:

1. What is financial planning?

2. How do you know if an advisor is qualified to give advice?

3. The concept of risk and return

4. What is salary sacrifice and how does it work?

Required: You are required to prepare a PowerPoint Presentation (PPT) which will be the basis of your talk. (Note: you are not required to give the actual talk). The PPT should be no more than 10 slides and should clearly address each of the above issues, but note that as a PPT you should not attempt to include full explanations on each slide. For your submission, you should submit Handouts or Notes format with at least 2 slides per page.

Question 2: Case study

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 Jason and Sandra Barlow:

Husband - Jason Barlow aged 54 Wife - Sandra Barlow aged 49

3 children -aged 26, 22 and 16    Older two children are independent, 16 year-old - Cooper attends secondary college and lives at home.

Jason has annual gross income of $115,000 Sandra has gross annual income of $55,000

The couple have combined savings of $30,000 earning minimal bank interest.

Jason has a balance of $320,000 in superannuation. Sandra's superannuation balance is $125,000 The couple do not salary sacrifice.

Jason has a managed fund with a current value of $40,000

They have a mortgage of $60,000 on their home. The mortgage will paid off in 4 years time. Jason plans to retire at 60 and Sandra will retire at 55.

The couple have set an objective of saving at least 15% of their combined after tax income until their retirement.

Assume their income will remain constant in dollar terms and that the 2015/16 tax rate will stay constant until their respective retirements.

Assume that the school fees and related education expenses will remain constant and continue for the next 4 years as their son completes secondary school and an undergraduate business degree.

Assume all expenses have been adjusted for inflation and will stay constant in dollar terms until the couple retire.

Assume the couple both have 9.5% employer superannuation until their retirement.

Annual Budget Sheet

Regular Commitments

$

Mortgage repayments .......................................

18,000

Rates ............................................................

1,260

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

1,350

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

2,500

Pay television/Internet ........................................

1200

Insurance - home/contents ..................................

550

School fees and related expenses ...........................

7,500

Insurance - car ................................................

475

Private health insurance .....................................

3,000

Credit cards .....................................................

15,000

Loans ...........................................................

5,000

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

8,000

Car registrations .............................................

1050

Public transport ...............................................

2,500

Annual deposit to Jason's managed fund.................

2,000

Other expenses

 

Food ............................................................

8,000

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

4,500

House maintenance ..........................................

3,500

Medical/Dental expenses.....................................

2,000

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

2,500

Clubs/Prof. Memberships ...................................

1,000

Gifts - Birthdays/Christmas .................................

3,500

Total ............................................................

94,385

Required:

2A) Calculate the Sandra Barlow's and Jason Barlow's annual income after tax and Medicare.

You can exclude income earned from the combined savings and Jason's managed fund.

Assume that the Barlows' Private Health Insurance has the tax rebate included in the premiums.

2B) Calculate the amount of combined funds Jason and Sandra will accumulate for their retirement. This will include their actual savings according to:

  • their annual budget;
  • Jason's managed fund and;
  • their 9.5% superannuation contributions.

You can show these as separate calculations. Use an excel spreadsheet to show calculations on a yearly basis up to the time of the Barlow's retirement age.

Assume a real rate of return of 4% for saving, managed funds and superannuation.

For ease of calculation, assume their savings, managed fund savings and superannuation contributions are made at the end of each year.

You can assume the Barlows have the correct amount of tax deducted from their gross earnings and do not need to pay more tax (or receive a tax refund) for each year until their retirement.

You can use a spreadsheet to make the calculations or use the relevant future value formulas below:

Future value - FV = PV(1 + i)n    

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

2C) Using all the information provided, comment on the key issues the Barlow's need to consider in planning for their retirement.

TAX RATES & FORMULA SHEET-

Income Tax Rates

Taxable income

Tax on this income

$1 - $18,200

Nil

$18,201 - $37,000

$0 + 19% of excess over       $18,200

$37,001 - $80,000

$3,572 + 32.5 % excess over $37,000

$80,001 - $180,000

$17,547 + 37% excess over  $80,000

$180,001 and over

$54,547  + 45% excess over $180,000

The above rates do not include the Medicare levy of 2%

Other Tax Rates

Complying superannuation fund.             15%

Non-complying superannuation fund.    45%

Fringe Benefits (Effective 1 April 2014)   47 %

Company Tax     30%

Friendly Society & Life Insurance Bonds 30%

Tax Rates for Minors     

Taxable Income

Tax Payable

$0 - $416

Nil

$417- $1,307

68% of each $1 over $416

$1,308 +

47% on total amount

Medicare Levy:

Medicare Levy is paid at 2% of taxable income.

A Medicare Levy does not need to be paid if taxable income is equal to or less than $20,896 ($33,044 for seniors and pensioners). Only part of the Medicare Levy is paid if your taxable income is between $20,896 and $26,121. ($33,044 and $41,306 for seniors and pensioners).

 A family is exempt from Medicare Levy if they earn less than A$ $35,261and, this is increased by $ 3,283 for each dependent child. Only part Medicare Levy is paid by a family whose income is between A$ $35,261and $44,076, increasing by $4,047 for each dependent child.

Medicare Levy surcharge of up to additional 1.5% of taxable income is payable where taxpayer does not have private health insurance.  Here is how the surcharge is calculated based on income.

Income thresholds and MLS rate

 

Unchanged

Tier 1

Tier 2

Tier 3

Singles

$90,000 or less

$90,001 -

$105,000

$105,001 -

$140,000

$140,001 or more

Families

$180,000 or less

$180,001 -

$210,000

$210,001 -

$280,000

$280,001 or more

Medicare levy surcharge rate

0%

1%

1.25%

1.5%

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91765049
  • Price:- $60

Priced at Now at $60, Verified Solution

Have any Question?


Related Questions in Basic Finance

Question utilizing the concepts learned throughout the

Question: Utilizing the concepts learned throughout the course, write a Final Paper on one of the following scenarios: • Option One: You are a consultant with 10 years experience in the health care insurance industry. A ...

Discussion your initial discussion thread is due on day 3

Discussion: Your initial discussion thread is due on Day 3 (Thursday) and you have until Day 7 (Monday) to respond to your classmates. Your grade will reflect both the quality of your initial post and the depth of your r ...

Question financial ratios analysis and comparison

Question: Financial Ratios Analysis and Comparison Paper Prior to completing this assignment, review Chapter 10 and 12 in your course text. You are a mid-level manager in a health care organization and you have been aske ...

Grant technologies needs 300000 to pay its supplier grants

Grant Technologies needs $300,000 to pay its supplier. Grant's bank is offering a 210-day simple interest loan with a quoted interest rate of 11 percent and a 20 percent compensating balance requirement. Assuming there a ...

Franks is looking at a new sausage system with an installed

Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped ...

Market-value ratios garret industries has a priceearnings

(?Market-value ratios?) Garret Industries has a? price/earnings ratio of 19.46X a. If? Garret's earnings per share is ?$1.65?, what is the price per share of? Garret's stock? b. Using the price per share you found in par ...

You are planning to make annual deposits of 4440 into a

You are planning to make annual deposits of $4,440 into a retirement account that pays 9 percent interest compounded monthly. How large will your account balance be in 32 years?  (Do not round intermediate calculations a ...

One year ago you bought a put option on 125000 euros with

One year ago, you bought a put option on 125,000 euros with an expiration date of one year. You paid a premium on the put option of $.05 per unit. The exercise price was $1.36. Assume that one year ago, the spot rate of ...

Common stock versus warrant investment tom baldwin can

Common stock versus warrant investment Tom Baldwin can invest $6,300 in the common stock or the warrants of Lexington Life Insurance. The common stock is currently selling for $30 per share. Its warrants, which provide f ...

Call optionnbspcarol krebs is considering buying 100 shares

Call option  Carol Krebs is considering buying 100 shares of Sooner Products, Inc., at $62 per share. Because she has read that the firm will probably soon receive certain large orders from abroad, she expects the price ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As