Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Question:

Read the Presentation section of the assessment in the subject outline carefully

? Use professional/business language

? Include a title page

? Start each question on a new page (use headers/subheaders)

? Please be careful with font size and line spacing

? Ensure your student name and number appear on all pages of your assignment.

If tables are used they must be formatted correctly and they do not cross pages (Horizontally)

Financial figures, numbers, are right aligned (never centred).

? You need to use aspects of all three sets of ratio analysis here.

? Do not forget to use the background information here as well.

? Identify four accounts or account areas only

? 2 assertions for each account (total of 8 assertions)

? Do not provide all the assertions – we are looking for the assertions relevant to the risk identified.

? Assertion must match the account type (transaction assertions for income statement related accounts and balance assertions for balance sheet accounts)

Answer:
Question 1
Part 1

Variance analysis of the financial statements

This analysis provides a comparison between financial statements of two years by making calculations of change in financial figures from one year to another (Marshall, McManus, & Viele, 2004). It also calculates the percentage change in the financial figures from one year to another.

Variance analysis for income statement

 

2017

2016

Variance $

Variance %

 

 

 

Increase or (decrease)

Sales

 $  3,080

 $  2,660

 $     420

15.789%

Cost of Goods Sold

 $(2,350)

 $(2,010)

 $    (340)

-16.915%

Gross Profit

 $     730

 $     650

 $       80

12.308%

Other Expenses

 $   (350)

 $   (390)

 $       40

10.256%

Interest

 $   (300)

 $   (120)

 $    (180)

-150.000%

Net Profit

 $       80

 $     140

 $      (60)

42.857%

Variance analysis for financial position

 

2017

2016

Variance $

Variance %

 

 

 

Increase or (decrease)

Assets

 

 

 

 

Current assets

 

 

 

 

Trade and other receivables

 $     772

 $     660

 $     112

16.970%

Inventory

 $     680

 $     510

 $     170

33.333%

Total current assets

 $  1,452

 $  1,170

 $     282

24.103%

Non-current assets

 

 

 

 

Property, plant and equipment

 $  1,810

 $  1,500

 $     310

20.667%

Intangible assets

 $       40

 $       -   

 $       40

∞ %

Total non-current assets

 $  1,850

 $  1,500

 $     350

23.333%

Total assets

 $  3,302

 $  2,670

 $     632

23.670%

Liabilities and equity

 

 

 

 

Liabilities

 

 

 

 

Current liabilities

 

 

 

 

Trade and other payables

 $     835

 $     795

 $       40

5.031%

Current borrowings - Bank Overdraft

 $       52

 $       40

 $       12

30.000%

Total current liabilities

 $     887

 $     835

 $       52

6.228%

Non-current liabilities

 

 

 

 

Non-current borrowings - Secured loan

 $  1,500

 $  1,000

 $     500

50.000%

Total liabilities

 $  2,387

 $  1,835

 $     552

30.082%

Net Assets

 $     915

 $     835

 $       80

9.581%

Equity

 

 

 

 

Share capital

 $     300

 $     300

 $        -   

0.000%

Retained earnings

 $     615

 $     535

 $       80

14.953%

Total Equity

 $     915

 $     835

 $       80

9.581%

This variance analysis raise various concerns related to the significant variance

  1. Organization’s revenue increased by the 15.79%, on the other hand, this increase is not reflected by an increase in gross profit. Gross profit of the organization shows increase on by12.31% due to a significant increase in the cost of goods sold by 16.92%.
  2. Inventory and receivables of the organization both showing a significant increase of 33.33% and 16.97% respectively. These balance sheet balances do not have a tendency for such significant increase.
  3. Increase in Plant, property, and equipment and bank liabilities is because of new investment by the way of bank liabilities.

Trend analysis is the financial analysis of calculating trends of historical financial balances (Guay, Samuels, & Taylor, 2016). Under this analysis, any significant change in such trend is observed by the auditor of the organization.

Trend analysis for income statement

 

2017

2016

2015

2014

Sales

100.00%

100.00%

100.00%

100.00%

