loan amount - 1,200,000. terms(years) - 15 interest rate - 3.125% payment frequency - monthly Amortizing...

loan amount - 1,200,000.

terms(years) - 15

interest rate - 3.125%

payment frequency - monthly

Amortizing Loan Assignment

Expert Solution

jeff jeffy answered 3 years ago

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.

loan - 1,200,000terms - 15 yearsinterest rate - 3.125%payment frequency- monthlyamortizing loan...

loan - 1,200,000terms - 15 yearsinterest rate - 3.125%payment frequency- monthlyamortizing loan assignmentplease solve in excel

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 fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is...

A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is 6 percent per year compounding monthly. Payments are to be made monthly. What is the principal payment in the first monthly payment?

Loan Amortization Schedule, $80,000,000 at 8% for 15 years Year Beginning Amount Payment Interest Payment of...

Loan Amortization Schedule, $80,000,000 at 8% for 15 years Year Beginning Amount Payment Interest Payment of Principal Ending Balance 1 $ 80,000,000.00 $ 1,933.28 $ 533,333.33 $ (531,400.05) $ 80,531,400.05 2 $ 80,531,400.05 $ 1,933.28 $ 536,876.00 $ (534,942.72) $ 81,066,342.77 3 $ 81,066,342.77 $ 1,933.28 $ 540,442.29 $ (538,509.01) $ 81,604,851.78 4 $ 81,604,851.78 $ 1,933.28 $ 544,032.35 $ (542,099.07) $ 82,146,950.84 179 $ 260,404,969.06 $ 1,933.28 $ 1,736,033.13 $ (1,734,099.85) $ 262,139,068.91 180 $ 262,139,068.91 $ 1,933.28 $ ...

5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is...

5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is 3% per year, Compounded annually Compounded monthly Compounded daily What are effective annual rates for 1,2, and 3 above?

2. A What is the monthly payment amount on a $100,000 home loan if the rate...

2. A What is the monthly payment amount on a $100,000 home loan if the rate is 8.0% APR, and the loan is made for a 15-year period? B A four-year investment requires annual deposits of $300 at the beginning of each year. The deposits earn 6% per year. What is the investment’s future value? Remember, the deposits are made at the beginning of each year (annuity due).

The loan term is 15 years, the payments are made monthly, the loan amount is $3,000,000...

The loan term is 15 years, the payments are made monthly, the loan amount is $3,000,000 and the interest rate is 8.25% APR. A. Create an amortization schedule for the following loan. B. What are the totals over the loan term for the interest? Principal? Total payments? C. What is the total principal payment during the 4th year (i.e. year 4 only!) of the loan?

# Payment and frequency (PMT) Time in years (n) Interest rate and compound frequency...

# Payment and frequency (PMT) Time in years (n) Interest rate and compound frequency (I/Y) Present Value (PV) Future Value (FV) 1. $380.00 every 6 months 8 years 7% compounded semi-annually ______________ Not Applicable 2 $456.50 per month 5 ¾ years 7 ¼ % compounded monthly Not Applicable _______________ 3 $____________ per year 25 payments 3 % compounded annually $20,000 Not Applicable 4 $454.30 per quarter __________years 7.54 % compounded quarterly Not Applicable $24,000 5...

On a 30-year, fixed-rate loan with a monthly payment of $1,000 and an interest rate of...

On a 30-year, fixed-rate loan with a monthly payment of $1,000 and an interest rate of 9%, what is the outstanding balance due on the loan with after the borrower has made 18 years of payments?

Question