FINANCE 361 Two Degrees Mobile Limited assignment 代写
100%原创包过,高质量代写&免费提供Turnitin报告--24小时客服QQ&微信：273427
FINANCE 361 Two Degrees Mobile Limited assignment 代写
FINANCE 361 - Assignment 2
1.Deadline and Submission
The deadline for this assignment is 17 Oct 2017 at 23:55. Submission is
via CANVAS for the PDF document and the supporting Excel
calculations. You should submit the Excel spreadsheet to Assignment 2
Valuation spreadsheet and the PDF document to Assignment 2 -
Valuation document (which is linked to Turnitin).
2.Context
Since joining Megabank Asset Management three months ago you have
been busy learning the ropes. You are about to grab dinner at 7pm
when your line manager, Charles de Vitry, sends you an email,
reproduced below:
Subject: Valuation of Bunnings Limited for tomorrow at 10am
Hi Sally
I’ve just been told by Peter from the Investment Committee that we have been
approached to bid on the equity of Two Degrees Mobile Limited (Two Degrees). To
start the process we are expected to submit an Expression of Interest form, in
which we have to indicate the price we would be happy to pay. Although this is
purely indicative and not a legally binding commitment, it is considered bad form
to back out of an expression of interest. The Investment Committee will be meeting
tomorrow at 10am to discuss our Two Degrees valuation; they will be expecting me
to have an opinion about the value of Two Degrees. So I need your help: Can you
run some numbers and come up with an equity valuation for Two Degrees as a
whole? I’ll need a 3-page summary (in pdf format please). I’d like a brief overview
of Two Degrees, a description and motivation of your valuation approach, key
1
assumptions and valuation drivers, the actual base case valuation (of the equity of
the whole firm) and some scenario analysis showing what the valuation might look
like if we change the key valuation drivers. I’ll be presenting this to the committee
so make sure it looks professional. You should be able to locate financials for Two
Degrees at their website . You can use any information that is publicly available. Be
1
sure to send me your Excel calculations just in case I get challenged on any of the
numbers.
I’ll be boarding my plane in 15 mins and should be back in town tomorrow morning by
9:15am. It would be great if you could email me the overview before then so I can have
a look at it while taking the taxi to the meeting.
Thanks, Charles
3.Required
If anything is unclear, do feel free to raise it in class. To be fair to other
students, I won’t be providing clari cation on an individual basis or via
email (other than in exceptional cases).
Please write up a document as requested by Charles de Vitry above.
The document should be in pdf format, and should be limited to 3
pages (including charts and graphics, excluding referencing). You can
include charts and graphics if you feel that helps you communicate
more clearly. You can use any information that is publicly available.
You will need to submit your calculations (ie Excel spreadsheet), so
make sure it is structured in a way that is easy to follow.
NOTE: This assignment may provide less structure and guidance than
you are used to. This is intentional: guring out what you need to do is
part of the assignment! It helps to imagine yourself as the customer:
what would you like to see if you were Charles de Vitry?
See https://www.companiesoffice.govt.nz/companies/app/ui/pages/companies/1117222/docum
1
The last of the reports have been downloaded for you as examples
(can be found on CANVAS under Assignment 2)
2
4.Grading
I will roughly allocate grades according to the breakdown below.
However, you will only receive an overall grade.
•Overall presentation - 20%, Overview - 10%
•Motivation of valuation approach - 20%
•Key assumptions and valuation drivers - 10%
•Valuation and scenario analysis - 30%
•Others (presentation of Excel spreadsheet, referencing etc.) - 10%
3
5.Helpful Hints 1: One way to approach the valuation of a
company
•You should already know how to do the calculations for a
valuation that is what the second part of this course is all about.
So what follows is really a bit of a guide about the rest of the
process...
•Stage 1: Find the key documents and information so you
understand the business you are valuing and the industry it
operates in (and the country or countries, if you are not familiar
with it/them)
Financials (aka Annual Reports, Interim Reports)
C o m p a n y w e b s i t e
Wikipedia entry
Regulatory lings
News reports (google, factiva, reuters, bloomberg)
Same for other rms that are comparable
•Stage 2: The business
What types of business does the company do? How does it
make money? Who are its customers, its suppliers, its
employees, its regulators?
How is the company funded? Who owns the equity in the rm?
Is it listed? Does it have any debt? Bonds, shareholder loans
or bank loans? What are the terms - interest rate, maturity?
What are the drivers of growth, market share and pro
tability?
Who are its competitors?
Key risks and opportunities
•Stage 3: The valuation approach
4
What is the appropriate valuation approach for the company?
Refer back to notes and readings for guidance.
Sketch out a mindmap of the valuation. Start with the basics
- cash ows and discount rates - then work out backwards
what you need in order to calculate each component until
you arrive at underlying inputs or assumptions.
•Stage 4: The model
Build the model in Excel. (This is where most inexperienced
people start... )
Build in checks and balances
Do a reality check - try a few quick and dirty calculations.
Based on your valuation, what is the implied growth rate?
What is the P/E ratio? Does it make sense? How does it stack
up against competitors?
Conduct sensitivity analysis on the important model inputs.
Conduct scenario analysis for key uncertainties.
∗ Sensitivity analysis: Example: If beta increases by 1%,
then the value of equity increases by ?%
∗ Scenario analysis: Value of equity given growth of (0%, 1%,
..., 10%) [Often best represented graphically or in a
table]
• Stage 5: Presenting the valuation
Presentation should address the following points
The valuation midpoint and range. (Any reader should be able
to nd this in under 2 seconds after picking up the document.)
∗ Include valuation target name, valuation date and valuer
contact details (that’s you!)
Why are you doing the valuation, what will it be used for,
who is using it?
Firm and industry overview
FINANCE 361 Two Degrees Mobile Limited assignment 代写
5
Description and motivation of the chosen valuation approach.
What approach did you take and why did you decide on it.
(Motivate the decisions you made re valuation approach) Key
inputs and assumptions.
Overview of the valuation calculation. Often best presented
in a table format.
Sensitivity analysis and scenario analysis. (Graphs can be
useful here.)
Disclaimer. (Not needed for assignments, but in the real
world you’ll need one. Talk to the people in your legal
department, or ask a lawyer for help.)
Proofread the document for spelling mistakes and
grammatical errors. Ensure the presentation looks
professional. (Muted and few colours, clear headings - search
for investment bank research notes to see how others do it.)
• In real life you do not always progress smoothly from one stage to
the next; often there is a bit of moving back and forth as you run
into problems or discover new information.
6.FAQ
Q1: We are getting one mark instead of two marks for assignment 2,
does that mean the Excel model is not going to be marked?
For assignment 2 you will receive an overall grade rather than two
separate grades for the Excel model and the pdf written document. We
will be looking at both les, and both parts count towards the overall
grade.
Q2: What is the purpose of the EXCEL spreadsheet?
Your Excel model should contain the supporting calculation of your
valuation. Both the Excel le and the pdf written document should be
clearly constructed and professionally formatted so that they are easy
to follow. Also, be sure to address the speci c requirements listed in the
6
assignment instruction (company/industry overview, sensitivity and
scenario analysis, etc.).
Q3: Can I use an existing excel template?
We recommend that you start fresh and build a model according to your
model description for assignment 2. However, feel free to look at other
valuation model spreadsheets as examples. You can also refer to the
assignment 1 Excel template as an example of a well-constructed and
presented Excel model.
Q4: What is the purpose of the written document?
Your written document should include a description of the valuation
model (what approach did you take, and why did you decide to use that
particular approach). It is also important to state the key results of
your valuation in the document. The reader should be able to
understand the valuation approach that you have chosen and the key
valuation results before looking at the Excel le. Also, remember to
state clearly the assumptions made in the valuation.
For the assignment, you should use a valuation approach that is
appropriate and logical for the target company. In the assignment, you
will be assessed on how well you can explain and motivate the
approach chosen, and how well the valuation was carried out.
Q5: Can I use estimates retrieved from external sources instead of
calculating my own for the assignment?
You can use any publicly available information for assignment 2,
including research results and estimations produced by others.
However, you should provide a short description of how the authors
derived the gures and justify why this is suitable to use given your
chosen valuation approach.
If you are using external materials and data, you should also cite the
source in your report and/or Excel model. A suggested referencing style
is the APA convention (for more details - http://
www.library.auckland.ac.nz/ subject-guides/bus/topicguides/
apa_for_business.htm )
7
FINANCE 361 Two Degrees Mobile Limited assignment 代写
