Analysis of the financial statements for the past two years

Reference no: EM131898121

ASSIGNMENT - CASE STUDY BASED RESEARCH

Learning Outcome's

Discuss and apply the principles and practices of financial analysis for the strategic management of an organisation.
Research and communicate financial analysis and make recommendations for various business situations to internal and external stakeholders for the efficient and effective performance of the organisation.
Analyse organisational requirements and prepare financial forecasts and budgets for planning and control within an organisation.
Apply cost accounting technique and method for the effective and efficient performance of an organisation.
Interpret financial reports to evaluate organisational performance and decision-making for the efficient and effective performance of an organisation.
Interpret and present financial data according to the legal and professional financial reporting and tax requirements in New Zealand.

Subject Aim:

To provide learners with the necessary knowledge, skills and tools for the application of financial information to support management planning and decision making within an organization. Learners will also gain an understanding of the compliance and regulatory requirements in accounting and finance for a business in New Zealand.

Assignment Aims:

Learners will be able to apply necessary knowledge, skills and tools for the application of financial information to support management planning and decision making within the organization.
Learners will be able to demonstrate their ability by applying their knowledge to a realistic case of New Zealand organization.
Learners will be able to apply cost concepts and cost accounting techniques in the decision-making process.
Learners will be able to apply financial forecasting techniques to provide information for decision making.
Learners will be able to prepare and analyse financial forecasts and budgets for planning and control within the organisation.

Assignment Type: Research Based Case study

RESEARCH BASED CASE STUDY - Read the following case carefully and carry out additional research to address the tasks in the requirements section.

Case Study: Lincoln Vet Clinic (LVC)

INSTRUCTIONS/REQUIREMENTS:

Task 1: Write a report on the business which provides:

An overview of the business
An analysis of the financial statements for the past two years
And a recommendation as to whether the veterinary clinic would be a worthwhile investment

Your report must include:

An executive summary (300 words maximum).

An introduction to the report including terms of reference, background information about the business and procedures used within the report.

A discussion of:

The importance of Financial statements and their analysis for strategic management of an organisation
Limitations of Financial Analysis (in general)
Limitations of Financial Analysis (specific to the analysis)

Calculations of ratios for the year ended December 2016 and 2017, to be used for measuring and analysing the financial performance and position of the company under the following headings (At least two for each):

Profitability ratios (see note 2)
Financial Stability
Working Capital Management
Asset Utilisation
Financial Market Ratios

Calculate the industry averages for Net profit and Return on Assets ratio to be used in the analysis below.

Discussion and Application of the principles and practices of financial analysis:

Your research must present the analysis of the financial ratios given above as follows:

What each ratio measures
Any increase/decrease for each ratio
The possible reasons of the changes from Year 2016 to 2017
Whether the increase/decrease in each ratio is favourable or unfavourable
How the business has performed compared to industry averages
Which stakeholders will be interested in a particular ratio
Any non-financial aspects that might impact on business operations.

Assess solvency (both arms of the solvency test) for 2017 and explain the director's responsibilities under the Company Act 1993 for authorizing any dividends.

A conclusion which must be based on a consolidation of the information from all parts of your analysis and should state whether the business is a viable option for purchase.

Recommendations, which focus on the areas the business needs to further improve if Jack invests in the Lincoln Vet clinic.

References: This section gives the full details of any source of information quoted or referred to in the report. All references should be cited in the correct APA style. (6th Edition)

Appendices (if used) contain information relevant to your discussion, but which is too detailed to include in the body of the report. Each appendix must be numbered and referred to in the body of the report.

Task 2: Continuing from the case study in Part one, the following additional information is provided to you:

1. Based on past performance and future market growth, the sales forecasts and cost of sales for the year 2018 for each quarter is as follows:

	1^st Quarter	2^nd Quarter	3^rd Quarter	4^th Quarter
Revenue	$201,200	$285,000$	$301,800	$370,000
Cost of sales	$28,200	$29,700	$31,750	$41,350

2. Selling expenses are expected to be 10% of sales for each quarter for the year 2018.

3. Administrative expenses for the 1^st quarter are estimated to be $145,000 and expected to increase by 8% in subsequent quarters.

4. The total expected financial expenses for 2018 are $84,800 which will be divided equally for each quarter.

5. Tax expense is estimated to be 15% more than the previous year.

