For a computer class. No stupid answers. If you are going to try to answer with something stupid. Don’t bother and move on, Thank you.

Please specify and explain.

I would use the financial formulas to interest rate calculations like:

pmt (calculate payments)

rate (calculate rate)

fv (future value)

pv (present value)

I would make use of if, sumif, countif, sumifs, etc to calculate and filter data while calculing.

Hope it helps.

I would use the financial formulas to interest rate calculations like:

pmt (calculate payments)

rate (calculate rate)

fv (future value)

pv (present value)

I would make use of if, sumif, countif, sumifs, etc to calculate and filter data while calculing.

Hope it helps.

References :