5 years terms but going to pay cash for just 2 years...

[RF02]

just now, tumawag ako wala parin daw.

i-email daw sa kanya (bank manager) tapos iforward daw nya sa email ko pag dumating na...

- - - - - - - - - - - - - - - - - - - - - -

just now, tumawag ako wala parin daw.

i-email daw sa kanya (bank manager) tapos iforward daw nya sa email ko pag dumating na...

[RF02]

*TS, loan computation pretty much had been standardized by BSP to be in line with global financial industry. Hence, to get the information you required, you can follow this steps:

1. Open MS Excel on your PC.
2. Select Open, then find "installed templates", then look for the "Loan Amortization"
3. Enter the following details
- Loan Amount (not the value of the car, but the actual amount you financed with the bank)
- Annual interest rate (this I think should be reflected in your contract. note that this is annual, do not use the interest rate for the whole 5 years as the output will be wrong)
- Loan period in years. in your case = 5
- Number of payments per year = 12
- Start date of loan - input date when you started the loan, but doesn't really matter much in computation of the amount as you only need to see the amortization table (payment and interest for each month).
- Optional Extra payments - leave blank
4. Assuming that you have not paid the 24th month yet and you will to settle everything, your payment will be the total of the following
- "Scheduled payment" on "Payment No." 24
- "Ending Balance" on "Payment No." 24

The above computation excluded per-termination and other fees that the bank may add.

Also, you may notice that your principal did not reduced significantly yet, this is because banks will prioritize interest payments to get as much profit as possible and they foresee that a lot will per-terminate their loans - so get they get the interests early.
HTH

Hi sir, hindi ko mahanap yan LOAN Amortization sa excel ko haha


pero sir may nahanap akong Amortization schedule from my bank na pinadala sakin tru mail after ko mag loan.

yun Outstanding Balance for the month of June 2015, yun po ba yun bbyaran ko pag iccash ko na yun unit this month? or may additional or less pa po yun?

[garic]

Outstanding Balance (also sometimes called as Remaining Balance), plus the monthly amortization for June 2015 are the amount you have to pay

Some banks add pre-termination fees, registry of deeds fee, and other fees. But this should not be substantial

[ar2roph]

Sir ganito, first what bank po ba naka-loan ang car ninyo? Different banks have different interests and 5 years loan have different interest rate from 2 years.

Bale siyempre 80% ng car amount ang loan mo sa bank and definitely alam mo interest for 5 years. Compute mo ngayon sir ang magiging interest ng 80% in 2 years lang then compute mo magkano na lahat naihulog sa 2 years monthly amortization mo then subtract mo yan sa computed 2 years interest, dapat hindi na lalayo dyan babayaran mo.

Talk to the business manager of the bank kung saan kayo nag-loan and discuss nyo yan concern nyo and dapat ire-compute ang babayaran nyo to just 2 years interest.

Hope this help sir.

Thank you

Hi guys... i really need your help..


baka meron po marunong mag compute kung paano malalaman magkano nalang bbyaran ko sa pickup ko naka bank loan sya for 5 years, pero bbyaran na ng cash this month saktong 2 years sya..


kahit estimate lang kahit hindi exact...


nag tanong kasi ako sa bank kung san naka loan yun sskyan, last month pa upto now hindi parin sya makabigay ng exact amount kaya nagdududa na ako.. eh sa previous car namin (caso in-house financing) ilang araw lang may final amount na agad.


i-pm ko po sayo yun details kung alam nyo po computation...

thanks in advance!

[RF02]

Outstanding Balance (also sometimes called as Remaining Balance), plus the monthly amortization for June 2015 are the amount you have to pay

Some banks add pre-termination fees, registry of deeds fee, and other fees. But this should not be substantial

copy sir, ang dali lang pala malaman inabot na ng halos 1 month yun kausap ko wala parin mabigay bigay na amount

Thanks po sir!!

- - - - - - - - - - - - - - - - - - - - - -

Outstanding Balance (also sometimes called as Remaining Balance), plus the monthly amortization for June 2015 are the amount you have to pay

Some banks add pre-termination fees, registry of deeds fee, and other fees. But this should not be substantial

copy sir, ang dali lang pala malaman inabot na ng halos 1 month yun kausap ko wala parin mabigay bigay na amount

Thanks po sir!!