Please answer this and create an excel;

Salwid-Fin, a financial planner, has hired you to develop a spreadsheet they will use with their clients. Theyve 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, theyd like to show their clients a graph with seven curves on it: one, the clients current super balance, two, the amount of super the client wants to withdraw, three, the fall in clients annual retirement income stream (henceforth, RIS) in retirement, four, the target RIS the client is aiming for, five, the target capital the client requires at retirement (the lump sum required to fund the RIS), six, the annual contributions required to hit the target RIS/capital if the super withdrawal goes ahead, and seven, the annual contribution to hit the target RIS/capital 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 two sheets. One sheet, titled Inputs and Result consists of the following.

1. The Salwid-Fin logo

2. The clients current age (an integer, from 18 to 64). Assume that it is the clients birthday on the date he or she sees you.

3. The clients gender (M or F)

4. The clients current super balance (in dollars)

5. The clients desired withdrawal (in dollars). Assume the withdrawal will be made today, on the clients 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 clients 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 j2 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.

*use factset for data