Xplan software Report

LearningOutcome Details

Unit Learning Outcome (ULO)Graduate Learning Outcome (GLO)
ULO 1: Communicate with clients effectively to obtain personal information, including negation where appropriate.GLO1, GLO2, GLO3, GLO4, and GLO5
ULO2:Analyse and critically evaluate a comprehensive set of client circumstances as it applies to satisfying the needs and objectives of a client.
ULO3:Construct a compliant comprehensive Statement of Advice (SOA) via a popular financial planning software program to meet client requirements in an ethical and professional manner.
ULO 4: Present and defend financial planning recommendations.

Description / Requirements

PART A – Written presentation requirements.

  • Prepare a comprehensive SOA to industry standards based on the client scenario provided.
  • The SOA should be submitted electronically as threedocuments:
    • The firstdocument is the Client Fact Finder which mustbecreated in XPLAN.
    • The seconddocument that you are requiredto submit are the insurance quotes using XPLAN.
    • The third document is your SOA which will be in the form of a Word document. Where Excel data is used within this Word document it should be pasted into the document using – Paste Special/Microsoft Excel Worksheet Object. Appendices to the SOA are recommended.
  • The SOA should be directed to the clients, in the first person.
  • You are free to generate as much of your SOA using XPLAN as you wish. However, students will be penalised where standard wording from templates such as XPLAN are simply copied into their SOA.
  • All pages must have a footer which includes the student ID and page numbers e.g. page 4 of 8.
  • All text based/Word information should in a 12-point Calibri font with a minimum line spacing of

1.15. The assignment should have standard left and right and top and bottom margins.

  • Recommendations must be made based on real products, quotes, and prices that you have researched. Finding accurate and detailed insurance quotes through the internet can be difficult, and accordingly it is required that you use XPLAN Risk Researcher to assist with this task. Finding suitable superannuation products on the web is less difficult nonetheless the XPLAN WealthSolver may assist with this task.
  • You can assume that the client has been provided with a Financial Services Guide (FSG). Where you recommend a product/service for which a PDS is available on the web you should reference the relevant URL.
  • The SOA is limited to 4,500 words in length. The word count excludes the Client Fact Finder,

insurance quotes and any appendices. All general information, projections etc must be in the appendix section.

  • You must address all the clients’ objectives in the SOA. The general advice on aged care should be addressed in detail in the appendix section.

Client Scenario

Adam and Clare McKenzie 100 Janson Court,

Doncaster VIC 3108

Introduction

Adam and Clare approach your financial planning practice for some advice. The couple are aged in their 50’s and expect to work until they turn 65 years of age, but both would like to be in a position to be able to retire when Adam turns 63. The couple own investments held outside of superannuation as well as their superannuation accounts. The couple have seen a financial planner previously who has now retired, and they were introduced to you by your client.

Personal details

Clare is aged 51 (DOB 01/01/1971) and Adam is aged 54 (DOB 03/04/1968). The couple have been married for 15 years.

Adam is a Software Engineer and earns an income of $200k. The following are his employer super contributions for the past 3 financial years:

FY19 – $19,000 FY20 – $19,000 FY21 – $20,000

Clare is a Dentist and earns a salary of $150,000 working 3 days a week. She had taken time off work when the children were younger and is slowly transitioning back to work. She is open to working 4 days per week if necessary. The following are her employer super contributions for the past 3 financial years:

FY19 – $14,250 FY20 – $15,000 FY21 – $15,000

Both Adam and Clare do not currently salary sacrifice or make any additional contributions to super.

Clare and Adam have 3 children – Carly age 12 who is in year 7, and Zack and Mack, twins aged 10 who are in Year 5 this year. They all attend a nearby public school and will continue public school for their secondary school years.

Both Adam and Clare are in good health and are non- smokers.

The couple have lived in their family home for the past 15 years. The house cost them $850,000 and is currently worth $1,600,000. The couple took out a mortgage for $650,000 at the time of purchase.

