Question

home healthcare has just borrowed $2,000,000 on a five-year, annual payment term loan at a 15...

home healthcare has just borrowed $2,000,000 on a five-year, annual payment term loan at a 15 percent rate. the first payment is due one year from now. construct the amortization schedule for this loan

please explain using PMT in excel format. I need to input this into excel

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

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

Rate =Interest Rate

Nper=Number of period

Pv=Value of Loan

Fv=Value of loan at end =0

Type =0

=PMT(15%,5,-2000000)

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Boston Healthcare has just borrowed $2,000,000 on a seven-year, annual payment term loan at a 6...
Boston Healthcare has just borrowed $2,000,000 on a seven-year, annual payment term loan at a 6 percent rate. The first payment is due one year from now. Construct the amortization schedule for this loan.
Consider a $75,000 mortgage loan with an annual interest rate of 4 percent. The loan term...
Consider a $75,000 mortgage loan with an annual interest rate of 4 percent. The loan term is seven years, but monthly payments will be based on a 30-year amortization schedule. What is the monthly payment? What will be the required balloon payment at the end of the loan term?
You borrow ​$300,000 to buy a house over a 15​-year term. The loan is structured as...
You borrow ​$300,000 to buy a house over a 15​-year term. The loan is structured as an amortized loan with annual payments and an interest rate of 10​%. Find the information for the amortization schedule for years 1 and 2. Payment​ ($) Interest in Payment​ ($) Principal Repaid​ ($) Principal Owing at End of Year​ ($)
A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an...
A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their twenty-fifth payment and the current balance on the loan is $208,555.87. Interest rates are at an all-time low, and Dave and Jana are thinking of refinancing to a new 15-year fixed loan. Their bank has made the following offer: 15-year term, 3.0%, plus out-of-pocket costs of $2,937. The...
You borrowed $50,000 for your business today with an interest rate of 7.5%. Your first of...
You borrowed $50,000 for your business today with an interest rate of 7.5%. Your first of five (5) equal annual payments on this loan will be made one year from now. PLEASE SHOW ALL EXCEL FORMULAS/FUNCTIONS (A) What is your annual payment on this loan? (B) Create an amortization table for this loan. The headings and periods (years) for the amortization table are provided below.
Rutherford Hayes has borrowed $80000 as mortgage loan at 7.5% interest rate and 30-year term. He...
Rutherford Hayes has borrowed $80000 as mortgage loan at 7.5% interest rate and 30-year term. He has to pay the loan in monthly installments. After how many payments will the unpaid balance become $40000?  (Answer: 264.94 months) Please answer in excel format
Mahesh takes a five year car loan of Rs.1,00,000 where he has to pay annual payments...
Mahesh takes a five year car loan of Rs.1,00,000 where he has to pay annual payments at 10%p.a. Calculate his annual payment and also prepare a loan amortization schedule for the loan repayment.
Your company is planning to borrow $1 million on a 5-year, 15%, annual payment, fully amortized...
Your company is planning to borrow $1 million on a 5-year, 15%, annual payment, fully amortized term loan. Develop an amortization schedule by inserting an additional column that will represent the fraction of the payment made at the end of each year that will represent repayment of principal.
Please create a Variable Interest Rate Loan Amortization schedule with the columns: Year, Amount owed on...
Please create a Variable Interest Rate Loan Amortization schedule with the columns: Year, Amount owed on the principal at the beginning of the year, Annuity payment, Interest portion of the annuity, Repayment of the principal portion of the annuity, outstanding loan balance at year end For the following: You obtain a $6,000 loan from a furniture dealer at a variable interest rate. The loan payments is adjusted every year based on the annuity amount implied by interest rate of year...
Allysha just borrowed 39,900 dollars. She plans to repay this loan by making a special payment...
Allysha just borrowed 39,900 dollars. She plans to repay this loan by making a special payment of 5,000 dollars in 5 years and by making regular annual payments of 7,900 dollars per year until the loan is paid off. If the interest rate on the loan is 4.79 percent per year and she makes her first regular annual payment of 7,900 dollars in one year, then how many regular annual payments of 7,900 dollars must Allysha make? Round your answer...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT