how do i do interest roll up calculation in excel

S

smartin

Steve Costello wrote:

[nada]

Steve, please throw us a bone and describe your problem in more detail.
 
S

Spiky

Make a table like for any loan. Period, Date, Payment, Interest,
Principal, Balance. In the Balance column where you usually take the
previous balance less principal payment, also add in the interest.
 

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

Calculate Daily Interest, Paid out Weekly 5
Back calculating compound interest... 1
How to roll mouse in formula 8
Calculating Future Value 8
Interest and Payment Calculations 6
How do I create the formula for this calculation? 1
Calculating interest due on late loan payments 1
how do I open a file when the file format is not valid? 0

Top