{"id":7416,"date":"2023-01-12T06:02:00","date_gmt":"2023-01-12T00:32:00","guid":{"rendered":"https:\/\/aiyoit.com\/tutorial\/?p=7416"},"modified":"2023-08-30T12:25:09","modified_gmt":"2023-08-30T06:55:09","slug":"financial-formula-in-ms-excel","status":"publish","type":"post","link":"https:\/\/aiyoit.com\/tutorial\/financial-formula-in-ms-excel\/","title":{"rendered":"Financial Formula in MS Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"7416\" class=\"elementor elementor-7416\">\n\t\t\t\t\t\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-1651349a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1651349a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-773039c\" data-id=\"773039c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-602cf65c elementor-shape-circle elementor-grid-0 e-grid-align-center elementor-widget elementor-widget-social-icons\" data-id=\"602cf65c\" data-element_type=\"widget\" data-widget_type=\"social-icons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-social-icons.elementor-grid-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-mobile-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-tablet-0 .elementor-widget-container{line-height:1;font-size:0}.elementor-widget-social-icons:not(.elementor-grid-0):not(.elementor-grid-tablet-0):not(.elementor-grid-mobile-0) .elementor-grid{display:inline-grid}.elementor-widget-social-icons .elementor-grid{grid-column-gap:var(--grid-column-gap,5px);grid-row-gap:var(--grid-row-gap,5px);grid-template-columns:var(--grid-template-columns);justify-content:var(--justify-content,center);justify-items:var(--justify-content,center)}.elementor-icon.elementor-social-icon{font-size:var(--icon-size,25px);line-height:var(--icon-size,25px);width:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)));height:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)))}.elementor-social-icon{--e-social-icon-icon-color:#fff;display:inline-flex;background-color:#69727d;align-items:center;justify-content:center;text-align:center;cursor:pointer}.elementor-social-icon i{color:var(--e-social-icon-icon-color)}.elementor-social-icon svg{fill:var(--e-social-icon-icon-color)}.elementor-social-icon:last-child{margin:0}.elementor-social-icon:hover{opacity:.9;color:#fff}.elementor-social-icon-android{background-color:#a4c639}.elementor-social-icon-apple{background-color:#999}.elementor-social-icon-behance{background-color:#1769ff}.elementor-social-icon-bitbucket{background-color:#205081}.elementor-social-icon-codepen{background-color:#000}.elementor-social-icon-delicious{background-color:#39f}.elementor-social-icon-deviantart{background-color:#05cc47}.elementor-social-icon-digg{background-color:#005be2}.elementor-social-icon-dribbble{background-color:#ea4c89}.elementor-social-icon-elementor{background-color:#d30c5c}.elementor-social-icon-envelope{background-color:#ea4335}.elementor-social-icon-facebook,.elementor-social-icon-facebook-f{background-color:#3b5998}.elementor-social-icon-flickr{background-color:#0063dc}.elementor-social-icon-foursquare{background-color:#2d5be3}.elementor-social-icon-free-code-camp,.elementor-social-icon-freecodecamp{background-color:#006400}.elementor-social-icon-github{background-color:#333}.elementor-social-icon-gitlab{background-color:#e24329}.elementor-social-icon-globe{background-color:#69727d}.elementor-social-icon-google-plus,.elementor-social-icon-google-plus-g{background-color:#dd4b39}.elementor-social-icon-houzz{background-color:#7ac142}.elementor-social-icon-instagram{background-color:#262626}.elementor-social-icon-jsfiddle{background-color:#487aa2}.elementor-social-icon-link{background-color:#818a91}.elementor-social-icon-linkedin,.elementor-social-icon-linkedin-in{background-color:#0077b5}.elementor-social-icon-medium{background-color:#00ab6b}.elementor-social-icon-meetup{background-color:#ec1c40}.elementor-social-icon-mixcloud{background-color:#273a4b}.elementor-social-icon-odnoklassniki{background-color:#f4731c}.elementor-social-icon-pinterest{background-color:#bd081c}.elementor-social-icon-product-hunt{background-color:#da552f}.elementor-social-icon-reddit{background-color:#ff4500}.elementor-social-icon-rss{background-color:#f26522}.elementor-social-icon-shopping-cart{background-color:#4caf50}.elementor-social-icon-skype{background-color:#00aff0}.elementor-social-icon-slideshare{background-color:#0077b5}.elementor-social-icon-snapchat{background-color:#fffc00}.elementor-social-icon-soundcloud{background-color:#f80}.elementor-social-icon-spotify{background-color:#2ebd59}.elementor-social-icon-stack-overflow{background-color:#fe7a15}.elementor-social-icon-steam{background-color:#00adee}.elementor-social-icon-stumbleupon{background-color:#eb4924}.elementor-social-icon-telegram{background-color:#2ca5e0}.elementor-social-icon-thumb-tack{background-color:#1aa1d8}.elementor-social-icon-tripadvisor{background-color:#589442}.elementor-social-icon-tumblr{background-color:#35465c}.elementor-social-icon-twitch{background-color:#6441a5}.elementor-social-icon-twitter{background-color:#1da1f2}.elementor-social-icon-viber{background-color:#665cac}.elementor-social-icon-vimeo{background-color:#1ab7ea}.elementor-social-icon-vk{background-color:#45668e}.elementor-social-icon-weibo{background-color:#dd2430}.elementor-social-icon-weixin{background-color:#31a918}.elementor-social-icon-whatsapp{background-color:#25d366}.elementor-social-icon-wordpress{background-color:#21759b}.elementor-social-icon-xing{background-color:#026466}.elementor-social-icon-yelp{background-color:#af0606}.elementor-social-icon-youtube{background-color:#cd201f}.elementor-social-icon-500px{background-color:#0099e5}.elementor-shape-rounded .elementor-icon.elementor-social-icon{border-radius:10%}.elementor-shape-circle .elementor-icon.elementor-social-icon{border-radius:50%}<\/style>\t\t<div class=\"elementor-social-icons-wrapper elementor-grid\">\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-facebook elementor-animation-buzz elementor-repeater-item-01b5564\" href=\"https:\/\/www.facebook.com\/aiyoit\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Facebook<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-facebook\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-instagram elementor-animation-buzz elementor-repeater-item-8a90b95\" href=\"https:\/\/www.instagram.com\/aiyoitns\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Instagram<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-instagram\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-youtube elementor-animation-buzz elementor-repeater-item-567c5bb\" href=\"https:\/\/www.youtube.com\/channel\/UCiagcH73PZUdTzRySS8Axig\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Youtube<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-youtube\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-5343c9d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5343c9d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cd232e1\" data-id=\"cd232e1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9b3aa86 elementor-widget elementor-widget-heading\" data-id=\"9b3aa86\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Financial Formula<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b959613 elementor-widget elementor-widget-text-editor\" data-id=\"b959613\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>\u092f\u0926\u093f \u0906\u092a\u0915\u094b \u0905\u092a\u0928\u0940 Worksheet \u092e\u0947\u0902 \u0915\u0941\u091b\u00a0Financial Calculations\u00a0\u0915\u0930\u0928\u0940 \u0939\u0948 (\u091c\u0948\u0938\u0947 EMI, Present Value, Future Value, Interest etc.) \u0924\u094b \u0907\u0938 Option \u092e\u0947\u0902 \u0906\u092a\u0915\u094b Advanced Financial Formulas \u092e\u093f\u0932 \u091c\u093e\u0924\u0947 \u0939\u0948, \u091c\u093f\u0928\u094d\u0939\u0947 \u0906\u092a Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02a3b53 elementor-widget elementor-widget-heading\" data-id=\"02a3b53\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">PMT<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5688fd1 elementor-widget elementor-widget-text-editor\" data-id=\"5688fd1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0915\u093f\u0938\u0940 Loan \u0915\u0940 EMI \u0915\u094b \u091c\u093e\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f PMT Formula \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0902|<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d4913cd elementor-widget elementor-widget-text-editor\" data-id=\"d4913cd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =PMT(rate, nper, pv, [fv], [type])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-311f7f9 elementor-widget elementor-widget-text-editor\" data-id=\"311f7f9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li><strong>rate\u00a0:<\/strong> The interest rate for the loan.<\/li><li><strong>nper\u00a0:<\/strong> The total number of payments for the loan.<\/li><li><strong>pv\u00a0:<\/strong> The present value, or total value of all loan payments now.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3d22693 elementor-widget elementor-widget-image\" data-id=\"3d22693\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"416\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PMT-1-1024x416.png\" class=\"attachment-large size-large wp-image-7553\" alt=\"PMT Formula in Hindi\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PMT-1-1024x416.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PMT-1-300x122.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PMT-1-150x61.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PMT-1-768x312.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PMT-1-1536x624.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PMT-1-2048x832.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-48a5556 elementor-widget elementor-widget-heading\" data-id=\"48a5556\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">IPMT<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a38fe88 elementor-widget elementor-widget-text-editor\" data-id=\"a38fe88\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0915\u093f\u0938\u0940 Loan \u0915\u0940 Monthly Interest \u0915\u094b \u0928\u093f\u0915\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f IPMT Formula \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-44f934e elementor-widget elementor-widget-text-editor\" data-id=\"44f934e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =IPMT(rate, per, nper, pv, [fv], [type])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-936217a elementor-widget elementor-widget-image\" data-id=\"936217a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"462\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/IPMT-1024x462.png\" class=\"attachment-large size-large wp-image-7552\" alt=\"IPMT Formula\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/IPMT-1024x462.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/IPMT-300x135.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/IPMT-150x68.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/IPMT-768x347.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/IPMT-1536x693.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/IPMT-2048x925.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7cc645a elementor-widget elementor-widget-heading\" data-id=\"7cc645a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">PPMT<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-00c718a elementor-widget elementor-widget-text-editor\" data-id=\"00c718a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0915\u093f\u0938\u0940 Loan \u0915\u0940 Monthly EMI \u0938\u0947 Principal Amount \u0915\u094b \u0928\u093f\u0915\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f PPMT Formula \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9514db elementor-widget elementor-widget-text-editor\" data-id=\"f9514db\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax :\u00a0 =PPMT<\/strong><strong>(rate, per, nper, pv, [fv], [type])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dffc92b elementor-widget elementor-widget-image\" data-id=\"dffc92b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"470\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PPMT-1024x470.png\" class=\"attachment-large size-large wp-image-7550\" alt=\"PPMT Formula\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PPMT-1024x470.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PPMT-300x138.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PPMT-150x69.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PPMT-768x353.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PPMT-1536x706.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/PPMT-2048x941.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-33f8a6b elementor-widget elementor-widget-heading\" data-id=\"33f8a6b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">PV<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bc00e3c elementor-widget elementor-widget-text-editor\" data-id=\"bc00e3c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Get the present value of an investment.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7678b6d elementor-widget elementor-widget-text-editor\" data-id=\"7678b6d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : \u00a0=PV(rate, nper, pmt, [fv], [type])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2bf5f21 elementor-widget elementor-widget-heading\" data-id=\"2bf5f21\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">FV<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0190806 elementor-widget elementor-widget-text-editor\" data-id=\"0190806\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Get the future value of an investment.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c765bc elementor-widget elementor-widget-text-editor\" data-id=\"0c765bc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =FV(rate, nper, pmt, [pv], [type])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b8cb64 elementor-widget elementor-widget-heading\" data-id=\"4b8cb64\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">RATE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-17eb273 elementor-widget elementor-widget-text-editor\" data-id=\"17eb273\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Get the interest rate per period of an annuity<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eb0605c elementor-widget elementor-widget-text-editor\" data-id=\"eb0605c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =FV(rate, nper, pmt, [pv], [type])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be1fd54 elementor-widget elementor-widget-image\" data-id=\"be1fd54\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"311\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/pv-1024x311.png\" class=\"attachment-large size-large wp-image-7551\" alt=\"PV FV Rate Formula\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/pv-1024x311.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/pv-300x91.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/pv-150x46.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/pv-768x234.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/pv-1536x467.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/pv-2048x623.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-307b3d1c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"307b3d1c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-11b2c4b5\" data-id=\"11b2c4b5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-14d5785 elementor-widget elementor-widget-text-editor\" data-id=\"14d5785\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0928\u094d\u0939\u0947 \u092d\u0940 \u092a\u095d\u0947 &#8212;<br \/><a href=\"https:\/\/aiyoit.com\/tutorial\/date-and-time-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Date and Time Formulas in Excel\u00a0<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/logical-function-and-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Logical Function in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/the-text-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Text Function in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/lookup-formula-reference-in-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Lookup and Reference Formula in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/math-and-trig-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Math and Trig Formula in Excel<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-910681d elementor-widget elementor-widget-text-editor\" data-id=\"910681d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p class=\"has-background\"><em>\u0906\u0936\u093e \u0915\u0930\u0924\u093e \u0939\u0942\u0901 \u0915\u0940 \u0907\u0938 Article \u0938\u0947 \u0906\u092a\u0915\u094b Financial Formula \u0938\u0947 \u091c\u0941\u0921\u093c\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092e\u093f\u0932\u0940 \u0939\u094b\u0917\u0940, \u0905\u0917\u0930 \u0906\u092a \u0915\u094b Excel \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0915\u0941\u091b \u0938\u092e\u091d \u092e\u0947\u0902 \u0906\u092f\u093e \u0939\u094b \u0924\u094b \u0905\u092a\u0928\u0947 \u0926\u094b\u0938\u094d\u0924\u094b\u0902 \u0915\u0947 \u092a\u093e\u0938 \u091c\u0930\u0942\u0930 Share \u0915\u0930\u0947 \u0924\u093e\u0915\u093f \u0909\u0928\u0915\u094b \u092d\u0940\u00a0 Excel \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 knowledge \u092e\u093f\u0932 \u0938\u0915\u0947\u0964 \u0905\u0927\u093f\u0915 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u093e\u0930\u0947\u00a0<strong><a href=\"https:\/\/www.facebook.com\/aiyoit?mibextid=ZbWKwL\" target=\"_blank\" rel=\"noreferrer noopener\">Facebook Page<\/a>\u00a0<\/strong>\u0915\u094b Follow \u0914\u0930\u00a0<strong><a href=\"https:\/\/www.youtube.com\/@aiyoit\" target=\"_blank\" rel=\"noreferrer noopener\">Youtube channel<\/a>\u00a0<\/strong>\u0915\u094b subscribe \u091c\u0930\u0942\u0930 \u0915\u0930\u0947 \u0905\u0917\u0930 \u0906\u092a \u0915\u093e \u0915\u094b\u0908 \u0938\u0935\u093e\u0932 \u0939\u094b \u0924\u094b comment box \u092e\u0947\u0902 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u092f\u0947\u0964<\/em><\/p><p><strong>Thank You !<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1a0dd9bb elementor-widget elementor-widget-eael-content-ticker\" data-id=\"1a0dd9bb\" data-element_type=\"widget\" data-widget_type=\"eael-content-ticker.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div class=\"eael-ticker-wrap\" id=\"eael-ticker-wrap-1a0dd9bb\"><div class=\"ticker-badge\">\n                    <span>Trending Today<\/span>\n                <\/div><div class=\"swiper-container-wrap eael-ticker\">\n                <div class=\"swiper-container eael-content-ticker swiper-container-1a0dd9bb\" data-pagination=\".swiper-pagination-1a0dd9bb\" data-arrow-next=\".swiper-button-next-1a0dd9bb\" data-arrow-prev=\".swiper-button-prev-1a0dd9bb\" data-effect=\"slide\" data-speed=\"400\" data-autoplay=\"2000\" data-loop=\"1\" data-arrows=\"1\">\n                    <div class=\"swiper-wrapper\"><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/upsi-gs-hindi-100-questions-quiz\/\" class=\"ticker-content-link\">UPSI GS &#038; Hindi &#8211; 100 Questions Quiz<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/upp-quiz-questions-100\/\" class=\"ticker-content-link\">UPP Quiz Questions 100<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/fundamental-word-excel-tally-photoshop-internet-test-quiz\/\" class=\"ticker-content-link\">Fundamental , Word, Excel, Tally, Photoshop, Internet -Test Quiz<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/fundamental-word-excel-tally-test-quiz-2\/\" class=\"ticker-content-link\">Fundamental , Word, Excel, Tally &#8211; Test Quiz<\/a>\n        <\/div>\n    <\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"content-ticker-pagination\"><div class=\"swiper-button-next swiper-button-next-1a0dd9bb\"><i class=\"fas fa-angle-right\"><\/i><\/div><div class=\"swiper-button-prev swiper-button-prev-1a0dd9bb\"><i class=\"fas fa-angle-left\"><\/i><\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-7a31ca0f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7a31ca0f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2886d155\" data-id=\"2886d155\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-337f5f3a elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"337f5f3a\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/plugins\/elementor-pro\/assets\/css\/widget-share-buttons.min.css\">\t\t<div class=\"elementor-grid\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_facebook\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on facebook\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_pinterest\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on pinterest\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-pinterest\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tPinterest\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_linkedin\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on linkedin\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-linkedin\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_whatsapp\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on whatsapp\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-whatsapp\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u092f\u0926\u093f \u0906\u092a\u0915\u094b \u0905\u092a\u0928\u0940 Worksheet \u092e\u0947\u0902 \u0915\u0941\u091b Financial Calculations \u0915\u0930\u0928\u0940 \u0939\u0948 (\u091c\u0948\u0938\u0947 EMI, Present Value, Interest etc.) \u0924\u094b \u0907\u0938 Option \u092e\u0947\u0902 \u0906\u092a\u0915\u094b Advanced Financial Formulas&#8230; <\/p>\n","protected":false},"author":6,"featured_media":7460,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[44],"tags":[9,985,497,1806,52,1533,1799,1800,1531,1804,1802,1801,1803,1805],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7416"}],"collection":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/comments?post=7416"}],"version-history":[{"count":25,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7416\/revisions"}],"predecessor-version":[{"id":11674,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7416\/revisions\/11674"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media\/7460"}],"wp:attachment":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media?parent=7416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/categories?post=7416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/tags?post=7416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}