A: FVannuity
Create a simple model that will calculate the future value of an annuity. Adjust the model to correctly calculate FVannuity based on MONTHLY compounding.
B: PVannuity
Create a simple model that will calculate the present value of an annuity. Adjust the model to correctly calculate PVannuity based on MONTHLY compounding.
C: PMT
Create TWO separate simple models that will accurately calculate payment amount for BOTH PVannuity and FVannuity. Adjust both models to correctly calculate PMT based on MONTHLY payments.
Please show the excel work for all of it.