You are here: HomeExcelTutorials

# calculating a discount rate

## calculating a discount rate

Price: FREE

I have a series of future cash flows, and a lump sum offer for them. Is there a function I can use in Excel to calculate what the discount rate used to generate that lump offer was? I can trial and error it using PV and extrapolating a rate, but I was hoping for something that I could plug Present Value, Future Value and Number of Periods into that would give me the

Visit publisher's web-site: calculating a discount rate

Category and Tags: ExcelTutorials : : Functions

## Related Tutorials

### Negative discount rate

Free: Yes
Tags: Excel ›

there! I found this forum and thought this would probably the best place to pose my question;
I am calculating the discount rate for 4 different revenue streams:
Initial costs / Revenue 1st yr / Revenue 2nd yr / 3rd yr / 4th yr Discount rate
It seems to be that there there is no upper limit for an positive discount rate (alternative 3). For a negative discount rate (see alternative 2 and 3), however, it seems that there is no possibility for getting a negative discount flow below 100% --> am I right in my assumption or do I miss anything here?

### Calculating Discount

Free: Yes
Tags: Excel ›

I am taking an Excel class and working on a project. I need some help calculating the discounted price of something. What I did is divide the price of something by the percent of discount. Example \$15.50/15%. Some of the cells have 0% discount because they don't get one. When I fill in the formula I get an error #DIV/0!
because the discount value is 0. How can I fix this. I have to compare to see how much the discount of sales can affect the total amount of sales.

### % commision

Free: Yes
Tags: Excel ›

I have following problem:
Salesmen give x% in discount
If discount % is between 0-4% he gets 25% bonus
If discount is 5-9% he gets 20%
If discount is 10-14% he gets 15%
If discount is 15-20% he gets 5%
If discount is >20% he gets 0%
How can I make function for this.

### Finding the interest rate.

Free: Yes
Tags: Excel › Functions

So present value = future value / (1+discount rate)^n where n is the number of compounding periods.
If I have PV, FV, and n, I assume I use the RATE formula to get the interest rate. I keep getting #NUM.

### Calculating a daily rate when the rate could be fixed or variable

Free: Yes
Tags: Excel ›

I am working on calculating a yearly cost for a service provider. The fixed rate in this section is \$12.00 per day which will be multiplied by a certain number of hours within a year. However, the provider is also given a blank "exception" cell in this row in which to enter a different rate of their choosing (could be different each time). How can I write a formula stating if the "exception" cell is blank to look to the \$12.00 daily rate and multiply that by the hours per year. And vice versa, if there is an amount in the exception cell, to use that daily rate and not the \$12.00 fixed rate. Hope I have explained that well enough. Thank you. C

## Related Applications & Scripts

### Galleries Pack 40% discount + Bonus a Video Player

Free: No
Tags: Flash › Excel Video Players

This package contains 3 galleries & banners. The discount is ~ 40% and you will also receive BONUS an Advanced Video Player with Playlist and Categories.
You do not need to know Flash in order to set the components. Every setting can be done in a main.xml file making it very easy to update.

### Mortgage Calculators

Free: Yes
Tags: PHP › Excel Calculators

How much do you save by paying more or making additional payments than your initial mortgage terms?
Monthly payment calculator
Want to know how much your monthly payment is for your mortgage?
How much do I have to earn?
Not sure how much money you'll have to earn to afford your house payment and accompanying expenses?
How much can I borrow?
Want to know how big of a mortgage you can take on?
Should I pay discount points?
Not sure if you should pay discount points on your mortgage loan?
How much will I save by refinancing my loan?
How long will it take to recoup the costs of refinancing my home mortgage?
How much will my tax deduction be?
Want to know how much your home mortgage will save you in taxes?
Bi-weekly mortgage calculator
Want to know how much time and money you'll save paying off your loan on a bi-weekly payment plan?
APR calculator
To find out the annual percentage rate of your loan, enter the loan amount, interest rate, points, other costs
and year-length term.
Interest only monthly payment calculator
To find out the monthly savings you could gain from an interest-only payment plan.

### ASP Ecommerce Shop /Store Builder

Free: No
Tags: ASP › Excel E-Commerce

This is a fully capable software for al full fledge ecommerce enabled website.
Features:
- One file to Setup
- Access or ms sql database
- Auto thumbnail
- Best seller list, buy also list
- New products, Last chance, Bargain bin, Auction
- Auto category, subcategory, shop by Brand
- Custom shipping rate, Flat shipping rate
- Discount code generation, online offline payment
- payment gateways setup

### Super Discount on Super Video Players Pack

Free: No

Super Video Players Pack - 53% Discount. This amazing package contains 3 super video players. The discount is ~ 53%.
You do not need to know Flash in order to set the video player. Every setting can be done in a main.xml file making it very easy to update. You can set this player to any size you want from the configuration XML file, changing the player width , the player height and the playlist width. You can easy integrate this in any projects you need, HTML or Flash.
This package contains:
- First Class Video Player - FLV/H.264/MP3 - Google Analytics & Subtitles