Question

The payment necessary to amortize a 5.4% loan of $71,000 compounded annually, with 5 annual payments is $16,580.96. The total

*** Blacked out part is 17,000. Please show steps using logs. Thank you.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Pv Loan amount $71,000
Rate Annual interest Rate 5.40%
Pmt Annual Payment $17,000
NPER Number of Years of payment 4.85954913 (Using NPER function of excel with Rate =5.4%, Pmt=17000, Pv=-71000)
(a) Time needed to pay off loan (Years) 4.85954913
(b) Total amount of payment =Pmt*NPER $82,612.34
.(c) Total Interest Payment $11,612.34 (82612.34-71000)
p g c anng fox =NPER (G3,G4,-G2) G5 X C D E G н K L м $71,000 Loan amount Pv Annual interest Rate 5.40% 3 Rate $17,000 4.8595
Add a comment
Know the answer?
Add Answer to:
*** Blacked out part is 17,000. Please show steps using logs. Thank you. The payment necessary...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Find the payment necessary to amortize a 4.9% loan of $7300 compounded semiannually, with 6 semiannual...

    Find the payment necessary to amortize a 4.9% loan of $7300 compounded semiannually, with 6 semiannual payments. Find (a) the payment necessary to amortize the loan and (b) the total payments and the total amount of interest paid based on the calculated semiannual payments. Then create an amortization table to find (c) the total payments and total amount of interest paid based upon the amortization table a. The semiannual payment needed to amortize this loan is $ (Round to the...

  • Please show the steps to calculate X 5.3.17 A borrower had a loan of $10,000.00 at...

    Please show the steps to calculate X 5.3.17 A borrower had a loan of $10,000.00 at 6% compounded annually, with 9 annual payments. Suppose the borrower paid off the loan after 5 years. Calculate the amount needed to pay off the loan. The amount needed to pay off this loan after 5 years is $. (Round to the nearest cent as needed.)

  • A company borrows $160000, which will be paid back to the lender in one payment at the end of 5 years. The company agree...

    A company borrows $160000, which will be paid back to the lender in one payment at the end of 5 years. The company agrees to pay semi-annually interest payments at the nominal annual rate of 10% compounded semi-annually. At the same time the company sets up a sinking fund in order to repay the loan at the end of 5 years. The sinking fund pays interest at an annual nominal interest rate of 4% compounded semi-annually. Find the total amount...

  • A. What would be your monthly mortgage payment if you pay for a $250,000

     4. A. What would be your monthly mortgage payment if you pay for a $250,000 home by making a 20% down payment and then take out a 3.74% thirty year fixed rate mortgage loan where interest is compounded monthly to cover the remaining balance. All work must be shown justifying the following answers. Mortgage payment = B. How much total interest would you have to pay over the entire life of the loan. Total interest paid = C. Suppose you inherit some money and...

  • Please provide the answer showing all steps. Suppose you borrowed $10,000 at an interest rate of...

    Please provide the answer showing all steps. Suppose you borrowed $10,000 at an interest rate of 12%, compounded monthly over 36 months. At the end of the first year (after 12 payments), you want to negotiate with the bank to pay off the remainder of the loan in 8 equal quarterly payments. What is the amount of this quarterly payment, if the interest rate and compounding frequency remain the same?

  • Please show your work as a calculation for all steps. Thank you You have set your...

    Please show your work as a calculation for all steps. Thank you You have set your sights on a house in an up and coming Sydney suburb that is selling for $650,000. You are very excited about the prospects of buying this house and negotiate a 25-year mortgage with 20% down and 5.2% p.a. interest rate, compounded monthly. B1. What will be the amount of your monthly payments? B2. For each month for the duration of your mortgage calculate how...

  • ***For calculator work, show the entries or steps you use.*** #3. To buy your dream home...

    ***For calculator work, show the entries or steps you use.*** #3. To buy your dream home you use a 4/16 reset loan that pays interest only (bullet loan) for the first 4 years, followed with a reset payment to amortize over the remaining 16 years. The loan amount is $180,000 at 5.5%, with 2 discount points (to the lender) and $875 in third party closing costs which the borrower must pay. a) What net amount does the lender disburse? b)...

  • Can you please show all work/steps on how to solve this problem? The correct answers are...

    Can you please show all work/steps on how to solve this problem? The correct answers are included in the screenshot. X Instructor-created question Question is graded. Grade: 0 of 1 pt Submit Grade Question Help A sailboat costs $21,455. You pay 15% down and amortize the rest with equal monthly payments over a 8-year period. If you must pay 6.9% compounded monthly, what is your monthly payment? How much interest will you pay? Monthly payments: $ 247.73 (Round to two...

  • please show your calculations Question 2: What would be the effective rate on a personal loan...

    please show your calculations Question 2: What would be the effective rate on a personal loan in the amount of $20,000 with an annual rate of 6%? Assume it is a discounted loan and the borrower will repay the loan with one payment at the end of 12 months. Question 3: Calculate how much interest you would pay during the first 12 months if you were to borrow $10,000 at 6% to paid off in 5 years via monthly installments....

  • Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $1...

    Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT