Net Return on Equity Calculator

Property Price *

Market Rent *

Mortgage LTV % *

Mortgage Interest % *

Service Charges *

Capital Requirement

Mortgage Debt

Yearly Mortgage Interest

Net Saving

Net Return on Equity

The equations necessary to make this calculator function are as follows:
Cell C8: =SUM(C3*((100-(C5*100))/100)+(C3*0.06))
Cell C9: =SUM(C3*C5)
Cell C10: =SUM(C9*(C6/100))
Cell C11: =SUM(C4-C7-C10)
Cell C12: =SUM((C11/C8)*100)-(6/C2)