Question: hello! below is an excel doc and i was wondwring what formulas are used to get these numbers at the bottom: thank you! c E

hello! below is an excel doc and i was wondwring what formulas are used to get these numbers at the bottom:
hello! below is an excel doc and i was wondwring what formulas
thank you!

c E G 2 YT 3 000 N 2. JAWNO 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 NPV PV FV D 6.00% CF 25000.00 25000.00 -300.00 -300.00 -300.00 -300.00 300.00 -300.00 -300.00 -300.00 -300.00 -300.00 -300.00 -300.00 300.00 -300.00 -300.00 -300.00 -300.00 -300.00 -300.00 -300.00 0.00 -500.00 0.00 -650.00 0.00 -800.00 -500.00 -950.00 -650.00 - 1100.00 -800.00 - 1250.00 -950.00 -1400.00 -1100.00 -1550.00 - 1250.00 -1700.00 - 1400.00 -1850 00 -1550.00 - 1700.00 -1850.00 0.00 0.00 0.00 -6015.18 (56.742.41) $18.984.82 18257.59 (566,369.201 83060.77 R_NPV r_pv R_FV pmt FV -6015.18 18984.82 -86369 20 1460.01 -86369 20 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!