Answer in Excel Please!

Part $1-$ Direct CapitalizationIn the first part of the assignment, you will apply the direct capitalization method to value an income$-$producing property. Use the following assumptions to value the property.Acquisition Assumptions$*$ Purchase Price: $$1,500,000$ Operating Assumptions$*$ Vacancy and Collection Loss $($V$/$L$)$ as a $\%$ of PGI: $4\mathrm{.}00\%*$ Operating Expenses $($OpEx$)$ as a $\%$ of EGI: $25\mathrm{.}00\%*$ Capital Expenditure $($CapEx$)$ as a $\%$ of EGI: $3\mathrm{.}00\%$Exit Assumptions$*$ Exit Cap Rate: $5\mathrm{.}50\%*$ Sales Costs: $3\%*$ Year $2$ NOI $$97,000$ Note: rent roll assumptions are already in the Excel Template.Part $2-$ Discounted Cash Flow $($DCF$)$In the second part of the assignment, you will use both the direct capitalization and simplified DCF methods to value an income$-$producing property held for $5$ years and sold at the start of year $6.$ The property has an assumed vacancy and collection loss at $6\%.$ More details about the leases can be found in the simple rent roll below.Figure $1.$ A simple rent roll of an income$-$producing property.Acquisition Assumptions$*$ Purchase Price: $$1,800,000*$ Discount Rate: $10\%$Operating Assumptions$*$ V$/$L $(\%$ of PGI$)$: $6\mathrm{.}00\%*$ OpEx $(\%$ of EGI$)$: $25\mathrm{.}00\%*$ CapEx $(\%$ of EGI$)$: $3\mathrm{.}00\%*$ Rental Growth Rate: $4\mathrm{.}00\%$Exit Assumptions$*$ Exit Cap Rate: $6\mathrm{.}00\%*$ Sales Costs: $3\mathrm{.}00\%$