The couple are making the minimum mortgage repayment each month. Their contents are worth around $120,000 and they have 2 cars. One car (a BMW X5) is used by Adam to commute to work and is worth $90,000 (owned by Adam) and the other car driven by Clare is a Toyota Kluger worth around

$30,000.

The couple also own two investment properties worth $1,800,000, they borrowed $1,300,000 for the investment properties, and own a share portfolio.

Apart from the property loans, they have a portfolio loan secured against their principal place of residence that was used to purchase the share portfolio. The only other liability the couple have is a credit card that typically has around $10,000 owing but is normally paid off at the end of each month to avoid an interest charge. All property loans are held with the Bank of Melbourne.

Clare’s mother lives close to them. She is 80 years old and have just been diagnosed with Dementia. They will have to place her in an Aged Care facility for better care. She is on aged care pension and has

$300k in financial assets (Term Deposit and Cash). Her house is worth $800k. She has no other assets. The couple’s financial details are provided below:

Item & DetailOwnershipMarket valueAnnual Return
Investment property – Lilydale (acquired in August 2018 for net $700,000)Clare$800,000Rent $20,000
Investment property – Diamond Creek (acquired in December 2020 for net $900,000)Adam$1,000,000Rent $30,000



(Rent for both



properties are



after all



expenses



except



interest)
Shares


National Australia Bank (NAB): 1,000 shares originally acquired in Aug 2020 for $17.80 each Australia New Zealand Bank (ANZ): 2,000 shares originally acquired in Dec 2018 for $24.64 eachJoint
?
?
Dividends of 3.5 % on market value
– Westpac Bank (WBC): 1,000 shares originally acquired in September 2015 for $29.99 each
?
Note: Bank account balance at 1st Apr 2022 held with Bank of Melbourne was $120,000. It is in an offset account offsetting the loan on their principal place of residence.

Xplan software Report

Liabilities

LoanAmount OutstandingOwnershipInterest RateRepayment
Home mortgage$500,000Joint2.95% p.a.$32,000 p.a. (principal & interest – 30 year term)
Investment property loan –Lilydale$570,000Clare2.99% p.a.$30,000 p.a. (principal & interest 30-year term)
Investment property loan – Diamond Creek$700,000Adam2.99% p.a$40,000 p.a (principal & interest 30 year term)
Portfolio Loan – Share portfolio$50,000Joint3.00% p.a.$8,000 p.a (principal and interest 10 year term)
Car Loan – BMW X5$70,000Adam5.00%$12,000 p.a (principal and interest 5 year term and balloon payment of $25,000)

Superannuation

Super FundAmountCostsReturnsTaxable componentInvestment Option / Asset allocationDeath Benefit Nomination
IOOF Personal Super -Adam SG contributions are paid into this fund
$420,000

ICR 1.07%pa

5-year average return of 7% pa

100%

Multimix – Growth Trust (IOF0097AU)

No nomination made
IOOF Personal Super -Clare SG contributions are paid into this fund
$230,000

ICR 1.07% pa

5-year average return of 7% p.a.

100%

Multimix – Growth Trust (IOF0097AU)

Non-binding nomination made to Adam

Insurances

The couple have the following personal insurances in place:

Policy typeAmount of coverPremiumComments
Life and TPD$1,000,00 – any occupation TPD$2,300 p.a. steppedClare – PPS Mutual and paid from IOOF Super
TPD$1,000,000 -own occupation TPD (linked to TPD in super)$700 p.a. steppedClare – PPS Mutual and paid from bank account
Life and TPD$1,300,000 – Any occupation TPD$2,200 p.a steppedAdam – BT Insurance and paid from IOOF Super

The couple hold private health insurance, including hospital cover and extra’s, with Bupa Health Insurance. They also have home, contents, and motor vehicle insurance policies. They do not have Trauma and Income Protection insurance.

