ExcelBanter - effective gross income

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - effective gross income (https://www.excelbanter.com/excel-worksheet-functions/76420-effective-gross-income.html)

Ror

effective gross income

I would like to know the formula in excel to calculate the effective gross
income if I have the value, capitalization rate and the operating expenses.
Or what abriviations Excel uses for capitalization rate and effective gross
income

Chris Marlow

effective gross income

Hi,

I'd look in Excel help for Financial functions - there is a range of NPV/IRR
type calculations one of which may meet your need.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master

"Ror" wrote:

I would like to know the formula in excel to calculate the effective gross
income if I have the value, capitalization rate and the operating expenses.
Or what abriviations Excel uses for capitalization rate and effective gross
income

All times are GMT +1. The time now is 11:15 PM.