• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Real Estate Cashflow Generation

D

DV

New Member
Hiii


Greetings!!!


I have a worksheet with the following parameters

a) Sales Projected

b) Project Schedule

c) Payment Plan

A payment plan is to be derived by taking the following criterias:-


• When a person buys a unit he has to pay the cumulative percentage(multiplied by Bsp ) till date according to the payment plan.


• The rest will be paid according to the schedule the start dates of which has been shown in the sheet.


A cashflow is to be generated by using some formula. I can not figure that part out.


Spreadsheet attached for reference.


http://speedy.sh/39hNQ/Excel-Cashflow.xls.xlsx


Kindly advice.


Regards,


Deependra
 
Drop box link for the same file


https://www.dropbox.com/s/o8k8khbpr35nqua/Excel%20Cashflow.xls.xlsx
 
Hi DV,


Can you explain the sheet with an example how things are done in it, can't understand the notations/terminology in this sheet.


Regards,
 
Hi, DV!


Please check these questions:

a) what's S39 intended to mean? date of what?

b) all units are 2000 sqft and the price is the same for all units and will be the same during the whole project (48 months)?

c) units are sold during the 48 months according to % of 17th. row?

d) cashflows usually have two components, incomes and expenses; in the below Inflow table you're just registering first one?

e) what are Tn, how do they apply to calculations, and how are they tied to the % of 17th. row?


Regards!

f)
 
You must log in or register to reply here.
Back
Top