How to calculate rentals?

[rejir007]

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]

Homework?

 

[joeu2004]

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.