Question

In: Finance

Constant Amortizing Mortgage Create an amortization schedule and answer the following questions for a $600,000 30-year...

Constant Amortizing Mortgage Create an amortization schedule and answer the following questions for a $600,000 30-year fully-amortizing CAM loan with monthly payments. The contract interest rate on the loan is 3.25% and there are no points associated with the loan.

a.) Assuming no upfront fees/points or prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 7?

b.) Assuming 1 point in origination fees but no prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 7?

Show in Excel with screenshot and formula

c.) Assuming 1 point in origination fees and a 2% prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 7?

Solutions

Expert Solution

Calculations:

Formulas:


Related Solutions

On the second tab build the full amortization table for a 15 year Constant Amortizing Mortgage...
On the second tab build the full amortization table for a 15 year Constant Amortizing Mortgage (CAM) Loan with a 6% interest rate compounded monthly. The initial loan amount should be $7,500,000. in excel
Your 30 year mortgage is $350,000 with an interest rate of 4%. Prepare the amortization schedule...
Your 30 year mortgage is $350,000 with an interest rate of 4%. Prepare the amortization schedule for repayment of the mortgage
Create an Amortization Schedule for a $275,000 office building to be purchased with a 30-year loan...
Create an Amortization Schedule for a $275,000 office building to be purchased with a 30-year loan at an APR of 5% compounded monthly. Determine the monthly payments and how much interest is paid over the life of the loan. (format amortization schedule with the following columns: month, beginning principal, monthly payment, monthly interest, principal reduction, ending principal)
On the third tab build the full amortization table for a 30 year Constant Payment Mortgage...
On the third tab build the full amortization table for a 30 year Constant Payment Mortgage (CPM) Loan with a 4.5% interest rate compounded monthly. The initial loan amount should be $2,500,000. in excel
Create a loan amortization schedule in Excell for a $275,000 mortgage that will be repaid over...
Create a loan amortization schedule in Excell for a $275,000 mortgage that will be repaid over 20 years with monthlypayments.  The annual interest rate is 5.5 %. What is your monthly payment?  $ What is the total dollar amount of payments made over the life of this loan? $__ What is the total dollar amount of interest paid over the life of this loan? $_ How many months will it take to pay off the loan if you pay an extra $100...
Create an amortization table for the following mortgage. a. Mortgage amount is $300,000. b. The mortgage...
Create an amortization table for the following mortgage. a. Mortgage amount is $300,000. b. The mortgage is a 30 year fixed at 4% (paid monthly). c. You pay an additional $100 per month until the mortgage is paid. When will the mortgage be paid off? Please show in Excel along with formulas.
Mortgage Payable The following amortization schedule can be used for the January, 20x3 mortgage payment on...
Mortgage Payable The following amortization schedule can be used for the January, 20x3 mortgage payment on the 7.0%, 30- year mortgage. Month Payment Interest Principal Balance January $3,500 $1,867 $1,633 $320,000 $318,367 Jan 31 The monthly payment for January of the mortgage payable was made. Required: What is the correct journal entry for this transaction and why?
An amortization schedule is a common concept within a banking enterprise. Create your own amortization schedule...
An amortization schedule is a common concept within a banking enterprise. Create your own amortization schedule for a $10,000 loan with monthly payments paid over two years. Assume the annual percentage rate (APR) is 4%. Create the amortization schedule within Excel or another spreadsheet application. Use page 184 as a template. Keep in mind that the example on page 184 uses annual payments, while your schedule will use monthly payments. You will need to adjust the number of payment periods...
Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two...
Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two years using an 8 percent APR.
A fixed-rate constant-payment partially-amortizing mortgage is made for $100,000 at 5% for 30 years. The balloon...
A fixed-rate constant-payment partially-amortizing mortgage is made for $100,000 at 5% for 30 years. The balloon payment will be $50,000 at the end of year 30. Calculate the monthly payment. What will the total of payments be for entire 30 years? Of the total, how much will be interest? What would be the outstanding balance after 5 years?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT