Finance 380: Financial Modelling

SAT This worksheet contains data concerning average SAT scores for the 50 states and Washington DC including participation rate (% of seniors taking SAT), per pupil expenditure and per capita income. Calculate mean medians, maxima, minima, and standard deviations for each variable. Report the correlation matrix.

TAXES I have included 3 tabs relating to taxes. The first is a spreadsheet that allows the user to enter his/her gross income and state of residence. TAXES2 is the spreadsheet we wrote in class that calculates federal tax liability (you can copy the classwork directly into this tab). TAXES3 contains information on MA, CT, and RI tax tables. Write a spreadsheet so that the user (on tab TAXES1) enters gross income and state of residence. The spreadsheet returns (also on tab TAXES1) federal tax liability, social security tax, medicare tax, state tax liability, total tax liability, average tax rate and marginal tax rate.

GRADES This worksheet contains grades (attendance, eight quizzes, two mid-terms and a final) for 34 students in my Nostalgic Spreadsheets class. Attendance is worth 10% of the overall grade and is based purely on the proportion (out of 42) of classes attended. Homework is worth 15% and is based on the average score of eight homework assignments, each of which was worth 10 points. The remaining 75% will be allocated thusly: 30% to the highest of the three exam grades, 25% to the middle grade, and 20% to the lowest. Students will receive an additional point added to their average for attending all classes, and an additional point if they turned in all eight homework assignments. Write a spreadsheet that calculates averages and assigns letter grades based on the following grade distribution: (HINT: See if you can figure out how to do this with the VLOOKUP function; it’s easier than a billion imbedded IF statements.