Thursday, November 8, 2018

Loans Analyzed with PMT and PV




Question One:   A person has $25,000 to lend for 20 years.

What is the monthly payment received if the annual interest rate is 3 percent per year?  

What is the monthly payment received if the annual interest rate is 6 percent per year?

Answer:  This problem is solved below with the PMT function.

Impact of Interest Rates on Bond Payments
rate
nper
PV
PMT
0.03
240
25000
$138.65
0.06
240
25000
$179.11
Diff.
$40.46


Question Two: How much should a person loan to receive a $300 monthly payment on a loan when the annual interest rate is 3 percent per year?

How much should a person invest to receive a $600 monthly interest payment on a bond at the same 3 percent annual interest rate?

Answer:   The required loan is calculated with the PV function.

Required Bond Purchase
Rate
nper
PMT
PV
0.03
240
300
$54,093.27
0.03
240
600
$108,186.55

Note that when the interest rate is doubled and the term (nper) is unchanged the required bond purchase doubles.

Note also that the two problems presented here involve loans not bonds.   The output from the PMT function is both interest and repayment of principal.


More questions solving finance problems in Excel can be found here.






5 comments:

  1. Thank you for such a well written article. It’s full of insightful information and entertaining descriptions. Your point of view is the best among many. direct partner lenders at slick cash loan

    ReplyDelete
  2. I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. personal loan against property in pakistan - hbl credit card

    ReplyDelete
  3. Thanks for a wonderful share. Your article has proved your hard work and experience you have got in this field. Brilliant .i love it reading. theloanrepublic

    ReplyDelete
  4. I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have enjoyed reading. Nice blog, I will keep visiting this blog very often. https://gogopaydayloans.com

    ReplyDelete
  5. New web site is looking good. Thanks for the great effort. crediteck.co.uk

    ReplyDelete