ACCTG 371 Financial Statement Analysis SEMESTER TWO, 2022
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
ACCTG 371
SEMESTER TWO, 2022
ACCOUNTING
Financial Statement Analysis
QUESTION 1
(a) Ami Heart Inc reports restructuring expenses for the last three years. Describe the
typical categories of restructuring costs that require cash settlement. (2 marks)
(b) What does a negative restructuring expense imply about one or more previous year’s
accruals? (1 mark)
(c) Ami Heart Inc reports “Other expenses, net” on its income statement. How can a company use such an account to potentially obscure its actual financial performance?
(2 marks) (Total for Question 1: 5 marks)
QUESTION 2
The following footnote is adapted from Air New Zealand Limited ’s financial statements for the year ended 30 June 2022.
Property, Plant and Equipment
Items of property, plant and equipment are stated at cost or deemed cost less accumulated depreciation and accumulated impairment losses.
Airframes, |
Spares |
Plant and |
Land and |
Capital |
Total |
|
engines and |
|
equipment |
buildings |
work in |
|
|
simulators |
|
|
|
progress |
|
|
$M |
$M |
$M |
$M |
$M |
$M |
|
Cost |
4,403 |
156 |
502 |
550 |
79 |
5,690 |
Accumulated depreciation |
(1,680) |
(75) |
(389) |
(341) |
- |
(2,485) |
Provision for impairment |
(3) |
- |
- |
(12) |
- |
(15) |
Carrying value as at 30 June 2022 |
2,720 |
81 |
113 |
197 |
79 |
3,190 |
Required:
(a) Compute Air New Zealand’s “percent used up” for (i) each of the depreciable items of
property, plant and equipment and (ii) total depreciable property, plant and equipment as at 30 June 2022. Note that “Capital work in progress” is not subject to depreciation. Show your workings. (3 marks)
(b) Based on your calculation in part (a), briefly explain what the “percent used up” has
indicated for Air New Zealand’s future cash flows. (2 marks)
QUESTION 3
(a) Following are some financial statement numbers for Fox Limited for the year ended 30
June 2022.
(in millions)
Sales
Depreciation expense
Capital expenditure (CAPEX)
Beginning Property, plant, equipment (PPE), net Ending Property, plant, equipment (PPE), net
2022 |
$20,000 1,000 1,500 10,000 10,500 |
Assume the following in 2023:
• a 5% growth in sales
• a continuation of the 2022 ratio of “Depreciation expense / beginning PPE, net”
• a continuation of the 2022 ratio of “CAPEX / Sales”
Required:
Forecast the company’s net balance of PPE by the fiscal year end of 2023. Show your workings and round your answer to the nearest million dollars. (4 marks)
(b) Below is information extracted from Cheeta Inc’s financial statements for 2022 and
preliminary forecasts for 2023.
2022
2023
(in millions) Reported Preliminary forecasts
Short-term investment (plug)
Interest income
Interest expense
The following assumptions are used in the preliminary forecasting process:
• “interest income” and “interest expense” are forecasted with no change
• “dividends” is 40% of net income
• “income taxes payable” is 40% of “income taxes expense”
• 2023 forecasted effective tax rate is 25%
• All remaining income statement and balance sheet items are forecasted either with no change or based on the 2022 percent of sales
“Short-term investment” is used as an account to balance the initial forecasted Balance
Sheet.
Required:
Calculate the revised plug value in the final forecasted Balance Sheet for 2023, assuming the following:
• the revised interest expense forecast is $490 million
• the revised interest income forecast is $280 million
Show your workings. (6 marks)
(Total for Question 3: 10 marks)
QUESTION 4
A junior analyst conducted the following valuation using the Discounted Cash Flow (DCF) model for a company’s equity value at the end of the fiscal year 2021:
Forecast and valuation assumptions |
|
Forecast horizon (excluding final year) sales growth (2022 – 2024) Forecast horizon final year sales growth (2025) Terminal period sales growth NOPAT margin (NOPM) which is based on the 2021 reported numbers, rounded to two decimal places, for the horizon period and the terminal period NOA turnover which is based on the 2021 reported numbers and ending NOA, rounded to two decimal places, for the horizon period and the terminal period Weighted average cost of capital (WACC) |
5% 1% 1% 21% 2.62
7.6% |
DCF valuation (in $millions except discount factors) |
Reported Forecast Horizon |
Terminal Period |
||||
2021 |
2022 |
2023 |
2024 |
2025 |
||
Sales (rounded) |
49,818 |
52,309 |
54,924 |
57,671 |
58,247 |
58,830 |
Comprehensive NOPAT |
10,486 |
10,985 |
11,534 |
12,111 |
12,232 |
12,354 |
NOA |
19,019 |
19,965 |
20,963 |
22,012 |
22,232 |
22,454 |
Increase in NOA |
|
946 |
998 |
1,049 |
220 |
222 |
FCFF Discount factor Present value of horizon FCFF Cumulative PV FCFF Terminal Value (TV) PV Terminal Value Total Firm Value Less (plus) NNO Total Equity Value |
Forecasted |
10,039 0.92937 9,330 |
10,536 0.86372 9,100 |
11,062 0.80272 8,880 |
12,012 0.74602 8,961
183,818 |
12,132 |
36,271 183,818 |
2023-05-29