FINANCIAL STATEMENT MODELING
EXAM |WALL STREET PREP|
COMPLETE QUESTIONS AND
ANSWERS
, QUESTION 1
The next two questions use data from Athenahealth financial filing, which can be downloaded by clicking
here. The next two questions will use the following scenario:
It is July 4, 2017 and you are asked to perform a company profile for Athenahealth (ATHN), with a latest
closing share price of
$140.07. The company’s most recent earnings report was for the first quarter 2017 for the period ending
3/31/2017.
Calculate ATHNʼs LTM Non-GAAP operating profit. Use the company’s own definition of Non-GAAP
operating profit when arriving at your calculations.
Hint: You only need the Q1 2017 and Q4 2016 press releases to answer this question.
26.6
27.4
130.1
132.3
154.3
QUESTION 2
This question uses the same Athenahealth data as the previous question, which can be downloaded by
clicking here. This question uses the same scenario as the previous question, repeated below:
It is July 4, 2017 and you are asked to perform a company profile for Athenahealth (ATHN), with a latest
closing share price of $140.07.
The companyʼs most recent earnings report was for the first quarter 2017 for the period ending
3/31/2017. Calculate ATHNʼs enterprise value.
Hint: You only need the Q1 2017 10Q and the 2016 10K to answer this question.
5,655.00
5,682.80
5,809.00
5,823.45
5,915.70
QUESTION 3
A Company has the same level of Operating Income for Q1 of two consecutive years. However, for the
more recent Q1, levels of D&A dropped. When you compare the Companyʼs most recent Q1 LTM EBIT and
EBITDA to those of its last complete fiscal year, you would expect:
EXAM |WALL STREET PREP|
COMPLETE QUESTIONS AND
ANSWERS
, QUESTION 1
The next two questions use data from Athenahealth financial filing, which can be downloaded by clicking
here. The next two questions will use the following scenario:
It is July 4, 2017 and you are asked to perform a company profile for Athenahealth (ATHN), with a latest
closing share price of
$140.07. The company’s most recent earnings report was for the first quarter 2017 for the period ending
3/31/2017.
Calculate ATHNʼs LTM Non-GAAP operating profit. Use the company’s own definition of Non-GAAP
operating profit when arriving at your calculations.
Hint: You only need the Q1 2017 and Q4 2016 press releases to answer this question.
26.6
27.4
130.1
132.3
154.3
QUESTION 2
This question uses the same Athenahealth data as the previous question, which can be downloaded by
clicking here. This question uses the same scenario as the previous question, repeated below:
It is July 4, 2017 and you are asked to perform a company profile for Athenahealth (ATHN), with a latest
closing share price of $140.07.
The companyʼs most recent earnings report was for the first quarter 2017 for the period ending
3/31/2017. Calculate ATHNʼs enterprise value.
Hint: You only need the Q1 2017 10Q and the 2016 10K to answer this question.
5,655.00
5,682.80
5,809.00
5,823.45
5,915.70
QUESTION 3
A Company has the same level of Operating Income for Q1 of two consecutive years. However, for the
more recent Q1, levels of D&A dropped. When you compare the Companyʼs most recent Q1 LTM EBIT and
EBITDA to those of its last complete fiscal year, you would expect:
