Question
. My recommendation is to use Yahoo Finance. Has tons of information on each company. 6. Complete Income Statement section first. 7. Complete Balance Sheet
. My recommendation is to use Yahoo Finance. Has tons of information on each company. 6. Complete Income Statement section first. 7. Complete Balance Sheet section. 8. Use Quad Graphics Data FIRST. Replicate my EXACT w/s. 9. Once you have replicated all my equations, now drop in your company data. 10. Once you have completed one company, just copy w/s into 2 new tabs. 11. Lather, rinse, repeat :-) 3. My recommendation is to use Yahoo Finance. Has tons of information on each company. Just click on COMPETITORS link to find out key competitors. 4. Download Income Statement Data and Balance Sheet Data into a new Excel w/s. 5. Start building the framework. 6. Complete Income Statement section first. 7. Complete Balance Sheet section. 8. Use Quad Graphics Data FIRST. Replicate my EXACT w/s. 9. Once you have replicated all my equations, now drop in your company data. 10. Once you have completed one company, just copy w/s into 2 new tabs. 11. Lather, rinse, repeat :-) Hi, I have an assignment similar to my friend's Karthik, whom you did last week. If u remember the STEPS, i just need step 1,2 & 3 only. I have already the base excel in which you have to fill the financial values and make it convincing. (like the assets and liabilities figures should be same and all that ) Please find the excel attached. My main company is american airlines and the competitor is Southwest Airlines. Please take its financial info from Yahoo finance and fill the sheets. I also have formulas in place but please check it once. I can better explain when you are available. Please let me know. I need it asap and I think you wont take much time as you already worked on the same assignment before. you have to work on 2,3,5,6,7 tabs in the excel. tab 1, tab 4 are replicated from my professor given sheet, so u need not work on it. I copied tab 1 info to tab 2 and tab 3 for both the companies asusal, if u change the financial numbers the rest will change.
please let me know if you have any questions
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started