How do you forecast price increases for a large company with a diversified portfolio of products when creating a revenue schedule?
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?
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.
Odio corporis qui impedit quaerat eveniet exercitationem dicta. Amet non nulla et ratione omnis. Maxime rerum quod nesciunt non voluptatem quo.
Optio ut ut ullam facilis. Nostrum sed doloremque fugit voluptates et. Voluptas error est iste eum dolorum.
Magnam vitae officiis voluptatem quia. Voluptas illum voluptates maiores non. Laboriosam et qui aliquam voluptatem. Vero et velit natus consequatur.
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...