Financial Analysis Assignment

$($To be completed on Spreadsheet$)$

Constructing an Income Statement. Using the income and expense account information for

Orange Products Inc. listed below, construct an income statement for the year ended ${31}^{st}$

December, $2023.$

Shares outstanding: $1,575,000$

Tax rate: $35\%$

Interest expense: $$3,540,000$

Revenue: $$950,500,000$

Depreciation: $$50,000,000$

Selling, general, and administrative expense: $$85,000,000$

Other income: $$1,350,000$

Research and development: $$5,200,000$

Cost of goods sold: $$730,000,000$

Constructing a Balance Sheet. Construct Orange Incorporated's $2023$ year$-$end Balance Sheet

using the asset, liability, and equity accounts listed below:

Retained Earnings $$60,500,000$

Accounts Payable $$57,000,000$

Accounts Receivable $$43,000,000$

Common Stock $$89,676,000$

Cash $$6,336,000$

Short Term Debt $$1,500,000$

Inventory $$42,000,000$

Goodwill $$30,000,000$

Long Term Debt $$74,000,000$

Other Non$-$Current Liabilities $$15,000,000$

PP&E $$225,000,000$

Other Non$-$Current Assets $$14,000,000$

Long$-$Term Investments $$25,340,000$

Other Current Assets $$12,000,000$

Common size statements: Re$-$state Orange Incorporated's $2023$ financial statements as

common$-$size statements and comment on them

Compute and analyze financial ratios. Using the $2023$ income statement and balance sheet of

Orange Products Inc, as constructed in problems $1$ and $2$ above, compute its financial ratios.

How is the firm doing relative to its industry in the areas of liquidity, asset management, leverage,

and profitability?