Financial ProjectDue: As an Ivy Tech student, you are making an investment in your education

Subject:MathPrice: Bought3

Share With

Financial ProjectDue:

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 high school graduate is $23,000 (although the actual value is higher). Use this value in comparison statements with proper absolute and relative change statements.

In this project you are required to do the following: 

Create an excel sheet to help calculate the correct values for housing and retirement. Although this is not a graded part of the project, only excel can produce the correct result (and not a simple calculator for most questions). Ask your instructor if you need to submit 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.

Your written portion of the project will consist of answering short answer questions given below. Each short answer solution should be a minimum of 3 sentences and 50 words. For each, use proper quantitative reasoning and wording to address the solution. This should include sophisticated and elegant solutions to clearly convey your message to the reader. Make sure to use your spreadsheet to answer "what if" questions with specific values and provide support for your statements. To do this, make changes in your spreadsheet and analyze the results of the manipulations - be quantitative and specific with correct absolute and relative change statements. 

HINT: As you are writing your absolute or relative change sentence, make sure to address "more than" or "less than" what value. Writing sentences such as, "The absolute/relative change is..." will NOT be counted as correct. What is the meaning of an absolute or relative change in each scenario?

1. Explain what job you have chosen and why. Use the median salary from the following website: https://www.bls.gov/ooh. Compare your salary to that of a high school graduate. How does your salary compare to the high school graduate? Use BOTH an absolute change and relative change statement for your comparison.

Mortgage Loan

2. Assume you are planning on spending a certain amount of income towards a mortgage. The terms of the mortgage are 3.0% APR for 25 years. You plan on spending 25% of your monthly gross income towards your mortgage. Make sure to show at least 1 sample formula that you used in Excel to get the house price.

• If you spend 25% of your monthly salary towards a house, what is the highest price house you can afford?

• What is the highest priced house a high school graduate can afford?

• Use an absolute or relative change statement to compare the house prices of the high school graduate and your house.

Retirement Account

3. Assume that your selected job has a retirement plan that allows you to save for 30 years.

• If 6.50% of your monthly income is put into a retirement account, how much should you expect if the annual return is 5.99%?

• How much should a high school graduate expect to get if they also save 6.5% of their salary for 30 years?

• Use an absolute or relative change statement to compare the retirement accounts of the high school graduate and your retirement. Make sure to show at least 1 sample formula used to get the retirement price.

4. Consider the retirement investment with 5.99% APR for 30 years using 6.5% of your monthly income. Which scenario will give you the best value for retirement? For each scenario, find the relative change from the original retirement amount to the doubled amount.

• If you were to double the APR (from 5.99% to 11.98%), how much would you have in your retirement account? Write a meaningful sentence about the relative change from the original to the new value.

• If you were to double the contribution into the account (from 6.5% to 13% of monthly salary), how much would you have in your retirement? Write a meaningful sentence about the relative change from the original to the new value.

• If you were to double the time that you are investing (from 30 years to 60 years), how much would you have in your retirement account? Write a meaningful sentence about the relative change from the original to the new value.

5. Assume 6.5% is saved for retirement with 5.99% APR (as in previous problems).

• How much money would you need to save each month to reach one million dollars in 30 years?

• Is this a feasible monthly payment for the job you have chosen?

• Use an absolute or relative change sentence comparing the money needed to reach one million dollars and the money you already are saving with 6.5%.

Answer the questions online to complete Project 2.