Financial Condition of a Fortune 500 Company

Financial Planning Case Study SPRING 2016

This subject introduces you to many aspects of the financial planning industry including regulation, products, tax issues and client relationships.  The Case Study detailed below has discrete questions that match the topic areas.  The assignment can be (and is encouraged to be) completed sequentially and the open ended nature of many of the questions will allow to demonstrate your understanding of the material.  You will need to make (and justify) several assumptions in this case study.

Students can complete the case study individually or in groups of up to four people.  If there is a dispute in any group then assignments will need to be completed individually.

Students should submit two files on canvas and all files (including excel) will be checked for plagiarism.

1. Word document:
   • Title page must include the course title, student names, student’s signatures, student’s ID numbers
   • Executive summary outlining some of the recommendations in your report
   • The answers to each of the eight questions (clearly marked) must be complete and not refer to excel spreadsheet (excel is only submitted as a supporting document).
   • Any assumptions need to be justified with supporting evidence where appropriate.
   • A reference section where all sourced material, including direct quotations must be appropriately acknowledged. Websites should also be referenced where material is incorporated (in any form) in your assignment.
   • Professionally presented (the use of colour and graphs is encouraged)
   • Documents should not exceed 25 pages in total (including title page and references).
   • Marks may be deducted for late submissions of assignments after the due date. This will account for 10% per day.

1. Excel spreadsheet:

• You should also provide a supporting spreadsheet showing your calculations.
• Each worksheet should be clearly labelled with the question number

Case study:

You are an ASIC registered financial advisor operating as an authorised representative of an AFS licensee with Universal Financial Planning (UFP) Pty Ltd.  Two new clients, Rodger (male 56) and Diane (female 55) have approached you  seeking some advice.  They are a married couple with two adult children (Julia, female, 23 and Michael, male, 21).  Their personal and financial information is detailed in the attached file notes.

They have come to you for advice on a number of issues:

1. Rodger and Diane were self employed for many years but their business closed in 2019 and they have had to find to salaried positions.
2. They tried to keep the business operational and incurred a significant credit card debt trying to keep it afloat.
3. They are often stretched each month to pay the credit card minimum payment, the mortgage and their car loans.
4. Julia and Michael, the couples adult children live at home with Rodger and Diane and don’t appear to have any plans to move out.   Rodger and Diane would like to ensure that the adult children are protected should either or both of them die prematurely.
5. Rodger and Diane only contribute the minimum amount to superannuation and they are concerned about their ability to fund their retirement. They recently saw an advertisement on TV that showed cryptocurrencies as a stable way  to fund their retirement and would like to consider this as an option.
6. Neither Rodger or Diane have any experience in investments

Question 1:

You have an initial meeting with Rodger and Diane, collect a range of information (see attached file note), outline your services and what you hope to achieve for them.  Outline the documents you need to provide them in the initial meeting.

The couple ask you to explain how you would be remunerated, whether you would receive any conflicted remuneration and what guarantees you will give them to put their interests first.

Question 2:

Rodger and Diane have been approached by a former client.  The client, Bill, would like to use Rodger and Diane’s business structure to run a number of large transactions.  Rodger and Diane’s company possesses no significant assets and no longer performs any operations.  Bill has asked Rodger and Diane to invoice him for $9,000 per month for consulting services.   Bill will pay the invoice in cash.  In return Bill will invoice Rodger and Diane for $7,000 in consulting services and they will pay him by bank transfer.  Bill says that this is a quick and risk free way of earning $2,000 per month. What advice would you offer Rodger and Diane?  What are your AML/CTF obligations in this situation?

Question 3:

Rodger and Diane have a limited understanding of financial affairs and are struggling to grasp the importance of long term investing for retirement.  In the last year they were only contributed the superannuation guarantee amount to their super.  You would like to them to consider the following options:

1. Contributing the superannuation guarantee only
2. Contributing a further $3000 every second year in addition to the superannuation guarantee
3. Contributing a further $30,000 as a lump sum today in addition to the superannuation guarantee

Illustrate to the couple the expected value of these investments at retirement.  Ignore taxes in this illustration and be specific about any assumptions (e.g. growth and inflation rates).

Question 4

Rodger and Diane have discussed their desire to reduce their credit card debt.  Conduct an analysis of their current financial position (including financial statements and projections) and suggest a strategy to reduce their short term debt and illustrate the impact on their financial analysis if the strategy is implemented.

Question 5

Provide an analysis of Rodger and Diane’s current asset allocation and analyse whether this matches the allocation suggested for their risk profile.    Suggest a strategy (and provide an analysis) to adjust their asset allocation to more accurately reflect their risk profile and retirement objectives.  Estimate the expected rate of return for the new asset allocation and use this growth rate to adjust your figures in question 3 and provide an updated illustration to your clients.

 

Question 6

One of Rodger and Diane’s concerns is their ability to provide for the family if either parent was to fall ill or die prematurely.  Conduct a risk management assessment and suggest a strategy to alleviate these concerns.

 

Question 7

Rodger has been offered a position with an advertised gross salary of $90,000 plus the superannuation guarantee.   Calculate Rodger’s tax payable if he takes the new role.    Assume that he also receives dividend income of $290 from the Qantas shares.

 

Question 8

Consider your projected superannuation balances in question 3.  Illustrate to Diane and Rodger whether they will be eligible for the aged pension under these scenarios if they withdraw their superannuation balance as a lump sum and invest in a balanced managed fund (use today’s pension rates and limits and their expected retirement ages).  In addition to their superannuation assets, assume at retirement age they each earn $10,000 p.a. in after tax income from an investment property worth $300,000.  Illustrate to Rodger and Diane how the combination of investment income and aged pension will provide for their living expenses in retirement.

Personal Details

 

Personal information	Client A	Client B
Title	Ms	Mr
Given Name	Diane	Rodger
Surname	Kennedy	Erickson
Gender	Female	Male
DOB	25 March 1965	24 July 1964
Age	55	56
Marital Status	Married	Married
Home Address	123 Ruby Lane, Smithfield	Same as A
Contact number	0411 XXX XXX	0422 XXX XXX
Email address	Diane_K@Kmail.com	Rodger_E@Kmail.com
Children (details and notes)	Julia, female, 23 Michael, male, 21	Same as A
Health
Personal health details	Good health, non-smoker	Good health, non-smoker
Family health history	Poor – cancer and dementia	Fair
Will in place	Yes	Yes
Power of attorney in place	Yes (Rodger)	Yes (Diane)
Employment details
Primary role	Administrator	Sales assistant
Years in the role	1	1.5
Type (FT/PT/SE)	Full time	Full time
Leave balance	1 week	2 weeks
Retirement planning
Intended retirement age	69	70
Retirement income needs	Moderate income	Moderate income

Financial Details (at 29/08/2014)

 

After tax Income	Combined
Primary employment Diane	$65,000
Primary employment Rodger	$75,000
Dividends from Qantas shares (Rodger)	$290 (50% franked)
Expenses
Basic needs	$95,000
Entertainment and travel	$35,000
Mortgage, loan and credit card repayments	$94,320
Non-superannuation Assets
Home and contents	$1,150,000
Cash in savings account	$2,000
Cars (2)	$32,000
Qantas shares (Rodger)	$28,000
Superannuation Assets
Diane (Australian Super Socially aware)	$30,000
Rodger (Australian Super High Growth)	$20,000
Liabilities
Mortgage	$450,000
Car loans	$22,000
Credit Card	$27,000
Insurance
Life insurance Diane (inside super)	$100,00
Life insurance Rodger (inside super)	$75,000
Private Health cover Diane	None
Private Health cover Rodger	None

 

Notes:

Rodger was bought Qantas shares on the advice of a friend in 2002.  They were valued at $30,000 in October 2019.

Risk Profile

 

Using UFP’s Risk Profiling questionnaire Rodger and Diane were assessed as following and we walked them through their outcomes.  We also provided them with likely scenarios using historical returns and explored alternative asset weightings.

Rodger’s personal attitude to risk and his long investment horizon place him as in the conservative category. Rodger’s income is slightly unstable and insecure and he doesn’t have any experience or training in financial products.  When shown the historical risk and return characteristics of various funds Rodger tended to focus solely on the negative returns.  His answers indicated that he could personally tolerate a 15% decline in capital value.

