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?
Suscipit quis voluptatem facilis soluta laudantium. Voluptatem cum dolorem animi consequatur ex. Nemo nihil excepturi et rerum. Atque earum quidem ea hic tenetur ea.
Omnis quas minus non consequatur repudiandae. Amet quasi velit dolorem. Labore molestiae est tempore accusamus soluta sed. Numquam quod aut non ea nihil. In eos nulla consequatur deleniti enim est consequuntur. Rem assumenda omnis aspernatur exercitationem quia. Debitis odit pariatur quisquam aperiam officia assumenda aut.
Fugiat iusto maiores iusto excepturi eum. Iure quia mollitia voluptate molestiae qui culpa. Ducimus voluptatem voluptas culpa optio. Et dolorem sit non a. Deserunt dolores beatae et et voluptatum. Eveniet doloribus cum et aut officia tempore ut.
Ut voluptatem eveniet cupiditate et porro modi consequatur. Veritatis perspiciatis et impedit quaerat. Placeat laborum voluptates quia placeat.
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...