Excel Sheet to Calculate the Values for Housing and Retirement - College Graduate VS High School Graduate - Science and Math Assignment Help

Assignment Task

Task: Financial Project

As an Ivy Tech student, you are investing 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 $24,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 (You must submit both Excel and Word documents):

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.

HINT: As you are writing your absolute or relative change sentence, make sure to address “from” what value “to” 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 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 on a mortgage. If you spend 20% 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. Assume that the standard APR is 2.45% for 30 years. Make sure to show at least 1 sample formula that you used in Excel to get the house price.

3. Research housing options in the area you want to live in. Will your future salary allows you to afford the house you want, or should you consider other housing options? How much more or less must you spend compared to the previous question to get the house you want? Cite what source you used to find housing costs. Based on the house you chose, what monthly payment is needed to afford the house? Assume that the standard APR is 2.45% for 30 years.

4. If you were to take a 15-year loan instead of a 30-year loan and the APR was a 2.0% instead of 2.45%, what is the highest-priced home you can afford using 20% of your salary? Assuming all payments are made on time, what amount of interest will you pay on the home? Refer to your mortgage value for 30 years (APR 2.45%), if you made all payments for the life of the loan as scheduled, how much interest will you pay on the 30-year mortgage? Compare the amounts of interest paid on both mortgages using an absolute or relative change statement.

Retirement Account:
5. Assume that your selected job has a retirement plan that allows you to save for 22 years. If 6% of your monthly income is put into a retirement account, how much should you expect if the annual return is 7.99%? How much should a high school graduate expect to get if they also save 6% of their salary for 22 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.

6. Consider the retirement investment with 7.99% APR for 22 years using 6% of your monthly income. Which scenario (A, B, or C) will give you the best value for retirement? For each scenario, find the relative change from the original retirement amount to the doubled amount. A. If you were to double the APR (from 7.99% to 15.98%), how much would you have in your retirement account? B. If you were to double the contribution into the account (from 6% to 12% of monthly salary), how much would you have in your retirement? C. If you were to double the time that you are investing (from 22 years to 44 years), how much would you have in your retirement account?

7. If you wanted to save $100,000 for your retirement, how many years would that take? If you wanted to save $200,000, how many years would that take? Is the amount of time to save $200,000 twice as much as to save $100,000? Explain why or why not. How long would it take for a high school graduate to reach $100,000 and $200,000?

8. Consider that you saved for 22 years using 6% of your income towards retirement at 7.99%. If the high school graduate also saved 6% at a rate of 7.99%, how long would it take for them to reach the same amount that you had after only 22 years? Instead, if the high school graduate saved for 22 years, how long would it take you to reach the same retirement since you are contributing more money? (Assume the same APR and years.)

9. Assume that in the future you will need $1,000,000. What monthly contribution would make this possible? You can assume you are still using 7.99% APR for 22 years. Is this a feasible option for the job you have chosen? Using a relative or absolute change sentence, how much more or less would you need to contribute to making this possible? What percent of your current monthly salary is needed to make this goal possible?

Salary Increase:
10. If your job gives a salary raise of 1.5% each year, what will be your salary after 10 years? (In other words, after 10 raises have occurred.) Write an absolute or relative change statement comparing the current salary to the salary after 10 raises. What will be your salary after 20 years? Write an absolute change statement from your current salary to the salary after 20 years.

11. How long will it take (rounded to the whole year) for your salary to be twice as much as when you started assuming you get a 1.5% raise every year? If the high school graduate also had a 1.5% raise each year, how long would it take for them to get twice as much money (rounded to the whole year)? Compare the years for both the college graduate and the high school graduate. Explain the reasoning for your answer.

HOUSING:
Determine the largest value of a house that could be bought using a 30-year mortgage or 15-year mortgage at the rate given by searching online for the current APR. In this example below, 3.5% is used for 30 years. NOTICE: $100,000 is used as an example for many of the calculations and 25% is taken out for your mortgage value. You will use the salary that you found for your job on the website for your desired career. A value of $20,000 is also assumed for a High School Graduate. You will need to reference the project for what percentage of income is dedicated to a mortgage!

This Science and Math Assignment has been solved by our Science and Math experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.