Given the following information, calculate the capitalization rate for the following apartment complex: number of apartments:30;

market rent (per month): $1,250;

vacancy and collection loss: 5% of potential gross income;

operating expenses: 20% of effective gross income;

capital expenditures: 5% of effective gross income;

acquisition price: $5,550,000

Can you teach me how to do this on excel?