In the event of their premature death or total or total and permanent disability (TPD), the couple would like all their debts paid out and provide funding to cover the family’s living costs, at least until the children turn 25. Funeral and medical costs can be assumed to be $20,000. Both Adam and Clare have 8 weeks of annual and long service leave outstanding. They would like to have ongoing income in the event of an illness or accident that may prevent them from working. Whilst they have private health cover, they would like a lump sum in the event of a serious illness.

Expenses

Home MortgageSee liability table
Investment property loanSee liability table
Portfolio LoanSee liability table
Car LoanSee liability table
All Household expenses (e.g. groceries, utilities, rates, general insurance)$70,000
Children related costs – Tuition and other activities$30,000
Travel and entertainment$30,000
Private Health Cover$4,500
TPD Insurance$700
Donations to registered charities$1, 500 each per year

EstatePlanning

The couple each have a basic Will in place that was prepared in 2010. They don’t believe it contains any provisions for a financial or medical Power of Attorney. Clare has the POA – both financial and medical plus advance care directive for her mother.

Xplan software Report

Risk profile

You speak to the couple about asset allocation and risk and return and ask the couple several questions to ascertain their likely risk profile. Both Adam and Clare take an interest in financial markets, and they suppose that they are happy with a growth portfolio. They do not have much time to manage their investments and want a portfolio that is well diversified. Both believe that minimising tax and keeping pace with inflation are important considerations with their investments. After completing a risk profile questionnaire and detailed discussions with the clients, they accept that around 75-85% of their portfolio should be invested in growth investments if they are to retire with a reasonably comfortable lifestyle.

Client objectives & concerns

  • Ensure their super fund is well diversified, appropriate for their risk profile, have investment choices when it comes to managed funds, is cost effective, have transparency in costs and has the option of paying for ongoing advice from super.
  • They want to minimise tax
  • Review their investments both in and outside super. They want appropriate diversification.
  • They want to set aside $50,000 for a home renovation next year
  • They want to give each child $75,000 when they reach age 25 for a home deposit and seek advice on a suitable investment product
  • Always hold $20,000 cash on hand for emergencies
  • Ensure they have appropriate personal insurance cover in place – in terms of adequacy, comprehensiveness, and cost effectiveness.
  • Plan for their retirement – they would both like to be able to retire when Adam turns 63. They would like to have a combined income of $70,000 p.a. (roughly 50% each) in real terms or today’s value (indexed to inflation) although if required, they could work for a few more years to maximise their retirement nest egg.
  • They want to pay off their home loan at retirement and are open to either keeping or selling their investments.
  • Clare seeks general advice on how to best manage and structure her mom’s financial assets in

anticipation of placing her in aged care.

https://download.asic.gov.au/media/ywsgxnxe/attachment-to-info-267-published-1-december-2021.pdf

Other information

  • The client is not interested in advice relating to any future social security entitlements
  • You have provided the client with a copy of your FSG.
  • You are an authorised representative of a practice called You’ll Never Walk Alone Financial Planners. You arelicenced under “Quadruple” – AFSL number 361892
  • Your remuneration model consists of the following:
    • preparation of a SOA: flat fee of $4,000 plus GST
    • ongoing fee: flat fee of $3,300 p.a. including GST
  • Your licensee has an Approved Product List (APL) which includes anything that has a research rating of “Recommendation / 3+ stars” and above. The IOOF funds and insurance are listed on the APL.
  • The couple’s expenses can be assumed to increase by the CPI (assume 2% p.a.). Their income is expected to be relatively stable and unlikely to increase in the medium term. The couple’s shares and properties can be assumed to increase by 4% p.a. and 2% p.a.
  • Assume long-term returns in pension phase will be 5.5% p.a. after fee
