Question
In: Finance
SHOW CLEAR WORK ON EXCEL A borrower is faced with choosing between two loans. Loan A...
SHOW CLEAR WORK ON EXCEL
A borrower is faced with choosing between two loans. Loan A is available for $75,000 at 6 percent interest for 30 years, with 6 points to be included in closing costs. Loan B would be made for the same amount, but for 7 percent interest for 30 years, with 2 points to be included in the closing costs. Both loans will be fully amortizing.
a. If the loan is repaid after 20 years, which loan would be the better choice?
b. If the loan is repaid after five years, which loan is the better choice?
Solutions
Expert Solution
To decide between the options, we need to calculate the annual effective interest rate paid by the borrower.
The choice with lower effective interest will be the better option as the effective total cost would be lower to the borrower:
Excel Calculations:
Kindly give a thumbs up!!
jeff jeffy answered 2 years agoRelated Solutions
A borrower is faced with choosing between two loans. Loan A is available for $75,000 at...
A borrower is faced with choosing between two loans. Loan A is
available for $75,000 at 6.5% interest for 30 years, with 3% loan
origination fee. Loan B would be made for the same amount, but for
7% interest for 30 years, with 0.5% loan origination fee. Both
loans will be fully amortizing.
a) If the loan is repaid after 20 years, which loan would be the
better choice?
b) If the loan is repaid after 5 years, which loan...
2. [6 pts] A borrower is faced with choosing between two fully amortizing level-payment loans. Loan...
2. [6 pts] A borrower is faced with choosing between two fully
amortizing level-payment loans. Loan A is available for $75,000 at
10% MEY for 30 years, with 6 points included in the closing costs.
Loan B would be made for the same amount, but at 11% MEY for 30
years, with 2 points included in the closing costs. Neither loan
defaults/is curtailed. a. [4] If the loan is to be repaid after 15
years, which is the better choice?...
SHOW CLEAR WORK ON EXCEL A fully amortizing mortgage loan is made for $100,000 at 6...
SHOW CLEAR WORK ON EXCEL
A fully amortizing mortgage loan is made for $100,000 at 6
percent interest for 30 years. Determine payments for each of the
periods a–d below if interest is accured:
a. Monthly.
b. Quarterly.
c. Annually.
d. Weekly.
SHOW CLEAR WORK ON EXCEL A 30-year fully amortizing mortgage loan was made 10 years ago...
SHOW CLEAR WORK ON EXCEL
A 30-year fully amortizing mortgage loan was made 10 years ago
for $75,000 at 6 percent interest. The borrower would like to
prepay the mortgage balance by $10,000.
a.
Assuminghecanreducehismonthlymortgagepayments,whatisthenewmortgagepayment?
b. Assuming the loan maturity is shortened and using the
original monthly payments, what is the new loan maturity?
1 City Choice ( show all work) A sports franchise is choosing between two cities: city...
1 City Choice ( show all work)
A sports franchise is choosing between two cities: city A and
city B. The team analyst has estimated the following demands for
each city:
City A: PA = 90 − .001A
City B: PB = 130 − .002B
where A is the quantity of fans in city A, and B is the quantity
of fans in city B. The analyst aalso estimates that the marginal
cost in each city is $10, and the...
A borrower is purchasing a property for $725,000 and can choose between two possible loan alternatives....
A borrower is purchasing a property for $725,000 and can choose
between two possible loan alternatives. The first is 85% LTV loan
for 30 years at 3.5% interest and 1 point and the second is at 70%
LTV loan for 30 years at 2.875% interest and no points. Assuming
the loan will be held until maturity, what is the incremental cost
of borrowing the extra money?
A) 6.14%
B) 6.7%
C)6.33%
D)7.74%
A borrower is purchasing a property for $725,000 and can choose between two possible loan alternatives....
A borrower is purchasing a property for $725,000 and can choose
between two possible loan alternatives. The first is an 85% loan
for 30 years at 3.5% interest and 1 point and the second is a 70%
loan for 30 years at 2.875% interest and no points. Assuming the
loan will be repaid in 5 years, what is the incremental cost of
borrowing the extra money?
A. 6.14%
B. 6.7%
C. 6.33%
D. 7.74%
20) A borrower is purchasing a property for $180,000 and can choose between two possible loan...
20) A borrower is purchasing a property for $180,000 and can
choose between two possible loan alternatives. The first is a 90%
loan for 25 years at 9% interest and 1 point and the second is a
95% loan for 25 years at 9.25% interest and 1 point. Assuming the
loan will be repaid in 5 years, what is the
incremental cost of borrowing the extra money? A) 13.95% B) 13.67%
C) 14.42% D) 12.39%.
I know the answer is...
A borrower is purchasing a property for $180,000 and can choose between two possible loan alternatives....
A borrower is purchasing a property for $180,000 and can choose
between two possible loan alternatives. The first is a 80% loan for
25 years at 8% interest and 1 point and the second is a 95% loan
for 25 years at 9.25% interest and 2 points. Assuming the loan will
be held to maturity, what is the incremental cost of borrowing the
extra money?
SHOW CLEAR WORK ON EXCEL Regarding Problem 3,how much total interest and principal would be paid...
SHOW CLEAR WORK ON EXCEL
Regarding Problem 3,how much total interest and principal would
be paid over the entire 30-year life of the mortgage in each case?
Which payment pattern would have the greatest total amount of
interest over the 30-year term of the loan? Why?
(reference problem 3)
A fully amortizing mortgage loan is made for $100,000 at 6
percent interest for 30 years. Determine payments for each of the
periods a–d below if interest is accured:
a. Monthly....
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Given an array of positive integers a, your task is to calculate the sum of every...
- Define “culture.” Software is defined by the Merriam-Webster Dictionary as "the programs that run on a...
- In humans, hypotrichosis (sparse body hair) is a rare autosomal recessive condition. Let h = hypotrichosis...
- Increase all of the listing prices by 5% for all listings under $500,000 and 10% for...
- Samsung Industry that requires you to act as a change agent to form an organizational change...
- Use fork() Create a program that reads characters from an input file. Use fork to create...
- A pension fund manager is considering three mutual funds. The first is a stock fund, the...
ADVERTISEMENT