METHOD MEDIA COMPUTER ACADEMY PRIVATE LIMITED

Add New Topic

Enter Topic Details

Select Topic

Topic Title

Video URL

Content Details

<p class="MsoNormal" style="text-align:justify;line-height:normal"><b><span style="font-size:14.0pt;font-family:
"Cambria","serif";mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">FV
(Future Value): -</span></b><span style="font-size:14.0pt;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">It returns
the future value of on investment based on periodic, constant payment and a
constant interest rate.<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify;line-height:normal"><span style="font-size:14.0pt;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">                        <b><i>Syntax: -</i></b>      =Fv(Interest/Condition, Term, Installment)<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify"><span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">                        <b><i>Ex: -</i></b>               =Fv(11%/12,
60, 1000)<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify"><span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">                                                =Fv(5%/365,
1825, 10)<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify"><span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">                                                =Fv(10%/4,
20, 5000)<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify"><span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">                                                =Fv(10%/2, 10, 10000)<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify;line-height:normal"><b><span style="font-size:14.0pt;font-family:"Cambria","serif";mso-ascii-theme-font:
major-latin;mso-hansi-theme-font:major-latin">PMT (Per Month Term):-</span></b><span style="font-size:14.0pt;font-family:"Cambria","serif";mso-ascii-theme-font:
major-latin;mso-hansi-theme-font:major-latin"> Calculate the payment for a loan
based on constant payments and a constant interest rate.<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify;line-height:normal"><span style="font-size:14.0pt;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin"><o:p> </o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify"><span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">                        <b><i>Syntax: -</i></b>      =PMT(Interest/Condition, Loan Amount)<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify"><span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">                        <b><i>Ex: -</i></b><i>   </i>            =PMT(11%/12, 60, 100000)<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify"><span style="font-size:14.0pt;line-height:115%;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin"><o:p> </o:p></span></p>

<p class="MsoNormal" style="text-align:justify;line-height:normal"><b><span style="font-size:14.0pt;font-family:
"Cambria","serif";mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">PV
(Present Value): -</span></b><span style="font-size:14.0pt;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">It returns
the present value of an investment. The present value is the total amount that
a series of future payment is worth row for example when you borrow money the
loan amount is the present value to the lender.<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify;line-height:normal"><span style="font-size:14.0pt;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">                        <b><i>Syntax: -</i></b>      =PV(Interest/Condition, Loan Installment)<o:p></o:p></span></p>

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align:
justify;line-height:normal"><span style="font-size:14.0pt;font-family:"Cambria","serif";
mso-ascii-theme-font:major-latin;mso-hansi-theme-font:major-latin">                        <b><i>Ex: -</i></b><i>   </i>            =PV(11%/12, 60, 2174.24)<o:p></o:p></span></p>

Short Key List

F1 = Dashboard
alt+s = Add Student
alt+r = Result View
alt+t = View Transaction
alt+w = Wallet Transaction
alt+i = Income/Expense
alt+a = Our Team