| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wieghted average rate
I need your help to calculate the weighted average for the loans expenses
(transfer pricing). Sample: # Of month outstanding loans TP rate 1 100,000 1.50% 2 98,000 1.54% 3 97,000 1.60% ...... -- ash |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wieghted average rate
Let's say the loans are in B2:B20 and the percentages in C2:C20
Use =SUMPRODUCT(B2:B2,C2:C20)/SUM(B2:B20) best wishes -- www.stfx.ca/people/bliengme "ash" wrote: I need your help to calculate the weighted average for the loans expenses (transfer pricing). Sample: # Of month outstanding loans TP rate 1 100,000 1.50% 2 98,000 1.54% 3 97,000 1.60% ..... -- ash |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wieghted average rate
Thanks Bernard
-- ash "Bernard Liengme" wrote: Let's say the loans are in B2:B20 and the percentages in C2:C20 Use =SUMPRODUCT(B2:B2,C2:C20)/SUM(B2:B20) best wishes -- www.stfx.ca/people/bliengme "ash" wrote: I need your help to calculate the weighted average for the loans expenses (transfer pricing). Sample: # Of month outstanding loans TP rate 1 100,000 1.50% 2 98,000 1.54% 3 97,000 1.60% ..... -- ash |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate weighted average effective interest rate | Excel Worksheet Functions | |||
| Compound Average Annual Growth Rate | Excel Worksheet Functions | |||
| Average Monthly Growth rate | Excel Worksheet Functions | |||
| Average Growth Rate | Excel Discussion (Misc queries) | |||
| growth rate but not average | Excel Discussion (Misc queries) | |||
Linear Mode
