Students will visit the web site for the US Treasury Department and down load data on US Treasury Bills. They will be asked to use the treasury yield formula in Excel to recalculate yields. Also they will be given several compound interest problems involving calculation of mortgage payments, and future value of time deposits. They will be asked to use Excel formulas to solve these problems. The spreadsheets will be imbedded in a three page WORD document and submitted as an attachment via email.
Assignment is due on the day of the final exam.
Students will visit the web site for the Economic Report of the President and down load data on the nominal gross domestic product and several measures of the money supply. Students will calculate correlation coefficients, compare the predictive value of the various money measures, and discuss caveats to their statistical analysis. The spreadsheets will be imbedded in a three page WORD document and submitted as an attachment via email. The instructor will post the weekly assignment on at the beginning of the week on the class listserv. The email is to be sent to Assignments are due before the beginning of the next class meeting following the news release.