Hello Guys,
Please advice on this:
How do i find a historic pattern between and construction spending... I am trying to forecast prices for copper prices.
and if I come up with the number how do i adjust in to my sales and balance sheet (inventory) since copper is part of raw materials?
Thanks a bunch!!!
| +150 | Return Rates For Interns Are Falling? | 47 | 3h |
| +128 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 7h |
| +84 | I am a drunk MD AMA | 36 | 3h |
| +73 | London IB BB is a challenge | 41 | 3h |
| +61 | VP Lifestyle at Top BB Coverage Groups | 39 | 13h |
| +56 | An Outsider’s View of RX Banking Out of College | 6 | 1d |
| +48 | SharePoint makes IB hours HELL | 15 | 2d |
| +42 | momentum of Rx groups | 15 | 16h |
| +39 | Fired during interview | 8 | 20h |
| +30 | Weird Majors->IB ? | 22 | 13h |
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.
-Research yearly housing data (cost, growth..) -Research yearly copper prices (if not find another commodity with strong correlation and substitute appropriately) -Plot your findings -come up with an estimate of the relation between the housing data and copper data - recognize current trends in both housing and copper prices -use that estimate in you calculation of future trend for copper prices
hope this helps
just put a few years worth of date for copper pricing and industrial spending into excel. run a regression and find the correlation.
I am sorry im weak at this but how do u run a regression and a correlation... I know the funtion in excel but... an example would be great..
does an y body have an example of similar case.. sorry for being a pain.. just trying to learn..
minitab is a good software :)
Use Linest function.
google it dude, its not that hard, dont feel like explaining it.
Impedit voluptatem nam deleniti debitis quos sequi est. Aut dolor aspernatur aut nobis itaque tenetur. Quo quas sed temporibus provident consequatur quidem voluptas ut. Deleniti quo ad quia et eos dolore.
Cumque ut eum et eum eos magni tenetur quidem. Repellendus rem saepe qui sit sit.
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...