rate

I have been trying to rework a common CAGR formula to be able to calculate the initial investment value if all I have if the annualized rate and the average value over the term. So I know the standard formula is: The formula is: R = (F/I)^(1/Y)-1 R = annualized rate I = initial investment...

<tbody> Target GM% 25% Hourly Cost 4.03375 Hourly Pay Rate $80.00 Hourly Bill Rate $100.00 Hourly GM $15.96625 Pay needed for Target GM $70.96625 Bill needed for Target GM GM% 15.96625% Amount off Target GM% -9.03375% </tbody> 1 2 3 4 5=B4-B3-B2 6=B3+(B4*B9) 7 8=B5/B4...

<tbody> Tier Rate Differential Rate 1 0 5% 5% 2 500,001 10% 5% 3 100,0001 15% 5% 4 1,500,001 20% 5% 5 6 Deal 1 Amount 1,000,000 7 Commission =sumproduct((A1:A4<B6)*(B5-A1:A4)*(C1:C4)) =75,000 </tbody> I have a tiered comm calculation using the above...

Hi all, Please help me to calculate the retentaion rate of customer over months For example, - In January I have 4 new customer. - In February, 3 out of 4 continue to purchase my product > retention rate is 3/4 = 75%. - In July, 1 out of 4 purchase my product > retention rate is 1/4 = 25%...

<tbody> <colgroup><col><col><col><col><col><col></colgroup><tbody> 30 Investors Rate Lender A Lender B Lender C Lender D Lender E 6.125 #N/A 105.801 #N/A #N/A #N/A 6.000 #N/A 105.192 0.000 105.782 105.382 5.875 0.000 104.883...

Employee wages = x Social security tax rate = 6.2% Social security limit = $128,700(no tax payed after) FUTA tax rate = .6% FUTA limit = $7,000 Medicare tax rate = 1.45% No limit

I am trying to create a table to show a rate difference between two years for Labor Rate Increases. I have a table where in Cells C2:C9 I have a Labor Type and Cells B2:B9 I have the rate increase between two years. Then below this table I have a whole listing of employees with their Labor Type...

I am in the design phase and looking to get some ideas on the best way to design my spreadsheet. We have a small private org that makes purchases and hold fundraisers. Some items we buy in Japanese yen and some we buy in US Dollars. We also receive Japanese Yen and US dollars. What is the best...

Hi Folks, I am requesting help on the formula :confused:I can use to lookup on worksheet-2 and will populate the info I need for that reference info. See table below for better appreciation. WORKSHEET 1 <tbody> A B C D E F G 1 Engr Name ENGR GRADE ENGR RATE 2 JOHN *FORMULA NEEDED...

Get Date From Column C Matching Row Of Max Value I have an Excel spreadsheet where I save history of currency exchange rates. In one cell I inserted the formula =MAX(A:A). This gets the maximum exchange rate appearing in that column. In another cell I inserted the formula...

Re: Goal seek function in excel Guys, I am having some challenges with the MS Excel GOAL SEEK function. It worked alright for the first few times that I used it to work out the EFFECTIVE INTEREST RATE for the issuance of bonds. However, it is now coming back with absurd results...

Good afternoon :) I'm working on something to calculate the response rate from a completed evaluation However, I have a number of programmes and module responses within the evaluation data I've used countifs to calculate the number the number of completions for a specific module within the...

I’m new SQL, trying to teach myself but need some help --PREVIOUS Product ID , ISNULL(CONVERT(char, ReplacedProductID), '') AS 'Previous Product ID' I have this code (above) thatreturns a Product ID number, can I run a query off this result (within the samequery) to return another...

Hi forum! I'm reaching out because I've been working with this repurchase overview for a couple of weeks now and I can't seem to find a good way to solve this issue. What I want to see is the repurchase rate of a product - per month. Short explained: how many customers that have purchased this...

Hi, I need to get real time currency exchange rate EUR/USD. I must use this<code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida...

Hi, I'm trying to extract the dividend rate for a stock(ticker) from a data spreadsheet but I only need the dividend rate if the dividend's ex date and pay date fall before and after a certain date. In the "data" spreadsheet, in column A I have a list of tickers or unique IDs but there can...

Hello I have a work book with two tabs. 1. Contractual Rent Steps - This shows the annual cost per square foot. 2. Market Rent Steps - This will use the annual market cost per square foot with a 3% increase when the tenants Contractual annual rent step increases. What I am trying to do is...

Hello! I have in a cell a number which is the initial amount and in another cell a rate of decay. That rate can be a number by which you reduce the initial amount or a decay percentage by which again you reduce the initial amount. How can I write a formula that will calculate the decay of this...

I am trying to graph the frequency of a series of cap rates but want to also show the average age of properties that have that cap rate. For example, the chart will show there are 3 properties with a 6.5% cap rate, 6 properties with a 6.75% cap rate etc. but I also want to see the average age...

I am trying to calculate interest due on a Per-Diem basis when the interest rate changed during a given time period. For example, our institution sends out $100M on 05/20/2018 and charges an interest rate of WSJ Prime (adjusting daily) on a Per-Diem Basis. We receive a payoff request for 6/30/18...