Investment analysts commonly use Microsoft Excel ... cash/debt balance (all in separate cells). Once this is done, use your spreadsheet's NPV (net present value) function to process your cash flow ...