Help in developing the real estate net calculation

Closed - This job posting has been filled.

Job Description

Hi,
I am looking for an accounting/tax expert who can provide investment property net profit in every year for the duration of the years investors holds the property.

Below is the input you should consider
1)Value of the property,
2) Down payment amount
3)Closing cost amount
4)Interest rate
5)term
6)yearly/monthly expenses to maintain the property, appreciation rate, selling cost rate and also yearly income in the form of rent,
Rental increase, repair or insurance increase.
Tax bracket for 25% and 33%.


Provide a calculation in excel
1) To give yearly cash flow,
2) yearly remaining loan balance,
3) yearly appreciation,
4) what is the gross & net profit for the investors for each years. consider the tax aspect and Also include the selling cost for the property.

Give the above calculation in excel spread sheet.