Timeline for Future value of loan: interest calculated daily and compounded at end of each calendar month
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 28, 2020 at 13:36 | comment | added | Chris Degnen | @Paul - I don't know of an inbuild Excel finance function that uses the 365 day basis. | |
| Sep 28, 2020 at 13:33 | history | edited | Chris Degnen | CC BY-SA 4.0 |
added 277 characters in body
|
| Sep 28, 2020 at 13:28 | comment | added | Paul | Im sure that this response will be useful to the OP. I would like to add that there are also some "built-in" financial functions in Excel for doing this sort of thing. The "FV" function (i.e. = FV(....)) may be particularly useful for him/her, and they might also refer to other financial functions such as =PPMT(...), =IPMT(...), etc. | |
| Sep 27, 2020 at 23:21 | history | edited | Chris Degnen | CC BY-SA 4.0 |
added 158 characters in body
|
| Sep 27, 2020 at 23:15 | history | edited | Chris Degnen | CC BY-SA 4.0 |
added 158 characters in body
|
| Sep 27, 2020 at 10:59 | history | edited | Chris Degnen | CC BY-SA 4.0 |
added 90 characters in body
|
| Sep 27, 2020 at 10:41 | history | answered | Chris Degnen | CC BY-SA 4.0 |