Question: please someone help me and send me with Google Doc EXCEL Link Solve each question in a separate sheet in Excel and label the sheet

please someone help me and send me with Google Doc EXCEL Link

please someone help me and send me with Google
Solve each question in a separate sheet in Excel and label the sheet accordingly. Also, copy and paste the question into the sheet similar to the class example. Lastly, make sure and color code any solutions and provide a key for your color-coding scheme (right now you will probably only have two colors but moving forward we will add to that). Please note* Points will be deducted for not following the above directions! Example solutions are located in the weekly videos posted in Canvas 1. In purchasing a house, you need to obtain a mortgage with a present value (loan amount) of $350,000. You have a choice of: (A) a 30-year mortgage at an interest rate/year of 9.74% or (B) a 15-year mortgage at an interest rate/year of 9.46%. Create loan amortization tables for both scenarios and provide your answer for the last question on the second scenario (B) sheet. What is the annual payment required by the two alternative mortgages? How much of each year's payment goes to paying interest and how much reducing the principal balance by the two alternative mortgages? Which mortgage would you prefer and why (this is the only question that is answered separately from your tables, in other words do not specifically answer the other questions but complete the tables to show the answer)? 2. How much extra profit does a bank make off of a 30-year fixed-rate mortgage for a $500,000 house when the interest rates increase from 2.25% to 7.1%? Show your work by using the timeline approach from above. 3. Use all of the information you have developed from the above questions to convince me that a 30-year mortgage is an effective hedge against inflation (the question is telling you that you must convince me, this is a hint). Explore inflation at 2% and 6% to help justify your answer. You won't necessarily need to create a timeline with any values but feel free to reference any of the above solutions as needed. Just answer this one in an empty Excel sheet and label accordingly. Being able to justify mathematically your answer, is most always the best approach

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!