$*$ 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$.$ If you feel like you miss a certain information in order to complete the calculation, please feel free to make up any number.

Scenario:

We are analyzing a potential investment multi$-$use property next to a university. The first floor is a convenience store and caf$,$ the second floor is residential.

We finally received the additional information we need to perform our due diligence and, just as you thought, the parking lot behind the building is included in the sale of the property.

Please use the Attached information to solve the questions.

Questions:

$1.$ Calculate the Discounted Cash Flow for the next $5$ years in an Excel Format. And please include the following points; Potential Growth Income, Vacancy & Credit Loss, Effective Gross Income, Operating Expenses, Net Operating Income, CapEx Allowance, Net Cash Flow, Discounted Cash Flow $($DCF$).$