For this project, you will update Apple′s information for 2023, 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. That′s the goal: finding the intrinsic value of this company!You can find Apple′s 2023 10-K here: https://investor.apple.com/investor-relations/default.aspx.
For this project, you will update Apple′s information for 2023, 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.
