Begin with creating a simple statement that ... Voilà ! Excel will tell you how much you should charge to achieve the target NPV. You have borrowed from a bank and the terms of the loan require ...