As an Ivy Tech student, you are making an investment in your education. This project will...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
As an Ivy Tech student, you are making an investment in your education. This project will look at how hat investment will pay off if you graduate and get a job in your desired field. The median annual income for a high school graduate is $28,025. This is the value that you will be omparing 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 response should explain what your desired area of employment is and what the median annual salary for that position is. Your response should contain at least one statement comparing your expected salary with that of the median income of a high school graduate. 2.) Housing Comparison: Current 30 year mortgage rates are at 4.15% 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 ant could be bought 2.) Housing Comparison: Current 30 year mortgage rates are at 4.15%) 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 4.15% 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 3.95% 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 er interest is paid? (We are ignoring other closing costs that in reality we would have 0 0.039 .041 each payment goes toward repaying the principal.) 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 mortga 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. As an Ivy Tech student, you are making an investment in your education. This project will look at how hat investment will pay off if you graduate and get a job in your desired field. The median annual income for a high school graduate is $28,025. This is the value that you will be omparing 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 response should explain what your desired area of employment is and what the median annual salary for that position is. Your response should contain at least one statement comparing your expected salary with that of the median income of a high school graduate. 2.) Housing Comparison: Current 30 year mortgage rates are at 4.15% 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 ant could be bought 2.) Housing Comparison: Current 30 year mortgage rates are at 4.15%) 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 4.15% 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 3.95% 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 er interest is paid? (We are ignoring other closing costs that in reality we would have 0 0.039 .041 each payment goes toward repaying the principal.) 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 mortga 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.
Expert Answer:
Answer rating: 100% (QA)
Income Comparison Desired Area of Employment Software Developer According to the Bureau of Labor Sta... View the full answer
Related Book For
Money Banking and Financial Markets
ISBN: 978-0078021749
4th edition
Authors: Stephen Cecchetti, Kermit Schoenholtz
Posted Date:
Students also viewed these finance questions
-
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....
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Assume that a security is selling at INR 217 and American call and American put options are available on the stock with 3 months maturity and an exercise price of INR 210. The call is selling at INR...
-
What is a buried verb? Give an original example. Why should writers avoid buried verbs?
-
Develop a Likert, a semantic differential, and a Stapel scale for measuring store loyalty.
-
Consider radiation exchange between two annular cylinders of radii \(R_{\mathrm{i}}\), and \(R_{\mathrm{o}}\) facing each other. This is similar to the radiation between flat plates considered in the...
-
Simco Blenders makes different kinds of electrical blenders, mixers, and grinders for various kitchen needs. These products are powered by small electric motors. Presently, Simco buys these motors...
-
We recently added the EPIX Movie Channels as part of a new tier of programming for our digital video subscribers. The EPIX channels are sold as an add-on package for $9.75 per month, but we would...
-
a. An analysis of WTI s insurance policies shows that $2,400 of coverage has expired. b. An inventory count shows that teaching supplies costing $2,800 are available at year-end. c. Annual...
-
Before you can begin to design a network, you must take into account the needs of the organization and the people associated with it as well as how those people will be accessing the network. For...
-
Each of the following allows you to integrate this chapter into your everyday life. Choose one from this list to complete. a. Interview someone who has been out of work for over a month. Is this...
-
Select three important relationships in your life. These might include your relationships with people at work or school, or with friends and family. For each relationship, rate on a scale ranging...
-
Sketch the graphs of the equations in Problems 31-38. \(y=4^{x}\)
-
Sketch the graph of each equation in Problems 3-30. \(y=\frac{1}{1,000} x^{2}\)
-
Sketch the graph of each equation in Problems 3-30. \(y=\frac{1}{2} x^{2}\)
-
onnor and Mandy form CON-MAN Partnership have the following: NI = $20,000; Connor's beginning capital balance = $46,000; Mandy's beginning capital balance = $50,000; salary to Connor $8,000; salary...
-
Time Solutions, Inc. is an employment services firm that places both temporary and permanent workers with a variety of clients. Temporary placements account for 70% of Time Solutions' revenue;...
-
Federal Reserve buying of mortgage-backed securities is an example of atargeted asset purchase. Explain how the Feds actions are intended to work.
-
How do venture capital firms, which specialize in identifying and financing promising but high-risk businesses, help the economy grow?
-
Financial stability is a goal of most central banks. Based on a graph showing the evolution of the European Central Banks assets (FRED code: ECBASSETS), how important was this goal for the ECB (a)...
-
Determine whether the following can be probability distributions of a random variable which can take on only the values \(1,2,3\), and 4 . (a) \(f(1)=0.19, \quad f(2)=0.27, \quad f(3)=0.27\), and...
-
An experiment consists of five draws from a pack of cards. Denoting the outcomes BRRBR, BRRRB,..., for black and red cards and assuming that all 32 outcomes are equally likely, find the probability...
-
Amy commutes to work by two different routes A and B. If she comes home by route A, then she will be home no later than 6 P.M. with probability 0.8, but if she comes home by route B, then she will be...
Study smarter with the SolutionInn App