Using the information in the tables above, please make the necessary cash flow calculations. Then use these projections to determine the intrinsic value of the firm, the equity value, and aGradedWorksheet+ Calculation Mode: Automatic Warkbook Statistics Using the information in the tables above, please make the necessary cash flow calculations. Then use these projections to determine the intrinsic value of the firm, the equity value, and the stock price per share. (Use cells A5 to G20 from the given information to complete this question.] Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment. GradedWorksheet+ Calculation Mode: Automatic Workbook Statistics Using the information in the tables above, please make the necessary cash flow calculations. Then use these projections to determine the intrinsic value of the firm, the equity value, and aGradedWorksheet+ Calculation Mode: Automatic Warkbook Statistics Using the information in the tables above, please make the necessary cash flow calculations. Then use these projections to determine the intrinsic value of the firm, the equity value, and the stock price per share. (Use cells A5 to G20 from the given information to complete this question.] Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment. GradedWorksheet+ Calculation Mode: Automatic Workbook Statistics