$*$ 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.

Because the investor wants fixed monthly payments, there are only two options under consideration for financing: Fixed$-$Rate Commercial Loan and Interest$-$only. We received the investor$$s tax information and can calculate the tax effects to the cash flows.

$-$Please do all calculations in an Excel format for the next $5$ years

Questions:

$1.$ Calculate the loan information for both loan options $($Loan amount, annual debt service, and balance at end of holding period$).$

$2.$ calculate the tax liabilities for Operating Cash Flows and Sale of Property Cash Flows for the three loan options $--$ no loan, Fixed$-$rate loan, and Interest$-$only loan.

$3.$ Add the tax liabilities to the existing DCF $($Unleveraged$)$ worksheet and calculate the after$-$tax cash

flows and IRR.

$4.$ Add a Summary Table for these three points: BTIRR, ATIRR and Partitioned IRR