I am trying to build a revenue schedule for Ford and would like to know how it is possible to model price increases of their products. Since Ford manufactures so many cars, I dont really know where to start. Is it accurate to find the average price of all their vehicles and use that to forecast?
| +273 | Earliest you can get fired | 58 | 1d |
| +254 | Investment Banking is Divine | 40 | 1d |
| +218 | Another $115bn Mega deal for these banks. Congrats! | 45 | 1d |
| +215 | US 2027 SA IB worried about background check | 53 | 1d |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 2d |
| +131 | Is UBS really that bad? | 38 | 1d |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 17h |
| +27 | FIG Pigeonholes you - is it true? | 8 | 1d |
| +27 | 2026-27 IB Energy Top Banks | 8 | 1d |
| +25 | How do you manage nerves in IB technical interviews? | 7 | 1h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
bump
That is accurate but more detailed then I’d care to do. You certainly can do it by individual car but there is no real need to. Sure. You get hyper-specific on the numbers but you’ll end up with a similar margin of error as doing the modeling at the vehicle type (ie - sedan, coupe, truck) level but you’ll have done a lot more work.
I would do sales by vehicle type and maybe geography.
Et asperiores minima dolores velit dolores. Ea unde quis omnis aut. Nulla at quia earum alias odit quia. Aperiam deserunt itaque consequatur inventore eveniet.
Sed veniam impedit et voluptatem odit similique. Numquam et sed ducimus repellendus veritatis deserunt. Quis quibusdam quidem veritatis quae occaecati.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...