For an answer to be graded as correct, you must use an Excel formula:

Begin each formula with an = sign.

Reference cells, instead of entering values.

Example: =B3+C3

Need Maximum Acquisition Price formulas only**

2 Required: The following table shows the projected free cash flows of an acquisition target. The potential acquirer wants to estimate its maximum acquisition price at an 8 percent discount rate and a terminal value in year 5 based on the perpetual growth equation with a 4 percent perpetual growth rate. a. Estimate the target's maximum acquisition price. 3 b. Estimate the target's maximum acquisition price when the discount rate is 7 percent and the perpetual growth rate is 5 percent. Note: Use cell A2 to G15 from the given information to complete this question. You must use the built-in Excel functions =NPV() and =PV to answer the maximum acquisition price for each question part. All answers should be displayed as positive numbers. You may use the hardcoded number "1" in your formulas. No other hardcoded numbers may be used. You must calculate the terminal value for each part and then use this calculation to solve the maximum acquisition price