$*$I know that this is a long question to ask, but if you can help me on this, I will appreciate it so much and

give you a thumbs up no matter what the results is gonna be$.$

Scenario: We are analyzing a potential investment property, a $8,400$ sq ft$,2$ floor, multi$-$use property next to a

university. The first floor is a convenience store and caf$,$ the second floor is residential.

$1.$ Create an Excel worksheet for the Discounted Cash Flow Analysis and project NOI for the investor$$s holding

period from the Following Informations. $($Use Assumptions for the number that you think is missing$)$