Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with this project using which ever career choice you decide. Needed asap. Will give an additional $8 for help. Assume that the

I need help with this project using which ever career choice you decide. Needed asap. Will give an additional $8 for help.

Assume that the median annual income for a high school graduate is $21,000. This is the value that you will be comparing your expected salary and lifestyle to in the following areas:

1)Income Comparison: Research your expected income after you graduate college. Assume you obtain whatever level of education needed to enter your desired area of employment and that you will have a salary equivalent to the annual Median salary found at: http://www.bls.gov/oes/current/oes_in.htm#27-0000 *You will need to click on your desired career in order to see the Annual Median wage.

Your reflection paper should explain what your desired area of employment is and what the median annual salary for that position is.

Your reflection paper should contain at least one statement comparing your expected salary with that of the median income of a high school graduate.

2)Housing Comparison: Assume that you and your high school graduate counterpart plan to spend 18% of your gross monthly income on house payments. Look up the current fixed rate APR for mortgages and use Excel to determine the largest value of a mortgage that each of you can afford to borrow under those conditions.

Your reflection paper should contain at least one statement comparing the value of the house that a high school graduate can afford and that you expect to be able to afford.

Explain in your reflection paper what Excel function was used for these calculations. Cite what source you used to find mortgage rates.

Research housing costs in an area where you would like to live. Will your future salary allow you to afford the house you want, or should you consider other housing options? How much more or less must you spend to get the house you want? Cite what source you used to find housing costs.

3)Retirement Comparison: 401 k investments are expected to earn a 4.99% annual return. Assume that 5% of gross monthly income is to be set aside for 401 k investment. Use Excel to determine the balance on such a 401 k after 40 years of investment for the high school graduate and for your expected income. Also use Excel to determine how many years it would take for the high school graduate and for your expected investment to reach $150,000.

Your reflection paper should contain at least one statement comparing the value of the 401 k investment of the high school graduate and for your expected salary.

Explain in your reflection paper what Excel function was used for these calculations.

Your reflection paper should contain at least one statement comparing the time it would take for the 401 k investment of the high school graduate and for your expected salary to reach $150,000.

Included excel spreadsheet as well.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Inference

Authors: George Casella, Roger L. Berger

2nd edition

0534243126, 978-0534243128

More Books

Students also viewed these Mathematics questions