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

Question

In: Finance

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

loan - 1,200,000

terms - 15 years

interest rate - 3.125%

payment frequency- monthly

amortizing loan assignment

please solve in excel

Expert Solution

jeff jeffy answered 2 years ago

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

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.

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

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?

Suppose that a 15-year mortgage loan for $200,000 is obtained. The mortgage is a level-payment, fixed-rate,...

Suppose that a 15-year mortgage loan for $200,000 is obtained. The mortgage is a level-payment, fixed-rate, fully amortized mortgage and the mortgage rate is 7.0% (APR, monthly). a. Find the monthly mortgage payment. b. Compute an amortization schedule for the first six months. c. What will the mortgage balance be at the end of the 15th year? d. If an investor purchased this mortgage, what will the timing of the cash flow be assuming that the borrower does not default?

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

The monthly payment on a loan may be calculated by the following formula: Payment = Rate *...

The monthly payment on a loan may be calculated by the following formula: Payment = Rate * (1 + Rate)N ((1 + Rate)N -1) Rate is the monthly interest rate, which is the annual interest rate divided by 12. (12 percent annual interest would be 1 percent monthly interest.) N is the number of payments, and L is the amount of the loan. Write a program that asks for these (Input) values then displays a report similar to: Loan Amount: $...

Develop the payment table for a balloon payment loan $125,000 loan, 10 years, 10% interest rate,...

Develop the payment table for a balloon payment loan $125,000 loan, 10 years, 10% interest rate, balloon payment of $100,000 Year Total Payment Interest Paid Principal Paid Principal Remaining Balloon

Coupon Rate as mentioned is 8.750% Payment Frequency is Semi Annually meaning payment to be done...

Coupon Rate as mentioned is 8.750% Payment Frequency is Semi Annually meaning payment to be done two times in a year. Offering Date is 01/05/1983 Maturity Date is 01/15/2023 Offering Price is $99.45 FV = 100 Trading Price = 105.06 A. Using the offering price found in step 3 and assuming the FV = 100 what is the YTM of your bond on offering (This means compute the YTM as if today was the offering date, show all work). B....

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 $ ...