*Cell B39 was chosen for this example, but you would plug in whichever from B39-B43

a) =IF(B39>=200,"HEAVY",IF(B39>=100,"MEDIUM","LIGHT"))

b) =IF(AND(B39>=200,B39<500),"HEAVY",IF(AND(B39<200,B39>=100),"MEDIUM",IF(AND(B39<100,B39>=0),"LIGHT","NA"))) Present value, future value, annuities in EXCEL

=PV(RATE, NPER, PMT, FV, Type)

=FV(RATE, NPER, PMT, PV, Type)

=PMT(RATE, NPER, PV, FV, Type)

=NPER(RATE, PMT, PV, FV, Type)

=RATE(NPER, PMT, PV, FV, Type)

Type is a binary variable, indicating the timing of the cashflows: 1 for the beginning; 0 for the end.

=NPV(rate, value1, value2, , ,)

=IRR(Values, Guess) a) =FV(C4, C5, -C3, 0, 0)

**because payments are going to things like car/home and are true pmts, that is the necessary negative value

Pmt is set to the dollar amount of the periodic payment

b) End =FV(C4, C5, -C3, 0,0) **same as above meaning above was asking assuming end**

Beginning =FV(C4, C5, -C3, 0, 1)