Help needed please. must be in excel.

by EXCEL is correct. EXERCISE 3.7 1. Assume that the annual return is 6%. Assume that you deposit 12,000 on 1/1/2002, what is the ending balance as of 12/31/2002? 2. You added 5,000 on 1/1/2003, what is the ending balance on 12/31/2003? 3. Assume no activities in year 2004, and 2005, what is the ending balance on 12/31/2005? (Ans. 21,104.8) 4. Use the IRR function to compute the above investment from 1/1/2002 thru 1/1/2006, as mentioned in exercise 1 thru 3. Verify that the return is 6% as mentioned in exercise 1. 1/1/2002 - 12000 1/1/2003 -5000 1/1/2004 ol 1/1/2005 1/1/2006 21104.8