Business Finance Homework Help

Using the excel attached and document any reference that was used.

1) Using the given Excel spreadsheet, show the common-size (in percentage) and common-base year (in numbers) of the Balance Sheet and Income Statement for both Companies A and T respectively, by doing a screen-shot of your Excel tables and paste them in your report. Ensure good clarity and resolution of your screen shots.

2) Solve for the Current and Cash ratios for both companies in year 2020. Show your Excel formulas. Round-off the answers to two (2) decimal places.

3) Solve for the Cash Conversion cycle for both companies. Show your Excel formulas. Round- off the answers to two (2) decimal places.

4) Show at least two (2) benefits of knowing and understanding the impact of Liquidity ratios and likewise, two (2) benefits of knowing Cash Conversion cycle, for the management of companies of concern.