Help with ER Question
I need help on a question for school and was hoping some of you fellow posters could help me out. Basically, I need to build an income statement/net earnings/eps model in Excel. I have to provide at least five years of history and two years of projections, while making sure the assumptions behind my forecast are clearly presented and explained. The model has to be based on the same format as traditional net income and earnings per share models found in the majority of stock analyst's reports.
I am not really even sure where to start, beside gathering the five year history. I am not familiar with what a traditional net income and earnings per share model looks like. And I do not know how to go about figuring the two year projections. Any help would be very much appreciated.
go to SEC.gov and look up random company's filings. As for the projections and assumptions, it'd depend on the company
The company is Dell.
Get 5 year hisotricals off the 10-Ks and base projections on publicly available analyst estimates or just make up your own BS assumptions (sales decline by 20%, increase expenses at the rate of inflation, decrease margin by 50 bps each year, etc.)
Provide macro commentary (retail headwinds, consumer discretionary down, etc.) etc. get it from the MD&A section of the latest filing or make it up
Your "model" with literally be 8 columns (line item detail, FY04A, FY05A, FY06A, FY07A, FY08A, FY09E, FY10E to project you obviously just do last year's value * (1+%increase), hold steady (= last year's cell to the left), or common size (based on balance sheet ratios)
Actually, Dell is probably cutting the sht out of the company so expenses should decline and gross margin will likely take a hit as the company discounts to drive top line
Just out:
"Dell quarterly profit fell 63% as the recession crimped computer sales around the world." -WSJ
That should help you a bit, haha
Build multiple scenarios that can drive the model - I like using the offset function.
The 10-k and 10-Qs should provide good guidance for management's expectations, which can be your 'base' scenario. Most models use sales growth as the primary driver, along with gross margin % and SG&A. If you can access any existing research reports on Dell, they'd be extremely helpful.
I'd imagine this is a group project?
Occaecati aut ex pariatur saepe odit iste. Est aut voluptatem expedita sint eum. Mollitia voluptas qui debitis excepturi. Est consequatur omnis exercitationem.
Quam ea excepturi quo nesciunt aliquid assumenda. Optio laborum repellendus velit cupiditate. Dolore est eligendi qui rem eum nobis consequatur atque. Cumque maxime fugiat sed et aut saepe.
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...