0

What interest rate should be applied to the PMT function in Excel?

Anonymous

∙ 12y ago

Updated: 8/18/2019

There is no single answer to that. It will depend on the calculation you are trying to do. You could use whatever rate is appropriate. The function can use any rate, so that will be based on the particular situation you are working on and what interest rate is specified.

Wiki User

∙ 12y ago

What else can I help you with?

Related Questions

What is NPER in Excel?

NPER is a financial function in Excel. It returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

What is the difference between the PMT and PPMT functions in Excel?

The PPMT function returns the amt. of interest in a specified instalment number whereas the PMT function returns the amt. of interest in every EMI payment.

What are things should be kept in mind while giving the range name in Microsoft Excel?

It should be short and meaningful. It should not be the name of a cell or function in Excel. It should be easy to remember. It should be unique.

What theme is applied to a chart when it is copied from Excel and pasted into Word?

by default what themes is applied to a chart when it is copies from excel and pasted into word

What is a pv cell?

PV is a function in Excel for returning the present value of an investment based on a constant interest rate and payment schedule.

What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.

A formula prewritten by excel is called?

Function

In excel 2013 where are the various function categories stored on the Ribbon?

In Excel Where are the various function categories stored on the Ribbon?

Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.

What is the function of percentage in micro-soft Excel?

functions of excel

What is the formula for quarterly compounded interest in M S Excel?

Although Microsoft excel does not include a function for determining compound interest , you can use following formula for this calculation.=PV*(1+r)^NWhere PV = Present Valuer = Interest RateN = No of investment period.E.g1000 is deposit amount at 10% interest for 5 years, then formula is=1000*(1+0.10)^5The answer will be 1,610.51

An If function within an if function in Excel is called what?

A nested if.

Trending Questions

Is it safe to courier the check book? What exactly is a zig-a-zig-aah and why do the spice girls want one so badly? How many wives does Jackie Chan have? Where can you buy the blue easy bake oven? What is the population of Mexico City 2012? How much is a Kyat dollar in us dollars? Who invented lip reading? Does a Mortgage credit report differ from credit reports that i can access through credit report com or other report services? How can you make your voice sound sick? What is the botanical name of Flax Seeds? How do you divide the word customer into syllables? What actors and actresses appeared in Khwahish - 1999? If the statement If I am hungry then I am not happy is assumed to be true is its inverse If I am not hungry then I must be happy also always true A.No B.Yes? How many multinationals use us gaap? What is the expanded form for 4.3? How can a router IP address be changed? Can I run a double 30 amp breaker with 10-3 wire to receptacle for 240v MIG welder. Distance from main box to destination is 60 feet.? What does mettanarrative mean? What causes the bad taste after use of ciprofloxacin hydrochloride ophthalmic drops? What are royal blue tang's preadators?

Resources

Top Categories

Product

Company

Copyright ©2025 Answers.com | Lunias Media Inc. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.