Upload your Project Report $($Word$/$pdf$)$ and Calculation $($Excel$)$ to Canvas on or before February $16,2024($Friday$)$ at $11$:$59pm.$

Total points: $15$ points $(15\%$ of your final grade$)$

Late submission will be penalized by deducting $5\%$ of the assigned points per day after the submission deadline.

Resubmission is allowed only once. The resubmitted projects cannot get more than $70\%$ of the total points i$.$e$.,10\mathrm{.}5$ points.

The project is an exercise of fundamental analysis of a firm by analyzing its ratios. You are expected to calculate a number of ratios for a firm and analyze its financial condition. As the main outcomes of the project, upload $2$ files on Canvas: Project Report $($Word$/$pdf$)$ and Calculation $($Excel$).$

Pick a prominent, non$-$financial, publicly listed corporation $($except Walmart$)$ from any industry. Calculate the following ratios for your chosen firm for $2022$ and $2023($if $2023$ data is not available, use $2021$ and $2022$ data$)$

$\backslash$table$[[\backslash$table$[[$Liquidity Ratios:$],[$Current Ratio$],[$Quick Ratio$],[$Cash Ratio$]],\backslash$table$[[$Solvency Ratios:$],[$Total Debt Ratio$],[$Debt$-$equity Ratio$],[$Times Interest Earned Ratio$]],\backslash$table$[[$Turnover Ratios:$],[$Inventory Turnover$],[$Receivables Turnover$],[$Total Asset Turnover$]]],[\backslash$table$[[$Profitability Ratios:$],[$Profit Margin$],[$Return on Assets $($ROA$)],[$Return on Equity $($ROE$)]],\backslash$table$[[$Market values Ratios:$],[$Price$-$earnings Ratio$],[$Price$-$sales Ratio$],[$Market$-$to$-$book Ratio$]],]]$

Investigate the firm's financial condition in $2023($by comparing it with $2022)$ in terms of its Liquidity, Solvency, Turnover, Profitability, and Market Values by analyzing the calculated ratios. How has the firm's performance changed over time? Based on your analysis, comment on the prospects of the firm from an investor's viewpoint.

Instructions:

Consistent with the university's academic integrity policy, your submission must be your original work.

Show all your work$/$calculations in an Excel file $($Question $1).$ The required financial statements $($Income Statement and Balance Sheet$)$ must be presented in Excel; calculate all the ratios from those data using Excel formulas. Using Excel formulas is mandatory for this project. The Excel calculations carry $10$ points.

Use a Word$/$pdf file for the analysis part $($Question $2).$ The Project Report must be at least $2$ full pages. The Project Report carries $5$ points.

For both calculation and analysis, use the content of Chapter $3$: Working with Financial Statements.

Use reliable web sources for financial statements, such as Bloomberg, Yahoo Finance, Edgar, etc.

The grade for the project depends on the quality of work in terms of accuracy, analysis, completeness, organization, writing, and relevance.