6. Assume, all the expected selling, administration and financial expenses are paid within each quarter. The expected cash received, and cash paid to creditors for each quarter is:

	1^st Quarter	2^nd Quarter	3^rd Quarter	4^th Quarter
Cash Received	$225,000	$225,000	$242,500	$250,000
Cash Paid	$12,500	$10,800	$11,000	$12,500

7. At the end of 2018, the following line items are expected to have these values:

Prepaid Expenses - $148,600

Inventory - $62,601

Non-Current Assets - $335,236

Loan - $40,000

Mortgage - $235,000

Equity - $282,530

Accounts Payable is expected to increase by 10% in 2018 while other liabilities are expected to increase by 20% in 2018. The amount of accrued expenses will double.

Requirements -

1. You are required to prepare and present a projected/forecasted income statement for the 2018 using best practice which meet the legal and professional financial reporting and tax requirements of New Zealand. (Download and use template 603_1 from Moodle).

2. Prepare the cash budget for each quarter for 2018 by using the information given (Download and use template 603_2 from Moodle).

3. Prepare forecasted balance sheet at the end of year 2018 using best practice which meets the legal and professional financial reporting and tax requirements of New Zealand. (Download and use template 603_3 from Moodle).

Note: Please round your calculations to 2 decimal places.

Task 3: Cost control systems are an important part of an organisation. They have a number of effects on an organisation. The management of LVC do not know the differences between the types of costing systems and need some guidance on which would be appropriate for LVC.

Required:

Prepare a written brief for the management of LVC which can be used by non-accountants to understand cost control systems. In your written brief, you should:

1. Explain and differentiate the following types of cost control systems:

a. Marginal Costing vs. Absorption Costing

b. Job Costing vs. Process Costing

c. Traditional Costing vs. Activity Based costing

2. Recommend which cost control system would be most appropriate for LVC Ltd. Justify your answer.

Attachment:- Assignment Files.rar

Reference no: EM131898121

Questions Cloud

Read each of the five cases in health administration : Read each of the five cases in health administration. Explanation for each case that explains why the case represents its particular ACHE competency domain.

Write a response paper about the forensic labs and its tools : Forensic labs require a variety of tools and assets in order to accommodate numerous investigations and evidence possibilities that might be encountered.

What are some of the external trends that will influence : What are some of the external trends (e.g., increased globalization, increased diversity and increased use of technology) that will influence leadership change?

Development of the healthcare work force : What are the forces that are influencing the development of the healthcare work force?

Analysis of the financial statements for the past two years : Case Study: Lincoln Vet Clinic (LVC). Write a report on the business which provides: An analysis of the financial statements for the past two years

Challenges associated with employee feedback : Assess the challenges of managers providing accurate, timely, and effective feedback to employees.

Example of a 12 pound electrical motor : Provide a mathematical example of a 12- pound electrical motor held close to the body vs. a situation where the load is held 20 inches from the body

Analyze how processes are created within organizations : Analyze how processes are created within organizations. Discuss how Dell creates its processes at a high level and then discuss process design activities?

What would you do to influence a culture to begin a threat : What would you do to influence a culture to begin a threat modeling discipline where threat modeling is not yet practiced?

Reviews

len1898121

3/12/2018 6:13:40 AM

You are encouraged to present your work in a word-processed report format using appropriate headings, page and section numbering, indentations, figures and tables, appendices, style (Arial or Times New Roman) and size (font 12, line spacing 1.5). Note: The report must be written in a business format and must be presented, not only to Jack's parents, but also to a bank manager so you can raise the required finance. Alternative arrangements can be made for presenting and submitting your work with help of the course instructor/tutor, in case of any special needs. The presentation of your work must use appropriate tone, register, vocabulary (including non-sexist language), grammar and syntax.

3/12/2018 6:13:34 AM

Apply knowledge of the principles and practices of operations, management accounting, sales/marketing, HR, and risk management, for the strategic objectives of the entity. Research, evaluate, and communicate information for entity’s performance. Apply analytical and problem-solving skills to resolve complex situations and challenges for efficient and effective performance of the entity. Analyse and apply financial information to make informed decisions and forecasts for efficient and effective performance of the entity. Manage compliance with internal and external requirements.

Write a Review

Required(*) Message

User Account

All Pages