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 1 year ago

Next > < Previous

Related 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...

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...

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....

Please, Show work and Formula in excel sheet Your initial loan amount is $200,000. The APR...

**Please, Show work and Formula in excel sheet** Your initial loan amount is $200,000. The APR is 5%. The number of years of the loan is 20 years. Generate the amortization table for the given loan. Assume this is the mortgage on your house. If you elected to pay an additional principal amount of $150.00 each month, in how many months would you pay off your mortgage? Not considering taxes, how much would you save in interest paid to service...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...

Subjects