Using an initial principal of 80% of the purchase price, Asking price of $262,000; a...

60.1K

Verified Solution

Question

Finance

Using an initial principal of 80% of the purchase price, Asking price of $262,000; a 180-month term (15 years), and the interest rate you found for a 15-year loan, create an amortization table for the loan. Label your columns Month, Interest Payment, and Principal Payment. Again, you must use a spreadsheet. Put this table into the second tab of your spreadsheet and label the tab 15-year.

How much total interest would you pay for the loan?

To the nearest whole percent, what percent of your payments would go to interest?

How much less interest would you pay than you would have for the 30-year loan?

Does anything surprise you about the last two answers? Explain why or why not.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students