loan amotization
This query is : Resolved
06 April 2011
dear sir how i can use pmt function in excel sheet for loan amotization
Kuldeep Verma
(Expert)
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
Kuldeep Verma
(Expert)
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
- Tax on Amount transferred in HUF Account
- Nursery business
- GST input credit on commercial property
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- GST REFUND ISSUE ON PURCHASE OF PLANT AND MACHINERY
- Working on Gold wastage during Melting of old gold jewellery
- TDS on Dashcam rent and allied services
- Subject: Legal Remedy for Removal of Income Tax Demand for AY 2024–25 – Charitable Trust
- Capital gains in IT returns
- Intimation under section 245
- How do you manage client document collection and follow-ups in your CA/CS practice?
- Urd purchase entry in tally prime
- TDS- 2026-27 Q1 Correction
- GSTR-9C filing
- Royalty payments to the Mining Department for procurement of murum - GST input
- HOW TO ADJUST CREDIT NOTE AMOUNT ?
- Import Order Cancelled.
- WRONG GSTR7 ENTRIES ACCEPTED ERRONEOUSLY
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
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
