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 2 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).

# 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?

Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years...

Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 180 month loan amortization schedule. How much is your total interest payment?

Question