\n Instructions\n <\/p>\n
\n As an Ivy Tech student, you are making an investment in your education. This project will look at how that investment will pay off if you graduate and get a job in your desired field. You will be comparing your future finances with someone who is not a college graduate. Assume that the median annual income for a person who is only a high school graduate is\u00a0$33,500\u00a0(although this may not be accurate for Indiana residents). Use this value in comparison statements with proper\u00a0absolute and relative change statements.\n <\/p>\n
\n In this project you are required to do the following:\n <\/p>\n
\n Create an Excel spreadsheet to help calculate the correct values for housing and retirement (this will be a graded part of the project). Ask your instructor if you need to use an Excel template. Refer to the Excel help in the book or notes in your course on how to find mortgage or retirement values. You will use the PV, FV, PMT formulas in Excel.\n <\/p>\n
\n Your typed responses for this project will consist of answering short-answer questions given below. Each short-answer should be a\u00a0minimum of 3 sentences and 50 words. Use proper quantitative reasoning and wording to address the solution. This should clearly convey your message to a reader who is not taking Math 123. Make sure to use your spreadsheet to answer \u201cwhat if\u201d questions with\u00a0specific values\u00a0and provide support for your statements. To do this, make changes in your spreadsheet and analyze the results of the manipulations \u2013 be quantitative and specific with correct absolute and relative change statements. See the last page of this project description for samples of what poorly written responses and well written responses would look like before you answer the questions below. Your answers to these questions will be typed in and submitted in IvyLearn using the link to Project 1.\n <\/p>\n
\n HINT: As you are writing your absolute or relative change sentence, make sure to address \u201cmore than\u201d or \u201cless than\u201d what value. Writing sentences such as, \u201cThe absolute\/relative change is\u2026\u201d will NOT be counted as correct. What is the meaning of an absolute or relative change in each scenario?\n <\/p>\n
\n Example of a poorly written response:\n <\/p>\n
\n I think that I could afford a $50,000 car as a college graduate.\n <\/p>\n
\n This response is not good. While a numerical response is given, the response does not indicate the student used their Excel spreadsheet, indicate what Excel function they used to determine that value, or explain what the values used in the Excel function represent.\u00a0 The response does not meet minimum sentence or word count.\n <\/p>\n
\n Example of a well written response:\n <\/p>\n
\n I think that I could afford a $50,000 car as a college graduate. I determined this using Excel and it is \u00a0based on the monthly gross income I determined earlier in the project and given the loan I obtained for 2.5% over the 5 year period we were directed to use for this part of the project.\u00a0 The Excel formula I used to determine the $50,000 amount was =EXCELfunction(number 1, number 2, number 3) where\u00a0number 1\u00a0represents\u2026,\u00a0number 2\u00a0represents\u2026, and\u00a0number 3\u00a0represents\u2026\n <\/p>\n
\n Student\u00a0provided a numerical value, provided the exact Excel function they used along with a detailed description of what each of the number values used in the Excel function represents. The response meets both the minimum sentence and word count.\n <\/p>\n
\n Written response questions:\n <\/p>\n
\n 1.\u00a0Answer the two following questions related to your median annual salary and that of the high school graduate:\n <\/p>\n