Your basic task is to select a company, download the firm’s financial statements for the past 3 – 5 years, and perform complete a financial statement analysis for the firm. Most of the basic ratios are listed in chapter 3. Include as many as possible in your analysis. You don’t need to worry about Altman’s Z-Score or EVA. Your completed model should provide some flexibility (formulas should include cell references, not numbers) and be formatted in a manner that makes it easy for the reader to understand the major points. Your model should include the following to demonstrate your understanding: array formulas data validation Vlookup named ranges and/or cells IF(AND IF(OR use outline for the financial statements where and if appropriate cumulative average growth rate (CGAR) using GEOMEAN spark lines graphs other then spark lines where appropriate. (You might want to tie these to you narrative to feature the major points.) narrative to highlight the major points that you wish to bring out from your analysis
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
Need assignment help for this question?
If you need assistance with writing your essay, we are ready to help you!
Why Choose Us: Cost-efficiency, Plagiarism free, Money Back Guarantee, On-time Delivery, Total Сonfidentiality, 24/7 Support, 100% originality