Please list step by step on how to do for the excel as well on top of the answers if you can. Thank you!

Homework In Excel Set up an Excel spreadsheet to determine value of a mixed use building: 1. Mixed-Use Building on Bedford Ave, Brklyn 2. Lot size 21,600 Sq Ft, FAR 4.2 3. 2 stores on ground floor, 480 SqFt entry hall not part of Retail leased space. 4. Resi Exp Ratio: 37% 5. Retail Leases $65/ft, Resi Leases $42/ft 6. Value at 4.5 cap, 5.0 cap & 5.5 cap. ace Homework In Excel Set up an Excel spreadsheet to determine value of a mixed use building: 1. Mixed-Use Building on Bedford Ave, Brklyn 2. Lot size 21,600 Sq Ft, FAR 4.2 3. 2 stores on ground floor, 480 SqFt entry hall not part of Retail leased space. 4. Resi Exp Ratio: 37% 5. Retail Leases $65/ft, Resi Leases $42/ft 6. Value at 4.5 cap, 5.0 cap & 5.5 cap. ace