Question

In: Finance

Discussion with lenders indicates that a loan can be obtained fro 75% of a property's market...

Discussion with lenders indicates that a loan can be obtained fro 75% of a property's market value. Loan terms will probably be 8% interest, 20-year amortization (monthly payments), with the rate renegotiable after 7 years. The property is estimated to be worth $200,000.

a) How much can be borrowed?

b) What will be the annual debt service?

c) What is the expected annual loan constant?

Show all work along with the formulas you used.

Solutions

Expert Solution

a)

Borrowing amount:

= $200,000*75%

= $150,000

b)

Equal monthly payment [P×r×(1+r)^n]÷[(1+r)^n-1]
Here,
1 Interest rate per annum 8.00%
2 Number of years                                                                                                                20
3 Number of compoundings per per annum                                                                                                                12
4 = 1÷3 Interest rate per period ( r) 0.67%
5 = 2×3 Number of periods (n) 240
Loan amount (P) $                                                                                                 150,000
Equal monthly payment $                                                                 1,254.66
150000*0.67%*(1+0.67%)^240)/((1+0.67%)^240-1)

Annual debt service = Equal monthly payment*12

= $1,254.66

= $15,055.92

c)

Annual loan constant:

= [Interest rate/12]/(1-(1/(1+[Interest rate/12])^n))*12

= [8%/12]/(1-(1/(1+[8%/12])^240))*12

= 10.04%


Related Solutions

Data Modeling question: model a personal lending app where Borrowers can request loan amounts, Lenders can...
Data Modeling question: model a personal lending app where Borrowers can request loan amounts, Lenders can offer Loans that are either amortized, installment-based, or interest-based, Borrowers can accept or reject loan offers, and the app tracks the principal, balance and payments made or missed.
A bank's loan officer rates applicants fro credit. The ratings are normally distributed with a mean...
A bank's loan officer rates applicants fro credit. The ratings are normally distributed with a mean of 620 and a standard deviation of 50. If 40 applicants are randomly selected, find the probability that their mean credit score is between 575 and 630. Round to 4-decimal places.
A bank's loan officer rates applicants fro credit. The ratings are normally distributed with a mean...
A bank's loan officer rates applicants fro credit. The ratings are normally distributed with a mean of 600 and a standard deviation of 50. If 40 applicants are randomly selected, find the probability that their mean credit score is more than 575. Round to 4-decimal places.
George bought a new car with a 4.1% interest rate fro 5 years. The loan is...
George bought a new car with a 4.1% interest rate fro 5 years. The loan is for $35,000. What is the interest portion of the 48th payment?
Name and describe the “C’s” of credit that Banks and other lenders use in evaluating loan...
Name and describe the “C’s” of credit that Banks and other lenders use in evaluating loan applicants. Which do you consider the most important and Why?
Name and describe the “C’s” of credit that Banks and other lenders use in evaluating loan...
Name and describe the “C’s” of credit that Banks and other lenders use in evaluating loan applicants. Which do you consider the most important and Why?
Detroit Fishing obtained a $40,000 loan for the construction of a trawler, The loan contract requires...
Detroit Fishing obtained a $40,000 loan for the construction of a trawler, The loan contract requires seven equal annual payments including interest at 11.830625% compounded annually. Construct the full amortization schedule for the loan.
Suppose that there is limited commitment in the credit market, but lenders are uncertain about the...
Suppose that there is limited commitment in the credit market, but lenders are uncertain about the value of collateral. Each consumer has a quantity of collateral H, but from the point of view of the lender, there is a probability a that the collateral will be worth p in the future period, and probability (1-a) that the collateral will be worthless in the future period. Suppose that all consumers are identical. a) Determine the collateral constraint for the consumer, and...
What are some lenders that do home loan refinance with someone of low income, state of...
What are some lenders that do home loan refinance with someone of low income, state of florida
A 100,000 loan can be obtained at a 10 percent rate with monthly payments over a 15 year term.
A 100,000 loan can be obtained at a 10 percent rate with monthly payments over a 15 year term.a. What is the after tax effective interest rate on the loan, assuming the borrower is in a 30 percent tax bracket and the loan is only held three years? Assume that the benefit of interest deductions for tax purposes occurs at the same time payments are made.b. Calculate the after tax effective cost for the above loan, assuming that 5 points...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT