-1
$\begingroup$

I am thinking to start investing monthly and i am trying to calculate my investment using excel with a compound interest of 5% monthly plus addition of certain amount.

First month investment is 10000 and from second month onwards i add monthly certain amount (1000/month or 5000/month).

But I am getting this weird result (spreadsheet attached)

if I invest 1000/month (sheet 1) after 3 years I get 3.39 times more profit comparing to 5000/month (sheet 2) which was just 2.8.

Assuming my calculation are not wrong, is it better to invest only a small amount monthly.

$\endgroup$

closed as off-topic by Bob Jansen Jul 15 '15 at 14:38

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Basic financial questions are off-topic as they are assumed to be common knowledge for those studying or working in the field of quantitative finance." – Bob Jansen
If this question can be reworded to fit the rules in the help center, please edit the question.

1
$\begingroup$

The problem is the way you compute profit, in which you are not accounting for the timing of cashflows.

If you compute NPV's you get a better comparison. Also if you check the IRR, it will be 5% for both investments.

$\endgroup$

Not the answer you're looking for? Browse other questions tagged or ask your own question.