Make an Excel model for a superannuation account. For simplicity, assume the rate is (2%)

Make the following inputs.

a. Age (an integer)

c. Desired superannuation withdrawal amount (in dollars)

d. Desired annual income for ages 65 to 85, inclusive (males), Assume this annual amount is paid on each birthday, starting at age 65, and ending at 85. This stream of annual payments is what we refer to below as the users retirement income stream.

The spreadsheet will then generate the following outputs.

a. The reduction in the users retirement income stream by making the above withdrawal from the users superannuation fund. This retirement income stream refers to constant annual payments made at ages 65 to 85, inclusive.

b. The lump sum required (today) at the users current (integer) age to generate the desired annual retirement income stream inputted.