TVM Principles and Mechanics Analyze the data below in Excel and then answer the following questions. A real estate investment reports the following cash flows:

Purchase Price: ? Year 1 $4,000 Year 2 $(10,000) Year 3 $(3,000) Year 4 $4.000 Year 5 $550,000 IRR = 2.66% A. What would you purchase the asset for based on the IRR noted above? B. Disregarding the 2.66% IRR above, if the purchase price is $477,658, what is the revised IRR? C. New iteration: If we know we want to earn a 6% IRRwhat would be the corresponding purchase price given the cash flow strip? D. Based on the answer to C. what is the reported Net Present Value of this investment?