ACCT867代写、代写Python程序设计

日期：2023-04-16 09:49

Master of Professional Accounting

ACCT867 Finance for Accountants

Trimester One, 2023

Individual Assignment

Due Date: 1st May 2023, at 12:00 pm (noon)

Weighting: 30% (20% for Written Assignment and 10% for Oral Presentation)

Type: Individual assignment

Length: Maximum 2,000 words (excluding tables, graphs, references, and

Appendix) for Written Assignment

Approximately 10 minutes for Oral Presentation

Submission: It requires submitting an electronic copy of the Written Assignment

via Turnitin and submitting the Oral Presentation recording via

Panopto Video.

It also requires submitting all the relevant calculations or evidence of

files (e.g., Excel or Python data etc.) that support your analyses to

katie.tseng@aut.ac.nz.

Requirements: The specific question(s) for this assignment will be posted on Canvas

in the Assignment folder. This assignment will cover topics introduced

in Weeks 1-5.

This assessment must follow the academic integrity guidelines stated

in the Business Programmes Assessment and Study Handbook or the

Law Programmes Assessment and Study Handbook and use the

required referencing style.

Compulsory: This assessment event is compulsory.

Programme

Learning Goals:

Learning Goal 2: Be effective thinkers and problem-solvers

Learning Goal 3: Be effective communicators (written and oral)

Learning Goal 4: Be able to apply accounting knowledge to issues in

professional accounting practice

Paper Learning

Outcomes:

1. Calculate and critically apply financial evaluation techniques to

capital investment decisions within the current financial market

environment.

3. Critically evaluate the principles and processes involved in various

sources of debt and equity finance alternatives.

4. Critically evaluate the developments in the valuation of capital

market returns (CAPM and WACC) and the capital structure decisions.

2

DESCRIPTION – WRITTEN ASSIGNMENT

PART A Equity Valuation

This individual assignment is designed to apply the techniques that you learned in class on the

equity valuation of companies in today’s stock markets.

Step 1: Pick the companies and intrinsic valuation

Using Yahoo Finance or NZX Research for company search. Pick two companies, making sure

at least you have:

(Company 1, the main Company that you analyse) One Company that has growth

potential. Look for companies whose earnings or revenues have grown in recent

financial years.

(Company 2) The other Company should be the competitor of Company 1, which

means that Company 2 has a similar capitalisation and business line to Company 1 or

is in competition with the business of Company 1 for market share.

Provide a narrative regarding the purpose of this report and introduce/brief necessary details

of Company 1 you choose (e.g., how your Company was evolving; describing the

product/service markets, industries, and the competition it faces; discussing the past three-

year financial performance evident in some key financial ratios). Also, you must: 1) justify the

validity of your companies’ comparison; 2) tie your narrative to key numbers and conclusion

in your valuation. (20%)

Step 2: Discounted Cashflow Valuation

Value the stock in Company 1 using a Free Cash Flows to Equity model (you need to decide

the specifications of FCFE model that best fit your companies, e.g., 2-stage, 3-stage, or n-

stage…etc.) and provide your responses to the requirements as follows.

a) Justify the specifications of the FCFE model for your companies (i.e. what pattern (2-

stage, 3-stage, or n-stage) will you assume the Company’s growth to follow and

why?). (10%)

b) Conduct firm valuation using the FCFE Model for Company 1 (besides descriptions,

please provide all your calculations/workings in tables and graphs as possible). See the

Steps below.

(10%)

c) Identify at least two assumptions used in your discounted cash flow valuation and

describe their economic meanings. (5%)

d) Provide additional analyses and explain how the assumptions identified in (c) affect

the results of your valuations. (20%)

e) Conduct Discounted Cashflow Valuation for Company 2 and compare the results in

valuation for Company 1 with those for Company 2. (5%)

3

Steps Using FCFE Valuation Model:

1. Estimate the discount rate r used in the equity valuation, that is, the cost of equity.

Please follow the instructions of PART B to calculate it.

2. Estimate the current free cash flows to equity investors (FCFE) (see Week 2 Lecture

slides)

To calculate FCFE, you may access annual reports (Form 10-K) of the companies

from SEC EDGAR Search https://www.sec.gov/edgar/searchedgar/companysearch.html

3. Estimate the future earnings and cash flows of the firm being valued, generally by

estimating an expected growth rate in earnings (1) based on analysts’ long-term

growth forecasts (i.e. forecasted 5-year growth rate in EPS).

4. Estimate when the firm will reach “stable growth” and what characteristics (risk & cash

flow) it will have when it does. In other words, determine the growth period(s), growth

rate (2 3 ), and terminal value.

5. Use the DCF model you choose to estimate the PV of future FCFEs.

6. Compare the value relative to the market capitalisation (= stock price x number of

outstanding shares) to estimate whether the equity value of the Company is currently

overvalued or undervalued.

Calculating Free Cash flow to Equity (FCFE):

For the firm’s leverage to be stable (i.e. the net capital expenditure assumption), we

use the following:

Free Cash flow to Equity (FCFE) = Net Income - (1- DR) (Capital Expenditures

- Depreciation) - (1- DR) Working Capital Needs; where DR = Debt/Capital

