Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc
Step 2 – Enter the following data/ Formula in respective cells.
Step 3 – Enter the formula as follows
B6 = PV (B2/12, B3*12, B4, B5)
C6 = PV(C2/12, C3*12, C4, C5)
Output:
Present value - at the beginning |
136409.4 |
Present value - at the end |
136410.04 |