You are an analyst working at a large Canadian bank, and your job is to evaluate the
Question:
You are an analyst working at a large Canadian bank, and your job is to evaluate the financial condition of potential corporate clients and make a recommendation as to whether they should be approved for a loan. Your task is to review the financial data for four potential borrowers and decide which of the four you would recommend for a loan - you can only recommend one of the four. The four applicants are companies operating in the manufacturing sector, and the financial data provided are 3-year averages for each of the companies.
Required:
(1) For each group of ratios (Liquidity(s/t), Liquidity(l/t), Turnover, and Profitability), summarize your analysis of how each company's ratios compare to one another.
(2) Based on your analysis in identify which company has the most favorable ratios in that group of ratios.
(3) Which company would you approve for a loan and why? Which companies would you reject for a loan and why?
Financial Analysis with Microsoft Excel
ISBN: 978-1285432274
7th edition
Authors: Timothy R. Mayes, Todd M. Shank