Find the lender's yield for this loan: Loan amount: $100,000, Term: 25 years, Interest rate: 8%,...

Find the lender's yield for this loan: Loan amount: $100,000, Term: 25 years, Interest rate: 8%, Lender "points" and origination fee: 2,500, Third-party fees: $3,000. Assume the loan is held until the end of year 5.

Expert Solution

jeff jeffy answered 2 years ago

The amount of a loan is $100,000 with an interest rate of 8%. The life of...

The amount of a loan is $100,000 with an interest rate of 8%. The life of the loan is 4 years. Create a loan amortization table.

Amortizing Loan Assignment Excels: Loan Amount Term (years) Interest Rate Payment Frequency Punam Barua $500,000 25...

Amortizing Loan Assignment Excels: Loan Amount Term (years) Interest Rate Payment Frequency Punam Barua $500,000 25 3.50% monthly Militza Bodesinsky $9,500 3 25.00% monthly Rob Boucher $350,000 20 3.00% monthly Janice Coleman $1,000,000 15 2.50% monthly Sadiera Crawford $6,500 3 30.50% monthly Delitzel Cruz $750,000 20 4.00% monthly Eroldy Duverge $25,000 5 6.25% monthly Arlene Flores-Icaza $400,000 30 5.25% monthly John Gurcak $35,000 6 6.75% monthly George Juzdan $800,000 30 3.65% monthly Amani Katerji $10,000 3 30.00% monthly Shanay Leary...

A property costs $100,000. A borrower can obtain an 80% loan with an 8% interest rate...

A property costs $100,000. A borrower can obtain an 80% loan with an 8% interest rate and monthly payments. The loan is to be fully amortized over 25 years. Alternatively he could obtain a 90% loan at an 8.5% interest rate with the same loan term. (annualize percentages) A. The borrower plans to own the property for the entire loan term. What is the incremental cost of borrowing the additional funds? B. How would your answer change if two points...

1. What are the monthly payments for a $100,000 mortgage amount, 8 percent interest rate, and...

1. What are the monthly payments for a $100,000 mortgage amount, 8 percent interest rate, and a 30-year term? A - 8,883 B - 740 C - 734 D - 8,000 2. You are borrowing $10,000 to purchase a car. You plan to make monthly payments for 24 months, and the interest rate is 12%. What is your monthly payment? A - 471 B - 1,285 C - 371 D - 5,075

Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate,...

Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate, a 20-year amortization and monthly payments of $965.02

Suppose that you have two loan choices with monthly payments Choice Loan Amount Term (years) Interest...

Suppose that you have two loan choices with monthly payments Choice Loan Amount Term (years) Interest Rate 1 $ 250,000 30 5% 2 $ 220,000 30 4.50% A) What is the annual incremental borrowing cost for loan 1 over loan 2 if you hold the loan for the entire term, assuming there is no origination cost associated with the loans? 3.34% 5.34% 8.34% 10.34% B) If the origination costs for loans 1 and 2 are $3,500 and $2,500 respectively, and...

Loan amount- 1,200,000 Term(years)- 15% Interest rate- 3.125% Payment frequency- monthly can anyone please solve this...

Loan amount- 1,200,000 Term(years)- 15% Interest rate- 3.125% Payment frequency- monthly can anyone please solve this in excel with formulas for each cells.

Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years...

Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 180 month loan amortization schedule. How much is your total interest payment?

Assume a mortgage loan amount of $ 300,000, with annual interest rate 4% and 5 years...

Assume a mortgage loan amount of $ 300,000, with annual interest rate 4% and 5 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 60 month loan amortization schedule. How much is your total interest payment?

Which of the following closing costs DO NOT increase the lender's effective loan yield? A.) Discount...

Which of the following closing costs DO NOT increase the lender's effective loan yield? A.) Discount points B.) Prepayment penalties C.) Title insurance charges D.) Origination fees

Question