logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Eli BishopStatistics
(5/5)

779 Answers

Hire Me
expert
William LongMathematics
(5/5)

938 Answers

Hire Me
expert
Sandeep KumarStatistics
(/5)

687 Answers

Hire Me
expert
Jihye KimHistory
(5/5)

534 Answers

Hire Me
Excel
(5/5)

Assume you obtain whatever level of education needed to enter your desired area of employment

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

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. 

The Mean annual income for a high school graduate is $28,250. 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 Mean 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 Mean wage. 

• Your response should explain what your desired area of employment is and what the Mean annual salary for that position is.

• Your response should contain at least one statement comparing your expected salary with that of the Mean income of a high school graduate. 

 

2.) Housing Comparison: Current 30 year mortgage rates are at 5.095% and a good rule of thumb is to spend no more than 25% of your gross income on house payments (Note: We are using a different formula here than the ‘Total Expense Ratio’ in the book, so you will not need to know tax and other info). Use Excel to determine the largest value of a house that could be bought using a 30-year mortgage at 5.095% with payments that are 25% of the gross monthly income for someone with only a high school diploma and then do the same calculation using your expected salary. Also, assume 4.595% interest on a 15-year mortgage, and calculate the largest value of house that could be afforded under this type of mortgage.  Make a couple statements comparing your findings.  Use Excel to create an amortization table for ONE of the following:  a 30 year mortgage with your anticipated income, a 15 year mortgage with your anticipated income, a 30 year mortgage for someone with the income of a high school graduate, and a 15 year mortgage for someone the income of a high school graduate.  Highlight the tenth year of the amortization table.  How much of the loan have you paid off after 10 years?  (This is related to the idea of home equity, which is the current value of the home minus the amount owed on the home.  Note that you build equity more quickly with a 15-year mortgage, because more of each payment goes toward repaying the principal.)  Calculate the total price of each home.  How much more interest is paid?  (We are ignoring other closing costs that in reality we would have to pay.)

• Your response 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 for each type of mortgage.

• Clearly label the amortization table in Excel.

• Make sure you have highlighted the tenth year in the amortization table.

• Your response should contain at least one statement comparing the total price of the 30 year mortgage with the total price of the 15 year mortgage for BOTH your expected salary, and that of a high school graduate.

• Be prepared to explain in your response what Excel function was used for these calculations.

3.) Retirement Comparison: Your future employer will match your 401k investments 30%, but your high school counterpart does not receive help with their retirement plan from their employer. You and your high school counterpart are able to invest at least 7.5% of your salary in a 401k investments that will earn a 6.295% annual return. Use Excel to determine the balance on such a 401K 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 $250,000.

• Your response should contain at least one statement comparing the value of the 401K investment of the high school graduate and for your expected income.

• Your response 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 income to reach $250,000.

• Clearly label these calculations within Excel.

 

4.) Raises: The high school graduate’s income is not expected to increase over the next five years, but assume that your field will guarantee you a 3.25% raise on your annual salary each year for the next five years. Determine what your new annual salary will be given these five years of raises. Using this new income, recalculate the 30 year mortgage from part 2. Also recalculate the 40 year 401 k information from part 3 using this new income (use the new income and 40 years for this, don’t worry about the complication of 5 years of changes). 

• Your response should contain at least one statement comparing your initial salary with the salary after 5 years of raises. 

• Your response should explain how you determined the increased salary.

• Your response should address how your increased salary might impact your mortgage and 401K values. 

 

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

269 Experts Online