Cost of Goods Sold

-76.30%

-75.56%

-76.02%

-73.97%

Gross Profit

23.70%

24.44%

23.98%

26.03%

Other Expenses

-11.36%

-14.66%

-13.11%

-10.69%

Interest

-9.74%

-4.51%

-3.40%

-0.15%

Net Profit (Loss)

2.60%

5.26%

7.48%

15.19%

Trend analysis for financial position

 

2017

2016

2015

2014

Assets

 

 

 

 

Current assets

 

 

 

 

Trade and other receivables

23.38%

24.72%

25.38%

39.92%

Inventory

20.59%

19.10%

20.56%

21.42%

Total current assets

43.97%

43.82%

45.95%

61.34%

Non-current assets

 

 

 

 

Property, plant and equipment

54.82%

56.18%

54.05%

38.66%

Intangible assets

1.21%

0.00%

0.00%

0.00%

Total non-current assets

56.03%

56.18%

54.05%

38.66%

Total assets

100.00%

100.00%

100.00%

100.00%

Liabilities and equity

 

 

 

 

Liabilities

 

 

 

 

Current liabilities

 

 

 

 

Trade and other payables

25.29%

29.78%

28.55%

41.80%

Current borrowings - Bank Overdraft

1.57%

1.50%

1.23%

1.67%

Total current liabilities

26.86%

31.27%

29.79%

43.47%

Non-current liabilities

 

 

 

 

Non-current borrowings - Secured loan

45.43%

37.45%

29.38%

0.00%

Total liabilities

72.29%

68.73%

59.17%

43.47%

Net Assets

27.71%

31.27%

40.83%

56.53%

Equity

 

 

 

 

Share capital

9.09%

11.24%

17.63%

31.35%

Retained earnings

18.63%

20.04%

23.21%

25.18%

Total Equity

27.71%

31.27%

40.83%

56.53%

This trend analysis raise various concerns related to significant trend variance

  • Operating expenses showing a decline in the present year however in all other three years it is having increasing trend.
  • Interest expenses showing a significant increase due to increase in bank liabilities.
  • Plant, property, and equipment are showing declining trend even after having a significant investment in this asset.

Ratio analysis is the analysis which shows profitability, liquidity, solvency etc. relationship between various financial figures (Weygandt, Kimmel, & Kieso, 2015).

Year ending

2016

2017

Profitability ratios

 

 

Net Profit margin

5.26%

2.60%

Operating Profit Margin

9.77%

12.34%

Return on common stock equity

16.77%

8.74%

Return on Total Assets

5.24%

2.42%

Efficiency ratio

 

 

Accounts receivable turnover ratio

4.09

4.04

Average collection period ratio

87.97

89.06

Accounts Payable turnover ratio

3.58

3.85

Accounts Payable turnover in days ratio

100.69

93.39

Fixed asset turnover ratio

1.77

1.66

Total asset turnover ratio

1.00

0.93

Long-term solvency ratio

 

 

Debt Ratio

68.73%

72.29%

Times interest ratio

2.17

1.27

Liquidity ratio

 

 

Current ratio

1.40

1.64

This ratio analysis raises various concerns
  • Operating profit ratio showing an unexpected increase
  • Accounts payable ratio shows an unexpected decline
  • Asset turnover ratios are also showing decline due to new investment in assets
  • The debt ratio is showing an increase due to increase in debt liabilities
  • A current ratio showing an unexpected increase
Part 2

Going concern is a significant accounting assumption. As per this assumption, every analyst for the economic business assumes that such business will continues till the end of unforeseeable future period (Amin, Krishnan, & Yang, 2014). Every organization prepares financial statements using historical values due to this concept. The organizations which are not expected to remain going concern in future will make their financial statements by using realization values in place of historical value.

Moreover, if an organization shows some indicators effecting going concern assumption adversely for the organization then such organization does not expect to remain going concern. Such indicators can be accumulated losses, nonpayment of dues, loss of market etc.

Furthermore, in the present case, the organization is having additions in the long term as well as short-term liabilities. Additionally, net income generated by the organization is showing a significant decline hence it can assume that organization may have some going concern issues.

