How to calculate rentals?

  • Thread starter Thread starter rejir007
  • Start date Start date
R

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
 
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
Click to expand...

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.
 
Back
Top