ExcelBanter - How to calculate rentals?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to calculate rentals? (https://www.excelbanter.com/excel-discussion-misc-queries/120134-how-calculate-rentals.html)

[email protected]

How to calculate rentals?

I have the following info for a construction of property:

total Loan amount: 100000
Interest rate : 8%
Loan duration: 10 yeras
How i calculate the rent to be charged from the tenants on renting this
property using excel

Reply ASAP

Don Guillett

How to calculate rentals?

Homework?

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
I have the following info for a construction of property:

total Loan amount: 100000
Interest rate : 8%
Loan duration: 10 yeras
How i calculate the rent to be charged from the tenants on renting this
property using excel

Reply ASAP

[email protected]

How to calculate rentals?

wrote:
I have the following info for a construction of property:
total Loan amount: 100000
Interest rate : 8%
Loan duration: 10 yeras
How i calculate the rent to be charged from the tenants on renting this
property using excel

Well, you really do not provide sufficient information for that
purpose. At the very least, you want to cover the monthly cost of the
loan, which is probably what you have in mind. You can approximate
that with:

=pmt(8%/12,12*10,-100000)

But that is only the tip of the iceberg. You will also want to cover
insurance costs, property tax and estimated maintenance costs. But you
will need to balance that against local competition.

All times are GMT +1. The time now is 05:02 PM.