Ratio or TL/TE Ratio

Step 3: Final Value Estimate and Recommendation

Consider the results obtained from the discounted cash flow and the comparable.

Provide the economic implications of your comparisons from Step 2. Make final

recommendations on the stocks of your Companies 1 and 2 (Strong Buy, Buy, Hold, Sell,

or Strong Sell), justify your recommendations, and summarise all your analyses and the

results with a conclusion. (15%)

PART B Cost of Equity

Required (please show all your workings of OLS regression analysis and simulations)

The Capital Asset Pricing Model (CAPM) is one of the most tested models in Finance. When

beta is estimated in practice, a variation of CAPM called the market model is often used. To

derive the market model, we start with the CAPM:

E() = + [() ? ]

Since CAPM is an equation, we can subtract the risk-free rate from both sides, which gives us:

4

E() ? = [() ? ]

This equation is deterministic, that is, exact. In regression, we know that there is some

indeterminate error. We need to formally recognise this in the equation by adding epsilon (),

which represents this error:

E() ? = [() ? ] +

Finally, think of the above equation in a regression. Since there is no intercept in the equation,

the intercept is zero. However, when we estimate the regression equation, we can add an

intercept term, which we will call alpha:

E() ? = + [() ? ] +

This equation, known as the market model, is generally the model used for estimating beta

(). The intercept term is known as Jensen’s alpha and represents the excess return. If CAPM

holds exactly, this intercept should be zero. If you think of alpha in terms of the SML, if the

alpha is positive, the stock plots above the SML and if the alpha is negative, the stock plots

below the SML.

You want to estimate the market model for the individual stock of a company you choose.

First, go to finance.yahoo.com, or use Datastream (Eikon) database to download the adjusted

prices for the last 61 months for the stock of the Company and the S&P 500.1 You may

access NZX Company Research from the AUT Library website for NZ companies. Next, go to

the St. Louis Federal Reserve website at www.stlouisfed.org. You should find the FRED?

database on this website (https://fred.stlouisfed.org/). Look for the 1-Month Treasury

Constant Maturity Rate and download this data.2 This will be the proxy for the risk-free rate.

This interest rate is the annual interest rate (EAR), while we are using monthly stock returns,

so you will need to adjust the 1-month T-bill rate. For the stock that you select, estimate the

beta and alpha of the stock using the market model. When you estimate the regression model,

find the box that says Residuals and check this box when you do each regression. Because you

are saving the residuals, you may want to keep the regression output in a new worksheet.

a) Draw characteristic lines for the companies and provide interpretation and

implications based on the estimated beta and alpha. (5%)

b) Calculate the average cost of equity for the companies E() over the period by

using the estimated equation. (5%)

c) Compare your companies based on the estimates obtained from (a) and (b). Provide

the corresponding implication. (5%)

DESCRIPTION – ORAL PRESENTATION

1 You may use historical data of S&P/NZX 50 (or S&P/ASX 200) if the company you chose is listed in New

Zealand (Australia) markets.

2 You may use the “Long-Term Government Bond Yields: 10-year: Main (Including Benchmark) for New

Zealand” for New Zealand companies. (or “Long-Term Government Bond Yields: 10-year: Main (Including

Benchmark) for Australia” for Australian companies).

5

Provide a 10-minute presentation based on the analyses and discussions in your written

assignment, assuming you are a financial analyst reporting the worthiness of investment on the

Company (Company 1) to your clients.

Make sure that you carefully read the Video Presentation Marking Criteria.

INSTRUCTIONS:

Please follow the instructions below for writing the assignment. Failure to follow these

instructions will result in lost marks.

a. This assignment is an individual assessment. It is not allowed to choose the same

companies in the same period as the other students do.

b. The written assignment must be word-processed in 12pt font, 1.5 line-spaced. Leave at

least 2.5cm margin. You are also required to show all your calculations, descriptive

statistics, and regression analysis in the Appendix. Please organise your workings of

calculations in Excel (or other application packages) and send them to

katie.tseng@aut.ac.nz

c. Grammar and spelling – must be correct otherwise penalised.

d. Use of Wikipedia and unverified sources is not acceptable. References and quotations

taken from other authors must be properly acknowledged at all times using the APA

referencing.

e. Plagiarism issues will be strictly handled. The assignment will be submitted to

TURNITIN for plagiarism check. Disciplinary actions will be taken if academic integrity

is breached.

f. Students must familiarise themselves with AUT’s Rules and Regulation regarding this

assignment as spelt out in the study guide.

g. In answering the questions, marks will be awarded for:

i. Clarity of discussions and analyses

ii. The correctness of content materials and calculations

iii. The logical structure of the report

iv. Depth of study: the ability to relate theoretical concepts to practice

v. The critical lens of analysis

vi. Quality of communication, e.g. correct spelling, grammar, structure, proper

page numbers and references used.

vii. Adhere to the word limit. Work that has exceeded 10% addition to the word

limit will not be marked.

viii. Concise and well-organised presentation and good academic writing.

h. Up to 5 points added to your assignment if applying Python or other tools of Analytics

into your project. Need to show evidence and provide a presentation (demonstration).