loan amotization
This query is : Resolved
06 April 2011
dear sir how i can use pmt function in excel sheet for loan amotization
07 April 2011
Excel PMT function can be used to calculate loan installments where installments are of equal amount.
Just use the following steps:
let Loan amt - 500,000
Interest rate PM - 1% (per month rate as inst. are of monthly basis)
Present value of Loan= loan amt- any down payment, Let 500000-100000(down payment)=400000
Calculation=
=PMT(loan,rate,PV)
that give u Monthly installment amt..
Just use the following steps:
let Loan amt - 500,000
Interest rate PM - 1% (per month rate as inst. are of monthly basis)
Present value of Loan= loan amt- any down payment, Let 500000-100000(down payment)=400000
Calculation=
=PMT(loan,rate,PV)
that give u Monthly installment amt..
07 April 2011
dear sir thanks for help but i am not able to understand so please give me some example for pmt function in excel
i want calculate monthly installment for one year for loan amount one lack rupees
thanks
i want calculate monthly installment for one year for loan amount one lack rupees
thanks
07 April 2011
give me ur id i will send excel sheet with calculation. also send the interest rate charged by lender.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Section 54F - Exemption on LTCG in 2026 for HP purchased in 2023
- STCG....................................................
- TAN for Partnership
- AMOUNT RECEIVED UNDER COMPULOSRY ACQUISITION OF AGRICULTURAL LAND
- Sales return eway bill
- Taxation on LTCG for property sold after 24JUL2024
- AY 26-27 ITR-4 FILING U/S 44-ADA
- Plot of land. Cost of Acquisition
- LTCG for Assmt year 26-27
- REGARDING GST LIABILITY/....
- Free lancer income
- Long Term Service award taxability in hands of company
- Standard Deduction claim for EPFO Pension and ICICI Prudential Life Annuity
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- Nomination of Bank for refund in itr 2
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
