Financial Ratios and Financial Statements. You are an analyst and have certain rates of return, profit margin, and other informaton on the Jeff, Matt, and Mike Associates company. Using the information in Exhibit $2\mathrm{.}8,$ complete the partial financial statements and calculate the missing financial information $($in highlighted cells$).$ All financial ratios using balance sheet numbers are calculated using Year $7$ ending balances instead of average balances. The company had no purchases or other additions to Intangible assets. It had no sales or retirements of property, plant and equipment or intangible assets. Essentially all of the company's property, plant and equipment is depreciable. All changes in financing occur at the end of fiscal year.

Work out the Income Statement of Year $7$ and Balance Sheet at the end of Year $7$ for the company by entering appropriate formulas in the yellow$-$colored cells. Some formulas have been provided in green$-$colored cells to help you solve the problem.

Exhibit P$2\mathrm{.}8$

$\backslash$table$[[$Income Statements $($$ MM$),$Year $7],[$Operating Revenue,$],[$Cost of Goods Share,$],[$Selling$,$ General and Administrative,$],[$Depreciation and Amortization $($All$),],[$Operating Income $($EBIT$),],[$Interest Expense,#VALUE!$]]$

$\backslash$table$[[$OTHER INFORMATION,Year $7],[$Income Tax Rate,$30\mathrm{.}0\%$