PMT, PPMT , IPMT, PV, FV, RATE, NPER in Excel ||Financial Function || Principal,Interest

Welcome to SP Commerce Crunch.
In this video we have covered
1. Financial functions in excel in that we have covered following contains :-
a PMT :- how to find out installment amount for loan in excel.
b. PPMT:- how to find out principal portion from installment amount.
c. IPMT.:- How to find out Interest portion from installment Amount.
d. PV :-. how to find out present value from future value.
e. FV :- how to find out future value from present value
f Rate :- How to find out Rate of interest for loan or Investment
h. Nper :-. how to find out number of period for loan amount
Hope you like video 📸 if you realy like the same , plz share it with your freind and do on like and comment for your support.
Time line for video 📷📸
PMT
PPMT
IPMT
FV
PV
RATE
NPER
#financialfunctions
#pmtfunction
#ppmt&Ipmt
#fv
#pvratenper
Declaimer -
Some contents are used for educational purposes under fair use. Copyright Disclaimer under Section 107 of the copyright act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favour of fair use.

[@user-ct4qt1zn2t]

You have explained every financial formula with complete details that is really appreciable. Actually, these formulas are most important in Microsoft Excel for any kind of Loan and EMI calculations So everyone must learn it with full concentration.

[@LaxmiKumari-cr1qu]

Thanku sir me ye hi search kr rhi but khi pr aisi video ni mili apne bhot achhe se deeply bhi smjhaya

[@powermotivation9552]

Sir garda teaching karte Mai bahut khush hua apke video dekh ke Muse sara samajh a gya bariki se Iske liye thank you🌹🙏❤🙏🙏

[@bhargav1389]

Thank you so much for covering these functions really learnt a lot. Appreciate for your efforts sir.

[@Farzvoice]

Thank you so much.... Awesome explanation.... Understood everything clearly.

[@ammarahmad5026]

Bhai Jaan you are the best teacher for all student

[@kamleshbhayani9723]

superb presentation..... very well explained all points... long awaited topic fulfilled.... thanks a lot it will help in my professional... thank you once again

[@kamaleshdeka7443]

Thank you sir for making a comprehensive video about the topic.

[@genius2195]

Very informative. Impressed on first view . good understandable

[@rohanpatel3297]

Nicely explained Great video 👏👌

[@narayandhami2228]

Thank you so much sir superb....well explained much helpful presentation

[@arvindladva]

Thanks sir Sir aap ke video se bahot kuch sikh ne ko milta he

[@rishimandal7508]

Love you bro, superb explanation 👍

[@sudharajpoot014]

Very helpful video

[@1955rauf]

Excellent amazing job thanks

[@yaminichauhan7277]

THANKYOU SO MUCH SIR VERY MUCH NEEDED THIS

[@hemantnimbre4005]

Very helpful for students like us. God Bless You❣

[@spcommercecrunch6517]

Thanks you so much yaar

[@rozigitu3305]

Thank you so much sir 👍👍👍👍

[@BABASHARO53655]

Very helpful video sir

[@Dj_Mit]

Awesome 👍

[@anupamsharma7766]

Nice sir 🎉

[@ChetanRanjanEd-Wise]

Underrated

[@akmotivatoinfactvedio2.0mv18]

Thankyou so much sir

[@kansingh5968]

Nice video thanks sir

[@komaldwivedi1259]

Thanks so much sir ji

[@parmeshwarmadheshia1865]

Very useful video ❤❤❤ T

[@subhashmaurya27]

Thanku sir...

[@umangsharma6252]

Thank you sir

[@nepalghosh7785]

Great sir

[@cricketfever2.037]

Thank u sir

[@LEARNANDEARNbasitsolanki]

Very nice sir

[@GMINTERESTINGCOLLECTIONSvlogs]

As usual very informative and quality content. Sir if you can send the working file (file link) in your video description will help us to practice alongside with you.

[@spcommercecrunch6517]

Sure sir

[@spcommercecrunch6517]

Will give u the same

[@dineshpatil440]

Nice 🙂

[@kalpeshyelkar6142]

Thanku sir..❤️

[@sandeepanpandey7483]

Thanks you kalpesh

[@reviewsforallnewtwowheeler152]

Weekly loan EMI calculation formula bataiye

[@ChetanRanjanEd-Wise]

Great

[@sasmitasenapati819]

Thank u

[@Baljeetsingh-sx6fh]

Maine itna sara video dekha finance ka lekin clear koi nhi bataya hai

[@user-ji6vz4ob3e]

Very hepldu

[@Baljeetsingh-sx6fh]

Sir apane finance ka pura video daka nahi hai dal dijiye plzz jisame rri , count, amodegrc jaise bahut sare

[@umangsharma6252]

Sir sabji ban gai🤣🤣

[@kpsingh6001]

Rate functioned not executed always show #NUM!. PL EXPLAIN

[@riyavinayak2141]

Great explained sirji 👌 Mera Balance ka Answer = 1,00,000 Aa rha hai apke wala answer nhi aa rha sirji🙏

[@spcommercecrunch6517]

Fir se eal bar video dekh ke karo Aa jayega ans. Barabar

[@riyavinayak2141]

@@spcommercecrunch6517 sirji 3 time kiya fir bhi apke wala answer nhi aaya🙆 apki video dekh ke sikh rhi hu bahut acha padte ho aap Sirji 🙏

[@rohitpawar7931]

G8

[@DHARAM1982]

waoou great bal ki khal utardi nicely done

[@sudharajpoot014]

Balance column me kaise kr rahe h samjh hi nahi aa raha

[@yesmeenanazir2342]

Sir pmt k full form kay hai

[@jibrankhan549]

file to download k liye dety

[@sursangammixing]

Documant upload

[@ThePrituality]

where is the excel file?

[@deepakkumardas4032]

Very nice sir

[@DHARAM1982]

waoou great bal ki khal utardi nicely done

[@RituSharma-qy7bt]

So informative.. Thanks