\$20 Bonus + 25% OFF

# AFA1105 Accounting For Management 3

0 Download5 Pages 1,011 Words Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
• Course Code: AFA1105
• Country: Australia

## Question:

Write a report of Lantern Hotel Groups

### Required:

• The following items are to be calculated: -
• salesrevenue
• net profit aftertax

Use the following table to insert absolute figures and the trend analysis

 Absolute Figures \$m 2017 2016 2015 2014 Total Sales revenue Net profit after tax Trend Analysis in % Total Sales revenue Net profit after tax

Graph the trends of the Lantern Hotel Group:-

• Total Salesrevenue
• Net profit after tax for 2014-2017

### 1. Vertical analysis

Vertical analysis is another method of converting the absolute dollar values in financial reports to more meaningful figures. Whereas horizontal analysis compares reported figures over time, vertical analysis involves comparing the items in a financial report to other items in the same financial report.

The vertical analysis involves comparing the items in a financial report to an anchor item in the same financial year. The anchor item in the Balance Sheet is the total asset figure. All assets, liability and equity items are expressed as a percentage of total assets and all revenue and expense items are expressed as a percentage of revenue

Using a Vertical Analysis

• Using the 30thJune 2017 income statement calculate a vertical analysis for the items listed

e.g. sales revenue, cost of sales, gross profit, other expenses, profit before income tax. Use sales at the anchor point – 100%.

• Using the 30thJune 2017 balance sheet, calculate a vertical analysis for the items listed as assets and
1. Ratio analysis

From the Company’s 2017 and 2016 financial statements and notes to financial statements, calculate the following ratios based on what you were taught.

Explain what the ratios mean in general and comment specifically on what they tell about the Company’s performance.

Examine and explain how the ratios are trending and comment/explain if the trend is favourable or not.

 2017 2016 Return on Equity (ROE) Net Profit After Tax / Average Equity (%) Return on Assets (ROA) Net Profit After Tax / Average Assets (%) Net Profit Margin Net Profit After Tax / Total Revenue (%)

Calculate Current Ratio and Quick Asset Ratio for the years 2017 and 2016. Show it in a table as in the previous sections and comment on the Company’s liquidity position.

### Company Overview

Lantern Hotel Group held a portfolio of hotels and pubs located in Australia and New Zealand. During the recent times, there have been issues on profitability and liquidity front for the company’s assets. As a result, the company has been rejigging the asset portfolio whereby it is selling non-profitable assets. Owing to cash crunch, it exited the New Zealand market in 2013. The sale proceeds were used for Australian properties renovation. Further, in 2014/2015, the company made a strategic decision to retain only certain pubs while liquidating all the other non-core portfolio assets and instead grow by acquiring new assets (Cummins, 2016). The strategy since then has been modified and company has executed the selloff strategy during FY2017 thus having assets only in the form of cash on the books of the company. These can be used to make acquisitions of assets which the company believes would be profitable (Young, 2017).

### Analysis

1. Trend  Analysis

Two items have been chosen from the profit and loss statement and a horizontal trend analysis has been conducted for the same during 2014-2017. It is  imperative to note that since in certain years, a significant contribution of profits and revenues was derived from discontinued operations, therefore the horizontal analysis has been conducted using the respective values from continuous operations only.

The trend above clearly highlights the company’s operational revenues have decreased which may be attributed to asset sale strategy being pursued by the company. The net result is that a large share of the revenue in the recent years (especially FY2017) is being derived on account of discontinued operations. The continuous loss generation by the company is clearly a cause of concern.

1. Vertical Analysis

For the year 2016/2017, the income statement vertical analysis is shown below.

In FY2017 is also on account of sell down strategy by the company since when the portfolio asset have been sold, the operating expenses would automatically decline. The tax paid for 2016 was zero on account of previous accumulated losses which got adjusted in FY2017 and hence some taxation burden was borne by the company. The huge jump in profit after tax in FY2017 is the result of increasing gross margins and lower expenses which is facilitated by a large chunk of revenue being generated by profits on the discontinued operations. Hence, the income statements of the two years are not comparable.

The balance sheet vertical analysis is indicated as follows.

A critical observation on the basis of vertical analysis is that for FY2017 closing, the company assets are in cash and equivalent form with no non-current assets. As a result, the company as on June 30, 2017 does not have any non-current liabilities and all the liabilities are current in nature. There is a major shift in the distribution of liabilities and equities with the share of liabilities jumping in FY2017 in comparison to the corresponding share in FY2016. The composition of assets for the company has also seen dramatic alteration since as on June 30, 2016, more than 75% of the assets of the company were in form of non-current assets which is not surprising considering the business model of the company. However, the representation of non-current assets has been trimmed to zero as on June 30, 2017 as the company has executed the sell-off strategy which involved liquidation of all the portfolio assets. The outstanding long term debt for the company has also been cleared as on June 30, 2017 when no such debt exists on the books. Thus, it can be concluded that the drastic shift in the company’s financial position owing to the sell-off strategy is apparent from the vertical analysis of balance sheet.

1. Ratio Analysis

The data obtained from the financial statement of the company and used for ratio computation is shown as follows.

Over the previous two years, the relevant profitability ratios are indicated as follows.

The above comparison highlights a sizable improvement with regards to the company’s profitability in FY2017 as compared to FY2016. All the three measures of profitability have a significantly higher value in FY2017 in comparison to FY2016 values. The main driver of the spectacular profitability ratios in FY2017 is the jump in profits to \$ 40.86 million for FY2017 when compared to FY2016 figure of \$ 7 million. This huge increase in profit is not the result of continuous operations but rather the impact of asset sale where profits have been realised by the company. The continuing operational revenue has seen decline during the given period. The increased profitability in FY2017 to an extent is also aided owing to absence of any depreciation charge for the year since there are no fixed assets with the company as on June 30, 2017  (Damodaran, 2015).