Universal Assignment (September 28, 2022) Xplan software Report. Retrieved from https://universalassignment.com/xplan-software-report/.
"Xplan software Report." Universal Assignment - September 28, 2022, https://universalassignment.com/xplan-software-report/
Universal Assignment May 28, 2022 Xplan software Report., viewed September 28, 2022,<https://universalassignment.com/xplan-software-report/>
Universal Assignment - Xplan software Report. [Internet]. [Accessed September 28, 2022]. Available from: https://universalassignment.com/xplan-software-report/
"Xplan software Report." Universal Assignment - Accessed September 28, 2022. https://universalassignment.com/xplan-software-report/
"Xplan software Report." Universal Assignment [Online]. Available: https://universalassignment.com/xplan-software-report/. [Accessed: September 28, 2022]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Get 45%* OFF on Assignment Help

Popular Assignments

VU22977 – Practice in a Legal Environment

Advanced Diploma of Legal Practice – 22565VIC PORTFOLIO- CLIENT MATTER FILE Assessment task 1 Prepare a comprehensive portfolio of documents to create a Client Matter File which must include: Element 1 Area of law Cover sheet stating client name and short description of legal matter Client Instruction Sheet, Costs Agreement

Read More »

KIT714 ICT Research Principles: Assignment 1

Practical Qualitative Research Exercise                                                                                                                                         Type:                 In-Semester, Individual Assignment Task Length:   minimum 2,000 words Weighting:     20% of total assessment for this unit Due Date:       Friday 5 August 2022 – 11:55 pm (Week05) Submission:    electronic submission on MyLO (WORD or PDF) Description:    This practical exercise will engage students in a qualitative research

Read More »

MODULE 44-704463 Dissertation Help

ASSESSMENT CRITERIA Dissertation (12,500 words) Deadline: JULY 29th 2022, 3pm Introduction and abstract  Situates the research question within the, theory, and concepts Explains the value of the study.  Relevance of the research question, to the field of study is fully justified. Leads logically into the Literature Review. Abstract of professional

Read More »

ITECH1103-Assignment: Assignment 2: Analytics Report

Overview The purpose of this task is to provide students with practical experience in writing a data analytical report to provide useful insights, patterns, and trends in a chosen dataset in the light of a set of tasks required within this document. This dataset will be chosen from the UC

Read More »

PBHL20001 Term 1, 2022 – Supplementary Assessment

PBHL20001 Term 1, 2022 Supplementary Assessment The influenza pandemic that followed World War I and took place over the period from 1918-1920 resulted in an estimated 100 million deaths worldwide and 500 million infections. In addition, this pandemic had a significant impact on public health practice throughout the 20th century

Read More »

Community Health Project 1 (HLTH 3058): Assessment 2: Portfolio Task 2

Community Health Project 1 (HLTH 3058) Assessment 2: Portfolio Task 2 – Evaluative Framework Marking Guide Weighting: 15% the total grade for the course   Criteria Outstanding performance (75-100%) Exceeds core requirements (65-74%) Meets core requirements (50-64%) Does not meet requirements (<50%) Comments Content (70%) Demonstrates adequate knowledge of integrating

Read More »

Community Health Project 1 (HLTH 3058): Assessment 2: Portfolio Task 1

Community Health Project 1 (HLTH 3058)Assessment 2: Portfolio Task 1 – Ethical Considerations Marking GuideWeighting of 15% the total grade for the course Criteria Outstanding performance (75-100%) Exceeds core requirements (65-74%)   Meets core requirements (50-64%) Does not meet requirements (<50%) Comments CONTENT (80%) Ethical Considerations   Demonstrates adequate knowledge

Read More »

SAM 11486/SAM G 6677: Assignment 1 – Individual

Assignment 1 – Individual (25%) Report Due: 11:59pm Sunday Week 5 04/09/2022 This assignment will be marked out of 25 marks and is worth 25% of the overall mark for the unit. Please check the unit outline for late penalties and restrictions on late submissions. This assignment is an individual

Read More »

