Otis 3-Statement Model
This repository contains a comprehensive 3-statement financial model for Otis, covering the years 2019 to 2021 and projecting financial data for the next five years (2022 to 2026). The model encompasses the Income Statement, Balance Sheet, and Cash Flow Statement, providing a holistic view of Otis's financial performance and position.
Data Sources: The model utilizes historical financial data from the years 2019 to 2021. Projections for the years 2022 to 2026 are based on insights from the Otis-Investor-Presentation.pdf, a publicly available document provided by breakingintowallstreet.com. These projections are carefully analyzed and incorporated into the model to ensure accuracy and relevance.
Unique Requirements: The Otis case presented unique requirements, such as the necessity to maintain a minimum of $3 billion in cash and equivalents on the balance sheet. These requirements have been meticulously integrated into the model to reflect Otis's specific financial constraints and objectives.
Thought Process: Throughout the model, detailed comments have been provided to elucidate the thought process behind various assumptions, calculations, and projections. These comments serve as a guide to understanding the rationale behind the model's structure and outputs, enhancing transparency and clarity.
Purpose: The purpose of this 3-statement model is to provide stakeholders, investors, and financial analysts with a comprehensive and insightful analysis of Otis's financial performance and outlook. By incorporating historical data, investor presentations, and unique requirements, the model offers valuable insights into Otis's financial health and trajectory.
Disclaimer: This financial model is for educational and illustrative purposes only. While efforts have been made to ensure accuracy and reliability, users are encouraged to conduct their own due diligence and verification. Any decisions made based on the information provided in this model are the responsibility of the user.
Contributions: Contributions, feedback, and suggestions for improvement are welcome. Feel free to review the model, provide comments, or suggest enhancements to further refine its accuracy and usefulness.
Acknowledgments: Special thanks to breakingintowallstreet.com for providing the Otis case study and to the financial community for their insights and contributions to financial modeling practices.