please show how to work in excel spreadsheet. This must be completed with excel so i can learn how to input things into excel for class and test purposes moving forward.

8.1 A city is trying to decide whether to build a parking garage. An engineering plan calculates that it takes a year to build at a cost of $2 million and $200,000 per year to operate. An in-depth analysis of operating revenue determines that the garage will start to earn revenues of $500,000 per year in the second year. The city is interested in knowing whether this project will be profitable (BC>1) over the next eight years (counting the year of construction) at 10%. The proj- ect's B/C ratio over the eight-year period is closest to (a) 0.77 (b) 0.87 (c) 1.33 (d) 2.50