Excel spreadsheet

I need to put together a spreadsheet that shows how much income or rent i need to bring in to pay off my loan against the property.

I will send through a spreadsheet that shows estimated rents for both a 1 and 2 bedrooms increasing at a rate of 2% per annum. please ignore anything more than the first 54 apartments as the rest are not built yet. i will also send through payment schedules.

We are borrowing $13.5m in total at a rate of 3.25% fixed interest only for the first 24 months. Thereafter we have a 20 year facility and are paying US prime rate minus 2.25% so totalling a 21.5 year facility including our interest-only period.

This borrowing is split into 3 facilities that don't have early repayment penalties.

Facility a) 8.162m
Facility B)$1.038m
Facility C)$4.3m

Facility b and c will be paid off on the sale of a home within 2 years. I would like to see how this affects our payment schedule.

I have attached the Net income schedule for Mayfair estates that we will have facility C levied against it. This should increase quote substatially but we need to see our position as a worst case .

Facility B is land so has no income

Facility A is 54 apartments and we need to see what this property needs to produce in order to make sure all facilities are clear and paid at a minimum.

Regards,

Chris