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}^{3t}$

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$