Part 3

Following Account, balances have a potential risk of misstatement

Account balance

Justification

Net income

a. Significant negative variances

b. The significant declining trend is a risk for going concern

Receivables

a. Significant increase in variance,

b. significant increase in current ratio

Total liabilities

a. Increase in debt ratio,

b. continually increasing trend is a risk for going concern

Noncurrent assets

a. Significant variance,

b. Significant increasing trend,

c. on the other side, asset turnover ratios have declining trend

Part 4

Following assertions are of primary interest

Account balance

Justification

Net income

 

    Operating expenses

Unexpected declining trend and unexpected increasing operating margin ratio emerge the risk of understatement of operating expenses.

    Income expenses

a. A significant increase in variance and trend

b. Percentage Variance change for interest balances is higher than the percentage variance change in debt liabilities

Receivables

 

    Gross account balance

A significant increase in variance and current ratio hence doubt of overstatement of the account balance

    Provision for doubtful receivables

A significant increase in the variance of gross amount and current ratio hence doubt of  underestimation of provisioning

Total liabilities

 

    Bank liabilities

The significant increasing trend, increasing debt ratio emerges the doubt regarding the utilization of funds from such external funding

    Payables

Payables have an unexpected declining trend and declining payable turnover ratio hence emerges doubt of payment for payables by an increase in bank liabilities

Noncurrent assets

 

   Plant property and equipment

Showing a declining trend even after having a huge investment in this asset

   Intangibles

This asset emerges from the current year hence need to make extensive procedures regarding this

Question 2
Part 1

Key control

Segregation of duties

The organization required this internal control for the execution of the transaction. Single-handed execution of cash transaction emerges the risk of cash theft and cash fraud (Kobelsky, 2014). In the present case receipts of cash cheques is made by office assistant and recoding is done by the bookkeeper.

Policies and procedure identification

The organization needs to identify policies and procedures for the significant financial transaction. Service charge calculation is the significant procedure for the organization. In the present case, the organization defined the procedure for making calculations of service charges i.e. 300% of hourly rates. This control helps in fairly and accurate service revenue calculation.

Approval for contract cancellation

Every organization must have approval policies for the significant transactions. A service contract is a significant business activity for the clinic.  In the present case acceptance and cancellation of any service contract is made by managing director. Hence it seems that organization is having control of policies and procedures.

Recording and reconciling cash

Real-time recording of cash transaction and periodical reconciliation of cash transaction results in a reduction in a misstatement of cash. In the present case, such recording and reconciliation are made by the bookkeeper.

Part 2

Test of controls

Test of controls are the procedures which performed by the auditor for testing actually the internal control is working appropriately or not (Auditing and Assurance Standards Board, 2013).

Observation

Segregation of duties can be tested by the auditor by making an observation. Under this auditor needs to observe how activities and operations are performed in the organization. In the present case, the auditor will observe how cash receipts and recoding of such receipts is actually performed in the organization. Are the receipts actually have control of segregation of duties or not?

Analytical review procedure

Analytical review procedures are ratio calculations, trend calculations and another financial number crunching (Auditing and Assurance Standards Board, 2009). In the present case service fee is charged at 300% of hourly rates. The auditor can make check service charge calculation by making analytical review procedures.

Inspection

In the present case acceptance and cancellation of any service contract is made by managing director. The auditor should check whether all cancellations of service contract and acceptance of service contracts have the approval of managing director or not. Hence for this test of control auditor should make an inspection of service contract file.

Re-calculations

In the present case, cash recording and reconciliation are made by the bookkeeper. The auditor needs to check whether such reconciliation is free from error or misstatement or not. Thus, for making this check auditor needs to make re-computation of the reconciliation statement.

Part 3

Concerns about the controls

  1. Segregation of duties for cash receipts and cash recording exists, however, cash depositing, reconciliation preparation, and cash transaction recording are under the control of the bookkeeper. Hence there is concern that improper segregation of duties may result in cash frauds or misstatements.
  2. Revenue recording is done by the organization on the cash basis, however; the organization is following accrual basis system of accounting. Hence there is a concern that revenue account balance of the organization will show wrong balances.
