Computation how to?

 :: General :: Help Line

View previous topic View next topic Go down

Computation how to?

Post by learn3d on Sat Apr 27, 2013 6:10 am

Guys pano ba magcompute ng loan sa pagibig? For example
Loanable Amount 1000000
Repricing Period 10 years at 10%
Terms 10 years
Principal & Interest Php 13,215.07

Ang lumabas eh Php 13,215.07
Di ko alam pano nakuha yan Php 13,215.07. Anong formula ginagamit nila?

Ang compute ko kasi is 1000000/120 months = 8333.33 x 1.10(10%) = 9166.663
Medyo malayo ang nakuha ko. Hehe. So may computation ang banks and pagibig na di ko naiintindihan.

learn3d
CGP Newbie
CGP Newbie

Number of posts : 99
Age : 37
Location : earth
Registration date : 24/09/2012

View user profile

Back to top Go down

Re: Computation how to?

Post by render master on Sat Apr 27, 2013 7:17 am

ahhh nag-aacumulate kase yan monthly try this on your MS Excel

formula:
=PMT(A1/A2, A3*A2, A4)

1. sa cell A1 input the interest rate ( say .10)
2. sa cell A2 enter the number of payments in a year (say 12)
3. sa cell A3 ilagay kung ilang years of payment
4. sa cell A4 ilagay ang loanable amount
5. sa cell A5 ilagay iyong formula sa taas

its the basic calculation, and it will varies kapag nagbayad ka more than the said amount kung ano lumabas sa formula. the same thing din kung nadelay or hindi ka nakapagbayad. the computer will generate that amount based on the present status. it will recalculated

hope it help.

_________________
http://rendermaster.blogspot.com/
avatar
render master
Game Master
Game Master

Number of posts : 3268
Age : 96
Location : riyadh, saudi arabia
Registration date : 27/09/2008

View user profile

Back to top Go down

Re: Computation how to?

Post by russelyacat on Sat Apr 27, 2013 7:31 am

ito sir baka makatulong Very Happy

http://www.docstoc.com/docs/7129491/Pag-ibig-loan-computation
avatar
russelyacat
CGP Apprentice
CGP Apprentice

Number of posts : 800
Location : gapan nueva ecija
Registration date : 06/02/2012

View user profile http://russelyacat.wix.com/rusviz

Back to top Go down

Re: Computation how to?

Post by learn3d on Sat Apr 27, 2013 8:43 am

Thanks rendermaster. Ito hinahanap ko actual formula kahit estimate.
Kasi baka personal loan nalang sa friend pero ang basis is pagibig computation pero at 6% lang 10 years to pay. Sorry ano ang PMT?

Thanks russelyacat will check the link too.

learn3d
CGP Newbie
CGP Newbie

Number of posts : 99
Age : 37
Location : earth
Registration date : 24/09/2012

View user profile

Back to top Go down

Re: Computation how to?

Post by one9dew on Sat Apr 27, 2013 8:54 am

sir pm me your email thumbsup i will send you the brochures/interest rate/qualifications/excel files in applying pag-ibig loan thumbsup
avatar
one9dew
CGP Apprentice
CGP Apprentice

Number of posts : 817
Location : M.E./G.T.C./I.N./I.S.
Registration date : 06/03/2010

View user profile

Back to top Go down

Re: Computation how to?

Post by render master on Sat Apr 27, 2013 9:56 am

learn3d wrote:..... Sorry ano ang PMT?

its an excel formula for finance, no define meaning for the abbreviation.

_________________
http://rendermaster.blogspot.com/
avatar
render master
Game Master
Game Master

Number of posts : 3268
Age : 96
Location : riyadh, saudi arabia
Registration date : 27/09/2008

View user profile

Back to top Go down

Re: Computation how to?

Post by JVT_Ltd on Sat Apr 27, 2013 8:48 pm

one9dew wrote:sir pm me your email thumbsup i will send you the brochures/interest rate/qualifications/excel files in applying pag-ibig loan thumbsup

paki na din simply_john_carlo@yahoo.com.ph thanks...
avatar
JVT_Ltd
CGP Apprentice
CGP Apprentice

Number of posts : 469
Age : 37
Location : Philippines
Registration date : 14/10/2010

View user profile

Back to top Go down

Re: Computation how to?

Post by one9dew on Sun Apr 28, 2013 12:44 pm

JVT_Ltd wrote:
one9dew wrote:sir pm me your email thumbsup i will send you the brochures/interest rate/qualifications/excel files in applying pag-ibig loan thumbsup

paki na din simply_john_carlo@yahoo.com.ph thanks...

sir john na email ko na check niyo na lang thumbsup
avatar
one9dew
CGP Apprentice
CGP Apprentice

Number of posts : 817
Location : M.E./G.T.C./I.N./I.S.
Registration date : 06/03/2010

View user profile

Back to top Go down

Re: Computation how to?

Post by Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 :: General :: Help Line

 
Permissions in this forum:
You cannot reply to topics in this forum