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?
| +200 | 2nd casualty of BofA, 25 yo credit trader | 64 | 6h | |
| +179 | Associates not checking my work and getting mad at me? | 35 | 2d | |
| Am I insane? (NEED ADVICE) | 63 | 3m | ||
| +97 | How Much Parental Assistance Do People Actually Have? | 35 | 32m | |
| +87 | Is it appropriate to take time off after a breakup? | 24 | 15m | |
| +86 | the new "email template" | 29 | 47m | |
| +66 | Analysts bitching on WSO | 16 | 3h | |
| +60 | Fitness vs Traditional Watches (in Office) | 40 | 4h | |
| +60 | Why are UK, UK based and UK-countries related (India, Nigeria...) students so cringe on LinkedIn? | 22 | 4h | |
| +52 | How is Northwestern? | 15 | 1d |
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.
A qui itaque nesciunt necessitatibus. Reiciendis iure labore quos nihil quod eum. Voluptatem id et consequuntur inventore sit aut et. Enim ut sunt cumque reprehenderit laboriosam sint qui.
Vel quos libero et non culpa alias earum. Perferendis nulla sunt dolores omnis tempore aut. Est quod qui at maiores quas dolorum ea.
Maiores omnis sed temporibus voluptas et et autem odit. Aut maxime dolores necessitatibus dignissimos. Consequuntur modi quos porro doloremque vero. Et laudantium omnis recusandae autem.
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...