Required: 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 G25 from the given information to complete this question.) The following are excerpts from a company's balance sheet and income statement. Included also are important rates that may apply to the following valuation. Randall-Hecho, Incorporated: Income Statement o (Year Just Randall-Hecho, Incorporated: Balance Sheet \begin{tabular}{|l|c|} \hline \multicolumn{1}{|c|}{ Randall-Hecho, Incorporated: Rates } & Rates \\ \hline Interest Rate on Debt & 0.060 \\ \hline Corporate Tax Rate & 0.200 \\ Sustainable Growth Rate & 0.010 \\ \hline \end{tabular} Required: 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 G25 from the given information to complete this question.) The following are excerpts from a company's balance sheet and income statement. Included also are important rates that may apply to the following valuation. Randall-Hecho, Incorporated: Income Statement o (Year Just Randall-Hecho, Incorporated: Balance Sheet \begin{tabular}{|l|c|} \hline \multicolumn{1}{|c|}{ Randall-Hecho, Incorporated: Rates } & Rates \\ \hline Interest Rate on Debt & 0.060 \\ \hline Corporate Tax Rate & 0.200 \\ Sustainable Growth Rate & 0.010 \\ \hline \end{tabular}