Question 3
Part 1
Concerns for relevant control

Nonperformance parallel test

Parallel test refers to the parallel running of the old and new system and makes identification of errors, wrong outputs, and bugs created by the new system. In the present case, the organization does not make this test hence new system have expectations of inefficient output.

Inefficient access control

In system implementation, access controls are most significant control. In the present case, the organization does not provide access to transaction file to the supervisor, the only master file can be accessed by supervisor. If a supervisor needs to access transaction file for making rechecking of any master file assertion then such access is denied by the system.

Part 2
Application controls

Existence control for the occurrence of a transaction

Organization’s application system should have an existence for all employee data which are currently working. Such data must be updated on each new recruitment and termination. Such data existence will help in the occurrence of payroll transactions for all current employees.

Input controls for the accuracy of transactions

The system must have input controls so that accuracy of transaction processing and output can be ensured. The organization can implement input controls of format check, check digit and reasonableness check. Such control helps in making an accurate input to the application system.

Part 3

The appropriate test of control for the application system is test data. Under this control auditor of the organization put some dummy data and observes the output from such dummy inputs. If such dummy inputs become eligible to provide expected correct output then it is concluded that application system is eligible to provide correct output otherwise not. In addition to this auditor can put some unacceptable input to check input controls.

References

Amin, K., Krishnan, J., & Yang, J. S. (2014). Going concern opinion and cost of equity. Auditing: A Journal of Practice & Theory , 33 (1), 1-39.

Auditing and Assurance Standards Board. (2013, November 11). Auditing Standard ASA 315 Identifying and Assessing the Risks of Material Misstatement through Understanding the Entity and Its Environment. Retrieved April 30, 2018, from https://www.auasb.gov.au: https://www.auasb.gov.au/admin/file/content102/c3/Nov13_Compiled_Auditing_Standard_ASA_315.pdf

Auditing and Assurance Standards Board. (2009, October). Auditing Standard ASA 520 Analytical Procedures. Retrieved April 26, 2018, from https://www.auasb.gov.au/admin/file/content102/c3/ASA_520_27-10-09.pdf

Guay, W., Samuels, D., & Taylor, D. (2016). Guiding through the fog: Financial statement complexity and voluntary disclosure. Journal of Accounting and Economics , 62 (2-3), 234-269.

Kobelsky, K. (2014). A conceptual model for segregation of duties: Integrating theory and practice for manual and IT-supported processes. International Journal of Accounting Information , 15 (4), 304-322.

Marshall, D., McManus, W., & Viele, D. (2004). Accounting: What the numbers mean. McGraw-Hill/Irwin.

Weygandt, J., Kimmel, P., & Kieso, D. (2015). Financial & managerial accounting. John Wiley & Sons.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Financial Statement Analysis: Variance, Trend, And Ratio Analysis. Retrieved from https://myassignmenthelp.com/free-samples/acc331-auditing-and-assurance-services.

"Financial Statement Analysis: Variance, Trend, And Ratio Analysis." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/acc331-auditing-and-assurance-services.

My Assignment Help (2020) Financial Statement Analysis: Variance, Trend, And Ratio Analysis [Online]. Available from: https://myassignmenthelp.com/free-samples/acc331-auditing-and-assurance-services
[Accessed 22 November 2024].

My Assignment Help. 'Financial Statement Analysis: Variance, Trend, And Ratio Analysis' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/acc331-auditing-and-assurance-services> accessed 22 November 2024.

My Assignment Help. Financial Statement Analysis: Variance, Trend, And Ratio Analysis [Internet]. My Assignment Help. 2020 [cited 22 November 2024]. Available from: https://myassignmenthelp.com/free-samples/acc331-auditing-and-assurance-services.

Get instant help from 5000+ experts for
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

loader
250 words
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Plagiarism checker
Verify originality of an essay
essay
Generate unique essays in a jiffy
Plagiarism checker
Cite sources with ease
support
close