Ford Stock Price Analysis

Description
This is an extensive 3-statement model to derive a fair price of Ford to determine a buy/sell/hold recommendation. This model includes a bottoms-up revenue projection, debt schedule, PP/E schedule, WACC calculation, and timing anlaysis. The model operates at a quarterly level, taking into account historical revenue timings for the company. Additionally, the model takes into account an upside, base, and downside scenario that is easily filtered with a dropdown menu. The first three tabs of model are 1. Annual Revenue, 2. Quarterly Revenue, and 3. Timing. The next three tabs make up the 3-statement model including the 4. Income Statement, 5. Balance Sheet, and 6. Cash Flow Statement. The next two components of the model are where this model adds additional complexity and nuance then most modeling courses.  7. PPE: this tab breaks down the companies different long term assets and projects out growth or decline to each item.  8. Debt Schedule: This tab shows how Ford's different debt instruments will mature and the interest rate on each tranche. This allows the analyst to come up with a more specific interest expense outlook. Finally tab 9. determines the companies cost of capital and tab 10. walks through the DCF.  This file is far beyond the typical Wall Street Prep or CFI template, and is meant to help investors come up with an actual thesis on whether the stock is a buy or sell. 

Note*: The file contains 6 other tabs not shown in the preview.