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🌹🙏❤🙏🙏

[@ammarahmad5026]

Bhai Jaan you are the best teacher for all student

[@sudharajpoot014]

Very helpful video

[@arvindladva]

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

[@genius2195]

Very informative. Impressed on first view . good understandable

[@bhargav1389]

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

[@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

[@Farzvoice]

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

[@narayandhami2228]

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

[@ChetanRanjanEd-Wise]

Underrated

[@kamaleshdeka7443]

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

[@reviewsforallnewtwowheeler152]

Weekly loan EMI calculation formula bataiye

[@1955rauf]

Excellent amazing job thanks

[@rohanpatel3297]

Nicely explained
Great video 👏👌

[@anupamsharma7766]

Nice sir 🎉

[@Dj_Mit]

Awesome 👍

[@rishimandal7508]

Love you bro, superb explanation 👍

[@rozigitu3305]

Thank you so much sir 👍👍👍👍

[@yaminichauhan7277]

THANKYOU SO MUCH SIR
VERY MUCH NEEDED THIS

[@parmeshwarmadheshia1865]

Very useful video ❤❤❤
T

[@BABASHARO53655]

Very helpful video sir

[@komaldwivedi1259]

Thanks so much sir ji

[@hemantnimbre4005]

Very helpful for students like us. God Bless You❣

[@spcommercecrunch6517]

Thanks you so much yaar

[@ChetanRanjanEd-Wise]

Great

[@kansingh5968]

Nice video thanks sir

[@akmotivatoinfactvedio2.0mv18]

Thankyou so much sir

[@deepakkumardas4032]

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

[@subhashmaurya27]

Thanku sir...

[@umangsharma6252]

Thank you sir

[@nepalghosh7785]

Great sir

[@cricketfever2.037]

Thank u sir

[@kalpeshyelkar6142]

Thanku sir..❤️

[@sandeepanpandey7483]

Thanks you kalpesh

[@Baljeetsingh-sx6fh]

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

[@Baljeetsingh-sx6fh]

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

[@dineshpatil440]

Nice 🙂

[@sasmitasenapati819]

Thank u

[@user-ji6vz4ob3e]

Very hepldu

[@umangsharma6252]

Sir sabji ban gai🤣🤣

[@kpsingh6001]

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

[@sudharajpoot014]

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

[@yesmeenanazir2342]

Sir pmt k full form kay hai

[@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 🙏

[@jibrankhan549]

file to download k liye dety

[@DHARAM1982]

waoou great bal ki khal utardi nicely done

[@rohitpawar7931]

G8

[@sursangammixing]

Documant upload

[@ThePrituality]

where is the excel file?

[@LEARNANDEARNbasitsolanki]

Very nice sir

[@DHARAM1982]

waoou great bal ki khal utardi nicely done

[@RituSharma-qy7bt]

So informative.. Thanks