"via135" wrote:
is there any worksheet function to represent your
formula as well as other financial calculations?

None that I am aware of for the formulas that I developed
for this loan structure. As for "other financial calculations",
there is a plethora of formulas including FV(), PMT(), NPER(),
and RATE(). Use Excel Help to learn about those functions
and others.