Announcement

Collapse
No announcement yet.

ATS Kocoon, ATS, Sector 109, Gurgaon

Collapse
X
Collapse

ATS Kocoon, ATS, Sector 109, Gurgaon

Last updated: May 27 2019
6003 | Posts
  • Time
  • Show
Clear All
new posts

  • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

    Originally posted by anuj2703 View Post
    Cool No worries mr vb.

    Rummy ji aapki izzazat hai excel ke liye ? yaar mana mat karna warna mei bana nahi paonga spreasheet, will make "s o f t w a r e" instead
    :-)...................
    Nothing Surprises Me

    Comment


    • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

      Builders should incorporate an IRR CD with BBA

      Hi
      Greetings

      It is becoming such a necessity now to check IRR. Most people check after they have handed over the money to the builder

      It would be a good suggestion for the builder to hand over a CD with different patterns of IRR
      With Dp
      With CLP
      With different rate of Interests
      With rental income
      What if super area is increased?
      What if EDC increases?
      What if I dont pay penalty for late possession?


      This would also keep invested people busy for the next 6-7 years. Khelte raho agle 6-7 saal computer pe IRR vs IRR

      Cheers

      Comment


      • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

        Originally posted by anuj2703 View Post
        Cool No worries mr vb.

        Rummy ji aapki izzazat hai excel ke liye ? yaar mana mat karna warna mei bana nahi paonga spreasheet, will make "s o f t w a r e" instead
        Lo ji, attaching it here for everyone's use. There could be certain mistakes still, awaiting Amit001 bhai's response.

        I have put regt amt = 4 lac randomly, you can put the exact amount and the excel will reflect this adjustment in IRR/NPV calculation automatically.

        Cheers!
        Attached Files

        Comment


        • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

          Originally posted by rummy21 View Post
          Lo ji, attaching it here for everyone's use. There could be certain mistakes still, awaiting Amit001 bhai's response.

          I have put regt amt = 4 lac randomly, you can put the exact amount and the excel will reflect this adjustment in IRR/NPV calculation automatically.

          Cheers!
          thanks mate
          just few more call outs!!

          1) How much principal is being paid in 4 years?
          2). How much would be prepayment charge (generally 1 % of the loan value)
          3). If one exits after 4 years the registration cost will NOT be required?
          Nothing Surprises Me

          Comment


          • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

            Interesting note from the net

            http://www.rupeetalk.com/articles/ho...yment-plan.php
            Last edited October 20 2011, 03:55 PM. Reason: format
            Nothing Surprises Me

            Comment


            • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

              Originally posted by vb2309 View Post
              thanks mate
              just few more call outs!!

              1) How much principal is being paid in 4 years?
              2). How much would be prepayment charge (generally 1 % of the loan value)
              3). If one exits after 4 years the registration cost will NOT be required?
              1. The entire principal is paid back along with the interest when one pays EMI. During the initial years, interest paid is more (it becomes lower every year) & principal is less (it increases every passing year).

              2. Prepayment charges, I believe have been scrapped off completely recently. But you can still confirm on this one.

              3. No, I think registration cost has to be borne by the person holding the property at the time of registration.

              Comment


              • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

                Originally posted by rummy21 View Post
                Lo ji, attaching it here for everyone's use. There could be certain mistakes still, awaiting Amit001 bhai's response.

                I have put regt amt = 4 lac randomly, you can put the exact amount and the excel will reflect this adjustment in IRR/NPV calculation automatically.

                Cheers!
                ah! nicely made calulation sheet.

                Only clarification that I need, this sheet assumed that cashflow at the end of every yea is 1795056. Is that correct ? as the cashflow is happening at the end of every month and not at the end of year.
                This calculation gives an inflated value of IRR.

                So either, to see the worst case bring the outflow at the beginig of year or take an average of worst and best case.

                Please correct my understanding if I am missing something !

                Comment


                • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

                  Originally posted by vikash.kumar View Post
                  ah! nicely made calulation sheet.

                  Only clarification that I need, this sheet assumed that cashflow at the end of every yea is 1795056. Is that correct ? as the cashflow is happening at the end of every month and not at the end of year.
                  This calculation gives an inflated value of IRR.

                  So either, to see the worst case bring the outflow at the beginig of year or take an average of worst and best case.

                  Please correct my understanding if I am missing something !
                  Yes, in case you want to know the exact IRR, one will have to discount EMI on a monthly basis. But this gives a good idea as to what your return will be.

                  Moreover, in case of cash flows at the beginning of the year, the IRR increases to ~23%.
                  Reason: Since we are paying at the beginning of the yr, we will also inherently assuming that we will receive the sale inflow at the beginning of the year. Therefore, we're making an exit at the same price but at the beginning of 5th yr (or end of 4th yr) thereby saving 1 year of holding the property and thus, higher return!


                  Hope it clarifies.

                  Comment


                  • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

                    Good read on the subject of CLP and DP

                    you may consider reading these articles:

                    Real Estate Payment Plans - Time-Linked vs. Construction-Linked - iTrust
                    Nothing Surprises Me

                    Comment


                    • Re : ATS Kocoon, ATS, Sector 109, Gurgaon

                      Got a news from ATS Management (through a bank that will be giving loan): ATS to be launched at 4500 DP and 5000 CLP...Supposed to be better than ATS green project...

                      The best club house on DEW e.t.c.....

                      Comment

                      Have any questions or thoughts about this?
                      Working...
                      X