You are a bank loan manager and you have had two companies (Arrow and Root) come...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a bank loan manager and you have had two companies (Arrow and Root) come to your bank, each requesting a 6-month loan. You must decide which company to give the loan to. Instructions: • Under Course Tools - My files - Group File Area, you will find your group's unique Microsoft Excel file that contains the financial statements for 2 companies (Arrow and Root) and a tab where you will calculate all ratios (See tab "Student Submission"). Required: There are two parts to this assignment: Part 1: In the Microsoft Excel file on the "Student Submission" tab, you will be calculating 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 Root. 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. If a ratio is uses % as a unit, please leave your calculation in decimal form (ie. 0.05 instead of 5%). There are drop-down menus available for you to select the units when you click into the cells in column F. In column G, comment on which company has a better ratio result based on your calculations (the ratios may be the same depending on your particular version of financial statements). There are drop-down menus available for you to select the better company when you click into the cells in column G. 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. (16 ratios x 2 marks each = 32 marks) Part 2: Below your calculations, you will write a conclusion relating to which company you would approve the loan to based on your calculations from Part 1. The final write-up should be in paragraph form. (5 marks) Revenue Sales Revenue Rent Revenue Interest Revenue Other Revenues Total revenues 3 Operating expenses Cost of Goods sold Wages expense Salary expense Benefit expense Research and development expense Repairs and maintenance expense Sales and distribution costs expense Depreciation expense-equipment Depreciation expense-vehicles Depreciation expense-furniture Depreciation expense-office building Insurance expense Property taxes expense Food and beverage expense 8 9 Supplies expense Interest expense 9 O 3 2 Total operating expenses 3 Profit before income tax 4 Income Tax expense 5 Profit ARROW LTD. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2022 CANADIAN DOLLARS (millions of dollars) Information technology expense Advertising expense 6 7 Denotes all of these sales were made on credit $ 1,081 456 324 381 315 336 176 140 32 27 152 31 3 8 11 15 35 77 64 33 30 203 139 $ 2,242 1,688 554 415 G 1 2 3 14 5 ASSETS 56 17 Current assets 48 Cash 49 Short-term investments 50 Accounts receivable 51 Inventory 52 Spare parts and supplies inventory 53 Prepaid Maintenance 54 Prepaid expenses 55 Total current assets 56 57 Investments 58 59 Property plant, and equipment 60 Land 61 62 63 64 65 Equipment Less: Accumulated depreciation Vehicles Less: Accumulated depreciation Furniture Less: Accumulated depreciation 6Total property, plant and equipment 20 71 Intangible assets 72 Trademark 73 Patient 74 Total intangible assets 75 Total Assets 66 67 68 ZER Office Building Less: Accumulated depreciation 76 77 Liabilities and Shareholders' Equity 78 ARROW LTD. STATEMENT OF FINANCIAL POSITION AS AT DECEMBER 31, 2022 CANADIAN DOLLARS (millions of dollars) + S 2,055 577 1,551 411 595 89 200 32 $ 1,927 866 390 93 86 384 41 65 1,478 1,140 506 168 74 26 $ 3,787 157 3,357 100 7,401 Current Liabilities Accounts payable Accrued liabilities Unearned Revenue Current portion of bank loan and mortgage payable Income Tax payable Total Current Liabilities Non-current liabilities Bank loan payable Mortgage Payable 4 5 6 Bond payable Total Non-current liabilities Total Liabilities Shareholders' Equity Preferred Shares ** Common Shares *** Retained Earning Total Shareholders' Equity Total liabilities and shareholders' equity There were no preferred dividends declared this year. ***The Weighted Average number of common shares outstanding are: The Market price per common share is : 45 339 291 575 374 335 504 315 1,129 427 971 2,141 20,000,000 1,914 1,948 3,862 3,539 7,401 You are a bank loan manager and you have had two companies (Arrow and Root) come to your bank, each requesting a 6-month loan. You must decide which company to give the loan to. Instructions: • Under Course Tools - My files - Group File Area, you will find your group's unique Microsoft Excel file that contains the financial statements for 2 companies (Arrow and Root) and a tab where you will calculate all ratios (See tab "Student Submission"). Required: There are two parts to this assignment: Part 1: In the Microsoft Excel file on the "Student Submission" tab, you will be calculating 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 Root. 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. If a ratio is uses % as a unit, please leave your calculation in decimal form (ie. 0.05 instead of 5%). There are drop-down menus available for you to select the units when you click into the cells in column F. In column G, comment on which company has a better ratio result based on your calculations (the ratios may be the same depending on your particular version of financial statements). There are drop-down menus available for you to select the better company when you click into the cells in column G. 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. (16 ratios x 2 marks each = 32 marks) Part 2: Below your calculations, you will write a conclusion relating to which company you would approve the loan to based on your calculations from Part 1. The final write-up should be in paragraph form. (5 marks) Revenue Sales Revenue Rent Revenue Interest Revenue Other Revenues Total revenues 3 Operating expenses Cost of Goods sold Wages expense Salary expense Benefit expense Research and development expense Repairs and maintenance expense Sales and distribution costs expense Depreciation expense-equipment Depreciation expense-vehicles Depreciation expense-furniture Depreciation expense-office building Insurance expense Property taxes expense Food and beverage expense 8 9 Supplies expense Interest expense 9 O 3 2 Total operating expenses 3 Profit before income tax 4 Income Tax expense 5 Profit ARROW LTD. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2022 CANADIAN DOLLARS (millions of dollars) Information technology expense Advertising expense 6 7 Denotes all of these sales were made on credit $ 1,081 456 324 381 315 336 176 140 32 27 152 31 3 8 11 15 35 77 64 33 30 203 139 $ 2,242 1,688 554 415 G 1 2 3 14 5 ASSETS 56 17 Current assets 48 Cash 49 Short-term investments 50 Accounts receivable 51 Inventory 52 Spare parts and supplies inventory 53 Prepaid Maintenance 54 Prepaid expenses 55 Total current assets 56 57 Investments 58 59 Property plant, and equipment 60 Land 61 62 63 64 65 Equipment Less: Accumulated depreciation Vehicles Less: Accumulated depreciation Furniture Less: Accumulated depreciation 6Total property, plant and equipment 20 71 Intangible assets 72 Trademark 73 Patient 74 Total intangible assets 75 Total Assets 66 67 68 ZER Office Building Less: Accumulated depreciation 76 77 Liabilities and Shareholders' Equity 78 ARROW LTD. STATEMENT OF FINANCIAL POSITION AS AT DECEMBER 31, 2022 CANADIAN DOLLARS (millions of dollars) + S 2,055 577 1,551 411 595 89 200 32 $ 1,927 866 390 93 86 384 41 65 1,478 1,140 506 168 74 26 $ 3,787 157 3,357 100 7,401 Current Liabilities Accounts payable Accrued liabilities Unearned Revenue Current portion of bank loan and mortgage payable Income Tax payable Total Current Liabilities Non-current liabilities Bank loan payable Mortgage Payable 4 5 6 Bond payable Total Non-current liabilities Total Liabilities Shareholders' Equity Preferred Shares ** Common Shares *** Retained Earning Total Shareholders' Equity Total liabilities and shareholders' equity There were no preferred dividends declared this year. ***The Weighted Average number of common shares outstanding are: The Market price per common share is : 45 339 291 575 374 335 504 315 1,129 427 971 2,141 20,000,000 1,914 1,948 3,862 3,539 7,401
Expert Answer:
Answer rating: 100% (QA)
For ARROW Liquidity Ratio Current Ratio Current AssetsCurrent Liabilities 30912144 144 1 Higher the better indicates shortterm liquidity Quick Ratio C... View the full answer
Related Book For
Money Banking and Financial Markets
ISBN: 978-0078021749
4th edition
Authors: Stephen Cecchetti, Kermit Schoenholtz
Posted Date:
Students also viewed these accounting questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
A car is randomly selected at a traffic safety checkpoint, and the car has 6 cylinders. Determine whether the given values are from a discrete or continuous data set.
-
In designing circular rides for amusement parks, mechanical engineers must consider how small variations in certain parameters can alter the net force on a passenger. Consider a passenger of mass m...
-
The steel chisel has a diameter of \(0.5 \mathrm{in}\). and a length of \(10 \mathrm{in}\). It is struck by a hammer that weighs \(3 \mathrm{lb}\), and at the instant of impact it is moving at \(12...
-
What happens to an existing partnership if a partner dies?
-
To: [Your name] From: Supervising Attorney Re: Commonwealth v.Jones; assault by means of a dangerous weaponlightning This is a bizarre case to say the least. We have been appointed by the court to...
-
Perform a chi-square test to look at the relationship between region of the country (REGION) and financial comfort (FCOMFORT). Using alpha = .05, what would you conclude from your test:
-
One model A1100 Kawasaki Jet Ski Personal Watercraft was sold for cash. This model retails for $9,375.00 plus 8% sales tax ($9,375.00 x 8% = $750.00). Invoice Number: G4011. Because a perpetual...
-
Use the mesh current method to find the power dissipation in the 10 Ohm resistor (10 points).
-
XYZ is a respectable midsized banking group in India that differentiates itself from its competitors through its attention to customer service and satisfaction. The bank also the lower interest rates...
-
Solve. log3 (p) = 5 p = Question Help: Video Message instructor Calculator Submit Question
-
Calvin reviewed his canceled checks and receipts this year (2023) for charitable contributions, which included an antique painting and IBM stock. He has owned the IBM stock and the painting since...
-
Chapter 8: (Algo) Applying Excel: Exercise (Part 2 of 2) Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the...
-
The following adjusted trial balance at December 31 of Wilson Trucking Company. Account Title Cash Accounts receivable Office supplies Trucks Land Accumulated depreciation-Trucks Accounts payable...
-
A rollercoaster has a first hill that is 1 6 0 . 0 m high. The roller coaster cart is going 2 5 . 0 m / s at the top of the second hill. No , you are not provided with the mass of the roller coaster...
-
Evaluate the function at the given value(s) of the independent variable. Simplify the results. (x) = cos 2x (a) (0) (b) (- /4) (c) (/3) (d) ()
-
Commercial banks have become increasingly involved in real estate market. Plot the percent change from a year ago of real estate loans made by commercial banks (FRED code: REALLN) and discuss the...
-
Splitland is a developing economy with two distinct regions. The northern region has great investment opportunities, but the people who live there need to consume all of their income to survive....
-
While we often associate informal financial arrangements with poorer countries where financial systems are less developed, informal arrangements often co-exist within the most developed financial...
-
The theory of monopolistic competition is based on three characteristics: (1) product _________, (2) many _________, and (3) free _________.
-
Monopolistic competitive sellers are price _________ and they do not regard price as given by the market. Because products in the industry are slightly different, each firm faces a(n)...
-
In the short run, equilibrium output is determined where marginal revenue equals marginal _________. The price is set equal to the _________ the consumer will pay for this amount.
Study smarter with the SolutionInn App