Please Solve In Excel

1. A 28-unit apartment building is offered for sale at $325,000. If it is purchased for the asking price, subject to its existing $204,500 mortgage expect the following outcome during the first full year of ownership: loan balance, an investor in the 28% marginal income tax bracket can UNIT 12 Traditional Measures of Investment Worth Potential gross rent Plus: Miscellaneous income $74,760 420 $75,180 3,759 $71,421 40,060 $31,361 25,334 $6,027 837 9,060 ($2,196) 0.28 ($615) $6,027 615 $6,642 Based on the first-year forecast and assuming the property is purchased for the asking price, compute the following: a. The potential gross income multiplier b. The net income multiplier c. The operating ratio d. The break-even ratio e. The debt-coverage ratio f. The overall capitalization rate g. The cash-on-cash rate of return Less: Vacancy allowance Effective gross income Less: Operating expenses Net operating income Less: Debt service Before-tax cash flow Plus: Principal paid Less: Cost recovery allowance Taxable income (loss) Times: Marginal tax rate Income tax (tax savings) Before-tax cash flow Plus: Tax savings After-tax cash flow h. The broker's rate of return