One of the formulas supported by Microsoft Excel is the sum of squares equation. To calculate the sum of squares using Microsoft Excel, you need to input a specific formula into the formula bar of the ...
Calculate the present value of each year's cash flow by dividing by (1 + discount rate)^number of years. Sum all present values to find the total value of projected cash flows, which in this example ...