Docstoc

extending basic functions

Document Sample
extending basic functions Powered By Docstoc
					Step 1: Compute the PV of the payments
Rate                            8%
Period                           10
Payment                    ($7,000)
Present Value         $576,950.37      =PV(B2/12,B3*12,B4)


Step 2: The above PV becomes the FV of the next calculation. Find the
PV of the above over the deferral period
Deferral Period                     1
Payment                           $0
Present Value          $532,733.73       =PV(B2/12,B10*12,B11,-B5)
                  Years 1-3      Years 4-6      Years 7-9        Total
Rate:                     10%            10%            10%
Term:                        3              3              3
Payment:              ($5,000)       ($6,500)       ($8,500)
Deferral:                    0              3              6

PV of Payments:   $154,956.18    $201,443.03    $263,425.50
PV of Deferral:   $154,956.18    $149,418.29    $144,930.86    $449,305.33

				
DOCUMENT INFO
Shared By:
Stats:
views:13
posted:3/24/2012
language:English
pages:2
Description: Guildline to learn extending basic functions of excel.