Directions

For the company you chose for your final project, open the following documents:

The balance sheet, income statement, and cash flow statement from the latest fiscal quarter $($from Mergent Online$)$

The Ratios Most Recent Fiscal Qtr worksheet in the Final Project Financial Formulas workbook $($linked in the What to Submit section$).$

example, if the latest fiscal quarter available is the third quarter in $2023,$ you'll compare those results to the same financial calculations

from the third quarter in $2022.$

Use the documents to calculate key financial ratios.

Then open the following documents:

The balance sheet, income statement, and cash flow statement from the same fiscal quarter one year ago

The Ratios Same Fiscal Qtr $1$ Year Ago worksheet

Use the documents to calculate the same financial ratios. Finally, compare those ratios and analyze your results.

Specifically, you must address the following rubric criteria:

Financial Calculations. Calculate accurate financial formulas to assess the business's current financial health. Specifically, calculate the

following formulas using the Ratios Most Recent Fiscal Qtr and the Ratios Same Fiscal Qtr $1$ Year Ago worksheets in the Final Project

Financial Formulas workbook:

A$.$ Working capital

B$.$ Current ratio

C$.$ Debt ratio

D$.$ Earnings per share

E$.$ Price and earnings ratio

F$.$ Total asset turnover ratio

G$.$ Financial leverage

H$.$ Net profit margin

I. Return on assets

J$.$ Return on equity

Fiscal Quarter Comparison. Summarize the differences between the following:

A$.$ The results from your financial calculations of the most recent fiscal quarter

B$.$ The results of the same financial calculations of the same fiscal quarter from one year ago

i$.$ For example, if the most recent fiscal quarter available is the third quarter in $2023,$ you'll compare those results to the same

financial calculations from the third quarter in $2022.$

Comparison Analysis. Explain what your calculations and comparison show about the business's current financial health. Give examples to

support your explanation for the following questions:

A$.$ Do the results show the business is financially healthy or unhealthy? Which results indicate this?

B$.$ What might be the causes of the business's financial success or failure?

C$.$ Is more information needed to determine the business's financial health? If $so,$ which pieces of information might still be needed?

Short$-$Term Financing. Explain how potential short$-$term financing sources could help the business raise funds needed to improve its

financial health. Base your response on the business's current financial information.

As Reported Quarterly Balance Sheet

Report Date $10/01/202307/02/202304/02/202310/02/2022$

$3$rd Quarter $2$nd Quarter $1$st Quarter $3$rd Quarter

Currency USD USD USD USD

Audit Status Unaudited Unaudited Unaudited Unaudited

Consolidated Yes Yes Yes Yes

Scale Thousands Thousands Thousands Thousands

Cash $3214000---$

Money market funds $3503000---$

Cash & cash equivalents $19728000211830001917000011355000$

Restricted cash $--7695000-$

Marketable securities $37830007322000544300022724000$

Accounts receivable, trade, gross $14958000169820001655700016091000$

Less: allowances $160000205000207000201000$

Accounts receivable, trade $14798000167770001635000015890000$

Raw materials & supplies $2233000241900022670001730000$

Goods in process $1961000194400018660002106000$

Finished goods $7004000852500086760007839000$

Inventories $11198000128880001280900011675000$

Prepaid expenses & other receivables $4196000---$

Prepaid expenses & other current assets $-239700029210003592000$

Government securities and obligations $4728000---$

Corporate debt securities $44000---$

Reverse repurchase agreements $7261000---$

Time deposits $748000---$

Other Sovereign Securities $2000---$

Corporate debt securities $78000---$

Non$-$U$.$S$.$ sovereign securities $150000---$

Total current assets $53703000605670006438800065236000$

Property, plant & equipment at cost $45626000512180005036700046681000$

Less: accumulated depreciation $26805000306420003019300028529000$

Property, plant & equipment, net $18821000205760002017400018152000$

Intangible assets, net $35021000462460004744800040336000$

Goodwill $36124000454400004557500033383000$

Deferred taxes on income $9259000877900088170009392000$

Other assets $131330001007800095670008625000$

Other Assets $-$ Balancing value $9110000---$

Equity investments $4023000---$

Total assets $166061000191686000195969000175124000$

Loans & notes payable $200000011701000179790004424000$

Accounts payable $835500010443000990900010153000$

Accrued liabilities $10101000106050001120400011953000$

Accrued rebates, returns & promotions $15808000156720001478400014021000$

Accrued compensation & employee related obligations $3337000306200022310003006000$

Accrued taxes on income $-2687000$