Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

the first three is the question and the the rest is just data for the answer! please help i need this today!!! Units is not

the first three is the question and the the rest is just data for the answer!
please help i need this today!!!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Units is not included only Arrow & Root!
i forgot to add this page by mistake, sorry! image text in transcribed
Group Number: Ratio Analysis Assignment Student Name: Student Name: Working Capital: Current Assets - Current Liabilities Current Ratio: Debt to Total Equity: You are the loan manager at a local bank. Two companies have approached you about securing a 6 -month loan. Based on your calculations above, please comment on the following: 1) Assess and comment on Arrow and Root's UQUDITY ratios. [1 mark] 2) Assess and comment on Arrow and Root's SOLVENCY ratios. (1 mark) 3) Assess and comment on Arrow and Root's PROFITABIUTY ratios. (1 mark) 4) Which company would you prefer to give the loan to between Arrow and Roet? Fxplain why. [t mark] 5) In 2-3 sentences, describe the concern you would have if you found out that Arrow had upgraded its accounting systern this year and the company did not test the new accounting system to make sure that the system was processing data coerectly? (I mark) ARROW LTD. ARROW LTD. STATIMLNT OF HNANCIAL POSTTON AS AT DECEMBER 31, 2022. CANADLAN DOULARS (mllions of dollars) ASSETS Current assets Liabilities and Shareholders" Equity Current Liabilities ROOT LTD. INCOME STATEMENT ROOT LTD. STATEMENT OF FINANCIAL POSITION AS AT DECEMBER 31, 2022 CANADIAN DOLLARS (millions of dollars) ASSETS Current assets Notes: Please use Excel formulae to calculate your ratios. If a ratio is reported in \% form, please present your solution in whole number form (ie. 5.25 instead of 0.0525). Cells have been formatted to display 2 decimal places. Please do not adjust the cell formatting. Please note: All submissions will be subject to plagarism detection software Turnitin. Scenario: You are a bank loan manager and you have had two companies (Arrow and Root) come to your banik, each requesting a 6-month loan. You must decide which company to give the loan to. Required: This file contains 4 tabs. The tabs "Arrow" and "Root" contain the respective financial statements for Arrow and Root. The "Student Submission" tab is where you will perform your calculations and written work. Part 1: (16 ratios 2 marks each =32 marks total) In the "Student Submission" tab, you will be caiculating Liquidity, Solvency, and Profitability ratios for each company, stating what makes a ratio more successful, and comparing the results between the two companies to determine which company has stronger results. In columns D and E, prepare your calculations for Arrow and Aoot. When typing in your formulae, it is recommended to create links to the financial statement figures to avoid transposition errors. Please complete all calculations to 2 decimal places. In columns F, please indicate the units for each ratio calculation. There are drop-down menus available for you to select the units when you click into the cells in column F. If a ratio is uses % as a unit, please leave your calculation in whole number form (le. 5.25 instead of 0.0525) In column G, comment on which company has a better ratio result based on your calculations (The ratios may be the same/comparable depending on your particular version of financial statements). Please note that when comparing the working capital ratios between companies, the companies need to be considered comparable in size. For the purposes of this assignment, assume that Arrow and Root are comparable. Part 2: (5 marks) Below your calculations, you will write a short 3-4 sentence conclusion relating to which company you would approve the loan to based on your calculations from Part 1. Submission: Please have one group member upload a copy of your group's completed assignment in Brightspace. Please make sure that the names of all of your group members and your group number are included on the top of the "Student Submission" tab

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Padhukas Students Handbook On Auditing And Assurance Including Multiple Choice Questions For CA Inter

Authors: CA G. Sekar, CA B Saravana Prasath

18th Edition

9390303087, 978-9390303083

More Books

Students also viewed these Accounting questions

Question

Outline the general approach for developing location alternatives.

Answered: 1 week ago

Question

Discuss the goals of financial management.

Answered: 1 week ago

Question

2. What is the impact of information systems on organizations?

Answered: 1 week ago

Question

Evaluate the impact of technology on HR employee services.

Answered: 1 week ago