I just need answer for the practical part to cross-check my figures. Pls ignore the reporting part in the requirement. I can take care of that.

Client Scenario: Andrea Danielson P. O. Box 38#6 Ivanhoe, VIC 3079 Andrea Danielson has approached you to assist her with financial planning advice. She earns a good level of income and enjoys a very comfortable lifestyle. She has accumulated a few investments but has not taken much interest in her superannuation balance. However, she has read a few reports of late which point out that the accumulated superannuation balances of many Australians will not be enough to support their retirement. Andrea Danielson now feels that perhaps the time has come to seek some professional advice before it is too late. MEETING - End of June 2020 Andrea Danielson is 35 years old and wish to build wealth between now and when she retires within her superannuation fund retirement age for her is expected to be 65. She will require a real income of $90,000 per annum in present value dollars from her superannuation fund when she retires as she wants to travel extensively. She wants an investment plan that is easy to manage while ensuring that her overall investments are well proportioned based on her risk profile and of a suitable quality. She also wants to minimise her tax liability as much as possible. Finally, she wishes to reduce her level of debt as quickly as possible. Andrea Danielson advises that she has a reasonably good knowledge of financial markets and enjoy spending time managing her investments. However, she is still learning and is inexperienced. She is prepared to accept some volatility in order to chase a reasonable rate of return. However, she realises that her current investment allocation and plan is unlikely to provide her with an appropriate nest-egg in retirement. Andrea Danielson has completed the following table to assist you in identifying her risk profile. Your concerns. Mark each dotted line with a number. Not concerned: 1; Slightly concerned: 2; Concerned: 3; Very concerned: 4. 3- Keep pace with inflation 2- Easy access to cash 2-Easy to manage 2-Attitude to short-term volatility in investments 4-Desire for tax effectiveness 2-Need to receive income from investments 4- Desire for capital growth from investments Andrea Danielson bought a new house about two months ago in the inner northern Suburbs of Melbourne. She settled on the property on 30th June 2020 and moved in on 15 July 2020. The house costed $ 950,000. She had to borrow $ 600,000. Her mortgage broker arranged a rate of 3.93% fixed- rate loan of $400,000 for the first five years and a $200,000 variable rate loan for the balance which has a current interest rate of 4.27%. Both loans are 20-year loans. Repayments are fortnightly. She has estimated her home insurance, repairs, council rates to be $7,658 for the first year. Andrea also owns a small unit in Travancore that she lived in up until 2 years ago, it costed her $375,000 back in 2016 and is now valued at $450,000. She has a loan on the property of $340,000 which is an interest-only loan with an interest rate of 4.22% fixed for the next 5 years. The rental return from the property is $375 per week and this covers both the interest on the loan and the other costs associated with the property like insurance, council and water rates, etc. so she views it as a no-cost investment. She does however generate a tax loss on the investment due to depreciation allowances of $4,000 per year which generates some tax savings for her. She works as Project Manager for a major construction firm. Her salary package is $ 167,800 and this includes the standard superannuation guarantee contribution (Salary after super contribution = $167,800 / (1+9.5%) = $153,242). In the last five years her salary has gone up by about 3% per annum and she think this rate of increase is likely to continue for the foreseeable future. She has about $ 168,350 in superannuation. The amount is invested in the Chus My Super (Growth) Fund with a non-binding death benefit nomination in place. The fund is expected to generate a net return of 3.50% p.a. (net of fees and taxes) for the foreseeable future. It is noted that superannuation earnings should be calculated based on the opening superannuation account balance. Andrea Danielson inherited 1,400 ASX: CBA shares back in 2010 when her grandmother passed away. Back then the CBA shares were valued at $28. She sold 700 of the CBA shares at $63.00 each on 1 June 2020 to free up some cash which she ultimately used to assist with the purchase of the house. She also inherited 5,000 ASX: QAN shares valued at $2.30 in 2010 which she retains. Andrea Danielson has a car worth about $ 60,000. She has $ 65,000 in a bank term deposit which was left to her by her deceased father and which pays 1.15% interest and a bank transaction account which has $ 41,070 and which pays zero percent interest. Andrea Danielson does not have health insurance. She asserts that she is young and healthy and does not need one. The following is a list of Andrea Danielson known living expenses for 2019/20. Rent $31,200; electricity, gas and water $2,756; car running costs/petrol/maintenance $7,880 and for registration and insurance $1,965; food groceries $13,278 and alcohol $3,660; chemist/medical/dental/optical $1,715; travel $8,260; entertainment/dining out $6,480; miscellaneous $4,152. Andrea Danielson has an CBA Platinum Awards Credit Card with about $ 22,000 owing. She never pays it off - with the interest, her payments and new purchases each month the balance owing stays fairly constant, nevertheless the balance increases each year by about the rate ofinflation. It is assumed that the inflation rate is 1% per annum and that the current tax rates and levels of dividend income remain unchanged for the next five years. Expenses will rise by inflation, unless there are contracts in place, which will affect these payments. Required Andrea Danielson requests you to analyse her current and future financial situation based on the above information and provide some suggestions on how she could improve her long-term net wealth. You are required to prepare a report for Andrea Danielson answering the issues detailed below. The report should be addressed and written for the client. The report should contain a covering letter addressed to Andrea Danielson detailing the purpose and general content of the report. There are no specific requirements for the format of the report. It should be user friendly for the client, answer the following questions through the use of headings, and make use of tables, charts etc where appropriate. You are required to provide the following: 1. Balance sheet as at 30 June 2020. (Assume that the values given by Andrea Danielson remain valid for 30 June 2020 - with exception of the CBA and QAN shares where you should use the price at COB on 30 June 2020) Cash flow statements for the financial years ending 30 June 2020 through to 30 June 2025, including detailed tax calculations. Use current tax rates for all years. Assume all surplus cash in the projection period will be deposited in the bank transaction account). (i) An excel spread sheet of accumulated superannuation for Andrea Danielson for each year from 1 July 2020 through to her retirement. 2. 3. You should use the following column headings in your spread sheet to illustrate the accumulation of their superannuation funds to retirement. Year Age Salary Opening Add super employer balance super contributions Less 15% contributions tax Add net Closing earnings super (net of tax balance and fees) Client Scenario: Andrea Danielson P. O. Box 38#6 Ivanhoe, VIC 3079 Andrea Danielson has approached you to assist her with financial planning advice. She earns a good level of income and enjoys a very comfortable lifestyle. She has accumulated a few investments but has not taken much interest in her superannuation balance. However, she has read a few reports of late which point out that the accumulated superannuation balances of many Australians will not be enough to support their retirement. Andrea Danielson now feels that perhaps the time has come to seek some professional advice before it is too late. MEETING - End of June 2020 Andrea Danielson is 35 years old and wish to build wealth between now and when she retires within her superannuation fund retirement age for her is expected to be 65. She will require a real income of $90,000 per annum in present value dollars from her superannuation fund when she retires as she wants to travel extensively. She wants an investment plan that is easy to manage while ensuring that her overall investments are well proportioned based on her risk profile and of a suitable quality. She also wants to minimise her tax liability as much as possible. Finally, she wishes to reduce her level of debt as quickly as possible. Andrea Danielson advises that she has a reasonably good knowledge of financial markets and enjoy spending time managing her investments. However, she is still learning and is inexperienced. She is prepared to accept some volatility in order to chase a reasonable rate of return. However, she realises that her current investment allocation and plan is unlikely to provide her with an appropriate nest-egg in retirement. Andrea Danielson has completed the following table to assist you in identifying her risk profile. Your concerns. Mark each dotted line with a number. Not concerned: 1; Slightly concerned: 2; Concerned: 3; Very concerned: 4. 3- Keep pace with inflation 2- Easy access to cash 2-Easy to manage 2-Attitude to short-term volatility in investments 4-Desire for tax effectiveness 2-Need to receive income from investments 4- Desire for capital growth from investments Andrea Danielson bought a new house about two months ago in the inner northern Suburbs of Melbourne. She settled on the property on 30th June 2020 and moved in on 15 July 2020. The house costed $ 950,000. She had to borrow $ 600,000. Her mortgage broker arranged a rate of 3.93% fixed- rate loan of $400,000 for the first five years and a $200,000 variable rate loan for the balance which has a current interest rate of 4.27%. Both loans are 20-year loans. Repayments are fortnightly. She has estimated her home insurance, repairs, council rates to be $7,658 for the first year. Andrea also owns a small unit in Travancore that she lived in up until 2 years ago, it costed her $375,000 back in 2016 and is now valued at $450,000. She has a loan on the property of $340,000 which is an interest-only loan with an interest rate of 4.22% fixed for the next 5 years. The rental return from the property is $375 per week and this covers both the interest on the loan and the other costs associated with the property like insurance, council and water rates, etc. so she views it as a no-cost investment. She does however generate a tax loss on the investment due to depreciation allowances of $4,000 per year which generates some tax savings for her. She works as Project Manager for a major construction firm. Her salary package is $ 167,800 and this includes the standard superannuation guarantee contribution (Salary after super contribution = $167,800 / (1+9.5%) = $153,242). In the last five years her salary has gone up by about 3% per annum and she think this rate of increase is likely to continue for the foreseeable future. She has about $ 168,350 in superannuation. The amount is invested in the Chus My Super (Growth) Fund with a non-binding death benefit nomination in place. The fund is expected to generate a net return of 3.50% p.a. (net of fees and taxes) for the foreseeable future. It is noted that superannuation earnings should be calculated based on the opening superannuation account balance. Andrea Danielson inherited 1,400 ASX: CBA shares back in 2010 when her grandmother passed away. Back then the CBA shares were valued at $28. She sold 700 of the CBA shares at $63.00 each on 1 June 2020 to free up some cash which she ultimately used to assist with the purchase of the house. She also inherited 5,000 ASX: QAN shares valued at $2.30 in 2010 which she retains. Andrea Danielson has a car worth about $ 60,000. She has $ 65,000 in a bank term deposit which was left to her by her deceased father and which pays 1.15% interest and a bank transaction account which has $ 41,070 and which pays zero percent interest. Andrea Danielson does not have health insurance. She asserts that she is young and healthy and does not need one. The following is a list of Andrea Danielson known living expenses for 2019/20. Rent $31,200; electricity, gas and water $2,756; car running costs/petrol/maintenance $7,880 and for registration and insurance $1,965; food groceries $13,278 and alcohol $3,660; chemist/medical/dental/optical $1,715; travel $8,260; entertainment/dining out $6,480; miscellaneous $4,152. Andrea Danielson has an CBA Platinum Awards Credit Card with about $ 22,000 owing. She never pays it off - with the interest, her payments and new purchases each month the balance owing stays fairly constant, nevertheless the balance increases each year by about the rate ofinflation. It is assumed that the inflation rate is 1% per annum and that the current tax rates and levels of dividend income remain unchanged for the next five years. Expenses will rise by inflation, unless there are contracts in place, which will affect these payments. Required Andrea Danielson requests you to analyse her current and future financial situation based on the above information and provide some suggestions on how she could improve her long-term net wealth. You are required to prepare a report for Andrea Danielson answering the issues detailed below. The report should be addressed and written for the client. The report should contain a covering letter addressed to Andrea Danielson detailing the purpose and general content of the report. There are no specific requirements for the format of the report. It should be user friendly for the client, answer the following questions through the use of headings, and make use of tables, charts etc where appropriate. You are required to provide the following: 1. Balance sheet as at 30 June 2020. (Assume that the values given by Andrea Danielson remain valid for 30 June 2020 - with exception of the CBA and QAN shares where you should use the price at COB on 30 June 2020) Cash flow statements for the financial years ending 30 June 2020 through to 30 June 2025, including detailed tax calculations. Use current tax rates for all years. Assume all surplus cash in the projection period will be deposited in the bank transaction account). (i) An excel spread sheet of accumulated superannuation for Andrea Danielson for each year from 1 July 2020 through to her retirement. 2. 3. You should use the following column headings in your spread sheet to illustrate the accumulation of their superannuation funds to retirement. Year Age Salary Opening Add super employer balance super contributions Less 15% contributions tax Add net Closing earnings super (net of tax balance and fees)