Assignment 1 – Ratio Analysis and visualization Grading:Calculations and inte

ORDER YOUR PAPER AND GET QUALITY FOR YOUR MONEY

Assignment 1 – Ratio Analysis and visualizationGrading:Calculations and interpretation (individually and trend) – (8/12)Your articulation of them in financial language – (2/12)Visual presentation of trends – (2/12)Objective:This group assignment aims to motivate students’ interest in the financial analysis of firms in the tourism and hospitality industry to provide them with a bird’s eye view. You will preform ratio analysis, compute common size balance sheet and income statement, compute variances in MS Excel.Requirements:a)Obtain the audited financial statements for the last 5 years of your assigned company. I will provide the latest 2 years. If you are having problem getting the others let me know soonest.b)Prepare common size balance sheets and income statements for all 5 years.c)Compute the income statement variance amounts and percentage for the applicable years.d)Perform ratio analysis – calculate, comment on the calculations, and present the information using visualization.Profit marginGross operating profit marginReturn on assetsPrice-to-earnings ratioDividend payout ratioDividend yield ratioCurrent ratioQuick ratioOperating cash flow to current liabilities ratioWorking capitalSolvency ratioDebt-to-equity ratioDebt-to-asset ratioOperating cash flows to total liabilities ratioTimes interest earned ratioFixed asset turnover ratioTotal asset turnover ratioNet working capital turnoverNB.Please provide a snapshot of the data and date accessed of market information where applicable.Utilize extensively, formulas and or cell referencing in MS Excel.Only do part a！