Is there a function that can be used to solve this instead of a big complex table also thanks I will like your answer!

Bruce is considering the purchase of a restaurant named Hard Rock Hollywood. With the help of his accountant, Bruce projects the net cash flows (cash inflows less cosh outflows) from the restaurant to be the following amounts over the next 10 years: Bruce expects to sell the restaurant after to years for an estimated \$1,8B0,000. (EV of S1. PV of S1. EVA. of S1, and PVA of SD) (Use tables, Excel, or a financial calculator. Round your answer to 2 decimal places.) Required: 1-o. Caiculate the total present value of the net cash fiows if Bruce wants to make at least 12% annually on his investment. (Assume al) cash flows occur at the end of each year Be sure to include the selling price in your calculation) 1-b. Assuming the restaurant is listed for sale at $1,050,000, should he purchase the restaurant? Complete this question by entering your answers in the tabs below. Cakulate the total present value of the net cash flaws i Bruce wants to mako at least 12% annually on his investment. (Assume all cash flows occur at the end of each yoar, Bur sure to include the selling price in your calcutation.)