Skip to main content
added 157 characters in body
Source Link
quid
  • 49.1k
  • 11
  • 101
  • 161

You can also skip the actual compound interest formula and just use the built in future value formula:

=FV(D$1/360,C$1-$A2,0,-B2)-B2

To drill down further on only compounding monthly you need to start to play with adjusting the dates...

To drill down further you need to start to play with adjusting the dates...

You can also skip the actual compound interest formula and just use the built in future value formula:

=FV(D$1/360,C$1-$A2,0,-B2)-B2

To drill down further on only compounding monthly you need to start to play with adjusting the dates...

added 183 characters in body
Source Link
quid
  • 49.1k
  • 11
  • 101
  • 161

At this point you're really splitting hairs because it's the difference of $1.74327 of interest versus $1.74331 when including the first months interest in the principal for the remaining months. This differs from the $1.85 in cell C2 above because you haven't been credited for the first 10 days in August yet. In a lot of cases the minute differences in compounding will only matter on big numbers, forand even then.... If you had $10,000,000 in principle, the compounding difference would change from $0.00004 to $4. For most purposes the first formula way up there is more than sufficient (and probably the one I would actually use in all cases because the practical difference in compounding daily versus monthly just isn't significant).

Anyway, happy hunting.

At this point you're really splitting hairs because it's the difference of $1.74327 of interest versus $1.74331 when including the first months interest in the principal for the remaining months. This differs from the $1.85 in cell C2 above because you haven't been credited for the first 10 days in August yet. In a lot of cases the minute differences in compounding will only matter on big numbers, for most purposes the first formula way up there is more than sufficient (and probably the one I would actually use in all cases).

Anyway, happy hunting.

At this point you're really splitting hairs because it's the difference of $1.74327 of interest versus $1.74331 when including the first months interest in the principal for the remaining months. This differs from the $1.85 in cell C2 above because you haven't been credited for the first 10 days in August yet. In a lot of cases the minute differences in compounding will only matter on big numbers, and even then.... If you had $10,000,000 in principle, the compounding difference would change from $0.00004 to $4. For most purposes the first formula way up there is more than sufficient (and probably the one I would actually use in all cases because the practical difference in compounding daily versus monthly just isn't significant).

edited body
Source Link
quid
  • 49.1k
  • 11
  • 101
  • 161

At this point you're really splitting hairs because it's the difference of $1.74327 of interest versus $1.74331 when including the first months interest in the principal for the remaining months. This differs from the $1.85 in cell C2 above because you haven't been credited for the first 10 days in August yet. In a lot of cases the minute differences in compounding will only matter on big numbers, for most purposes the first formula way up there is more than sufficient (and probably the one I would actually use in all cases).

At this point you're really splitting hairs because it's the difference of $1.74327 of interest versus $1.74331 when including the first months interest in the principal for the remaining months. In a lot of cases the minute differences in compounding will only matter on big numbers, for most purposes the first formula way up there is more than sufficient (and probably the one I would actually use in all cases).

At this point you're really splitting hairs because it's the difference of $1.74327 of interest versus $1.74331 when including the first months interest in the principal for the remaining months. This differs from the $1.85 in cell C2 above because you haven't been credited for the first 10 days in August yet. In a lot of cases the minute differences in compounding will only matter on big numbers, for most purposes the first formula way up there is more than sufficient (and probably the one I would actually use in all cases).

edited body
Source Link
quid
  • 49.1k
  • 11
  • 101
  • 161
Loading
edited body
Source Link
quid
  • 49.1k
  • 11
  • 101
  • 161
Loading
edited body
Source Link
quid
  • 49.1k
  • 11
  • 101
  • 161
Loading
Source Link
quid
  • 49.1k
  • 11
  • 101
  • 161
Loading