Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which formula to use for compounding interest for specific # of da
Principal amount is $57,310.38; interest is 3% per annum, length of time is
195 days with 1 payment at the end of the 195 days. I'm clueless as to which formula to use and what #'s to plug in. Hope someone can help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which formula to use for compounding interest for specific # of da
Is this compounded daily, or is it compounded once at the end of the 195 days
(in which case wouldn't technically be compounded)? By "1 payment" I assume you mean the entire pricipal is to be paid back after 195 days. I'll assume compounded daily and entire principal paid @ t=195 days: Amount paid Back = 57,310.37 * (1+ .03/365)^195 = $58,236.27 Resulting in $925.90 in interest paid (58,236.27-57,310.37) Does that help? -- Regards, Dave "ROL" wrote: Principal amount is $57,310.38; interest is 3% per annum, length of time is 195 days with 1 payment at the end of the 195 days. I'm clueless as to which formula to use and what #'s to plug in. Hope someone can help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Formula to calculate cumulative interest | Excel Worksheet Functions | |||
Construction Loan Interest Formula | Excel Worksheet Functions | |||
Interest Earned Formula | Excel Discussion (Misc queries) | |||
Interest formula on Personal Line | Excel Discussion (Misc queries) |