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.

Expert Solution

As shown in attached Screen shot. Put Loan Amount in C3 = 1200000, Interest in C4 in absolute terms i.e. if rate 3.125% then put it as 0.03125, Enter no of periods in C5 i.e. if 5 years and frequency is monthyl then put 180.

Now enter = pmt. the following syntax appears

=PMT (rate, nper, pv, [fv], [type])

Select at Rate = C4/12 ( Divide 12 because monthly frequency and rate is Annual)

nper is No of periods = C5

PV = - C3 ( put minus sign to get positive value in PMT)

[Fv] = It is optional if FV given otherwise left blank

[type] = it is also optional ( 0 for end period payment and 1 for beginning payment i.e. annuity due) ( left blank if annuity regular because it is bydefault.

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

Determine the monthly payment using the added interest method Loan Amount: $ 2,700 Loan term: 2...

Determine the monthly payment using the added interest method Loan Amount: $ 2,700 Loan term: 2 years Interest rate: 7.5% 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?

Suppose that you have two loan choices with monthly payments Choice Loan Amount Term (years) Interest...

Suppose that you have two loan choices with monthly payments Choice Loan Amount Term (years) Interest Rate 1 $ 250,000 30 5% 2 $ 220,000 30 4.50% A) What is the annual incremental borrowing cost for loan 1 over loan 2 if you hold the loan for the entire term, assuming there is no origination cost associated with the loans? 3.34% 5.34% 8.34% 10.34% B) If the origination costs for loans 1 and 2 are $3,500 and $2,500 respectively, and...

Find the lender's yield for this loan: Loan amount: $100,000, Term: 25 years, Interest rate: 8%,...

Find the lender's yield for this loan: Loan amount: $100,000, Term: 25 years, Interest rate: 8%, Lender "points" and origination fee: 2,500, Third-party fees: $3,000. Assume the loan is held until the end of year 5.

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

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