Assignment title: Information
The couple requests that you analyse their current and future financial situation based on the above information and provide some suggestions on how they could improve their long-term net wealth. The couple are not sure what their financial situation will be once Jenny is retrenched although they realise it will be a struggle. You are required to prepare a report for the couple answering the issues detailed below. The report should be addressed and written for the couple. The report should contain a covering letter addressed to the couple 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. Cash flow statements for the 3 financial years ending 30 June 2015 - 2017, including detailed tax calculations (use current tax rates). 2. Balance sheets for the 3 financial years ended 30 June 2015-2017. 3. I. An excel spreadsheet of accumulated superannuation for both Jerry and Jenny for each year from 1 July 2015 to their retirement in 30 June 2030.You should use the following column headings in your spread sheet to illustrate the accumulation of their superannuation funds to retirement