Question: table with calculated ratios for each year. Ratio 2021 (A) 2021 (B) 2022 (A) 2022 (B) 2023 (A) 2023 (B) Current Ratio 2.0 1.67 1.86

table with calculated ratios for each year.

Ratio 2021 (A) 2021 (B) 2022 (A) 2022 (B) 2023 (A) 2023 (B)
Current Ratio 2.0 1.67 1.86 1.60 1.75 1.55
Quick Ratio 1.67 1.39 1.54 1.33 1.44 1.27
Debt-to-Assets Ratio 0.5 0.5 0.5 0.51 0.49 0.49
Debt-to-Equity Ratio 1.0 1.0 1.0 1.03 0.96 0.97
Net Profit Margin 15% 11.43% 15.81% 12.5% 15.63% 13.51%
ROE 18% 13.33% 18.85% 14.52% 17.86% 14.71%

Company A and Company B both have declines in their liquidity ratios (current ratio and quick ratio) throughout 2021-2023, but Company A has a higher ratio which shows better financial health. Company A has higher profitability (Net Profit Margin and ROE) than Company B. Company A has a better leverage (Debt-to-Assets Ratio and Debt-to-Equity Ratio) over the period. Overall, Company A is better off financially.

2. NPV and IRR:

Calculate NPV and IRR using the provided cash flows for Company A.

Year Cash Flow Present Value Factor (10%) Present Value
1 $30,000 0.909 27,270
2 $40,000 0.826 33,040
3 $50,000 0.751 37,550
Total PV 27,270 + 33,040 + 37,550 = 97,860
NPV 97,860 - 100,000 = -2,140

Deliverable:

  • Summarizing key findings about the companies' financial positions based on the ratios.
  • Show the calculations for NPV and IRR clearly.
  • explain whether the project is financially viable and why.

Step 4: Summary and Reflection

Tasks:

  • Short conclusion summarizing the key takeaways from your analysis.
  • Reflect on the importance of financial ratios and capital budgeting in making business decisions.

Deliverable:

  • A short paragraph summarizing your findings and reflections.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!