Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

For ass 1- Analysis percentage of Balance sheet- Analysis percentage of Cash flow statement- Analysis percentage of Statement of Income- Analysis debtor and creditor value by account receivable and...

1 answer below »
For ass 1- Analysis percentage of Balance sheet- Analysis percentage of Cash flow statement- Analysis percentage of Statement of Income- Analysis debtor and creditor value by account receivable and payable ratio- Analysis director’s report in the annual report- Calculate ratio as part B
Ass 2- Set target for company and also KPI
Ass 3- Introduce new line of product- Launch marketing promotion- Renovation the store- Identify factor impact company- Assess their impact- Strategies to minimize impact- Strategies for internal communication- Calculate NPV
Ass 4- Summarize ass 1-3
Answered Same Day Jun 12, 2021 FNS50215


Harshit answered on Jun 22 2021
131 Votes
    Sl. No.
    Page No.
Assessment Task 1
3 - 11
Assessment Task 2
12 - 14
Assessment Task 3
Assessment Task 4
The financial data of the company Nick Scali Limited is provided from 2012-2014. The company has two
ands Nick Scali and Sofa2Go. The company is also listed in the Australian stock exchange. Based on the annual reports a small trend analysis and assessment of the company's performance is ca
ied out in following the areas as discussed below:
Trend Analysis: Trend analysis is a technique that is used to collect information related to the past and analyze a trend or pattern in performance to predict the future performance of the company and its likely impact. It helps in determining the future share prices of the company (Zeff, S.A.). It refers to the comparison of data of one period with the other so that a pattern can be determined to identify future activities. For Nick Scali Limited trend analysis is conducted in the following areas:
· Evaluation of assets and liabilities from the balance sheet: The table below shows the trend in assets and liabilities from the information obtained in the annual report. The base is taken as 2012 and calculation of increase or decrease is All figures in the table are expressed in '000 $.
    Total assets
    % increase/(decrease)
    Total Liabilities
    % increase/(decrease)
The company assets and liabilities have increased by 12% from 2013 to 2014 taking 2012 base year. This indicates that the company is unwilling to pay its debtor is unable to pay its debt, which indicates that there will be default in the future. The company would not be able to clear off its debts. The liabilities of the company are increased indicating that they are not paid off on time.
· Cash Flow Analysis: Next, we will identify the trend in the cash flows under the three different heads i.e. operating, investing, and financial. The cash flow statements show the cash spend and received by the company and analyzing trend on this is done to check whether the cash flows has increased or decreased. Here also the base year is taken as 2012. The figures are in ‘000 $.
    Cash flows from operating activities
    % increase/decrease
    Cash flows from investing activities
    % increase/decrease
    Cash flows from financing activities
    % increase/decrease
The cash flow from operating activities has a positive result. Also, the % change in cash flows for 2014 is more than 2013 when compared to 2012. This indicates that core activities or activities which are operative in nature are doing good. The inflow of cash is increasing when compared to outflow. The cash flow from investing activities give a negative trend. The results are negative and in 2013 it is highest. This indicates that many assets have been purchased in 2013 as compared to any other year. There is also a negative result for cash flow from financing activities. This indicates that the company has repaid its debt more that there has been inflow which will lead to a decrease in the assets of the company.
· Sales and Cost Analysis:
Sales and cost analysis are done to determine whether there is growth in the company or whether the company can control and manage its cost. The trend analysis is conducted to see the increase or decrease keeping the year 2012 as the base year. All figures are expressed in ‘000 $.
    % Increase/(decrease)
    Cost of goods sold
    % Increase/(decrease)
     Other Indirect expenses
    % Increase/(decrease)
The sales
evenue has increased for both the years as compared to the base year. This indicates that there is a growth prospect for the company. But the % change in the cost of goods sold is more than the change in sales. This implies that the overall change in the gross profits will decrease. The cost of goods sold is also increasing as the revenue is increasing. Hence, costs should be taken care of, so that the gross profit ratio is maintained. Also, we see that the indirect expenses are increasing as compared to base year on an average of 10%. To improve this adequate cost-cutting measures should be taken.
· Analysis of creditors and debtors:
An analysis of the trend in debtors and creditors will help in determining whether the company is making credit sales or purchases, whether the company can collect the revenues in time or pay its creditors on time. The trend analysis is shown below:
    Total Debtors
    % Increase/(decrease)
    Total Creditors
    % Increase/(decrease)
