Recall Example 1 from Chapter 1: How $200 a month can grow Use Excel to find NPVAND IRR Year / Interest 0% 1% 3% 6% 9% 12% 1 $1,200 $1,206 $1,217 $1,234 $1,251 $1,268 5 5 $6,000 $6,150 $6,465 $6,977 $7,542 $8,167 10 $12,000 $12,615 $13,974 $16,388 $19,351 $23,004 15 $18,000 $19,411 $22,697 $29,082 $37,841 $49,958 20 $24,000 $26,556 $32,830 $46,204 $66,789 $98,926 25 $30,000 $34,067 $44,601 $69,299 $112,112 $187,885 Recall Example 1 from Chapter 1: How $200 a month can grow Use Excel to find NPVAND IRR Year / Interest 0% 1% 3% 6% 9% 12% 1 $1,200 $1,206 $1,217 $1,234 $1,251 $1,268 5 5 $6,000 $6,150 $6,465 $6,977 $7,542 $8,167 10 $12,000 $12,615 $13,974 $16,388 $19,351 $23,004 15 $18,000 $19,411 $22,697 $29,082 $37,841 $49,958 20 $24,000 $26,556 $32,830 $46,204 $66,789 $98,926 25 $30,000 $34,067 $44,601 $69,299 $112,112 $187,885