HELP!! Monthly Interest for Loan Reports

[Joels7]

I need to prepare a report which will show a record of all
interest payments made on Investments, showing a complete history of interest payments made on each investment.

So for an investment that payed interest semi annually, it would have to show interest payments having on January 1 and July 1st of previous years.

The interest is based on a 365-day year, so I need to be able to show interest amounts for each month.

I'm looking for advice in organizing this as simply as possible.

Thank you,

Joels

 

[MichaelRed]

At best this is mixed metaphor. If a payment is due semi-annually, then the interest is for the payment period of (six months). It is NOT due (and therefor not reportable) on a monthly basis. You also state the " ... interest is based on a 365-day year ... " -BUT this doesn't give the interest type or wheather the interest (payment is due at the beginning of the payment period or the end). If you have Excel on your system, you should look at the help for various financial functions (PPMT, FV, PMT, PV ...). there will -perhaps- give you some thoughts regarding the info necessary to do the calculation.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over