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!!!
| +67 | Any tips for sleeping well? | 36 | 6h |
| +50 | Wealthy Parents / Jaded | 13 | 14h |
| +40 | Background check issue IB Full Time | 21 | 13h |
| +36 | Venezuela Debt Restructuring - LAZ vs CVP | 12 | 5h |
| +34 | How are hours rn for SA (interns) | 21 | 3h |
| +28 | Q dealflow slowdown | 22 | 2d |
| +25 | HL vs WB | 19 | 17h |
| +24 | Investment Banking in Mexico | 6 | 4h |
| +23 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 11 | 18h |
| +22 | MM bottom bucket bonus | 9 | 15h |
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.
Omnis atque sunt explicabo voluptas. Numquam voluptas expedita voluptatem saepe fugiat labore. Illo dolor cupiditate blanditiis sunt aut. Rerum minima et saepe pariatur.
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...