The trend analysis taking 2012 as a base shows that the debtors are decreasing each year implying that there is no capital block. All sales are done on a cash basis and steps are taken to avoid credit sales. The total creditors are increasing from the base year meaning thereby that the purchases are made on a credit basis. This means the financial position of the company is not good. Steps have to be taken to improve the same.
· Analysis of the Director's Report: The analysis of the director's report shows that sales revenue has increased in 2014 because there has been the establishment of new stores and also sales growth in those stores. The company opened two new stores at the yearend 30th June 2014. Both the stores were performing within expectations. The gross profit remained the same. There has been increasing in operating costs due to new stores opening. The motive of the company is to expand its business, earn more revenue, and reduce costs.
Thus, the various conclusions drawn by ca
ying out the trend analysis will help determine and set achievable, realistic, etc. targets and develop Key Performance Indicators under various heads.
Ratio analysis is an important tool to identify the financial health and the cu
ent performance of the organization. It helps in making various decisions related to the organization. There are various categories of ratio which are shown below:
Now, based on the financial statements from the year 2012-2014 of Nick Scali Furniture as provided, we will analyze some of these ratios and draw some interpretations from that:
1. Debt to equity ratio: This is a financial ratio that is used to calculate the debt and shareholders equity that are used to finance a company's assets. It indicates how much a company bo
ows and how much it uses its fund. An ideal debt to equity ratio of 1 or 1.5 is considered. For the company, it is as given in the table:
Debt-to-equity Ratio = Total Liabilities
Total Shareholder’s Equity
    Total liabilities in ‘000 $ (A)
    Total Shareholder’s Equity in ‘000 $ (B)
The company's debt-equity ratio is good. There is less risk involved as the company raises almost equal funds through both i.e. debts and its capital.
2. Cu
ent Ratio
This ratio is used by the creditors to access the financial position of the company to repay its debts or the ability to pay short-term debts. An ideal ratio of 2:1 is considered ideal. The formula for the cu
ent ratio is:
ent Ratio = Cu
ent Assets
ent Liabilities
For the company, the cu
ent ratio is given below:
ent assets in’000$ (A)
ent liabilities in’000$ (B)
ent Ratio (A/B)
The company’s cu
ent ratio is not satisfactory. This implies that the financial position is not enough to pay off the liabilities and short-term bo
owings. The ratios are 1.74, 1.70, and 1.77. The liquid position of the company is not good to pay liabilities i.e. the cu
ent assets are not enough to pay cu
ent liabilities.
3. Return on Equity
It is the ratio used to examine the profitability of the company (Meng, J. and Berger, B.K.). It shows how much profit the company can earn from the money invested. Investors can know the return on their investments. Generally. ROE on 15-20% is considered good:
Return on Equity = Net income * 100
Shareholder’s Equity
    Net income in ‘000 $ (
    Shareholder’s Equity in ‘000 $
    ROE (A/B*100)
The company has a good return on investments. This means the company is earning good and investors are getting a sufficient amount on their investments. Higher ROE indicates the higher profitability of the company.
4. Liquidity Ratio:
These ratios are used to determine the liquid position of the company. The two major liquidity ratios are the Cu
ent Ratio and Quick Ratio. Cu
ent ratio formula and analysis is already done above. Now, we will analyze the liquid ratio:
Quick Ratio = Cu
ent Assets – Inventories
ent Liabilities
ent assets in’000$ (A)
    Inventories in ‘000$ (B)
    Quick Assets (A-B)
ent liabilities in’000$ (C )
    Quick Ratio (A-B)/C
The company’s liquid ratio is not good. This indicated that the company does not have enough cu
ent assets to pay off its cu
ent liabilities. The company needs to improve this ratio so that it becomes 2:1 i.e. cu
ent assets are two times the cu
ent liabilities.
5. Debt Ratio: It is the financial ratio that indicates what amount of a company's assets are bought using debts. A debt ratio of 0.4 and lower is...

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here