FSAP_Requirement_3
Description
Fix / correct your Income Statement numbers in your current (permanent) template from FSAP Requirement 2. You will submit your corrections along with FSAP Requirement 3.
You will receive an email containing the Balance Sheet for your company. In your current (permanent) template create a new tab and rename it to Balance Sheet. Copy the entire Balance Sheet tab that I send you into this tab. Now your file will contain both the Income Statement and Balance Sheet.
- For your competitor, extract Balance Sheet information from the SEC Edgar database, fill out the two columns (prior year, current year).
- In the tab Ratio OUTPUT_1A complete the following ratios for your company.
- Return on Equity (ROE)
Return on Assets (ROA)
DuPont Disaggregation:
- Return on Sales (ROS) aka Profit Margin
Asset Turnover
ROA = multiply ROS * Asset Turnover (use formula)
Financial Leverage (FL)
ROE = multiply ROA * FL (use formula)
Add another column (with a blank column in between) to develop ratios for your competitor company. In this column develop, all the ratios (for Income Statement and Balance Sheet) we have done so far for your designated company.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."