Calculate the Present Value (PV) of the Growing Annuity: Apply the NPV function in Excel to find the present value of the growing annuity. Enter the following formula: =NPV(F5,C6:C15) Press Enter to get the required growing annuity which is $63,648.30. Method 2 – Applying FV Function...