how do i convert a flat rate into a reducing rate?
I was hoping if somebody has a sheet which can covert fixed interest % to reducing interest % and vice versa in excel. I'm not very such about the math involved here as well. Is anybody of you into finance ? If yes
I need a formula that will multiply the value by one of four interest rates, depending on the size of the value. In other words, if the value is under $100,00, multiply by rate A. If the value is over $100,00 multiply by rate B. If over $150,00 multiply by rate C. And if over $200,00 multiply by rate D. And the value I'm speaking of is the Sum of A and B.
A1+B1=C1 Depending on the value in C1, I need it multiplied by the appropriate rate as explained above. I appreciate any help you can offer me.
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.
Have 3 columns
A has funds
B column has minimum Guaranteed Interest Rate
C column has current interest rate
Current interest rate and minimum Guaranteed Interest Rate are different. Client will get which one is higher Interest Rate.
Question.:When I select the funds on E10(drop-down Lists) how do I get the best interest rate on F10(from B and C)
More in attached sheet
Looking for a formula that will calculate a different rate of pay based on time employee starts and finishes work.
Two time rates of pay;
8am/8pm - rate of pay 1
8pm/8am - rate of pay 2
I have attached a screen shot of the spreadsheet.
Effectively I just need a formula to look at times in the START and END columns and calculate the appropriate formulas in the RATE 1 and RATE 2 columns.
Related Applications & Scripts
Bundle rate shipping allows you to provide special bundled shipping rates when a customer purchases multiple items in the same category.
This is a fully capable software for al full fledge ecommerce enabled website.
- 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
- Newsletter option
Currency Server was designed to be the most advanced currency-enabling component on the market. It provides exchange rate information and currency internationalization, conversion and rounding services via COM/ActiveX, .NET and SOAP Web services, and Ajax-style scripting. Currency Server supports more clients, more platforms, and a larger number of independent providers of exchange rate data than other tools.
By working locally rather than relying on remote servers for each transaction, Currency Server provides a unique level of performance, reliability and independence. The service is always available to satisfy thousands of information and conversion requests per second. Support for a variety of data providers (both free and subscription-based) and advanced administration notification options assure fault tolerance and peace of mind.
With this class you can easily store, display and send files from a db. It has a built-in hit counter and stores information of last edition, upload, etc. This class uses my db abstraction layer, AbstractDB, which allows a unified and easy access to databases, which you can see in this class.