11486 Systems Analysis and Modelling

Assignment Case Study C – Feed Me Now Disclaimer: The situation described in the following case study is fictional, and bears no resemblance to any persons, businesses, or organisations, living or dead. Any such resemblance, if exists, is merely co-incidental in nature, and is not intentional. Feed Me Now is

Read More »

MAA703 – Accounting for Management

Trimester 2 2022 Assessment Task 2 Part B – Teamwork Reflection (Individual) DUE DATE AND TIME:                        Wednesday, 7 September 2022 by 8:00pm (AEST) PERCENTAGE OF FINAL GRADE:    10% WORD COUNT:                                   750 – 800 words Description Teamwork is one of the vital components of many workplaces and the ability to demonstrate

Read More »

Research project assessment proforma and marking schemes

BSc Biomedical Sciences with Health, Exercise and Nutrition (HEN6004) and BSc Biomedical Science (APS6022) Instructions for use All forms must be completed electronically and uploaded to the student submission point in  turnitin. Please note the literature review assessment will be completed in January whereas the assessment of the paper/poster and

Read More »

XERO and Spotlight reporting software Report Assignment

Case facts – Read me carefully please City Infrastructure Holdings Ltd (CIH) and Network Maintenance Services Ltd (NMS) City Infrastructure Holdings Ltd (CIH) acquired 100% of the 300,000 issued shares in Network Maintenance Services (NMS) on 1 July 2021.  The consideration provided to shareholders of NMS consisted of $1.20 in cash plus 1

Read More »

KIT103 Computational Science

School of Information and Communication Technology College of Sciences and Engineering Unit Outline KIT103 Computational Science Semester 2, 2022 Sandy Bay Campus, Hobart Newnham Campus, Launceston COVID-19 (Coronavirus Information) For information on how you can help keep us all safe, please review the Coronavirus updates page here: https://www.utas.edu.au/about/safety-security-and-wellbeing/coronavirus Sections that

Read More »

SEN725 Urban Stormwater Asset Design

Assessment Task -4 Final Report – Analysis of CoGG Stormwater Network Weight 50% This is an individual assessment task. Plagiarism and collusion is unacceptable practice at Deakin University. You must appropriately reference your work. Failure to do so will result in disciplinary action. For more information on plagiarism and collusion,

Read More »

PSY3PRP 2022 Assignment 2: Research Project Report

PSY3PRP 2022 Assignment 2: Research Project Report Guidelines and Marking Rubric Individual Research Report due Wednesday 19th October 11.59pm (50% of total grade) For this assignment—with support through structured tutorial work across much of the semester— you will produce an individually-written report on the broad topic of feeding difficulties in

Read More »

Increasing Demand for assignment help in Namibia

With the growing population, the demand for clean energy, advanced technology, new structures, and better healthcare is escalating day by day which makes engineering the most popular degree for the youth. As more people pursue engineering nowadays, it also makes it one of the most difficult and competitive degrees also.

Read More »

Online Assignment Help in Germany

How Could You Do Exam Preparation Effectively? Exam time is full of challenges and difficulties. You have to juggle exams even in high school, college, or higher education. It defines your knowledge of a specific subject and how well you know the curriculum. The exam also tests how much you

Read More »

Get Excellent Human Values Assignment Help Immediately

Get Excellent Human Values Assignment Help Immediately: Expert Solutions to all your Queries Instant Human Values Assignment Help Online Students can get Human Values assignment help online in a fast and simple way from the experts at Universal Assignment Help Service. Their team of over 172+ subject experts works every

Read More »

Get Top Modern History Assignment Help Online

Order Modern History Assignment Help immediately Students often need modern history assignment help for many reasons. Getting immediate online help for assignments helps students boost their academics in incredible ways. Sometimes, the pressure of studies is too much to take for students. This causes them to score poor grades and

Read More »

Get Instant Assignment Help in the United Arab Emirates

