Question
A home is purchased for $230,000 with an amortized loan over 15 years at an interest rate of 4.4%. Complete an amortized loan schedule in
-
A home is purchased for $230,000 with an amortized loan over 15 years at an interest rate of 4.4%. Complete an amortized loan schedule in a spread sheet and answer the following questions.
-
Find the balance owed after 5 years
-
Determine the cost of the loan (interest).
-
If an extra $100 a month is paid towards the balance find the new number of payments and the total cost of the loan.
-
If the interest rate of the loan is doubled to 8.8% does the cost of the loan double? Explain
-
If the principal of the loan is doubled to $460,000 does the cost of the loan double? Explain
-
If the term of the loan is doubled to 30 years does the cost of the loan double? Explain
A home is purchased for $230,000 with an amortized loan over 15 years at an interest rate of 4.4%. Complete an amortized loan schedule in a spread sheet and answer the following questions.
-
Find the balance owed after 5 years
-
Determine the cost of the loan (interest).
-
If an extra $100 a month is paid towards the balance find the new number of payments and the total cost of the loan.
-
If the interest rate of the loan is doubled to 8.8% does the cost of the loan double? Explain
-
If the principal of the loan is doubled to $460,000 does the cost of the loan double? Explain
-
If the term of the loan is doubled to 30 years does the cost of the loan double? Explain
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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