The relevant ratio analysis of the company in relation to liquidity is highlighted as follows.

The liquidity ratios for the company have shown some decrease in FY2017 as compared to FY2016. Even though, there has been decline in the liquidity ratios but the company faces no issues of liquidation or short term cash crunch as on June 30, 2017 especially considering that all assets are in the form of cash (Parrino and Kidwell, 2014).  Further, the company has disposed all non-current assets and only retains asset in the form of cash at the end of FY2017. The liquidity ratios in FY2017 have seen a decline as current assets fall is higher than the corresponding fall in current liabilities. Further, there is no difference between the current ratio and quick ratio for FY2017 as the company does not have any inventory or any other current asset which is not liquid.

## References

Damodaran, A. (2015). Applied corporate finance: A user’s manual 3rd ed. New York: Wiley, John & Sons.

Parrino, R. & Kidwell, D. (2014) Fundamentals of Corporate Finance, 3rd ed. London: Wiley Publications

Young, A. (2017) Lantern Hotels Group sells its last remaining pub, Retrieved from https://www.theshout.com.au/news/pub-news/lantern-hotels-group-sells-its-last-remaining-pub/

### Cite This Work

"Accounting For Management 3." My Assignment Help, 2019, https://myassignmenthelp.com/free-samples/afa1105-accounting-for-management-3.

My Assignment Help (2019) Accounting For Management 3 [Online]. Available from: https://myassignmenthelp.com/free-samples/afa1105-accounting-for-management-3
[Accessed 28 January 2020].

My Assignment Help. 'Accounting For Management 3' (My Assignment Help, 2019) <https://myassignmenthelp.com/free-samples/afa1105-accounting-for-management-3> accessed 28 January 2020.

My Assignment Help. Accounting For Management 3 [Internet]. My Assignment Help. 2019 [cited 28 January 2020]. Available from: https://myassignmenthelp.com/free-samples/afa1105-accounting-for-management-3.

### Latest Accounting Samples

#### BUACC5934: Financial Accounting Assignment

• Course Code: BUACC5934
• University: Federation University Australia
• Country: Australia

Answer: Introduction A careful study and a logical analysis of the sustainability report of BHP clearly makes one conclude that the report has been prepared as per the guidelines laid down by the Global Reporting Initiative Standards comprehensive-level reporting (Belton, 2017).  The reporting approach followed by BHP is a comprehensive one, i.e. the assets, functions, achievements, marketing and supply; all have been reported for t...

#### ACC 200: Fundamentals Of Financial Accounting

• Course Code: ACC 200
• University: Southern New Hampshire University
• Country: United States

Answers: Question 1 Costing is the function of assigning cost to different products produced or sold by the company on a reasonable basis so as to find out the total cost incurred to produce or to sell that product. In every profit-oriented business organisation, profitability of business majorly depends on individual profitability of each product dealt by it. Product costing serves as the foundation on which various critical decisions relate...

#### BSB110 Assessment Marking Criteria Sheet Semester 2

• Course Code: BSB110
• University: Queensland University Of Technology
• Country: Australia

Answer: The three possible motivations for the organisations to make voluntary social and environmental disclosures include the following: Competitive advantage: The organisations expect that maintaining positive relationships with their stakeholders would help them in gaining competitive advantage and thus, better economic outcomes could be accomplished. Moreover, such relationships would result in the formation of valuable capabilities a...

#### HI5020 Corporate Accounting Report

Answer: Introduction The role of accounting has enhanced with the changes in the financial structure and competitiveness in business environment. Most of the business follow a reporting framework which is approved by one or more accounting bodies such as IASB or ASSB. An ideal reporting framework consist of all relevant information with appropriate disclosures for the same (Gitman, Juchau and Flanagan 2015). The assessment proceeds with signi...

#### ACCM4200-Financial Accounting And Reporting

Answer 1.Difference between Depreciation, Impairment and Revaluation Deprecation is charge to the profit and loss towards the usage of an asset. When an asset is used, its value is declined. Depreciation is the charge on the asst in order to account for its usage, obsolesce and degradation in value due to efflux of time.   An asset is said to be impaired when the recoverable amount of the asset in an open market falls below its carrying ...

Next

### Save Time & improve Grades

Just share your requirements and get customized solutions on time.

Orders

Overall Rating

Experts

### Our Amazing Features

#### On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

#### Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

#### 24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

#### Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

#### Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

### Our Experts

5/5

1592 Order Completed

96% Response Time

### Jane Sima

#### Singapore, Singapore

5/5

755 Order Completed

95% Response Time

### Douglas Cowley

#### Wellington, New Zealand

5/5

440 Order Completed

99% Response Time

### Jack Arens

#### London, United Kingdom

5/5

647 Order Completed

98% Response Time

### FREE Tools

#### Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

#### Essay Typer

Get different kinds of essays typed in minutes with clicks.

#### Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

#### Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

## Refer Just 5 Friends to Earn More than \$2000

1

1

1

### Live Review

Our Mission Client Satisfaction

Expert provided good service and able to upload the answers within the specified time limit.

#### User Id: 246827 - 28 Jan 2020

Australia

Previous feedback was for other order and the website itself, not the writer. This writer did a great job! Very appreciated

#### User Id: 363978 - 28 Jan 2020

Australia

this assignment was perfect. i got A i encourage every one to use this website for help

Australia