Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

would like to know how to do it without exel 1. You graduated from Milligan and got an Engineering job offer with a starting salary

image text in transcribed
would like to know how to do it without exel
1. You graduated from Milligan and got an Engineering job offer with a starting salary of $63,000 per year. Congratulations! You are planning to move to Kingsport to be closer to your work and you are expecting to work there for at least 4 years to build up your engineering skills. You are considering if you want to buy a house or to rent an apartment. Your monthly take home salary, assuming a tithe of 12%, a 7% retirement savings, and a tax rate of 28% is $2,885. You should generally spend less than 30% of your income (pre-tax) on housing, $1,275. a. Use Excel to determine your price range based on a 20% down payment an APR of 5.5% compounded monthly, and a 30 year term. Assume that taxes and fees add about $200 to your monthly payment. b. What is your down payment on this home (20%)? c. Use excel to determine the amount of principle and interest paid each month for all 360 payments. d. Calculate the total principle and total interest paid over the term. e. If you add an additional principle payment of $200 every month, how much does this reduce the total interest paid and the term of the loan? f. How else could you reduce the amount of interest you pay on the loan while keeping within the restriction of paying less than 30% of your income on housing? 1. You graduated from Milligan and got an Engineering job offer with a starting salary of $63,000 per year. Congratulations! You are planning to move to Kingsport to be closer to your work and you are expecting to work there for at least 4 years to build up your engineering skills. You are considering if you want to buy a house or to rent an apartment. Your monthly take home salary, assuming a tithe of 12%, a 7% retirement savings, and a tax rate of 28% is $2,885. You should generally spend less than 30% of your income (pre-tax) on housing, $1,275. a. Use Excel to determine your price range based on a 20% down payment an APR of 5.5% compounded monthly, and a 30 year term. Assume that taxes and fees add about $200 to your monthly payment. b. What is your down payment on this home (20%)? c. Use excel to determine the amount of principle and interest paid each month for all 360 payments. d. Calculate the total principle and total interest paid over the term. e. If you add an additional principle payment of $200 every month, how much does this reduce the total interest paid and the term of the loan? f. How else could you reduce the amount of interest you pay on the loan while keeping within the restriction of paying less than 30% of your income on housing

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

Principles Of Corporate Finance

Authors: Richard Brealey

10th Global Edition

0071314172, 9780071314176

More Books

Students also viewed these Finance questions

Question

9.4 Explain the roles in career development.

Answered: 1 week ago

Question

8.6 Discusstwo techniques used for assessing training needs.

Answered: 1 week ago