Respuesta :
Answer:
The total loan value would be of $261,825
Explanation:
In order to calculate how expensive of a home can Tedd purchase using a 4%, 30 year mortgage we would have to calculate first the amount of annual payments as follows:
amount of annual payments = $48,000*0.25 = $12,000
PMT = 12,000/12 = 1000
FV = 0
rate = 4%/12
N = 30*12
Hence, use FV function in Excel amount after down payment = $209,461.24
this represents 80% of the loan , so total loan value = $209,461.24/0.8 = $261,825
The total loan value would be of $261,825
The total loan amount is $261,825.
- The calculation is as follows:
Amount of annual payments = 25% of $48,000 = $12,000
PMT = 12,000 ÷ 12 = $1,000
FV = $0
Rate = 4% ÷ 12 = 0.333%
N = 30 × 12 = 360
Here we have to apply the FV function in the excel.
So,
Amount after downpayment = 209,461.24
The above amount represents 80% of the loan
Now
Total loan value is
= $209,461.24 ÷ 0.8
= $261,825
Learn more: brainly.com/question/6201432
