Draft a spreadsheet showing financial history and projected performance for the company( home depot) you plan to use in this course’s final project.

Financial model spreadsheet | Business & Finance homework help

Financial History and Projected Performance of Home Depot

FY 2018 FY 2019 FY 2020 FY 2021 FY 2022
Revenues $108.2B $110.2B $112.4B $114.8B $117.5B
Net Income $10.3B $9.934B $10.1B $11.067B $12.1 B
Operating Margin (%) (EBIT/Revenue) 8% 8% 8% 9% 10%
Return on Equity (%) (Net income/Shareholder’s equity) 22 % 20 % 21 % 23 % 25 %

Projected Growth Rate: 12-13% p/a in revenues and net income over the five years projection period, as well as 0-1 percentage point increase in operating margin each year, ending with an operating margin of 10%. Return on Equity would be expected to increase by 2 percentage points each year, ending with a return of 25%.