Amy Ltd supplies, installs and maintains burglar alarms systems for business clients. The accountant has provided...

Amy Ltd supplies, installs and maintains burglar alarms systems for business clients. The accountant has provided a horizontal analysis and is concerned about the firm's performance.”

Amy Ltd: comparison to previous year
	2017	2018	2019
Accounts receivable	1.20%	8.2%	7.4%
Inventory	8.4%	1.7%	4.9%
Sales	-3.0%	1.2%	5.4%
Non-current assets	2.3%	4.8%	7.6%
Borrowings	3%	9.8%	19.8%

Required: provide a brief report on the results of the analysis? Comments should include any concerns you may have

Solutions

Expert Solution

Answer : A brief report on the results of the analysis of various ratios including any concerns is described below.

1. Accounts receivable

Explanation : With the interpretation of data of years i.e. 2017, 2018 and 2019 we can conclude that the percentage of account receivable is increasing over the years which -

does not effect company's net income.
increasing percentage of account receivable shows that more people are paid on credit which results in drain on cash on company.
Having high percentage of account receivable is not good for any company.

2. Inventory

Explanation : With the interpretation of data of years i.e. 2017, 2018 and 2019 we can conclude that the percentage of invntory holding decreased in 2018 but shows a slightly increase in 2019 which shows,

For 2018- company has sold more goods than it purchased which is good for company.
For 2019- company has sold less goods than it purchased which is not a good sign for company.

3. Sales

Explanation : With the interpretation of data of years i.e. 2017, 2018 and 2019 we can conclude that the percentage of sales in continuously increasing in all years which indicates that company is generating and increasing a handsome amount of revenue

It represent that company is facing it's growth phase.

4. Non-current assets

Explanation : With the interpretation of data of years i.e. 2017, 2018 and 2019 we can conclude that the percentage of non current asstes is incresing every year which indicates that company is loosing it's liquidity and it requires more cash to support its day to day activities.

5. Borrowings

Explanation : With the interpretation of data of years i.e. 2017, 2018 and 2019 we can conclude that the percentage of borrowing is increasing .

Increasing debt causes leverage ratios to rises which forces to company for heavy amount of interest payment.

ekkarill92 answered 2 years ago

Next > < Previous

Related Solutions

Safe Inc. is a service firm that sells home security systems, which it installs and maintains....

Safe Inc. is a service firm that sells home security systems, which it installs and maintains. After the sales force makes initial contact with a new customer and completes the sale, setting up the new service requires two processes: (1) a home visit where the equipment is physically installed and (2) the remote connection from off-site at corporate headquarters. Given the different levels of skill and work required, Safe Inc. tracks costs separately for the Installation and Connection processes. Nevertheless,...

You are a public accountant with many small business clients. During a recent visit to a...

You are a public accountant with many small business clients. During a recent visit to a client’s business, the bookkeeper approached you with a problem. The columns of the trial balance were not equal. You helped the bookkeeper find and correct the error, but believe you should go one step further. Requirement: Write a memo to all of your clients that explains (a) the purpose of the double-entry framework, (b) the importance of maintaining the equality of the accounting equation,...

Business Systems agreed to provide supplies to IBM as a subcontractor to a deal to update...

Business Systems agreed to provide supplies to IBM as a subcontractor to a deal to update computer systems of the Chicago Transit Authority. The budget for this deal was set at $3.6 million; however, only $2.2 million of services were actually performed under the contract. Business Systems sued IBM, believing that it was entitled to an additional $1.4 million that it had not received in the performance of the project. As evidence of contract, Business Systems produced a spreadsheet detailing...

Metro Telcom Systems develops, sells, and installs computer systems. The company has divided its customer base...

Metro Telcom Systems develops, sells, and installs computer systems. The company has divided its customer base into five regions, and it has 15 representatives who sell and install the company’s systems. The company wants to allocate salespeople to regions so that they maximize daily sales revenue. However, whereas the sales increase as the number of increases, they do so at a declining rate, according to the following nonlinear formula: total sales = a - (b/x) Following are the a and...

Mensa Ltd has acquired all the shares of Careers Ltd. The accountant for Mensa Ltd, having...

Mensa Ltd has acquired all the shares of Careers Ltd. The accountant for Mensa Ltd, having studied the requirements of AASB 3/IFRS 3 Business Combinations, realises that all the identifiable assets and liabilities of Careers Ltd must be recognised in the consolidated financial statements at fair value. Although she understands the need to revalue items recorded by the subsidiary at carrying amounts different from fair value and to recognise previously unrecorded assets or liabilities at fair value, she is unsure...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. You are also given the following information that summarizes the business activity for the current year,2020 As arecently hired accountantfor a smallbusiness,SMC,Inc., you are providedwithlast year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. SMC, Inc. Balance Sheet December 31, 2019 Assets Cash...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. SMC, Inc. Balance sheet December 31, 2019 Assets $34,500 Cash $25,000 Accounts receivable $10,000 Supplies $200 Total assets $69,700 Liabilities and stockholders equity Liabilities: Accounts payable $12,000 Salaries payable $1,000 Income taxes payable $3,675 Total liabilities $16,675 Stockholders equity: Capital stock (10,000 shares outstanding) $25,000 Retained earnings $28,025...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. SMC, Inc. Balance sheet December 31, 2019 Assets $34,500 Cash $25,000 Accounts receivable $10,000 Supplies $200 Total assets $69,700 Liabilities and stockholders equity Liabilities: Accounts payable $12,000 Salaries payable $1,000 Income taxes payable $3,675 Total liabilities $16,675 Stockholders equity: Capital stock (10,000 shares outstanding) $25,000 Retained earnings $28,025 Total...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. SMC, Inc. Balance sheet December 31, 2019 Assets $34,500 Cash $25,000 Accounts receivable $10,000 Supplies $200 Total assets $69,700 Liabilities and stockholders equity Liabilities: Accounts payable $12,000 Salaries payable $1,000 Income taxes payable $3,675 Total liabilities $16,675 Stockholders equity: Capital stock (10,000 shares outstanding) $25,000 Retained earnings $28,025 Total...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last...

As a recently hired accountant for a small business, SMC, Inc., you are provided with last year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. SMC, Inc. Balance Sheet December 31, 2017 Assets Cash ......................................................................................................... $34,500 Accounts receivable ................................................................................ 25,000 Inventory .................................................................................................. 10,000 Supplies ................................................................................................... 200 Total assets.............................................................................................. $69,700 Liabilities and Stockholders’ Equity Liabilities: Accounts payable ............................................................................. $12,000 Salaries payable ............................................................................... 1,000 Income taxes payable ...................................................................... 3,675 Total liabilities.......................................................................................... $16,675 Stockholders’ equity: Capital stock...

Subjects