Module 1 Knowledge Test Q5

4 posts / 0 new

Wed, 01/04/2015 - 12:11am

BenF15

Anyone have the excel formula for this? I was looking at the FV but end up stuffing it up each time as the answer comes out ridiculous.

And does anyone have the breakdown for the long formula (not using FV).

Question is:
Calculate return:
$1000 per month, invested for 25 years at 12% compounding monthly.

Any help appreciated.

Tue, 14/04/2015 - 8:33pm

ritchiematheson

Hi Ben. If you IM me your email I can send you the spread sheet I used as a reference.
I did not use a formula for this to show my workings, but did it the long way.

Cheers

Ritchie

Tue, 14/04/2015 - 9:58pm

Anthony25c13

Have a look here: should help you along your way

http://www.calculator.net/interest-calculator.html?cstartingprinciple=0&...

Thu, 04/08/2016 - 9:05pm

Alan and Monica

thanks for this - we spent a long time trying to this out - web link most helpful

Navigation

Module 1 Knowledge Test Q5

You are here