Suppose that you plan to contribute to your retirement fund once you start working full time. When you plan to withdraw, there is some penalty if you withdraw before age of 60. Use information in the input section, and use IF () function to answer : 1) how much you can withdraw at a give age 2) display detailed year to year information of your fund till the withdraw year. Make the table display only till the withdraw year. Note: Please always display your entered formula next to your results. Output Withdraw age 59 Input Data Start Age Annual deposit to retirement fur Rate of investment One time penalty rate if withdraw before age of 60 28 $7,000 5% Withdraw total amount after penalty adjustment 7% Answers: Age Deposit Interst payment Balance Quarter 1 2 1 2 3 1. Create pivot table summarizes total sales revenue by regions and year/quarter. 1 2. Create pivot atble to find out average unit cost per iterm for each quarter. 2 1 2 1 3. Create pivot bar chart to display the total sales by each rep, rank from the the highest to the lowest. 2 1 2 1 2 3 1 1 1 Region Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central East East East East East East East East East East East East East West West West West West West West West West West Rep Andrews Andrews Andrews Andrews Andrews Gill Gill Gill Gill Gill Gill Jardine Jardine Jardine Jardine Jardine Kivell Kivell Kivell Kivell Morgan Morgan Morgan Smith Smith Smith Howard Howard Jones Jones Jones Jones Jones Jones Jones Jones Parent Parent Parent Sorvino Sorvino Sorvino Sorvino Thompson Thompson Thompson James James James Item Binder Binder Pencil Pencil Pencil Binder Binder Pen Pen Pencil Pencil Binder Binder Pen Set Pencil Pencil Binder Desk Pen Set Pen Set Binder Pen Set Pencil Binder Desk Pencil Binder Pen Binder Binder Binder Pen Pen Set Pen Set Pencil Pencil Binder Pen Pen Set Binder Desk Pen Pencil Pen Binder Pencil Pencil Pen Set Binder Units 43 28 75 66 14 46 80 27 27 53 7 11 94 50 36 90 50 5 96 42 28 55 90 87 2 67 29 96 60 60 4 64 16 62 95 35 81 15 74 7 3 76 56 48 57 32 45 24 36 UnitCost Total 4.99 214.57 4.99 139.72 1.99 149.25 1.99 131.34 1.29 18.06 8.99 413.54 8.99 719.2 19.99 539.73 19.99 539.73 1.29 68.37 1.29 9.03 4.99 54.89 19.99 1,879.06 4.99 249.5 4.99 179.64 4.99 449.1 19.99 999.5 125 625 4.99 479.04 23.95 1,005.90 8.99 251.72 12.49 686.95 4.99 449.1 15 1,305.00 125 250 1.29 86.43 1.99 57.71 4.99 479.04 4.99 299.4 8.99 539.4 4.99 19.96 8.99 575.36 15.99 255.84 4.99 309.38 1.99 189.05 4.99 174.65 19.99 1,619.19 19.99 299.85 15.99 1,183.26 19.99 139.93 275 825 1.99 151.24 2.99 167.44 5.99 287.52 19.99 1,139.43 1.99 63.68 1.99 89.55 25.99 623.76 12.99 467.64 Year 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 3 1 1 1 2 2 2 1 1 1 2 3 2 1 2 1 3 1 1 2 1 2 1 2 2 1 2 1 1 2 Suppose that you plan to contribute to your retirement fund once you start working full time. When you plan to withdraw, there is some penalty if you withdraw before age of 60. Use information in the input section, and use IF () function to answer : 1) how much you can withdraw at a give age 2) display detailed year to year information of your fund till the withdraw year. Make the table display only till the withdraw year. Note: Please always display your entered formula next to your results. Output Withdraw age 59 Input Data Start Age Annual deposit to retirement fur Rate of investment One time penalty rate if withdraw before age of 60 28 $7,000 5% Withdraw total amount after penalty adjustment 7% Answers: Age Deposit Interst payment Balance Quarter 1 2 1 2 3 1. Create pivot table summarizes total sales revenue by regions and year/quarter. 1 2. Create pivot atble to find out average unit cost per iterm for each quarter. 2 1 2 1 3. Create pivot bar chart to display the total sales by each rep, rank from the the highest to the lowest. 2 1 2 1 2 3 1 1 1 Region Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central East East East East East East East East East East East East East West West West West West West West West West West Rep Andrews Andrews Andrews Andrews Andrews Gill Gill Gill Gill Gill Gill Jardine Jardine Jardine Jardine Jardine Kivell Kivell Kivell Kivell Morgan Morgan Morgan Smith Smith Smith Howard Howard Jones Jones Jones Jones Jones Jones Jones Jones Parent Parent Parent Sorvino Sorvino Sorvino Sorvino Thompson Thompson Thompson James James James Item Binder Binder Pencil Pencil Pencil Binder Binder Pen Pen Pencil Pencil Binder Binder Pen Set Pencil Pencil Binder Desk Pen Set Pen Set Binder Pen Set Pencil Binder Desk Pencil Binder Pen Binder Binder Binder Pen Pen Set Pen Set Pencil Pencil Binder Pen Pen Set Binder Desk Pen Pencil Pen Binder Pencil Pencil Pen Set Binder Units 43 28 75 66 14 46 80 27 27 53 7 11 94 50 36 90 50 5 96 42 28 55 90 87 2 67 29 96 60 60 4 64 16 62 95 35 81 15 74 7 3 76 56 48 57 32 45 24 36 UnitCost Total 4.99 214.57 4.99 139.72 1.99 149.25 1.99 131.34 1.29 18.06 8.99 413.54 8.99 719.2 19.99 539.73 19.99 539.73 1.29 68.37 1.29 9.03 4.99 54.89 19.99 1,879.06 4.99 249.5 4.99 179.64 4.99 449.1 19.99 999.5 125 625 4.99 479.04 23.95 1,005.90 8.99 251.72 12.49 686.95 4.99 449.1 15 1,305.00 125 250 1.29 86.43 1.99 57.71 4.99 479.04 4.99 299.4 8.99 539.4 4.99 19.96 8.99 575.36 15.99 255.84 4.99 309.38 1.99 189.05 4.99 174.65 19.99 1,619.19 19.99 299.85 15.99 1,183.26 19.99 139.93 275 825 1.99 151.24 2.99 167.44 5.99 287.52 19.99 1,139.43 1.99 63.68 1.99 89.55 25.99 623.76 12.99 467.64 Year 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 3 1 1 1 2 2 2 1 1 1 2 3 2 1 2 1 3 1 1 2 1 2 1 2 2 1 2 1 1 2