I need help with the formulas / answers for part 4. I have the rest setup here

There are two main goals for this assignment. First, it is meant to help improve your understanding of the mechanics of the Solow growth model that we covered in the first half of the class and to make sure you don't forget about it before the final. Second, since many jobs for economics majors require at least a basic knowledge of Microsoft Excel, it is also meant to give you some practice with some of Excel's basic features. If you do not have access to Excel, Google sheets will also work as a free alternative. The Assignment For this assignment, we will be simulating a Solow Growth Model in an Excel spreadsheet. To do this, please try follow these steps. 1. Set up the parameters of the model: Somewhere on your sheet, input the following numbers as values for each parameter. We will use numbers on your student ID to give each of you a unique setup (if any number is a 0, skip it and move to the next number and continue from there). We will assume a Cobb-Douglas production function , = AthLrl_\" a) Set capital's share of income @ = (0.X where X is the first number on your student ID divided by 2 (round to the nearest whole number). b) Set the saving rate s = 0.X where X is the second number of your student ID c) Set the depreciation rate 6 = 0.0X where X is the third number of your student ID d) Set the population growth rate 7 = 0.0X where X is the fourth number of your student ID e) Set the technology growth rate y = 0.0X where X is the fifth number of your student ID. Calculate using your values for y and a. 2. Calculate steady state capital per effective worker, output per effective worker, and consumption per effective worker by hand. 3. Set the initial level of technology Ay = 1 and L, = 1,000. Set k, equal to half its steady state value that you calculated in 2. Put these three values in the first row of three separate columns in your spreadsheet. 4. Using Excel formulas (i.e. not calculating by hand), calculate , y, k, Yo, Co Ky Y,,, and C, putting each in the first row of their own column in your spreadsheet (you should now have 11 columns filled in total). You should be able to calculate all of these variables using l} A~, L, and parameters. Solow Growth Model: , = AP KLt~ ey - - 1 i ~ PN - A - T ~F ~ R - TN - I Student ID 805284198.00 Period 0 1.00 1,000.00 B2 Share of income (a) 040 Period 1 1.07 1,080.00 Saving Rate (s) o.50| _|Period 2 114 1,166.40 Depreciation Rate (8) 0.02 Period 3 1.21 1,259.71 Population Growth Rate (17) 0.08 Period 4 1.29 1,360.49 Technological Growth Rate (y) 0.04 Period 5 1.38 1,469.33 Technological Growth Rate of 4 () 0.07 Period 6 147 1,586.87 Steady State Capital per Effective Worker (k7) 6.24 Period 7 157 1,713.82 Output per Effective Worker (y7) 2.08 Period 8 1.68 1,850.93 Consumption per Effective Worker (\") 125, Period 9 1.79 1,999.00 Period 10 191 2,158.92 Period 11 2.03 2,331.64 Period 12 217 2,518.17 Period 13 231 2,719.62 Dawind 14 247 720a2710