Hotel Finance and Revenue: A Financial Analysis Report
Verified
Added on 2023/06/12
|24
|5308
|409
AI Summary
This report conducts a financial analysis of British Airways, evaluating its profitability, efficiency, liquidity, capital structure, and investor ratios. The report provides insights into the company's financial performance and position.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Running Head: Hotel Finance and revenue 1 Project Report: Hotel Finance and revenue
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Hotel Finance and revenue 2 Contents Introduction.......................................................................................................................3 Company overview...........................................................................................................3 Findings............................................................................................................................3 Profitability ratios.........................................................................................................4 Efficiency ratios............................................................................................................5 Liquidity ratios..............................................................................................................7 Capital structure ratios..................................................................................................9 Investor’s ratios..........................................................................................................10 Discussion.......................................................................................................................11 Conclusion and recommendation...................................................................................12 References.......................................................................................................................14 Appendix.........................................................................................................................16
Hotel Finance and revenue 3 Introduction: Financial evaluation and analysis is a process which is used by the companies and the investors and financial analyse of the company to analyze the performance of the company in context with the finance. This process evaluates the budgets, projects, financial related entities etc of an organization to identify the suitability and the performance of the company. Normally, financial analysis process is used by the related parties to identify that whether the organization is stable, liquid, solvent and profitable enough to manage the performance and the position in the industry. Financial analyst and the financial manager of a company evaluate the financial statement and the financial transaction of a company to generate the idea about the performance of the company. There are various tools to evaluate the financial performance of the company. All the tools are used by the companies to generate a basic idea about the different business transactions and the decisions of the company. In the report, British airways has been taken into the concern and the ratio analysis study has been conducted on the company to generate an idea about the stable, liquid, solvent and profitable position of the company. Company overview: “British airways” is the largest airline on the basis of fleet size in United Kingdom. The company has been founded in 1974. The head office of the company has based in Waterside at London Heathrow Airport. The company has been merged with a company, Iberia to diversify the market.The British airways are offering its services at many destinations in Australia as well as at international level.Currently, company is serving into 183 destinations. Company is registered in London stock exchange by the name of Boeing Company (Home, 2018).The financial evaluation explains that the last few decades was not that much good for the company. Various up and down has been faced by the company in last few decades. Findings: The financial statement of the company has been evaluated to identify the performance of the company. The ratio analysis study has been conducted on the company to generate an idea about the stable, liquid, solvent and profitable position of the company as well as the changes into the financial statement of the company has also been evaluated on
Hotel Finance and revenue 4 the basis of year 2013 to analyze that how much changes have occurred into the financial performance of the company in last five years. Ratio analysis is a quantitative analysis which evaluates information that is combined in the financial statement of a company. Ratio analysis study is used by the companies to evaluate the various financial aspect of an organization. It explains about the stable, liquid, solvent and profitable position of the company. The ratio analysis study of the company is as follows: Profitability ratios: Profitability ratios express about the ability of a business that is used to generate the earnings of an organization in comparison with the expenses and other related cost of the company in a particular time period. Profitability ratios make it easier for the investors and the analyst of the company to evaluate about the profitability level of the company. There are various ratios on the basis of that profitability position of an organization could be evaluated such as net profit margin, return on equity, return on assets etc. (Dewachter et al, 2015) Return on assets: Return on assets measures the total profit which has been generated by the company against the total resources which has been used to generate the profit. The return on assets of British airways has been calculated and it has been found that the ROA of the company has been enhanced from 5.48% to 8.88% in 2017 from 2015. Return on assets Net profit /51,76,00048,95,00081,97,000 Total assets9,44,08 ,000 8,99,97 ,000 9,23,33, 000 Answer:%5.48%5.44%8.88% (Morningstar, 2018) Return on equity: Return on equity measures the total profit which has been generated by the company against the total stockholder’s equity which has been invested to generate the profit. The return on equity of British airways has been calculated and it has been found that the ROE of the company has been enhanced from 82% to 96% in 2017 from 2015. Return on equity
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Hotel Finance and revenue 5 Net profit / 51,76,00048,95,00081,97,00 0 Total stockholder's equity63,35,00081,70,00085,50,00 0 Answer:%82%60%96% Profit margin: Profit margin explains about the total profit of the company against the sales revenue of the company. The profit margin of the company has been evaluated further to recognize the profit position of the company and it has been found that the profit margin of the company has been enhanced from 5.39% to 8.78% in 2017 from 2015 (Bekaert & Hodrick, 2017). Profit margin Net profit /51,76,00048,95,00081,97,000 Sales Revenue%9,61,14,0009,45,71,0009,33,92,000 Answer:5.39%5.18%8.78% Figure1: Profitability Ratios Efficiency ratios:
Hotel Finance and revenue 6 Asset efficiency ratios express about the combination of assets and liabilities of the company and evaluates about the performance of the company. Efficiency ratios are used by the companies and the financial analyst to evaluate the commercial performance of the company. It measure the total time period in which the cash conversion cycle of an organization competes. There are various ratios on the basis of that efficiency position of an organization could be evaluated such as receivable turnover ratio, inventory turnover ratio, payable turnover ratio etc. Inventory turnover: Inventory turnover ratio explains about the total time in which the inventory of an organization would be sold and new inventory would take place. Inventory turnover ratio of the company explains that the turnover times are quite similar in last 3 years. The company is following the same policies to manage the inventory. Inventory Turnover Average Inventory /4725700 0 4319900 0 4434400 0 Cost of Sales8202400 0 8073100 0 7599600 0 Answer:0.580.540.58 Inventory turnover (days): Inventory turnover days explain about the total days in which the inventory of an organization would be sold and new inventory would take place (Barr & McClellan, 2018). The inventory turnover days of the company are quite similar in last 3 years. Inventory Turnover (days) Average Inventory /4,72,57, 000 4,31,99, 000 4,43,44, 000 Cost of Sales# days 8,20,24, 000 8,07,31, 000 7,59,96, 000 Answer:(note the above needs to be x 365) 210.29195.31212.98 Accounts receivable turnover: Accounts receivable turnover ratio explains about the total time in which the receivables of an organization would be getting back and new receivables would take place. Accounts receivable turnover ratio of the company explains that the turnover times have been
Hotel Finance and revenue 7 enhanced from 0.066 to 0.105. It explains that few changes have taken place into the receivable policies. Accounts receivable tunrover Average trade debtors /800300078040009763000 Sales revenue9,61,14,00 0 9,45,71,00 0 9,33,92,00 0 Answer:0.0830.0830.105 Accounts receivable turnover (days): Accounts receivable turnover days ratio explains about the total days in which the receivables of an organization would be getting back and new receivables would take place. Accounts receivable turnover ratio of the company has been enhanced from 24.22 days to 38.16 days (Barney & Hesterly, 2006). It explains that few changes have taken place into the receivable policies of the company. Receivables Turnover (days) Average trade debtors /80, 03,000 78, 04,000 97,6 3,000 Sales revenue(note used operating revenue) # da ys 9,61 ,14,000 9,45 ,71,000 9,33, 92,000 Answer:(note the above needs to be x 365) 30.3930.1238.16 Figure2: Efficiency Ratios
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Hotel Finance and revenue 8 Liquidity ratios: Liquidity ratios express about the combination of current assets and current liabilities of the company and evaluates about the capability of the company to pay its short term debt obligation in a particular time period. Liquidity ratios are used by the companies and the financial analyst to evaluate the risk position and the liquidity position of the company. It measure the total times in which the current debt would be paid by the company on the basis of current assets (Wang & Chung, 2015). Liquidity position of an organization could be evaluated on the basis of current liquidity ratio and quick liquidity ratio. Current ratio: Current ratio of an organization explains about the liquidity position of the company. It evaluates the short term debt payment capability of an organization. The current liquid position of the company explains about the lower rate. Current Ratio Current Assets /6,82,34,00 0 6,24,88,00 0 6,51,61,00 0 Current liabilities5,04,12,00 0 5,01,34,00 0 5,62,69,00 0 Answer:1.351.251.16 Quick ratio: Further, quick ratio of an organization explains about the liquidity position of the company. It evaluates the short term debt payment capability of an organization in terms of those assets which could be liquidated at any time into cash (Pearce, Robinson & Subramanian, 2000). The quick liquid position of the company explains about the lower rate in last 5 years. Quick ratio Current Assets - Inventory / 2,09,77,00 0 1,92,89,00 0 2,08,17,00 0 Current Liabilities5,04,12,00 0 5,01,34,00 0 5,62,69,00 0 Answer:0.420.380.37
Hotel Finance and revenue 9 Figure3: Liquidity ratio Capital structure ratios: Capital structure ratios evaluate the debt level, asset kevel and equity level of an organization. It measures the overall operations and the growth of the company by using the different sources through which the company has raised the funds. Capital structure position of an organization could be evaluated on the basis of debt, assets and equity level of the company (Lau, 2016). Capital structure ratios of the company are as follows: Debt to asset ratio: Debt to asset ratio explains about the level of debts of an organization in terms of assets of the company. It measures the level of both the sources to identify the risk and return position of the company. Debt to assets ratio of the British airways is 0.112 in current year which has been enhanced from 0.104 in 2015. Debt to assets ratio Total debt /98,14,00098,14,0001,03,79,0 00 total assets9,44,08,0008,99,97,0009,23,33,0 00 Answer:% 0.1040.1090.112 (Titman, Keown & Martin, 2017) Debt to equity ratio:
Hotel Finance and revenue 10 Debt to equity ratio explains about the level of debts of an organization in terms of equity of the company. It measures the level of both the sources to identify the risk and return position of the company. Debt to equity ratio of the British airways is 1.214 in current year which has been enhanced from 1.5419 in 2015. Debt to equity ratio Total debt /98,14,00098,14,0001,03,79,0 00 Total equity63,35,00081,70,00085,50,000 Answer:%1 .549 1 .201 1. 214 Figure4: Debt to equity ratio Investor’s ratios: Investors’ ratios evaluate the market position of the company and measure the performance of the company. It measures the overall operations and the growth of the company in the market. Investment position of an organization could be evaluated on the basis of earnings, stock price etc of the company (Renz & Herman, 2016). Investor’s ratios of the company are as follows: Earnings per share: Earnings per share explain about the total net income of an organization in terms with total outstanding shares of the company. It measures the financial performance of the
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Hotel Finance and revenue 11 company. The earnings per share of the company have been 13.605 in 2017. The growthrate explains about the better increment. Earnings per share Net income51,76,00048,95,00081,97,000 Weighted average shares outstanding 6,86,9006,35,5006,02,500 Answer: 7.5357.70313.605 Times interest earned ratio: Times interest earned ratio explains about the earrings before interest and tax of an organization in terms with total interest payable amount of the company. It measures the financial performance of the company. The times interest earned ratio of the company has been 23.54 in 2017. Times interest earned ratio EBIT /72,34,00055,97,0001,01,23,0 00 Interest payable3,39,0003,65,0004,30,000 Answer:2 1.339 1 5.334 23 .542 Figure5: Investor's ratios
Hotel Finance and revenue 12 Discussion: On the basis of the above calculation and evaluation, it has been found that various changes have occurred into the financial performance and position of the company in last 5 years. The profitability level of the company has been studied firstly and it has been found that the enough profits are generated by the company. The level of the profits has also been enhanced from last years in the current financial year of the company. Though, it has been found that the company should focus on the operating expenses of the company which is quite higher (Finkler et al, 2016). These changes would help the company to earn more. The return on equity and return on asset ratio of the comapny explains that the equity level of the company is quite lower and thus the return on equity of the company is quite higher than the return on assets of the company. Further, the efficiency ratios of the company have been evaluated which explains about the efficient operations and position of the company. On the basis of calculations, it has been found that the inventory turnover ratio of the company is quite higher which explains about more working capital involvement of the company. So, the company should make few changes into inventory policies so that the working capital involvement could be lower and capital requirement could also be lower (Bekaert & Hodrick, 2017). In addition, the accounts receivable turnover days of the company are quite competitive and it explains about competitive position of the company. In addition, the liquidity ratios of the company have been evaluated which explains about the liquid position of the company. On the basis of calculations, it has been found that the current liquidity ratio and quick ratios of the company has been lower form 2015 in 2017. These changes are quite competitive and explain about the better position of the company. Currently, the debt payment capability of the company is quite better in terms of industry. Capital structure ratios have been discussed further. The capitals structure ratio of the company has been evaluated which explains about the risk and return of the company. On the basis of calculations, it has been found that the debt to equity level of the company is quite higher which explains that the level of debt is more than equity level. These changes are quite risky for the company. Though, the debt to asset level of the company is quite better and explains about the competitive position (Vogel, 2014).
Hotel Finance and revenue 13 Lastly, the investor ratios have been discussed further. The investor ratio of the company has been evaluated which explains about market position of the company. On the basis of calculations, it has been found that the market position of the company is quite better which explains that the investment opportunity of the company is quite attractive. The company is offering good returns to its stockholders. Conclusion and recommendation: On the basis of the above findings and discussion, it has been found that the few changes rare required to be done in the organization for the better performance of the company. The company should maintain the performance and the position according to the industry. Company is required t make the changes into its quite level. The equity level should be improved by the company for the better position of the company. On the other hand, inventory management policies are also required to be change to manage the working capital of the company. To conclude, the current financial performance of the company is quite competitive, various positive changes have taken place into the performance of the company in last 5 years which has made the position of the company more attractive. The investors are recommended to make investment into the company for the great returns.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Hotel Finance and revenue 14 References: Barney, J. B., &Hesterly, W. S. (2006).Strategic management and competitive advantage. Upper Saddle River, NJ: Pearson Prentice Hall. Barr, M. J., & McClellan, G. S. (2018).Budgets and financial management in higher education. John Wiley & Sons. Bekaert, G., & Hodrick, R. (2017).International financial management. Cambridge University Press. Bekaert, G., & Hodrick, R. (2017).International financial management. Cambridge University Press. Dewachter, H., Iania, L., Lyrio, M., & de Sola Perea, M. (2015). A macro-financial analysis of the euro area sovereign bond market.Journal of Banking & Finance,50, 308-325. Finkler, S. A., Smith, D. L., Calabrese, T. D., & Purtell, R. M. (2016).Financial management for public, health, and not-for-profit organizations. CQ Press. Home. (2018). British Airways limited. (online). Reterived as on 27thApril 2018 from https://www.britishairways.com/travel/home/public/en_us Inventors. (2018). Boeing co. (online). Reterived as on 27thApril 2018 from http://investors.boeing.com/investors/financial-reports/default.aspx. Lau, C. (2016). Financial Management. Pearson. Morningstar. (2018). Boeing co. (online). Reterived as on 27thApril 2018 from http://financials.morningstar.com/ratios/r.html?t=BA Pearce, J. A., Robinson, R. B., & Subramanian, R. (2000).Strategic management: Formulation, implementation, and control. Columbus, OH: Irwin/McGraw-Hill. Renz, D. O., & Herman, R. D. 2016).The Jossey-Bass handbook of nonprofit leadership and management. John Wiley & Sons.
Hotel Finance and revenue 15 Titman, S., Keown, A. J., & Martin, J. D. (2017).Financial management: Principles and applications. Pearson. Vogel, H. L. (2014).Entertainment industry economics: A guide for financial analysis. Cambridge University Press. Wang. Y, & Chung, Y. (2015). Hotel brand portfolio strategy.International Journal of Contemporary Hospitality Management. 27(4). 561 – 584. Yahoo finance. (2018). Boeing co. (online). Reterived as on 27thApril 2018 from https://finance.yahoo.com/quote/BA/
Hotel Finance and revenue 16 Appendix: Ratio Calculations201520162017 Profitability Ratios:201520162017 Return on assets Net profit /51,76,00048,95,000 81,97,0 00 Total assets 9,44 ,08,000 8,99 ,97,000 9,23, 33,000 Answer:%5.48%5.44%8.88% Return on equity Net profit /51,76,00048,95,000 81,97,0 00 Total stockholder's equity63,35,00081,70,000 85,50,0 00 Answer:%82%60%96% Profit margin Net profit /51,76,00048,95,000 81,97,0 00 Sales Revenue% 9,61,14,00 0 9,45,71,00 0 9,33,92, 000 Answer:5.39%5.18%8.78% Efficiency Ratios201520162017 Inventory Turnover Average Inventory /4725700043199000 443440 00 Cost of Sales8202400080731000 759960 00 Answer:0.580.540.58 Inventory Turnover (days) Average Inventory / 4,72,57,00 0 4,31,99,00 0 4,43,44, 000 Cost of Sales # da ys 8,20,24,00 0 8,07,31,00 0 7,59,96, 000 Answer:(note the above needs to be x 365)210.29195.31212.98 Accounts receivable tunrover Average trade debtors /80030007804000 976300 0 Sales revenue 9,61,14,00 0 9,45,71,00 0 9,33,92, 000
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Hotel Finance and revenue 17 Answer:0.0830.0830.105 Receivables Turnover (days) Average trade debtors / 80, 03,000 78, 04,000 97,6 3,000 Sales revenue(note used operating revenue) # da ys 9,61 ,14,000 9,45 ,71,000 9,33, 92,000 Answer:(note the above needs to be x 365)30.3930.1238.16 Liquidity Ratios201520162017 Current Ratio Current Assets / 6,82,34,00 0 6,24,88,00 0 6,51,61, 000 Current liabilities 5,04,12,00 0 5,01,34,00 0 5,62,69, 000 Answer:1.351.251.16 Quick ratio Current Assets - Inventory / 2,09,77,00 0 1,92,89,00 0 2,08,17, 000 Current Liabilities 5,04,12,00 0 5,01,34,00 0 5,62,69, 000 Answer:0.420.380.37 Capital Structure Ratios201520162017 Debt to assets ratio Total debt /98,14,00098,14,000 1,03,79, 000 total assets 9,44,08,00 0 8,99,97,00 0 9,23,33, 000 Answer:%0.1040.1090.112 Debt to equity ratio Total debt /98,14,00098,14,000 1,03,79, 000 Total equity63,35,00081,70,000 85,50,0 00 Answer:%1.5491.2011.214 Investor's Ratios201520162017 Earnings per share Net income51,76,00048,95,000 81,97,0 00 Weighted average shares outstanding6,86,9006,35,500 6,02,50 0
Hotel Finance and revenue 18 Answer:7.5357.70313.605 Times interest earned ratio EBIT /72,34,00055,97,000 1,01,23, 000 Interest payable3,39,0003,65,000 4,30,00 0 Answer:21.33915.334 2 3.542 Financial Analysis - Company $000's 201520162017 Balance Sheet ASSETS Current Assets Cash and cash equivalents $ 1,13,02,000 $ 88,01,000 $ 88,13,000 Restricted cash $ 7,50,000 $ 12,28,000 $ 11,79,000 Accounts receivable $ 80,03,000 $ 78,04,000 $ 97,63,000 Inventories $ 4,72,57,000 $ 4,31,99,000 $ 4,43,44,000 Securitized vacation ownership notes receivable $ - $ - $ - Prepaid expenses and other $ 9,22,000 $ 14,56,000 $ 10,62,000 Deferred income taxes $ - $ - $ - Total Current Assets$6,82,34,000. 0 $6,24,88,000. 0 $6,51,61,000. 0 Non Current Assets Investments128400013170001260000 Property and equipment, net120760001280700012672000 Assets held for sale, net476600051890004767000 Goodwill and intangible assets, net778300078640008132000 Deferred income taxes265000332000341000 Other assets Securitized vacation ownership notes receivable, net Total Non-Current Assets$2,61,74,000. 0 $2,75,09,000. 0 $2,71,72,000. 0
Hotel Finance and revenue 19 Total Assets$9,44,08,000. 0 $8,99,97,000. 0 $9,23,33,000. 0 LIABILITIES Current Liabilities Short-term borrowings and current maturities 1234000384000735000 Accounts payable108000001119000012202000 Current maturities of long-term securitized vacation 26200089000380000 Accrued expenses592200066020006037000 Accrued salaries, wages and benefits243640002386900027440000 Accrued taxes and other783000080000009475000 Total Current Liabilities$5,04,12,000. 0 $5,01,34,000. 0 $5,62,69,000. 0 Non-Current Liabilities Long-term debt863300094870009696000 Long-term securitized vacation ownership debt 244960002594000022102000 Deferred income taxes239200013380001839000 Other liabilities207800022210002015000 Total Non-Current Liabilities$3,75,99,000. 0 $3,89,86,000. 0 $3,56,52,000. 0 Total Liabilities$8,80,11,000. 0 $8,91,20,000. 0 $9,19,21,000. 0 OWNERS EQUITY Common stock; $0.01 par value506100050610005061000 Additional paid-in capital483400047620006804000 Accumulated other comprehensive loss-42316000-49720000-56830000 Retained earnings387560004071400045320000 Total Shareholder's equity$63,35,000.0$8,17,000.0$85,50,000.0 Non-controlling interest Total Owners Equity$63,35,000.0$8,17,000.0$85,50,000.0 Total OE & Liabilities$9,43,46,000. 0 $8,99,37,000. 0 $9,22,76,000. 0 201520162017 Profit & Loss Statement Revenue961140009457100093392000 Cost of Sales820240008073100075996000 Gross Profit$1,40,90,000. 0 $1,38,40,000. 0 $1,73,96,000. 0 Operating Expenses
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Hotel Finance and revenue 20 Owned, leased and consolidated joint venture hotels333100046270003179000 Vacation ownership and residential Selling, general, administrative and other352500036160004094000 Restructuring and other special charges (credits), net Depreciation Amortization Other expenses from managed and franchised properties Total operating expenses$68,56,000.0$82,43,000.0$72,73,000.0 Operating Profit$72,34,000.0$55,97,000.0 $1,01,23,000. 0 Equity earnings Loss on early extinguishment of debt Gain (loss) on asset dispositions517600048950008197000 Loss from discontinued operations Gain (loss) on dispositions of discontinued operations Net loss attributable to noncontrolling interests EBIT$20,58,000.0$7,02,000.0$19,26,000.0 Interest expense339000365000430000 Income tax benefit (expense)260000336000354000 Net Profits (Loss)$51,72,000.0$48,92,000.0$81,91,000.0 Operating Data (minimum - please use seperate sheets for detailed Regional/Hotel Data)201520162017 # Rooms100012001200 % Occupancy80.0%85.0%85.0% # Hotels588 # Staff140001540016940 Revpar $961140009457100093392000 Av Room rate $$65.83$50.80$50.17 201520162017 RATIO ANALYSIS Liquidity Current Ratio %135%125%116%
Hotel Finance and revenue 21 Quick Ratio1.3352376421.2173774281.139152997 Accounts Receivable Turnover (times)0.040.04 Solvency Debt to Equity Ratio %155%120%121% Interest Cover (times)0.050.070.04 Total Liabilities/Total Assets93.2%99.0%99.6% Profitability Net Margin %5.38%5.17%8.77% ROA %5.5%5.4%8.9% ROE %82%599%96% $ Movement% Movement 2015-162016-172015-17 2015- 16 2016- 17 2015- 17 -$25,01,000.0$12,000.0-$24,89,000.0-22%0%-22% $4,78,000.0-$49,000.0$4,29,000.064%-4%57% -$1,99,000.0$19,59,000.0$17,60,000.0-2%25%22% -$40,58,000.0$11,45,000.0-$29,13,000.0-9%3%-6% $0.0$0.0$0.0 $5,34,000.0-$3,94,000.0$1,40,000.058%-27%15% $0.0$0.0$0.0 -$57,46,000.0$26,73,000.0-$30,73,000.0-8%4%-5% $33,000.0-$57,000.0-$24,000.03%-4%-2% $7,31,000.0-$1,35,000.0$5,96,000.06%-1%5% $4,23,000.0-$4,22,000.0$1,000.09%-8%0% $81,000.0$2,68,000.0$3,49,000.01%3%4% $67,000.0$9,000.0$76,000.025%3%29% $0.0$0.0$0.0 $0.0$0.0$0.0 $13,35,000.0-$3,37,000.0$9,98,000.05%-1%4% -$44,11,000.0$23,36,000.0-$20,75,000.0-5%3%-2%