CASE - 1	A model for Company UltraX is given in the question which operates a restaurant in the evening and party hall in the morning shift
A)	Illustrate the loan payment schedule based on the following information given below	10
1	Bank will provide term loan for 75% of the project value
2	Debt will be disbursed in 3 stages
	Stage I - 50% of the debt
	Stage II - 25% of the debt
	Stage III - 25% of the debt
3	Interest rate applicable is given in the sheet
4	Moratorium period and the loan repayment period is given in the sheet
B)	Reconstruct the model by incorporating the debt nuances into the model	10
1	Do the necessary interest adjustments
2	Do the necessary payment adjustments
3	Incorporate the changes to complete the FA schedule, Depreciation Schedule, Income Statement, Cash-Flow and Balancesheet
C)	Complete the Ratio sheet and Interpret the ratios	5
1	Debt service coverage ratio, Debt Equity Ratio and Current Ratio
2	Do the interpretation of the ratios in the space provided for the same

Please provide the answers in excel format with relevant explanation