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
a) Set capital’s share of income where X is the first number on your student ID divided by 2 (round to the nearest whole number).
b) Set the saving rate where X is the second number of your student ID
c) Set the depreciation rate where X is the third number of your student ID
d) Set the population growth rate where X is the fourth number of your student ID
e) Set the technology growth rate where X is the fifth number of your student ID. Calculate using your values for and .
3. Set the initial level of technology and . Set equal to half its steady state value that you calculated in
4. Using Excel formulas (i.e. not calculating by hand), calculate , , , , , , and 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 , , , and parameters.
̃A0 = 1 L0 = 1,000 ̃k0
̃y0 ̃c0 k0 y0 c0 K0
6. Using the law of motion for capital per effective worker, calculate for 100 periods
7. Calculate values for the other 8 variables for 100 periods (carrying formulas down).
8. From the 100 values you have generated, create graphs of
a) Capital per effective worker (include a dashed line at the steady state level of capital that you calculated in 2)
b) The natural log of capital per worker
c) The natural log of aggregate capital
d) The growth rate of capital per worker and aggregate capital (use the difference in the logs as an approximation for the growth rate). You may put these on the same plot or separate plots.
a) Capital per effective worker
b) Output per effective worker
c) Consumption per effective worker
a) Output per effective worker (include dashed lines at both the original and new steady states))
b) The natural log of output per worker
c) The natural log of aggregate output
d) The growth rate of output per worker and aggregate output (again using the difference in logs). You may put these on the same plot or separate plots. 11. You should now have 13 graphs (or 11 if you combined the growth rate graphs). Put these together into a single document (final form must be pdf but any program works to create it), including a brief description (a few sentences) explaining what is happening in each of the three parts.
1. Your graphs should include labeled axes and a title. If you have multiple lines on the graph (for graphs where you plot a steady state), include a legend making it clear what each line represents.
2. You must make at least some changes to the default Excel (or whatever program you use) style (e.g. change the color, font, sizes of the lines, gridlines, etc.). This is just to practice making Excel graphs. Don’t go overboard with the changes – make sure everything still looks clean.
3. Make sure your final document with graphs and descriptions looks professional and readable. If it is hard for the grader to figure out what you are trying to show you won’t get as high a score.
4. The assignment is out of 150 points (around 15% of your final grade in the class). It is meant to be a major assignment in the class (worth more than all the problem sets combined) and it will take time. I do not recommend waiting until the last day to start. TAs will be providing some Excel tips during week 7 TA sections. I highly recommend getting started soon after that.
120-125 (B): All required components are included, but there are some major mistakes in calculations and/or graphs look messy and are hard to read. Descriptions of graphs may not describe what is happening in the graphs well.
130-135 (B+/A-): All required components are included and graphs are generally well made and easy to read, but there are a few mistakes in calculations, flaws in some graphs, or lack of clarity in the descriptions.
140-145 (A): All required components are included, there are only very minor or no mistakes in calculations or graphs, all graphs are well made and easy to read, and descriptions add some insight to what is happening in the graphs
150 (A+): No mistakes in calculations, professional and visually appealing graphs, insightful descriptions. Only the very best assignments will earn a perfect score.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS