SalwidFin. a nancial planner. has hired you to develop a spreadsheet they will use with their clients. They've noticed that many of their clients ask about the consequences of withdrawing money from their super funds well before retirement. They want a spreadsheet that demonstrates these consequences to their clients. Broadly. they'd like to show their clients a graph with seven curves on it: one. the client's current super balance. two. the amount of super the client wants to withdraw. three. the fall in clients climate! retirement income stream (henceforth. BIS] in retirement. four. the target thi the client is aiming for. ve. the target capital the client requires at retirement {the lump sum required to fund the H15). six. the annual contributions required to hit the target HJSfcapital if the super withdrawn] goes ahead. and seven. the annual contribution to hit the target RISfcapital if no super is taken out now. To achieve these objectives. you have been asked to develop the following. Develop a spreadsheet with at least taro sheets. One sheet, titled 'Inputs and Result' consists of the following. 1. The Salwid-Fin logo 2. The client's current age (an integer, from 18 to 64). Assume that it is the client's birthday on the date he or she sees you. 3. The client's gender ('M' or 'F") 4. The client's current super balance (in dollars) 5. The client's desired withdrawal (in dollars). Assume the withdrawal will be made today, on the client's birthday. 6. Desired annual income between ages 65 to 85, inclusive, for males, assumed to be paid at the end of every year (so the first payment is at age 66; the last payment is at age 85). This is the client's desired, or target. RIS. For females, work with a payment period from age 65 to 87 (inclusive). 7. CY22, the Australian 10-year government bond yield for calendar year 2022 (i.e., the 10-year government bond yield on 31 December 2022, a jz rate).* We will adjust this rate, by adding 170 basis points to it, and assume this is the (constant) level of interest rates from the current time into the foreseeable future. "You will need to use FactSet to find this value.8. A horizontal bar graph, on a log scale, with seven components. These are as follows. (a) 'Super balance now' (b) 'Super out now' (c) 'RIS fall at 65' (d) "Target RIS at 65' (e) 'Target capital at 65' (f) 'Conts to target RIS' (g) 'Above if nothing out' These seven components are detailed in the third paragraph of this document, above.{)ne sheet. titled 'Model'__ consists of the following: a cash ow diagram. drawn from the perspective of the client [choose either male or female). and: following the principles developed in the lectures: models the super withdrawal. accumulation and decunullation {when the HIS is paid) phases. Use the following notation on your diagram. 1. I: the current age of the client 2. B: the client's current super halance__ prior to any withdrawal 3. W. the client's desired withdrawal {now} 4. c: the client's required contributions prior to retirement to achieve hisz'her desired R15 5. R. the client's desired R15 {annual} . 1;: the {constant} assumed rate of interest In doing your calculations note the following. 1. The client will retire at age E35. 2. The client will make contributions from the current age to age '35. These contributions are made in arrears: so if the client's current age is :r.'.. then the rst contribution will he made at age I + lthe last contribution will made at age E35. 3. The client's first RIS payment will be at age 66, and will continue annually up to and including age 85 for a male, and 87 for a female. 4. The rate of interest from now and into the foreseeable future will remain constant at CY2 plus 170 basis points