I’m trying to use excel to calculate a loan payment under the flowing
parameters; some number of equal consecutive monthly payments followed by a
residual or “balloon” due at the end of the term. Will excel do this and if
so how?