Question: Please use this formula TABLE 3.6 Summary of Discrete Compounding Formulas with Discrete Payments Cash Flow Diagram Flow Type Factor Notation Formula Excel Command Compound
Please use this formula
TABLE 3.6 Summary of Discrete Compounding Formulas with Discrete Payments Cash Flow Diagram Flow Type Factor Notation Formula Excel Command Compound F=P(1 + i)N amount Present worth P/F i, N) Compound = PV(1,N, 0, F) amount (FIA, i N) 01 2 3 N-1 TH -77N = PMT (i,N, 0, F) Sinking fund Present worth PV(i,N, A) 123 N-IN Capital recovery PMT (i,N, P) TABLE 3.6 Summary of Discrete Compounding Formulas with Discrete Payments Cash Flow Diagram Flow Type Factor Notation Formula Excel Command Compound F=P(1 + i)N amount Present worth P/F i, N) Compound = PV(1,N, 0, F) amount (FIA, i N) 01 2 3 N-1 TH -77N = PMT (i,N, 0, F) Sinking fund Present worth PV(i,N, A) 123 N-IN Capital recovery PMT (i,N, P)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
