Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

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

Mcconnell corporation has bonds on the market with 185

McConnell Corporation has bonds on the market with 18.5 years to maturity, a YTM of 7.9 percent, a par value of $1,000, and a current price of $1,067. The bonds make semiannual payments. What must the coupon rate be on t ...

Thanks for starting out the discussion on financial

Thanks for starting out the discussion on Financial Leverage. It is taking on Debt and Interest payments for a business. Debt is not a bad thing but too much debt can be a bad thing. How does this relate with Financial L ...

Describe a bank accepted bill and explain the role of the

Describe a bank accepted bill, and explain the role of the acceptor, payee, drawer and discounter, in the context of bank accepted bills.

Your cousin is currentlynbsp10nbspyears old she will be

Your cousin is currently 10 years old. She will be going to college in 8 years. Your aunt and uncle would like to have $90,000 in a savings account to fund her education at that time. If the account promises to pay a fix ...

Assume that the current yield on a one-year security is 60

Assume that the current yield on a one-year security is 6.0 percent and that the yield on a two-year security is 7.2 percent. For this question, assume that there is a liquidity premium on a two-year security of 0.4 perc ...

You have just leased a car that has monthly payments of 365

You have just leased a car that has monthly payments of $365 for the next 4 years with the first payment due today. If the APR is 6.84 percent compounded monthly, what is the value of the payments today? $13,979.07 $15,3 ...

Sidney took a cash advance of 300 by using checks linked to

Sidney took a cash advance of $300 by using checks linked to her credit card account. The bank charges a cash advance fee of 4 percent on the amount borrowed and offers no grace period on cash advances. Sidney paid the b ...

How does the bid-ask spread affect market orders vs limit

How does the bid-ask spread affect market orders vs limit orders? (Does it related to a narrow/wide spread?)

Question - how is cash flow different than net income what

Question - How is cash flow different than net income? What are some items included in the cash flow statement that are not included in the profit and loss statement? Write a 3-6 paragraph response to the above question( ...

Genetic insights co purchases an asset for 10797 this asset

Genetic Insights Co. purchases an asset for $10,797. This asset qualifies as a seven-year recovery asset under MACRS. The seven-year fixed depreciation percentages for years 1, 2, 3, 4, 5, and 6 are 14.29%, 24.49%, 17.49 ...

  • 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