Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Financial function requested, please
200000 is invested in an account that pays 5.05% APR (fixed). Interest is
compounded daily. I am trying to get an Excel formula that returns the amount of interest for a specified number of days. I see that there are a vast number of financial functions built into Excel and I am sure that one of these will do the trick, but getting lost. Any help appreciated. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Financial function requested, please
Jack Sheet wrote:
200000 is invested in an account that pays 5.05% APR (fixed). Interest is compounded daily. I am trying to get an Excel formula that returns the amount of interest for a specified number of days. If by "APR", you mean APY -- that is, the compounded rate, not the nominal rate -- then the daily rate can be computed by: =rate(365, 0, -1, 1+5.05%) Alternatively: =(1+5.05%) ^ (1/365) - 1 In either case, you might need to change the cell format to Percentage with 4 or more decimal places (Format Cells Number). Thus, the amount of interest accrued over 13 days can be computed by: =fv(A1, 13, 0, -200000) - 200000 where A1 is the daily rate. You might need to change the cell format to Number or Currency with 2 decimal places. PS: If by "APR", you actually mean the nominal annual rate, then the daily rate is simply 5.05%/365. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Financial function requested, please
Thank you very much. Yes I was quoting the APY - just what I needed
wrote in message oups.com... Jack Sheet wrote: 200000 is invested in an account that pays 5.05% APR (fixed). Interest is compounded daily. I am trying to get an Excel formula that returns the amount of interest for a specified number of days. If by "APR", you mean APY -- that is, the compounded rate, not the nominal rate -- then the daily rate can be computed by: =rate(365, 0, -1, 1+5.05%) Alternatively: =(1+5.05%) ^ (1/365) - 1 In either case, you might need to change the cell format to Percentage with 4 or more decimal places (Format Cells Number). Thus, the amount of interest accrued over 13 days can be computed by: =fv(A1, 13, 0, -200000) - 200000 where A1 is the daily rate. You might need to change the cell format to Number or Currency with 2 decimal places. PS: If by "APR", you actually mean the nominal annual rate, then the daily rate is simply 5.05%/365. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
financial function ..please | Excel Worksheet Functions | |||
VBA | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |