Question

In: Finance

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.

  1. Calculate the Monthly Payments and Loan Balances for years 1-4 by designing an Amortization Table:

Solutions

Expert Solution

Formulas used:-

Installment=PMT(B5,B4,-B3)


Related Solutions

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 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:
An ARM is made for $150,000 for 30 years with the following terms: Initial interest rate...
An ARM is made for $150,000 for 30 years with the following terms: Initial interest rate = 3% Index = 1-year Treasuries Payments reset each year Margin = 2 percent Fully amortizing Interest rate cap = 1 percent annually; 3 percent lifetime Estimated forward rates: BOY 2 4.00% BOY 3 5.25% BOY 4 6% BOY 5 6.50% Compute payments and balances for each of the years 1-5.
​You wish to buy a car worth $27,500. The terms of the loan call for a weekly payment for 6 years at 7.5 percent rate of interest.
You wish to buy a car worth $27,500. The terms of the loan call for a weekly payment for 6 years at 7.5 percent rate of interest. If you decide to go ahead in purchasing this car what will be the amount of each payment?
      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...
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?
You choose a 3/1 hybrid loan of $150,000 with 30 year amortization and an initial rate...
You choose a 3/1 hybrid loan of $150,000 with 30 year amortization and an initial rate of 4.25%. What is the balance of the loan after three years? A. $143,985 B. $142,080 C. $143,400 D. $141,736
A fully amortizing CPM loan is made for $150,000 at 5% interest rate for 20 years...
A fully amortizing CPM loan is made for $150,000 at 5% interest rate for 20 years with monthly repayments. 1. Calculate the monthly debt service. 2. What will be the outstanding loan balance at the end of year 10 and how much total interest will have been paid on the loan by then? 3. If the borrower chooses to reduce the loan balance by $20,000 at the end of year 10, when will the loan be fully repaid if the...
Assume that the lender offers a 30-year, $150,000 adjustable rate mortgage (ARM) with the following terms:...
Assume that the lender offers a 30-year, $150,000 adjustable rate mortgage (ARM) with the following terms: Initial Interest Rate = 7.5% Index = one-year Treasuries Payments reset each year Margin = 2% Interest rate cap = 1% annually; 3% lifetime Discount points = 2% Fully amortizing; however, negative amortization allowed if interest rate caps reached. Based on estimated forward rates, the index to which ARM is tied forecasted as follows: Beginning of year BOY2 = 7%; BOY3 = 8.5%' BOY4...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT