Question: Please do it on excel using formula 3 A lender is considering what terms to allow on a loan. Current market terms include 8% interest

Please do it on excel using formula

3 A lender is considering what terms to allow on a loan. Current market terms include 8% interest for 25 years for a fully amortizing loan. The lender anticipates market rates to move upward very soon, possibily before the loan is closed and the borrower has a less than perfect credit record. The lender decides to offer the borrower a constant payment mortgage (our typical loan) for $95,000 at 9% for 25 years; however, the lender wants to charge a loan origination fee (points) to make the mortgage loan yield 10%. a. What origination fee should the lender charge? b. What fee should be charged if the loan will be repaid in 10 years

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 Accounting Questions!

3 A lender is considering what terms to allow on a loan. Current market terms include 8% interest for 25 years for a fully amortizing loan. The lender anticipates market rates to move upward very...

A lender is considering what terms to allow on a loan. Current market terms are 9 percent interest for 25 years for a fully amortizing loan. The borrower, Rich, has requested a loan of $105,000. The...

A lender is considering what terms to allow on a loan. Current market terms are 9 percent interest for 2 5 years for a fully amortizing loan. The borrower, Rich, has requested a loan of $ 1 0 9 , 0 0...

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

Q.1 all of my answers are incorrect Q.2 both answers are inccorect John wants to "roll in" or finance the loan fee of $3,500 into the loan amount which would make the loan $87,500 and the interest...

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

Please show ALL work in excel specifically the origination fee calculation. Thank you! A lender is considering what terms to allow on a loan. Current market terms are 9 percent interest for 25 years...

SHOW CLEAR WORK ON EXCEL A lender is considering what terms to allow on a loan. Current market terms are 9 percent interest for 25 years for a fully amortizing loan. The borrower, Rich, has requested...

In January 20X3, Elliott Industries recorded the following transactions: (1) Paid bills from 20X2 totaling $120,000 and collected $150,000 for sales that were made in 20X2. (2) Purchased inventory on...

A cardioid can be described by the polar cquation r = 2+2 cos 0 Determine the gradient of this curve when 0 = T/2 making clear your workings. 5

What was the Adjusted Closing price of Walmart common stock ranging in the current month? Multiple Choice Less than $ 2 0 0 Berween $ 2 0 1 and $ 2 5 0 Betweten $ 2 5 1 and $ 3 0 0

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? left join university.students on...