ExcelBanter - HELP! monthly recurring revenue

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

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

- - HELP! monthly recurring revenue (https://www.excelbanter.com/excel-worksheet-functions/6978-help-monthly-recurring-revenue.html)

DigtalMe

HELP! monthly recurring revenue

Does anyone know the formula for Monthly Recurring Revenue?

Currenty I use the following formula for NMAC (Net margin after capital).
NMAC = [NPV(MRR) + NRI
- NPV(DirectMRC) - Direct NRC
- NPV(OPEXMRC) - OPEX NRC
- NPV(CAPMRC)
- (NPV(MRR) + NRI) * 1.86%
-(NPV(MRR) + NRI - NPV(DirectMRC - Direct NRC) * 1.1%]
/[NPV(MRR) + NRI]

All times are GMT +1. The time now is 03:31 PM.