Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interest Earned Formula
What is the formula to enter to obtain for example the yearly or monthly
interest earned on an account with an opening deposit of $1000.00 that has an APY of 2.9% and is compounded daily with the interest credited on a monthly basis? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interest Earned Formula
Try =A1*((1+((D1)/365))^(C1))-A1 where A1 = opening balance, D1 = interest rate C1 = days where C1 would be days in this month. rray0032 Wrote: What is the formula to enter to obtain for example the yearly or monthly interest earned on an account with an opening deposit of $1000.00 that has an APY of 2.9% and is compounded daily with the interest credited on a monthly basis? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=489757 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interest Earned Formula
"rray0032" wrote:
What is the formula to enter to obtain for example the yearly or monthly interest earned on an account with an opening deposit of $1000.00 that has an APY of 2.9% and is compounded daily with the interest credited on a monthly basis? Do you really mean APY, or is 2.9% the nominal annual interest rate? If it is the nominal rate, arguably the simplest formula is one of the following, depending on the term of the savings account: =FV(2.9%/365, years*365,, -1000) - 1000 =FV(2.9%/365, months*30,, -1000) - 1000 =FV(2.9%/365, days,, -1000) - 1000 Note the double-comma before -1000. Also note that the "months" formula is the least accurate, since it assumes an average of 30 days per month (360 days per year). If 2.9% is truly the APY, the daily compounding factor is already incorporated and 2.9%/365 would overstate the daily interest rate. Replace 2.9%/365 with RATE(365,,-1,1+2.9%). Arguably, RATE() complication is not worth the trouble. It makes a difference of less than $2.40 in interest over 5 years and less than $29.30 over 30 years per $1000 principle -- 1.5% to 2.2% respectively. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Interest Earned on Investment w/Daily Compounding | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Interest formula on Personal Line | Excel Discussion (Misc queries) |