Loan Calculate Help.

sunlog

Well-known member
  • Dec 9, 2012
    3,520
    1,534
    113
    sri rajasinha adawiya
    machan man loan ekak ganna yanne rs.450,000. 17.25% interest eka (annually)
    5 years walata danne. interest eka adu wena widiyata. ;)
    maseta gewanna thiyenne 7500 + interest.
    5 years iwara weddi mulu interest eka hoyaganna kramayak thiyenawada? (formula ekak ) danna ekek help karapanko. :rolleyes:
     

    eshanx

    Well-known member
  • Mar 16, 2008
    3,104
    149
    63
    38
    K_City
    Loan eka ganna yana bank eka mokakda ban??? matat loan ekak ganna ona personal lons dena banks monada ban tiyenne low interest rates walata ???
     

    roshan18u

    Active member
  • Apr 24, 2009
    229
    78
    28
    1. Excel Open karanna
    2. left hand side eke yatama Sheet 1 eka right click karana insert click karanna
    3. spreadsheet Solutions tab ekata yanna..
    4. Loan Amortization select karala Ok karanna....
    5. Loan eke detail enter karanna witharai thiyenne....


    Total interest : Rs 244,654.33
     
    Last edited:

    sunlog

    Well-known member
  • Dec 9, 2012
    3,520
    1,534
    113
    sri rajasinha adawiya
    1. Excel Open karanna
    2. left hand side eke yatama Sheet 1 eka right click karana insert click karanna
    3. spreadsheet Solutions tab ekata yanna..
    4. Loan Amortization select karala Ok karanna....
    5. Loan eke detail enter karanna witharai thiyenne....


    Total interest : Rs 244,654.33

    ela thanks machan.. :yes::yes::yes: