Repeat calculations

[JimDandy]

How can I perform a series of what I can only describe as circular
calculations? What I mean is I want to perform a calculation which
creates a particular result. I then want to perform that same
calculation using the newly created result and I’d like to perform that
process a certain number of times based on input from the user.

I also need to keep a running total of certain amounts calculated along
the way. The calculations I want to do stem from a basic amortization
calculation and I’d like to be able to calculate how much principal has
been paid after a certain number of payments are made, same with knowing
how much interest has been paid.

LoanAmt $180,000
IntRate 7%
PerYears 30
NumPayYr 12

Using the –PMT(rate, nper, pv) formula, is it possible to keep track of
how much interest and principal has been paid after 30 payments with one
or two cells of formulas?

 

[JimDandy]

Well, as what usually happens to me is once I ask the question, I'm able
to get over the mental block I have and find the answer myself. I failed
to take enough time to understand the CUMPRINC and CUMIPMT functions.

I think I've got my answer....