Create a Loan Calculator using InfoPath and Excel Web Parts

Download this episode

Download Video


In this week’s “5 for Forms” video demo, Nick Dallett will show you how to create a loan calculator application without writing a line of code. This simple application leverages the power of the InfoPath and Excel Web Parts by using an InfoPath form to input the values that are sent to an Excel Workbook which contains the complex formulas that calculate the repayments.

If you want to learn more about the new InfoPath Form Web Part, check out Nick’s earlier video demo – Managing data in your SharePoint Lists using the InfoPath Form Web Part.

This video is also available on the InfoPath Team Blog.



Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image

      In the past, with the 2007 release, I was always hesitant to recommend use of InfoPath in anything other than a small environment as I just didn’t feel it was quite mature enough; and often custom development was a less risky option for the solution (how often do you hear that!).

    • User profile image

      I agree that the loan calculator is a very important application. It helps you to be aware of your rates and be more calm as for your financial situation that is not steady after the crises at all. Economics changes all the time and it doesn't bring any confidence. Instead it leads to hesitation and uncertainty. People often ask themselves if they really should do this or not, for example, should they take <a href="">instant no fax payday loans</a> or not.

    • User profile image
      Robert A

      Technological progress brings us a lot of additional opportunities and comfort. There are a lot of useful and convenient programs and  applications. This loan calculator is a great innovation that helps a lot, to my mind. It gives you a chance to forecast your financial situation for you to be aware of your rates. It helps to make a decission for those, for example, who have a <a href="">consolidate credit card debt</a>.

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.