| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Financial formulas
I have the following spreadsheet: year beg bal yr contr int rate int inc ending balance 2006 25000 10000 15% ?? What formula do I use to calculate the interest income? -- JR573PUTT ------------------------------------------------------------------------ JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587 View this thread: http://www.excelforum.com/showthread...hreadid=524890 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Financial formulas
You can use: =SUM(B2:C2)*D2, although this does not take into
considerationmotnly interest earnings, but only one annual earning "JR573PUTT" wrote: I have the following spreadsheet: year beg bal yr contr int rate int inc ending balance 2006 25000 10000 15% ?? What formula do I use to calculate the interest income? -- JR573PUTT ------------------------------------------------------------------------ JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587 View this thread: http://www.excelforum.com/showthread...hreadid=524890 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Financial formulas
It depends on when you make your yearly contribution. If you make it at the
beginning of the year, the formula is: =(begbal+yrcont)*intrate If it's at the end of the year, the formula is: =begbal*intrate -- Regards, Fred "JR573PUTT" wrote in message ... I have the following spreadsheet: year beg bal yr contr int rate int inc ending balance 2006 25000 10000 15% ?? What formula do I use to calculate the interest income? -- JR573PUTT ------------------------------------------------------------------------ JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587 View this thread: http://www.excelforum.com/showthread...hreadid=524890 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - how can I practice formulas on financial questions? | Excel Discussion (Misc queries) | |||
| Countif formulas change after doing a sort | Excel Worksheet Functions | |||
| I can not use the financial formulas. | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Add-Ins for Excel 2003 - Financial Formulas does not download | Setting up and Configuration of Excel | |||
Linear Mode
