(TCO A, B, C) Bug Bastion Village, a student apartment complex, generates effective gross income of $26,000. Income tax savings are $12,500 (due to interest and depreciation expense, the owner's income

tax liability for the year is $12,500 less than it would have been without the investment). There are no capital transactions, and all operating expenses were tax deductible. The after-tax cash flow to the equity investor was $13,800, and operating expenses equaled 90 percent of net operating income. What percent of net operating income is needed to cover the debt service obligation? Present the property's operating statement in good form.

Please explain the problem using excel