IPMT Function for fractional periods

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm want to know, for an equal amortizing loan, the interest amount for each
period. However, the first period is a fractional period. It starts today
and calculated until the beginning of Sept. I'm not sure how to use the PMT
and IPMT functions for fractional periods. thx
 
Adjust the units you express the period in to days (or half months or weeks, whatever your requirements are).
Of course you'll have to adjust the interest rates accordingly.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm want to know, for an equal amortizing loan, the interest amount for each
| period. However, the first period is a fractional period. It starts today
| and calculated until the beginning of Sept. I'm not sure how to use the PMT
| and IPMT functions for fractional periods. thx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create amortization schedule 0
IPMT Function 4
Amortization table problem 2
pPMT malfunction 1
Problem with Amortization Table using beginning of period 4
PPMT Function 4
PMT formula help 5
Internet amortization answers differ from function 5

Back
Top