document.write('<div class="feedburnerFeedBlock" id="microsoft/ACaOu7urls6h48hafath0ubf8dvbu4">');
document.write('<p class="feedTitle">Financial Functions</p>');
document.write('<ul>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/108725" target="_blank" >Basis Argument for Financial Functions</a></span>');
document.write('<div>This article describes the Basis argument and how it is evaluated in Microsoft Excel financial functions.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/wI_QnqpiD0lplZWLQa0Kqwv409Q\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/wI_QnqpiD0lplZWLQa0Kqwv409Q\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/wI_QnqpiD0lplZWLQa0Kqwv409Q\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/wI_QnqpiD0lplZWLQa0Kqwv409Q\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214150" target="_blank" >XL: Adjusting the Period of Financial Functions</a></span>');
document.write('<div>The compounded period used by Microsoft Excel in calculating financial functions can be altered by changing the number of periods over which the function is calculated. For example ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/N35Ziock9ZSTOi40ffWTHm36Kg4\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/N35Ziock9ZSTOi40ffWTHm36Kg4\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/N35Ziock9ZSTOi40ffWTHm36Kg4\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/N35Ziock9ZSTOi40ffWTHm36Kg4\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214050" target="_blank" >XL2000: Basis Argument for Financial Functions</a></span>');
document.write('<div>This article describes the Basis argument and how it is evaluated in Microsoft Excel financial functions.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/z1f39KKPeWLmNBcRT_Ad_mXA_3E\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/z1f39KKPeWLmNBcRT_Ad_mXA_3E\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/z1f39KKPeWLmNBcRT_Ad_mXA_3E\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/z1f39KKPeWLmNBcRT_Ad_mXA_3E\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/247795" target="_blank" >XL2000: Some Financial Functions May Return Incorrect Results with ...</a></span>');
document.write('<div>In Microsoft Excel, certain financial functions may return an incorrect value. Excel may calculate an incorrect value when the following conditions are true: You are using one of ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/YudC1frFv2IsCpR5y5exuS1h9TA\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/YudC1frFv2IsCpR5y5exuS1h9TA\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/YudC1frFv2IsCpR5y5exuS1h9TA\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/YudC1frFv2IsCpR5y5exuS1h9TA\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/294396" target="_blank" >XL: Examples of Interest Calculations Outside the United States</a></span>');
document.write('<div>Microsoft financial functions presume customary financial practices in the United States. Other countries have different laws about quoting and computing interest. This article ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/yKJFBj72T_3ZootDAYxC0U9Afic\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/yKJFBj72T_3ZootDAYxC0U9Afic\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/yKJFBj72T_3ZootDAYxC0U9Afic\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/yKJFBj72T_3ZootDAYxC0U9Afic\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/175081" target="_blank" >XL97: Financial Functions Return #NUM! If Dates After Year 2078</a></span>');
document.write('<div>If you use a financial function from the Analysis ToolPak in Microsoft Excel 97, and you pass a date greater than 12\/31\/2078 to the function, the function may return the #NUM ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4v2WW53d6RQtq_uMSaZWmnBiWlk\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4v2WW53d6RQtq_uMSaZWmnBiWlk\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4v2WW53d6RQtq_uMSaZWmnBiWlk\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4v2WW53d6RQtq_uMSaZWmnBiWlk\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213939" target="_blank" >XL2000: Algorithms Used in the ATP Functions</a></span>');
document.write('<div>For detailed information about the algorithms or financial methods used to create the Microsoft Excel financial functions, refer to the following books:\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/ZtWIRiW4b4RMZtqDcEbjsqsfSLY\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/ZtWIRiW4b4RMZtqDcEbjsqsfSLY\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/ZtWIRiW4b4RMZtqDcEbjsqsfSLY\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/ZtWIRiW4b4RMZtqDcEbjsqsfSLY\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/149236" target="_blank" >Algorithms Used in the ATP Functions</a></span>');
document.write('<div>For detailed information about the algorithms or financial methods used to create the Microsoft Excel financial functions, refer to the following books:\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/SZNRP4wTllrjR_G83wD2qxDSUpc\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/SZNRP4wTllrjR_G83wD2qxDSUpc\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/SZNRP4wTllrjR_G83wD2qxDSUpc\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/SZNRP4wTllrjR_G83wD2qxDSUpc\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/269356" target="_blank" >XL2000: Overview and History of Excel 2000 Updates</a></span>');
document.write('<div>247795 (http:\/\/support.microsoft.com\/kb\/247795\/EN-US\/ ) XL2000: Some Financial Functions May Return Incorrect ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/UuIjj27OSyMnkmVntXXYJ5H80GU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/UuIjj27OSyMnkmVntXXYJ5H80GU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/UuIjj27OSyMnkmVntXXYJ5H80GU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/UuIjj27OSyMnkmVntXXYJ5H80GU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/191109" target="_blank" >XL98: Using NPV() or Solver to Find Guess for IRR()</a></span>');
document.write('<div>For more information about the IRR Function, click the Office Assistant, type financial functions, click Search, and then click to view \"IRR.\"\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/YaFTmTH6pz6ry6T4rAAqZYbx8w8\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/YaFTmTH6pz6ry6T4rAAqZYbx8w8\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/YaFTmTH6pz6ry6T4rAAqZYbx8w8\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/YaFTmTH6pz6ry6T4rAAqZYbx8w8\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb239435.aspx" target="_blank" >Npv Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>For information about annuities and financial functions, see PV. NPV is also related to the IRR function (internal rate of return). IRR is the rate for which NPV equals zero: NPV ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4uXmrZnwy_5dS3Q0mwwvKF_bka0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4uXmrZnwy_5dS3Q0mwwvKF_bka0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4uXmrZnwy_5dS3Q0mwwvKF_bka0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4uXmrZnwy_5dS3Q0mwwvKF_bka0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/291106" target="_blank" >XL97: How to Use the EFFECT and NOMINAL Functions to Calculate Loan or ...</a></span>');
document.write('<div>Financial institutions may calculate interest based on ... and illustrates the importance of knowing the financial environment in which you are using the worksheet functions.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/fnI05r7ImFWUP464gtxLsrJPZxo\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/fnI05r7ImFWUP464gtxLsrJPZxo\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/fnI05r7ImFWUP464gtxLsrJPZxo\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/fnI05r7ImFWUP464gtxLsrJPZxo\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb239402.aspx" target="_blank" >Ispmt Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>... by negative numbers; the cash you receive, such as dividend checks and other deposits, is represented by positive numbers. For additional information about financial functions, see ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/lqzdFRdo59vmhx2EzYPv9e7za2M\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/lqzdFRdo59vmhx2EzYPv9e7za2M\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/lqzdFRdo59vmhx2EzYPv9e7za2M\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/lqzdFRdo59vmhx2EzYPv9e7za2M\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/253235" target="_blank" >OFFAUTMN.exe discusses Office 97 and 2000 Automation and provides ...</a></span>');
document.write('<div>You don\'t need to write your own calculation engine to provide the multitude of mathematical, financial, and engineering functions that Excel provides; Instead, you can automate ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/UBh9AbRzj8M_-6mW7x9k5oCvw5g\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/UBh9AbRzj8M_-6mW7x9k5oCvw5g\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/UBh9AbRzj8M_-6mW7x9k5oCvw5g\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/UBh9AbRzj8M_-6mW7x9k5oCvw5g\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/289150" target="_blank" >How to set up and use the RTD function in Excel</a></span>');
document.write('<div>... create a workbook that includes data that is updated in real time, for example, financial ... For example, in the previous scenario, the user might be provided with two functions ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/DQaw2vJdnsQyEBweDsG770M2aRg\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/DQaw2vJdnsQyEBweDsG770M2aRg\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/DQaw2vJdnsQyEBweDsG770M2aRg\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/DQaw2vJdnsQyEBweDsG770M2aRg\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/262339" target="_blank" >XL2000: ODDFYIELD Returns #NUM with Online Help Example</a></span>');
document.write('<div>This behavior also applies to the following worksheet functions: ODDFPRICE; ODDLPRICE; ODDLYIELD; For more information about the resources used to derive financial, statistical, and ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/_bU8J_5dZSmuaQHm-Zh73rPdWzs\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/_bU8J_5dZSmuaQHm-Zh73rPdWzs\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/_bU8J_5dZSmuaQHm-Zh73rPdWzs\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/_bU8J_5dZSmuaQHm-Zh73rPdWzs\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/office/aa905420.aspx" target="_blank" >Excel Community</a></span>');
document.write('<div>BI303\u2014Developing User Defined Functions for Excel 2007 and Excel Services ... Nathan Oliver has a work day that ranges from merger and acquisition financial structure ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tU9ozKmUOOM_AZJnGVBwLyzDPK0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tU9ozKmUOOM_AZJnGVBwLyzDPK0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tU9ozKmUOOM_AZJnGVBwLyzDPK0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tU9ozKmUOOM_AZJnGVBwLyzDPK0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb239471.aspx" target="_blank" >Pv Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>In annuity functions, cash you pay out, such as a deposit to savings, is represented by a ... Microsoft Excel solves for one financial argument in terms of the others.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/GQiXSlBpsB6be_G1QDPo8FvuYYs\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/GQiXSlBpsB6be_G1QDPo8FvuYYs\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/GQiXSlBpsB6be_G1QDPo8FvuYYs\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/GQiXSlBpsB6be_G1QDPo8FvuYYs\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/ee264226.aspx" target="_blank" >Chapter 4: Explore Range Objects</a></span>');
document.write('<div>Contrast this to when you use the same functions from the global group\u2014or as members of ... uses a data type (currency) that can handle the large-scale precision needed in financial ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/6lwpwCJwvDuLoYmVHHER7_DRqKU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/6lwpwCJwvDuLoYmVHHER7_DRqKU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/6lwpwCJwvDuLoYmVHHER7_DRqKU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/6lwpwCJwvDuLoYmVHHER7_DRqKU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/ACaO"><img border="0" src="http://www.feedburner.com/fb/i/icn/feed-icon-10x10.gif"/> Subscribe to this Feed</a></p>');
document.write(' <div id="creditfooter"><a href="http://www.feedburner.com" target="_blank"><img src="http://www.feedburner.com/fb/images/buzzboost-pwrd.gif" alt="Headlines by FeedBurner" style="border:0"/></a></div>');
document.write('</div>');