Your group will conduct a comprehensive financial analysis of a publicly traded corporation and make a presentation to the Board of Directors (professor). Your professor will assign different industries to each group and your group will select a firm from within the industry assigned by the professor. Your financial analyses will be performed in Excel and the presentation will be prepared in PowerPoint. The Excel file must support the figures in your presentation. The results of the financial analysis will be presented in a professional quality audio-enhanced PowerPoint presentation, with the speaker's notes under each slide. Alternatively, at your professor's discretion, students may be invited to make a live presentation. Step 1: Prepare your Excel file All cells requiring computations must have a formula. Cell formulas should reference other sheets where appropriate. Complete all calculations in one Excel file; multiple sheets are encouraged.

Answer rating: 100% (QA)

Step 1 Prepare your Excel file Set up Sheets Create separate sheets for different sections of the financial analysis such as Income Statement Balance ... View the full answer