Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question: Evaluate the financial performance of Air Asia Berhad using time series and cross sectional analysis over a five years' period based on the data
Question: Evaluate the financial performance of Air Asia Berhad using time series and cross sectional analysis over a five years' period based on the data above (Hint: Analyze the profitability and liquidity ratio for cross sectional analysis)
A B D E F 1 AIR ASIA Berhad (MY) (MYR) 2015 2016 2017 2018 2019 2 current asset 4286 4775 4323 8818 5292 3 4 current liabilities 5272 4919 5334 6850 7135 5 6 inventories* comes under current asset 26 44 68 106 146 7 Liquidity 2015 2016 2017 2018 2019 8 current ratio 0.81297 0.97073 0.81046 1.2873 0.7417 9 Quick ratio 0.80804 0.96178 0.79771 1.27182 0.72123 10 11 Profitability 2015 2016 2017 2018 2019 12 Gross profit* (one sentence) 1622 1996 1853 805 1226 13 14 Sales* (one sentence, tht its increasing) 6298 6846 9710 10638 11860 15 16 Earning available to com.stockholder 541 1622 1629 1967 -316 17 18 19 number of share of com stock outstanding (Bas 2783 2783 3304 3342 3342 20 number of share of com stock outstanding (Dily 2783 2783 3304 3342 3342 21 Asset (total) 21316 21986 21674 18550 25595 22 23 Common stock equity 4451 6628 6710 6185 2911 24 25 Gross profit margin (sales -cogs)* 0.25754 0.29156 0.19083 0.07567 0.10337 26 Net profit margin* (sales made for the year) 0.0859 0.23693 0.16777 0.1849 -0.0266 27 EPS (BASIC) 0.19439 0.58282 0.49304 0.58857 -0.0946 28 EPS (Diluted) 0.19439 0.58282 0.49304 0.58857 -0.0946 29 ROI ROA" (find online) 0.02538 0.07377 0.07516 0.10604 -0.0123 30 ROE (write about total equity to know worth) 0.12155 0.24472 0.24277 0.31803 -0.1086Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started