J
Joe B.
No sure if anyone goes back to see comments on the answers they give, so I am
reposting this one where we left off in the post on the 13th, previous posts
are found at the bottom...(sorry for the repetition...)
The answer for this comes in fairly close to what the answer should be, but
not exactly. This answer comes out as: $17,604.19 and the answer should be
(as seen below) $16,460.09 when payments are made at the beginning of the
year or $16,300.17 when payments are made at the end of the year.
Thanks anyhow, though! If you come up with anything else, please let me know.
Joe B.
Ending Payments:
Nper Pmt Int. Earned Total
0
1 $1,000.00 $0.00 $1,000.00
2 $1,030.00 $80.00 $2,110.00
3 $1,060.90 $168.80 $3,339.70
4 $1,092.73 $267.18 $4,699.60
5 $1,125.51 $375.97 $6,201.08
6 $1,159.27 $496.09 $7,856.44
7 $1,194.05 $628.52 $9,679.01
8 $1,229.87 $774.32 $11,683.20
9 $1,266.77 $934.66 $13,884.63
10 $1,304.77 $1,110.77 $16,300.17
Beginning Payments
Nper Pmt Int. Earned Total
0
1 $1,000.00 $80.00 $1,080.00
2 $1,030.00 $86.40 $2,196.40
3 $1,060.90 $175.71 $3,433.01
4 $1,092.73 $274.64 $4,800.38
5 $1,125.51 $384.03 $6,309.92
6 $1,159.27 $504.79 $7,973.99
7 $1,194.05 $637.92 $9,805.96
8 $1,229.87 $784.48 $11,820.31
9 $1,266.77 $945.62 $14,032.70
10 $1,304.77 $1,122.62 $16,460.09
Expand AllCollapse All
reposting this one where we left off in the post on the 13th, previous posts
are found at the bottom...(sorry for the repetition...)
The answer for this comes in fairly close to what the answer should be, but
not exactly. This answer comes out as: $17,604.19 and the answer should be
(as seen below) $16,460.09 when payments are made at the beginning of the
year or $16,300.17 when payments are made at the end of the year.
Thanks anyhow, though! If you come up with anything else, please let me know.
Joe B.
Ending Payments:
Nper Pmt Int. Earned Total
0
1 $1,000.00 $0.00 $1,000.00
2 $1,030.00 $80.00 $2,110.00
3 $1,060.90 $168.80 $3,339.70
4 $1,092.73 $267.18 $4,699.60
5 $1,125.51 $375.97 $6,201.08
6 $1,159.27 $496.09 $7,856.44
7 $1,194.05 $628.52 $9,679.01
8 $1,229.87 $774.32 $11,683.20
9 $1,266.77 $934.66 $13,884.63
10 $1,304.77 $1,110.77 $16,300.17
Beginning Payments
Nper Pmt Int. Earned Total
0
1 $1,000.00 $80.00 $1,080.00
2 $1,030.00 $86.40 $2,196.40
3 $1,060.90 $175.71 $3,433.01
4 $1,092.73 $274.64 $4,800.38
5 $1,125.51 $384.03 $6,309.92
6 $1,159.27 $504.79 $7,973.99
7 $1,194.05 $637.92 $9,805.96
8 $1,229.87 $784.48 $11,820.31
9 $1,266.77 $945.62 $14,032.70
10 $1,304.77 $1,122.62 $16,460.09
Frank Kabel said:Hi
you have a post from Harlan in Excel.worksheetfunctions
P.S.: please don't multipost
Expand AllCollapse All