How Can Assignments Help Students? Whatever the definition of homework is, one thing is certain: it helps students thoroughly learn the concepts they have studied in class. The number of such assignments may cause stress or a burden. It means students and tutors are both correct in their type of

Read More »

Assignment Help in Mexico

How to Gain Awesome Grades in Your Chemistry Subject? Whether you are pursuing a technical degree or studying in the science stream, chemistry is always at the forefront. If you love to observe reactions, molecules, acids, condensation, evaporation, and dilution, chemistry will prove a resource for getting outstanding academic marks.

Read More »

Assignment Help in Kenya

How Could You Find the Best Biology Homework Website? Getting online homework help from an expert is neither embarrassing nor unauthentic. The vast majority of students around the world believe that doing online assignments and tutoring is beneficial. The Standard Graduate School of Education revealed that 56% of students suffer

Read More »

Assignment Help in Bangladesh

The Best 6 Hacks to Shortlist the Top Civil Engineering Assignment Tutor? Finding a homework expert for civil engineering assignments is a hectic task. As civil engineering has several fields, getting expertise is difficult for tutors. You may struggle to receive civil engineering assignment help in Bangladesh due to this

Read More »

Assignment Help in Pakistan

What Will Unethical Occur from Getting Homework? Homework looks like a mode of learning in most cases. But what happens to its quantity? Its quantity should be more than enough for students. Such circumstances may be detrimental to the health of the pupils. Sometimes, college faculties or teachers forget to

Read More »

Assignment Help in Malaysia

The Best 4 Skills You Should Learn For Making Your Career in 2022 As technological innovations leap forward daily, new skills are entering our market. Sticking to one skill set enables you to lose lucrative job opportunities. That is why it gives importance to having diverse skills, which should be

Read More »

MKT200 Marketing Principles: Infographic

Assessment 2 Information Subject Code: MKT200 Subject Name: Marketing Principles Assessment Title: Infographic Assessment Type: Individual infographic Length: Two pages Weighting: 30% Total Marks: 100 Submission: Online Due Date: Week 9 Your task Individually, you are required to create a two-page infographic outlining the communications process of two competitor brands.

Read More »

MMP-223, Property and Real Estate Law and Practice

MMP-223, Property and Real Estate Law and Practice, Trimester 2, 2022 Assignment 2, Client Report, Individual Assignment 25% of Unit Assessment (1,250 words*) Due Date: September 16, 2022, 8-pm AEST Assignment Brief: Clyde, being a real estate agent, loves property. With his share of the sale of the Sorrento property

Read More »

NUR1398 – Foundations of Nursing Practice Theory

Assessment: Care Plan Report Task overview Course NUR1398 – Foundations of Nursing Practice Theory Brief task description Written care plan addressing nursing care requirements for older patients with degenerative conditions. Rationale for assessment task Registered Nurses are required to think through the different aspects of patient care to arrive at

Read More »

MBA641 Project Strategy Framework

Assessment 1 Information Subject Code: MBA641 Subject Name: Strategic Project Management Assessment Title: Project Strategy Framework Assessment Type: Length: Individual video recording and supporting Infographic Video: 10-minute (no more) Supporting infographic: 1 page (no more) Weighting: 30% Total Marks: Submission: 100 Online Due Date: Week 4 Your task You are

Read More »

SEJ201 Structural Design Assessment

SEJ201 Structural Design Assessment Task 5 FINAL PROJECT REPORT Summary The Final Project Report is an individual task which builds on teamwork completed earlier in the trimester. This report shall clearly explain and justify the design solution proposed. In this report students you should identify project scope, inputs and constraints,

Read More »

42907 Design for Durability

Introduction Overall, explain what readers will find in the report, general information about the structure, location, climatic conditions, detail which specific parts of the structure will be designed according to which Australian standard. Which type of foundation, why? You can use figures in this section. Provide the scope of the

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?