Question: 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

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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A borrower is faced with choosing between two loans. Loan \ ( A \ ) is available for \ ( \ $ 9 4 , 0 0 0 \ ) at 6 percent interest for 3 0 years, with 6 points to be included in closing costs. Loan B...

Ch 4 Assignment 2 Problem 4 - 1 6 5 points eBook References A borrower is faced with choosing between two loans. Loan A is available for $ 7 5 , 0 0 0 at 6 percent interest for 3 0 years, with 6...

both parts A&B please. need asap A borrower is faced with choosing between two loans. Loan A is available for $84,000 at 6 percent interest for 30 years, with 6 points to be included in closing...

A borrower is faced with choosing between two loans. Loan A is available for $ 8 3 , 0 0 0 at 6 percent interest for 3 0 years, with 6 points to be included in closing costs. Loan B would be made for...

19 A partially amortizing loan for $90,000 for 10 years is made at 6 percent interest. The lender and borrower agree that payments will be monthly and that a balance of $20,000 will remain and be...

[20 pts] The average life of a bond is defined as = (_(t=1)^TtPCFt)/(_(t=1)^T PCFt) where PCF t is the principal cash flow at time t , and T is the maturity of the bond. a. [1 pt.] What is the...

13. John wants to buy a property for $105,000 and wants an 80 percent loan for $84,000. A lender indicates that a fully amortizing loan can be obtained for 30 years ( 360 months) at 6 percent...

A borrower is faced with choosing between two loans. Loan A is available for $ 7 9 , 0 0 0 at 6 percent interest for 3 0 years, with 6 points to be included in closing costs. Loan B would be made for...

You have had a 30yr FA FRM at 10% for 5 years. The original principal was 1,000,000. You are considering a cash-out refi into a 15-year mortgage at 7.5%. The old mortgage has a prepay penalty of 3%...

Explain the treatment of dividends from the associate under the equity method of accounting.

5-Fluorouracil is a drug used in cancer chemotherapy. What is its structure?

Think total costs do they change as the activity ( i . e . production level ) changes? Following is a list of various costs incurred in producing replacement automobile parts. With respect to the...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...