For this project, you will update Apple's information using their most recent financials, building a three-statement model as well as supporting schedules. Then, using free cash flows from your model, you will perform a company valuation analysis. You will also perform a sensitivity analysis in Excel. All models and supporting schedules, etc. should be submitted through Canvas. Because we do not have access to all of the same resources/documents used in the Wall Street Prep exercises, feel free to use Bloomberg, CRSP, or free online resources. Do the best you can to build your model and arrive at a valuation. hat's the goal: finding the intrinsic value of this company! Please note that you will have to make some assumptions in your model. T You can find Apple's most recent 10-K on the website
For this project, you will update Apple's information using their most recent financials, building a three-statement model as well as supporting schedules. Then, using free cash flows from your model, you will perform a company valuation analysis. You will also perform a sensitivity analysis in Excel. All models and supporting schedules, etc. should be submitted through Canvas. Because we do not have access to all of the same resources/documents used in the Wall Street Prep exercises, feel free to use Bloomberg, CRSP, or free online resources. Do the best you can to build your model and arrive at a valuation. hat's the goal: finding the intrinsic value of this company! Please note that you will have to make some assumptions in your model. T You can find Apple's most recent 10-K on the website
Essentials Of Business Analytics
1st Edition
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Camm, Jeff.
Chapter6: Data Mining
Section: Chapter Questions
Problem 20P
Related questions
Question
Please correct answer and don't use hand raiting
Transcribed Image Text:For this project, you will update Apple's information using their most recent financials, building
a three-statement model as well as supporting schedules. Then, using free cash flows from
your model, you will perform a company valuation analysis. You will also perform a sensitivity
analysis in Excel. All models and supporting schedules, etc. should be submitted through
Canvas.
Because we do not have access to all of the same resources/documents used in the Wall
Street Prep exercises, feel free to use Bloomberg, CRSP, or free online resources. Do the best
you can to build your model and arrive at a valuation. hat's the goal: finding the intrinsic value
of this company! Please note that you will have to make some assumptions in your model. T
You can find Apple's most recent 10-K on the website
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College