pmt function

  1. R

    Calculate Present Value/Property Price

    Hi there, I'm clearly out of my league on this one. I'm trying to calculate the total price of a property / present value (this is the variable) knowing everything else. I was thinking of using the PMT (rate, nper, pv) function but I'm stumped here. I don't know how to calculate the present...
  2. P

    Why excel PMT functions's outcome is different from my calculation

    Hello all, Below PMT function is giving me 879,16 for 10%, 12 monthes and 10 000. =PMT(D2/12,12,D1) with D2=10%, Can you please explain howdoes excel comes with this 879,16 outcome? In my mind I do the same calculation like: 10% of 10 000 is 1000. A total amount is 10 000 + 1000 = 11 000. I...
  3. J

    PMT function in VBA form doesn't work with percentages in the textbox

    Hi All, I'm trying to build a really simple form that calculates the monthly payment of an investment. so there are three textboxes: 1. Investment amount 2. Cost of capital 3. Amortization months. and then I have a button that calculates the monthly payment using a PMT function. The issue is...
  4. E

    Help needed with PMT Function with an initial down payment

    I need help solving the following problem. I know what to do with the standard PMT Function but what does one do when one has an initial deposit or down payment. I have to solve the following problem: A client is interested in a certain insurance product. She expects to earn $11, 0000 after 18...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top