bank loan help!!

[dynamite1234]

bank loan gana help 1 dipan...


onne mekai prashne mchnla;

1. loan eka = Rs 900,000
2. poliya = 5%
3. payment time = 25 years


mata danaganna one maseta kiyak varika saha poliya gewanna oneda kiyala, mema gana hadana vidiya steps vidiyata liyala dapan hode...

 

[Profile_01]

බම්ප්

 

[STU26015]

බම්ප්

 

[nuwa11]

බම්ප්

 

[Richard Hammond]

total interest- rs 562500
monthly rental- rs 4875

 

[Athugala]

Rs 900,000
25 years
rate 5%

monthly rental: 5261.31
total Interest: 678393
Calculated according to reducing balance method.

 

[dynamite1234]

Rs 900,000
25 years
rate 5%

monthly rental: 5261.31
total Interest: 678393
Calculated according to reducing balance method.

steps tika liyala denawada?

 

[dynamite1234]

Rs 900,000
25 years
rate 5%

monthly rental: 5261.31
total Interest: 678393
Calculated according to reducing balance method.

5261.31 gatta vidiya liyapnko

 

[Athugala]

5261.31 gatta vidiya liyapnko

Use Excel PMT function in excel.

=PMT(5/1200,300,-900000)

5/1200 => 5% /12 => (5/100) / 12 = > 5/1200
300 = 12* 25
-900000 = 900000 cash out flow

 

[Lazy Lizard]

බම්ප්

 

[D-ICE]

https://www.vertex42.com/ExcelTemplates/loan-amortization-schedule.html


meke excel eka download karagena balapang..