Financial Statement Analysis, Cost-Volume-Profit, Budgeting

ASSIGNMENT 02 ANSWER BOOKLET ACCTG 101
THE UNIVERSITY OF AUCKLAND
First SEMESTER, 2019
Campus: City
ACCOUNTING
ACCTG 101 – Accounting Information
Due date: 4 pm Thursday 23 May 2019
LAST NAME STUDENT AUID
FIRST NAMES
QUESTION TOPIC MARKS
1 Financial Statement Analysis 20
2 Cost-Volume-Profit 15
3 Budgeting 15
50
NOTE
1. This assignment counts for 10% of the final grade. There is no Plus sage.
2. Attempt ALL questions.
3. Fill out your personal details on Page 1.
4. Answers should be provided in a clear and concise manner demonstrating a high
standard of communication skills. Type answers into the corresponding boxes.
5. Type your answers using Verdana 10 Font. No hand written answers will be
accepted.
6. Present numerical work clearly and concisely. Show your workings, as they will be
graded. Full marks will be given only where a solution is supported by clearly labelled
workings.
7. See details on submission of this booklet on the first page of the assignment
question.
YOU MUST SUBMIT THIS BOOKLET ELECTRONICALLY.
CONTINUED

ASSIGNMENT 02 ANSWER BOOKLET ACCTG 101
1. Financial Statement Analysis: 20 marks
(a) (I)
Auckland Airport 4-year Summary
Horizontal analysis
Change
% 2018 Change
% 2017 Change
% 2016 2015
Income
Airfield Income 31% 122.1 28% 119.6 11% 103.4 93.3
Passenger Services
Charge 27% 179.1 24% 174.3 10% 154.9 140.9
Retail Income 44% 190.6 23% 162.8 19% 157.5 132
Rental Income 51% 97.6 31% 84.9 16% 74.7 64.6
Rates Recoveries 18% 6 10% 5.6 6% 5.4 5.1
Car Park Income 31% 61 21% 56.3 12% 52.1 46.6
Interest Income -33% 2.2 -30% 2.3 -48% 1.7 3.3
Other Income 11% 25.3 4% 23.5 7% 24.2 22.7
Total Income 34% 683.
9 24% 629.
3 13% 573.
9
508.
5
Expenses
Staff 25% 57.9 9% 50.5 1% 46.8 46.3
Asset management,
maintenance and airport
operations
57% 69.5 26% 55.6 11% 49.1 44.2
Rates and Insurance 28% 13.7 14% 12.2 7% 11.5 10.7
Marketing and
Promotions 5% 13.8 27% 16.7 23% 16.3 13.2
Other Expenses 60% 22.6 50% 21.2 41% 19.9 14.1
Total Expenses 38% 177.
5 22% 156.
2 12% 143.
6
128.
5
EBITDAFI 33% 506.
4 25% 473.
1 13% 430.
3 380
Comment: There is an increase in EBITDA of the company as compared to the last two
financial year. It means the company is in progressive stage and the growth of the
company is also good.
Page 2 of 10

ASSIGNMENT 02 ANSWER BOOKLET ACCTG 101
(a) (ii)
Auckland Airport 4-year Summary
Vertical trend analysis
%
Change 2018 %
Change 2017 %
Change 2016 %
Change
201
5
Income
Airfield Income 18% 122.1 19% 119.6 18% 103.4 18.3% 93.3
Passenger Services
Charge
26% 179.1 28% 174.3 27% 154.9 27.7% 140.
9
Retail Income 28% 190.6 26% 162.8 27% 157.5 26.0% 132
Rental Income 14% 97.6 13% 84.9 13% 74.7 12.7% 64.6
Rates Recoveries 1% 6 1% 5.6 1% 5.4 1.0% 5.1
Car Park Income 9% 61 9% 56.3 9% 52.1 9.2% 46.6
Interest Income 0% 2.2 0% 2.3 0% 1.7 0.6% 3.3
Other Income 4% 25.3 4% 23.5 4% 24.2 4.5% 22.7
Total Income 100% 683.9 100% 629.3 100% 573.9 100.0% 508.
5
Expenses
Staff 8% 57.9 8% 50.5 8% 46.8 9.1% 46.3
Asset management,
maintenance and airport
operations
10%
69.5
9%
55.6
9%
49.1
8.7%
44.2
Rates and Insurance 2% 13.7 2% 12.2 2% 11.5 2.1% 10.7
Marketing and
Promotions
2% 13.8 3% 16.7 3% 16.3 2.6% 13.2
Other Expenses 3% 22.6 3% 21.2 3% 19.9 2.8% 14.1
Total Expenses 26% 177.5 25% 156.2 25% 143.6 25.3% 128.
5
EBITDAFI 74% 506.
4
75% 473.
1
75% 430.
3
74.7% 380
Comment: On the basis of the analysis of the financial of the company there is a growth
comparison to previous year. The company EBITDA has also increased as compared to the
previous year.
Page 3 of 10