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
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...
Ms. Jordan has just taken out a $150,000 mortgage loan at an interest rate of 6...
Ms. Jordan has just taken out a $150,000 mortgage loan at an interest rate of 6 percent. If the mortgage calls for equal monthly payments for 20 years, what is the amount of each payment? Also, work out an amortization table
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT