compounding interest worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Compounding Interest Worksheet
2
3
4
Straight Interest
5
Year 0Year 1Year 2Year 3Year 4Year 5
6
Investment($900)
7
Interest$100$100$100$100$100
8
Return Of Principal$900
9
10
Net Cash Flow($900)$100$100$100$100$1,000
11
IRR11.1%
12
Total Profit$500
13
14
15
Compounding Interest
16
Year 0Year 1Year 2Year 3Year 4Year 5
17
Investment($900)
18
Interest$100$100$100$100$100
19
Return Of Principal$900
20
Reinvestment of Year 1 Interest($100)
21
Interest$11$11$11$11
22
Return Of Principal$100
23
Reinvestment of Year 2 Interest($111)
24
Interest$12$12$12
25
Return Of Principal$111
26
Reinvestment ofYear 3 Interest($123)
27
Interest$14$14
28
Return Of Principal$123
29
Reinvestment of Year 4 Interest($137)
30
Interest$15
31
Return Of Principal$137
32
Net Cash Flow($900)$0$0$0$0$1,524
33
IRR11.1%
34
Total Profit$624
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Loading...
 
 
 
Sheet1
Sheet2
Sheet3
Sheet4