ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Which formula to use for compounding interest for specific # of da (https://www.excelbanter.com/excel-worksheet-functions/91351-formula-use-compounding-interest-specific-da.html)

ROL

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.

David Billigmeier

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.



All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com