<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://www.clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/67205372-fef9-404d-b89a-439614632f32/F0C282B3-2A2B-4F12-9144-5B25BC514D07/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/" href="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/" style="font-size: 11px;">www.thesimpledollar.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/"><STRONG>APR (annual percentage rate) is the return your money would earn in an investment over a year without any compounding.</STRONG></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/"><STRONG>APY (annual percentage yield) is the return your money would earn in an investment over a year <EM>with</EM> compounding.</STRONG></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/"><STRONG>companies will use whichever one makes their product look better in print.</STRONG></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/"><STRONG>Converting APY To APR</STRONG></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/"><P>In cell A1, type <STRONG>APY</STRONG> In cell A2, type <STRONG># times a year</STRONG> In cell A3, type <STRONG>APR</STRONG> In cell B3, type <STRONG>=((1+B1)^(1/B2)-1)*B2</STRONG></P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/">type your desired APY value into cell B1 and the number of times a year the interest is compounded into B2 </blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/">The APR will appear in B3.</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/"><STRONG>Converting APR To APY</STRONG></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/"><P>In cell A1, type <STRONG>APR</STRONG> In cell A2, type <STRONG># times a year</STRONG> In cell A3, type <STRONG>APY</STRONG> In cell B3, type <STRONG>=(1+B1/B2)^B2-1</STRONG></P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/">type your desired APR value into cell B1 and the number of times a year the interest is compounded into B2</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thesimpledollar.com/2007/06/23/how-to-calculate-apr-and-apy-in-a-spreadsheet-and-why-you-would-want-to/">The APY will appear in B3.</blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/F0C282B3-2A2B-4F12-9144-5B25BC514D07/blog/" title="blog or email this clip"><img src="http://content6.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks:  Amplify.com - Don't just share the news...Amplify it!