Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started