Diane’s personal attitude to risk place her in the aggressive category.  She has some knowledge of accounting and this helped with her grasp of investment structures.  When shown the historical risk and return characteristics of various funds Rodger tended to focus solely on the high returns and was interested in how to capture these in the future.

Superannuation

 

Rodger and Diane both recently opened superannuation accounts with Australian Super.  Neither remembered what investment option they chose but their statements reveal that Rodger is in a Super High Growth strategy and Diane is in a Socially Aware strategy.  In 2019 they only contributed the superannuation guarantee amount.

 

 

 

Business Forecasting Method

Consider you need to conduct a business forecast (choose any business with using table and number for analysis and evaluation). Describe your forecast process according to the steps listed below. Please make sure to describe all steps in the context of your problem. Your essay should have a minimum of 300 and a maximum of 800 words. You can make use of figures and/or charts as you see fit to help explaining your writing.

Steps are:

1. Define the purpose of the forecast.
2. Establish a time horizon.
3. Select a forecasting technique.
4. Gather and analyse relevant data.
5. Perform the forecasting process.
6. Evaluate the results.

Accounting Theory and Standards

KARRICK Gold & Copper Ltd. (KGC Ltd), an Australian mining firm listed on the

Australian Stock Exchange (ASX), has been operating a large Open Cast (Pit) gold and copper mine in the Star Mountain Range in Papua New Guinea (PNG) for 30 years. The

Star Mountain Range in PNG is very isolated (no roads) and has a wide range of exotic plants and animals found nowhere else in the world.

Other Information—KGC Ltd. has:

1) Revenues of $30 billion Australian dollars (AUD) a year and, in the absence of new ore finds, has only seven years of ore reserves.

2) The Net Book Value (NBV) of the PP&E is $16.5 billion AUD and another $5.0 billion

AUD is needed over the next seven years.

3) There is no active prospecting for additional reserves of ore—because the firm’s current license from the PNG government to mine in that region will expire in eight years.

4) While there have been several rich “shows” of silver and lead ore,

1 nothing so far is of commercial quantity and quality. However, the mine manager expects that over the next eight years large deposits of commercially-viable silver-and-lead ore will be found within the mine property or adjacent.

5) The KGC Ltd. employs 3,400 full-time employees in its PNG mine, offices, and processing plant—3,000 are PNG citizens and reside in the Star Mountain Range. The labourparticipation rate in that region of PNG is 32 percent and the unemployment rate (among those 32 percent) is 45 percent.

NB: If KGC Ltd. shuts down its mining operations in the Star Mountain Range in PNG, the unemployment rate among the 32 percent participating in the labour market will rise to 95 percent and there are few if any alternative sources of employment.

6) The KGC Ltd. PNG operations pay $4 billion in royalties to the traditional owners of the land where they mine and process ore and $6 billion in taxes to the PNG government. Also, they built and operate the only water-processing plants, grade schools, hospitals, and health centres in the Star Mountain Range in PNG.

 

 

1 A “show” of a mineral is a small finding of noncommercial amounts. A show of a mineral is a strong indicator that there may be commercial amounts of the ore but is not definitive.

HI6026 ACCOUNTING THEORY & CURRENT ISSUES

TRIMESTER 1, 2016

GROUP ASSIGNMENT

Assessment Value: 20%

Instructions:

7) In the last few decades, the Christian-animist residents of the Indonesian half of the Island of

New Guinea (the Indonesians call their half of the island “Irian Jaya” or “Papua”) have been agitating for independence from Indonesia (it is estimated that 100,000 of them have died in the conflict and some of the tribes have resumed headhunting with the Indonesian soldiers and settlers being targeted. The PNG tribes near the border with Papua are closely related to the tribes across the border and there is fear the conflict and the police actions by the

Indonesian army will spill into the PNG portion of the Star Mountain Range.

8) A recent collapse of a “tailings” pond dumped 5 million litres of ore-waste sludge into a river from which two local villages draw their drinking water, fish, hunt, harvest lotus root and water their taro root, yam and cassava crops.

