Working from the top down, enter data needed from the text question. Calculate a solution for each cell back-lighted in yellow. Build your formulas in calculation cells by referencing cells above that in turn reference numbers directly from the text problem.

a Solving for r using Brute Force (an internal rate of return calculation) The present value of the following cash flows is known to 1 $7,000.00 : What is the discount rate? Cash Flows CF1= $800.00 CF2= $2,200.00 CF3= $5,100.00 PV of Cash Flows in on year PV(CF1)= in two years PV(CF2) in three years PV(CF3)= Sum of Discounted Cash Flows= $0.00 Discount rate= Sum of Discounted Cash Flows minus PV= $7,000.00