jagomart
digital resources
picture1_Spreadsheet Calculator 46189 | Present Value Calculator Net Present Value Calculator Discounted Cash Flow Calculator By Financeplusinsurance


 229x       Filetype XLSX       File size 0.14 MB       Source: financeplusinsurance.com


File: Spreadsheet Calculator 46189 | Present Value Calculator Net Present Value Calculator Discounted Cash Flow Calculator By Financeplusinsurance
net present value financeplusinsurance calculator all about finance insurance investment details investment summary future value fv 0 no of emi payments 20 systematic contribution 5 000 total investment amount 100 ...

icon picture XLSX Filetype Excel XLSX | Posted on 17 Aug 2022 | 3 years ago
Partial file snippet.
                  Net Present Value                                  © FinancePlusInsurance
                           Calculator                                     All About Finance & Insurance
                   Investment Details                                               Investment Summary
              Future Value (FV)    $                    0                   No. of EMI Payments              20
       Systematic Contribution     $             5,000                 Total Investment Amount      $                  100,000 
         Investment Frequency          Annual                       Discounted Cash Flow (DCF)      $                    57,432 
            Years of Investment          20                                   Present Value (PV)    $                    42,568 
       nflation/Discounted Rate        10.00%                           Present Value IFA (PVIFA)   $                    42,568 
          Investment Start date       1/1/2022                          Net Present Value (NPV)     $                    42,568 
                                  12                                                                           12 
                                  10                                                                           10 
                                   8                                                                           8 
                                   6                                                                           6 
                                   4                                                                           4 
                                   2                                                                           2 
                                2  -     3       4       5       6        7       8       9       0       1    -   
                                2        2       2       2       2        2       2       2       3       3
                                0        0       0       0       0        0       0       0       0       0
                                2        2       2       2       2        2       2       2       2       2
         Serial    Investment         Starting          Regular         Discounted Cash Flow         Ending Balance
          No.          Date           Amount         Contribution                (DCF)
            1        1/1/2022       $                    0   $               5,000   $                                   455   $                      4,545 
            2        1/1/2023       $             4,545   $               5,000   $                                   868   $                      8,678 
            3        1/1/2024       $             8,678   $               5,000   $                                1,243   $                    12,434 
            4        1/1/2025       $           12,434   $               5,000   $                                1,585   $                    15,849 
            5        1/1/2026       $           15,849   $               5,000   $                                1,895   $                    18,954 
            6        1/1/2027       $           18,954   $               5,000   $                                2,178   $                    21,776 
            7        1/1/2028       $           21,776   $               5,000   $                                2,434   $                    24,342 
            8        1/1/2029       $           24,342   $               5,000   $                                2,667   $                    26,675 
            9        1/1/2030       $           26,675   $               5,000   $                                2,880   $                    28,795 
           10        1/1/2031       $           28,795   $               5,000   $                                3,072   $                    30,723 
           11        1/1/2032       $           30,723   $               5,000   $                                3,248   $                    32,475 
           12        1/1/2033       $           32,475   $               5,000   $                                3,407   $                    34,068 
           13        1/1/2034       $           34,068   $               5,000   $                                3,552   $                    35,517 
           14        1/1/2035       $           35,517   $               5,000   $                                3,683   $                    36,833 
           15        1/1/2036       $           36,833   $               5,000   $                                3,803   $                    38,030 
           16        1/1/2037       $           38,030   $               5,000   $                                3,912   $                    39,119 
           17        1/1/2038       $           39,119   $               5,000   $                                4,011   $                    40,108 
           18        1/1/2039       $           40,108   $               5,000   $                                4,101   $                    41,007 
           19        1/1/2040       $           41,007   $               5,000   $                                4,182   $                    41,825 
           20        1/1/2041       $           41,825   $               5,000   $                                4,257   $                    42,568 
         Serial    Investment         Starting          Regular        Discounted Cash Flow          Ending Balance
          No.          Date           Amount         Contribution               (DCF)
         Serial    Investment         Starting          Regular        Discounted Cash Flow          Ending Balance
          No.          Date           Amount         Contribution               (DCF)
         Serial    Investment         Starting          Regular        Discounted Cash Flow          Ending Balance
          No.          Date           Amount         Contribution               (DCF)
The words contained in this file might help you see if this file matches what you are looking for:

...Net present value financeplusinsurance calculator all about finance insurance investment details summary future fv no of emi payments systematic contribution total amount frequency annual discounted cash flow dcf years pv nflationdiscounted rate ifa pvifa start date npv serial starting regular ending balance...

no reviews yet
Please Login to review.