question
|
LLC |
Current Asset |
Current Liabilities |
Total Liabilities |
Total Assets |
|
2016 |
5,857.9 |
8,824.3 |
12,978.2 |
18,592.9 |
|
2017 |
6,261.3 |
10,757.7 |
14,687.7 |
20,854.2 |
|
2018 |
6,314.2 |
6,588.0 |
10,549.4 |
16,963.6 |
|
2019 |
5,756 |
6,287 |
10,821 |
17,178 |
|
2020 |
5,977 |
5,653 |
10,816 |
17,748 |
|
2021 |
4,950 |
5,983 |
10,049 |
17,000 |
|
BKW |
Net Cash Provided by operating activities |
Operating Income Before Tax |
Finance Costs |
Cash and cash eqiv & Accounts receivables |
|
2016 |
853.0 |
862.8 |
- 126.2 |
1,008.4 + 2,785.0 |
|
2017 |
146.0 |
1,007.0 |
- 108. 6 |
1,249.2 + 2,749.2 |
|
2018 |
72.8 |
1,066.2 |
- 88.0 |
1,177.1 + 2,670.2 |
|
2019 |
60 |
620 |
- 142 |
1,290 + 2,050 |
|
2020 |
137 |
- 536 |
- 165 |
1, 1 1 1 + 1,667 |
|
2021 |
468 |
295 |
- 146 |
1,662 + 1,741 |
All the figures are in millions
Please write down the formulas used to answer the question and use excel to answer.
Calculate:
Step by step
Solved in 2 steps
The question is required to answer year by year. Meaning separately 2016 quick ratio, 2017 quick ratio etc.
Thank you
by Bartleby Expert
