Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The house I chose is $475000 please show answer in excel with formulas thank you interest rate-5.996 I want you to find a home that
The house I chose is $475000
please show answer in excel with formulas thank you
interest rate-5.996
I want you to find a home that you would like to buy. Use Google, Zillow, Realtor.com, or another real estate site to find a home. Make sure to include the link for the home in your discussion post. Next, prepare an Amortization Schedule for this home. I expect the amortization schedule to be completed in Excel with all work shown in Excel. Thus, I should be able to click on any cell and see your work embedded in that cell. If this is not done, it will be an automatic 50% deduction. Assume you pay the full asking price and make a 20% down-payment. Do not use an online amortization schedule. I will only give you credit if you create your own amortization table. Use page 225 of your textbook as a guide. Note the textbook amortization schedule is using an annual payment. Please complete your schedule for both 180 months (15 years) and 360 months ( 30 years). Find the appropriate interest rate for your area at Bankrate. Remember to divide your interest by 12 to get a monthly rate. After completing the amortization schedule, attach your amortization sheet to a new post and discuss what you found. How much interest will you pay over the life of each loan? You can determine this by summing all the payments and subtracting the amount borrowed. I want you to find a home that you would like to buy. Use Google, Zillow, Realtor.com, or another real estate site to find a home. Make sure to include the link for the home in your discussion post. Next, prepare an Amortization Schedule for this home. I expect the amortization schedule to be completed in Excel with all work shown in Excel. Thus, I should be able to click on any cell and see your work embedded in that cell. If this is not done, it will be an automatic 50% deduction. Assume you pay the full asking price and make a 20% down-payment. Do not use an online amortization schedule. I will only give you credit if you create your own amortization table. Use page 225 of your textbook as a guide. Note the textbook amortization schedule is using an annual payment. Please complete your schedule for both 180 months (15 years) and 360 months ( 30 years). Find the appropriate interest rate for your area at Bankrate. Remember to divide your interest by 12 to get a monthly rate. After completing the amortization schedule, attach your amortization sheet to a new post and discuss what you found. How much interest will you pay over the life of each loan? You can determine this by summing all the payments and subtracting the amount borrowed 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