### Financial Pre-Test Problems

I am looking for the way to solve these by hand and in Excel, and also the proper answer: 1. Suppose that the following cash flows are received: 0 = -$500, 1 = $200, 2 = $200, 3 = $200 The Internal Rate of Return on the cash flows (rounded to the nearest percent) is 8%, 9%, 10%, 11%, or 12% 2. A 10-year bond payin