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.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 grad

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

Exhibit P$2\mathrm{.}8$

Income Statements $($$ MM$)$

Operating Revenue

Cost of Goods Share

Selling, General and Administrative

Depreciation and Amortization $($All$)$

Operating Income $($EBIT$)$

Interest Expense

Income Before Income Tax Expense $($EBT$)$

Income Tax Expense $($Benefit$)$

Net Income

Accounts Payable

Accruals

Total Current Liabilities

Total Debt

Year $7$

Beginning of Year Balance $-$ Intangible Assets $ $2,500$

Common Dividends $,$$$3,014$

EBITDA to Fixed Charges

Quick $($Acid Test$)$ Ratio

Days of Inventory Held

Accounts Receivable Collection Period

Trade Cash Cycle

Provision for Bad Debts Ratio

Depreciable Life of Gross Plant

Depreciable Life of Net Plant

PPEQ Investment $($CAPEX$)$ to Revenues

PPEQ Investment $($CAPEX$)$ to Depreciation

$$2,160$

$$3,070$