Economy homework with excel proplem

Instructions:

1. You may consult any text book, the Internet, or any other academic resource. However, the solutions submitted must be your own.

2. Some problems specifically require a spreadsheet model. You may submit your write-up in word or pdf format. DO NOT submit a hand written solution.

3. There are 4 problems in total (95 points). Another 5 points are for presentation of your work. By now you should know the difference between a good and a poorly organized spreadsheet. Articulate your answers properly.