4. Calculate the new monthly payment given a $150,000 loan for 6%, 30 years (monthly)...

4. Calculate the new monthly payment given a $150,000 loan for 6%, 30 years (monthly) with a lump-sum pay down of $20,000 made after 12 years have lapsed.

New MP:

Calculate the upfront fees that needs to be charged by the lender given a loan for $150,000 with terms 6%, 30 years (monthly compounding). The lender wants to earn a 6.6% yield. Assume a holding period of 12 years.
Calculate the total payments and total interest expense for a $150,000 loan with terms 6%, 30 years compounded monthly. The loan is assumed to be held to maturity.

Total Payments: _________________________

Loan Amount: ___________________________

Interest Expense: _________________________

Expert Solution

1) Monthly EMI Calculation if 20000 is paid after 12 years

Information
Loan	150000
Interest	6% pa	0.50%	Monthly
Year	30 years	360	Months

Date	Loan	Principal	Interest	Total EMI	Net Balance	First 12 Years
43,952.00	1,50,000.00	149.32	750.00	899.32	1,49,850.68
43,983.00	1,49,850.68	150.07	749.25	899.32	1,49,700.60
44,013.00	1,49,700.60	150.82	748.50	899.32	1,49,549.78
44,044.00	1,49,549.78	151.58	747.75	899.32	1,49,398.21
44,075.00	1,49,398.21	152.33	746.99	899.32	1,49,245.87
48,274.00	1,19,227.26	303.19	596.14	899.32	1,18,924.07
48,305.00	1,18,924.07	304.70	594.62	899.32	1,18,619.37

Loan	₹ 1,18,619
Lump Sum Repayment	₹ 20,000
Net Loan	₹ 98,619
Interest	6% pa	0.50%	Monthly
Years	18.00	216	Months

EMI	₹ 747.69

2 Interest Principal and total calculation

Information
Loan	150000
Interest	6% pa	0.50%	Monthly
Year	30 years	360	Months

Date	Loan	Principal	Interest	Total EMI	Net Balance
01-05-2020	1,50,000.00	149.32	750.00	899.32	1,49,850.68
01-06-2020	1,49,850.68	150.07	749.25	899.32	1,49,700.60
01-07-2020	1,49,700.60	150.82	748.50	899.32	1,49,549.78
01-08-2020	1,49,549.78	151.58	747.75	899.32	1,49,398.21
01-09-2020	1,49,398.21	152.33	746.99	899.32	1,49,245.87
01-10-2020	1,49,245.87	153.10	746.23	899.32	1,49,092.78
01-12-2049	4,430.93	877.17	22.15	899.32	3,553.76
01-01-2050	3,553.76	881.56	17.77	899.32	2,672.20
01-02-2050	2,672.20	885.96	13.36	899.32	1,786.24
01-03-2050	1,786.24	890.39	8.93	899.32	895.85
01-04-2050	895.85	894.85	4.48	899.32	1.00
	Total	1,49,999.00	1,73,757.93	3,23,756.93

Principal= 150000

INterest = 173758

Total= 323756

jeff jeffy answered 2 years ago

The loan is for $150,000 with a rate of 6% for 30 years payable monthly. Calculate...

The loan is for $150,000 with a rate of 6% for 30 years payable monthly. Calculate the Monthly Payment (MP): Do a monthly Amortization Table for 4 months using the MP: Calculate the Loan Balance (LB) using the formula approach at the end of 4 months.

Refinance decision: The original loan is for $150,000 with terms 6%, 30 years payable monthly. The...

Refinance decision: The original loan is for $150,000 with terms 6%, 30 years payable monthly. The elapsed time on the original loan is 5 years. The new loan rate is 3.6% which will be held 7 years. The cost of refinancing is $3,000. The opportunity cost is 9%. A. Prepare a table that calculates the change in monthly payment and change in Loan Balance numbers: B. Do the Present Value Analysis:

The loan is for $150,000 with terms 6%, 30 years. The graduation rate is 7.5% and...

The loan is for $150,000 with terms 6%, 30 years. The graduation rate is 7.5% and occurs 3 times. Calculate the Monthly Payments and Loan Balances for years 1-4 by designing an Amortization Table:

You purchased a home 6 years ago using a 4% 30-year mortgage with a monthly payment...

You purchased a home 6 years ago using a 4% 30-year mortgage with a monthly payment of $1072.25. Assuming you want to pay off your mortgage today, how much would you have to pay the lender in order to pay off the outstanding balance on your mortgage loan? Round to the nearest dollar.

Calculate the monthly payment for loan amount of $250,000 using the following parameters: • 30 Year...

Calculate the monthly payment for loan amount of $250,000 using the following parameters: • 30 Year Loan, fully amortizing • Interest Rate of 3.50% What is the monthly payment amount (rounded to the nearest dollar)? a. $1,123 b. $1,321 c. $1,572 d. $1,252 Calculate the monthly payment for loan amount of $250,000 using the following parameters: • 15 Year Loan, fully amortizing • Interest Rate of 3.09% What is the monthly payment amount (rounded to the nearest dollar)? a. $1,398...

You obtain a loan of $150,000 at 5.875% amortized over 30 years with monthly payments. You...

You obtain a loan of $150,000 at 5.875% amortized over 30 years with monthly payments. You are required to pay closing costs and fees of 2% of the loan amount to the lender. What is the yield of the loan if paid off at the end of 5 years?

Calculate the loan balance after 6 years of payment of the following Balloon Payment Mortgage: 1...

Calculate the loan balance after 6 years of payment of the following Balloon Payment Mortgage: 1 million dollar loan Rate =5% annualized, monthly compounding Loan term = 25 years Amortization = balloon at the end of loan term of $300,000

The monthly payment for a given loan pays the principal and the interest. The monthly interest...

The monthly payment for a given loan pays the principal and the interest. The monthly interest is computed by multiplying the monthly interest rate and the balance (the remaining principal). The principal paid for the month is therefore the monthly payment minus the monthly interest. Write a pseudocode and a Python program that let the user enter the loan amount, number of years, and interest rate, and then displays the amortization schedule for the loan (payment#, interest, principal, balance, monthly...

The holding period when needed is 12 years, Loan is $150,000 with terms 6%, 30 payable...

The holding period when needed is 12 years, Loan is $150,000 with terms 6%, 30 payable monthly Calculate the effective-interest cost or yield after 12 years have lapsed: Now, assume a prepayment penalty of $600 when calculating the effective-interest cost to the borrower after 12 years have lapsed. Effective-Interest Cost or Internal Rate of Return for the lender:

In underwriting a new 30-year, monthly payment mortgage loan at5% interest for Jackie, the lender...

In underwriting a new 30-year, monthly payment mortgage loan at 5% interest for Jackie, the lender requires that Jackie meet three ratios to be approved for the loan.First, the payment on her loan plus the monthly cost of homeowner's insurance of $200 plus monthly property taxes of $225 plus monthly home owner association fees of $100 can be no more than 28% of her gross monthly income.Second, the monthly total of the four items above plus her car loan payment...

Question