2 While most of the sludge flushed through to the ocean in a few days, many environmental groups in Australia are screaming that KGC Ltd. is environmentally irresponsible. The complaints got especially loud and strident after the General Manager of the PNG mine stated at a public meeting: “First) The sludge will quickly flush out to sea; Second) “At sea the sludge will be vastly diluted; Third) The solution to pollution is dilution; Fourth) The peoples of the Star Mountain Range in PNG depend on the KGC Ltd. operations for most of their jobs, clean potable water, health care, and education”

9) The cost of remediating the sludge spill (i.e. a combination of clean-up, fines, offsetting work elsewhere, and compensating cash payments) is expected to range between $6 billion and $60, billion, depending on the outcome of a court case in PNG that has been initiated by an ecological group from Australia. Please note: KGC Ltd. is claiming that the annual benefits of the KGC Ltd. operations in the Star Mountain Range in PNG offset the harm of the mining and processing (including the rare sludge spill) by manyfold and that should the mine be shutdown, the loss to that region and PNG in general would be devastating.

While this case study is adapted from real events and circumstances, names have been changed to protect the innocent and to avoid lawsuits.

 

 

 

Please answer the following questions using the above information and supplementing it (as needed) with information from the course, the internet, and other literature. Marks will be awarded for clarity of thought and succinctness of presentation.

 

 

Required Marks

1. a) Should KGC Ltd. revalue its major PPE assets from historic cost to fair market value?

(Discuss the principles, potential issues and risks). 30

20. b) The PP&E is estimated to have a replacement value of $20.5 billion AUD and a value in use of $12.0 billion AUD under current expected operations (i.e. five years) but rises to $30 billion AUD if the contract is renewed for 10 years in addition to the current seven years and new viable ore bodies are found. What is the “True and Fair” value of the PP&E? (Explain).

40

1. c) Discuss the merits and risks of KGC Ltd. including a “Triple Bottom Line” aspect to its reporting approach 30
2. d) Discuss the nature of “Legitimacy” and the importance of KGC Ltd. Maintaining legitimacy in the eyes of the traditional land-owners, the government of PNG, and the people of Australia. 20

e)

Is the “Legitimacy” of KGC Ltd. at risk and what consequences that KGC Ltd. May suffer if it loses “Legitimacy”. 30

1. f) Discuss how KGC Ltd. can restore its legitimacy (include a section on the two types of stakeholder theory in this discussion). 20
2. g) List the various ways that KGC Ltd. could record the cost of the harm associated with the sludge spill in its GPFS, discuss the pros-and-cons of each method, choose a method and defend your choice.3

30

200

2 The sludge in the tailings ponds of mines are typically acidic and have toxic levels of mercury, arsenic, and other nasty metals. While the toxicity is relatively low, long-term exposure can create serious chronic health issue.

3 Pros-and-cons = the arguments in favour of and against a method, argument

Taxation Theory Practice and Law Questiosn and Answers

Case study 1: Residence and source

Fred, an executive of a British corporation specializing in management consultancy, comes to Australia to set up a branch of his company. Although the length of his stay is not certain, he leases a residence in Melbourne for 12 months. His wife accompanies him on the trip but his teenage sons, having just commenced college, stay in London. Fred rents out the family home. Apart from the absence of his children, Fred’s daily behavior is relatively similar to his behavior before entering Australia. As well as the rent on the UK property, Fred earns interest from investments he has in France. Because of ill health Fred returns to the UK 11 months after arriving in Australia.

Requirement

Discuss whether Fred is a resident of Australia for taxation purposes. ( 4 Marks, maximum 500 words)

Case study 2: ordinary income

Explanations of the respective outcomes reached by the courts in the following cases which all involving sales of land

1. Californian Copper Syndicate Ltd v Harris (Surveyor of Taxes) (1904) 5 TC 159
2. Scottish Australian Mining Co Ltd v FC of T (1950) 81 CLR 188

III. FC of T v Whitfords Beach Pty Ltd (1982) 150 CLR

1. Statham & Anor v FC of T 89 ATC 4070
2. Casimaty v FC of T 97 ATC 5135
3. Moana Sand Pty Ltd v FC of T 88 ATC 4897

VII. Crow v FC of T 88 ATC 4620

VIII. McCurry & Anor v FC of T 98 ATC 4487

(16 marks, max. 2000 words).