Question: 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

 would like to know how to do it without exel 1.
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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!