Excel FV for One Day: Daily Rate and Annuity Explained

In Excel, calculate a one-day future value with FV by using a one-day interest rate and setting the number of periods to 1. If your rate is a nominal annual rate, convert it to a daily rate first; FV does not automatically interpret an annual rate as a daily one.

What Excel FV means

Excel’s FV function returns the future value of an investment based on a constant interest rate and regular payments. Its syntax is FV(rate, nper, pmt, [pv], [type]). The rate and number of periods must describe the same time interval: a daily rate goes with a count of days, a monthly rate with a count of months, and so on.

The arguments are:

rate: Interest per period, expressed as a decimal or percentage. For example, 5% is entered as 5% or 0.05.
nper: The total number of periods. For exactly one period of one day, this is 1.
pmt: A fixed payment made each period. Use 0 when there are no recurring payments.
pv: The present value, or starting balance. This is optional in the function syntax, but including it makes the cash flow easier to see.
type: The payment timing: 0 means payments occur at the end of each period, and 1 means they occur at the beginning. If omitted, Excel uses 0.

FV follows a cash-flow sign convention. Money paid into an investment is normally entered as a negative amount, while the future amount received is positive. Thus, a negative present value can produce a positive future value. The signs identify the direction of cash flow; they do not mean the account balance itself is negative.

Set up the one-day calculation

For a clear worksheet, put the starting balance in B2, the nominal annual rate in B3, the number of days used for the annual rate in B4, and the number of days to grow the balance in B5. For example, enter 1000 in B2, 5% in B3, 365 in B4, and 1 in B5. This treats the quoted 5% as a nominal annual rate divided into 365 equal daily periods.

With the $1,000 starting balance in B2, the 5% nominal annual rate in B3, 365 in B4, and one day in B5, use:

=FV(B3/B4,B5,0,-B2)

The result is about $1,000.14. The daily rate is 5% divided by 365, or approximately 0.0136986% per day. One day’s interest is about 13.7 cents, so the unrounded balance is approximately $1,000.136986. Excel may display fewer decimal places depending on the cell format; currency formatting rounds the displayed value to $1,000.14.

There are no regular payments in this example, so pmt is 0. The starting balance is entered as -B2 so that FV returns the accumulated amount as a positive value. If you omit pv, FV assumes there is no starting balance, which would not answer this particular question.

Choose the right meaning of the annual rate

Dividing an annual rate by 365 is appropriate only when that matches the rate convention you are modeling. A nominal annual rate is often converted to a periodic rate by dividing by the number of periods in the year. An effective annual rate already represents the total compounded return over a year; its equivalent daily rate is not generally the effective annual rate divided by 365.

For an effective annual rate of 5%, put the starting balance in B2, the effective annual rate in B12, and the year’s day count in B4. The following calculation converts the effective annual rate to an equivalent daily rate and grows the B2 balance for one day:

=FV((1+B12)^(1/B4)-1,1,0,-B2)

With B2 equal to $1,000, B12 equal to 5%, and B4 equal to 365, the result is approximately $1,000.13. The daily equivalent rate is slightly lower than 5% divided by 365, because compounding that equivalent daily rate for a full year must produce exactly 5%. The difference for a single day is small here, but the distinction matters when matching an account’s stated rate or comparing results across a longer term.

Check the product’s terms before choosing the conversion. A bank account, loan, investment, or contract may define its rate using a particular compounding frequency or day-count convention. Excel FV performs the calculation you specify; it does not know which convention applies to a real financial product.

Use FV for a daily-payment annuity

A one-day future value of a single starting balance is different from the future value of an annuity. An annuity calculation involves a series of equal payments, made at regular intervals. If a person deposits money every day, the FV rate must be the daily rate, and nper must be the number of daily deposits or periods in the plan.

For an example, put a daily deposit of $10 in B8, a nominal annual rate of 5% in B9, 365 in B10, and 30 daily periods in B11. With payments made at the end of each day and no initial balance, calculate the value after 30 periods with:

=FV(B9/B10,B11,-B8,0,0)

The result is approximately $300.60. The deposits total $300, and earlier deposits earn a little interest before the end of the 30-day period. The first deposit is made at the end of day one, so it earns interest for fewer days than the deposits made earlier. The final payment is made at the end of day 30 and earns no interest within this calculation.

If the same $10 payments are made at the beginning of each day instead, enter 1 for type. With the same values in B8:B11, this formula gives the beginning-of-period result:

=FV(B9/B10,B11,-B8,0,1)

That result is approximately $300.64. Each payment is invested one period earlier than in the end-of-period example, so each has an extra day to earn interest. The distinction is modest at this rate and term, but it can become more noticeable with larger payments, higher rates, or longer periods.

Understand day counts and dates

FV does not take start and end dates as arguments. It counts equal periods. A calculation using a daily rate and nper of 1 therefore models one daily period, not necessarily the exact interest on a particular calendar date under a financial contract. The contract might use actual days in the year, a 360-day basis, business days, or another rule.

For instance, dividing by 365 assumes 365 equal periods in the year. That is a practical illustration, not a universal rule. In a leap year, a product might still apply a 365-day denominator, or its terms may specify another treatment. Similarly, one business day and one calendar day are not interchangeable when a weekend or holiday falls between dates.

Use FV when the periods are regular and equal. If you need to calculate interest across irregular dates, or must follow an exact day-count convention, identify that convention first and use a method designed for the dates and rules involved. Do not change the denominator merely to make a result look familiar; it should reflect the rate definition you are applying.

Common mistakes and how to check them

Several frequent errors come from mixing units or misunderstanding the cash-flow arguments. Before relying on a result, check the following:

Annual rate with daily periods: Using 5% as rate and 1 as nper calculates one period at 5%, not one day at a 5% annual rate. Convert the rate to the matching daily rate.
Wrong number of periods: For one day, nper is 1. For 30 daily periods, it is 30. Do not enter 365 simply because the annual rate is quoted per year if the calculation lasts only one day.
Missing starting balance: If there is no payment and pv is omitted, the result is zero. Include the opening balance in pv when calculating growth on existing money.
Cash-flow signs reversed: If both pv and pmt are entered with the same sign, FV may return a negative result. Reverse the sign of the cash paid in so the future receipt appears positive.
Payment timing overlooked: The default type is 0, for payments at the end of a period. Choose type 1 only when payments happen at the start.
Displayed rounding mistaken for calculation error: Excel can retain more precision than the cell shows. Increase displayed decimal places or inspect the underlying value before concluding that a few cents are missing.

A useful reasonableness check is to compare the result with the starting amount. At a positive rate and with no withdrawals, a one-day future value should be slightly above the starting balance. At a negative rate, it may be slightly below. For a short annuity at a modest positive rate, the future value should be close to the total contributions, with a small increase from interest when early payments have time to grow.

When FV is not the right tool

FV is suitable for a constant rate and regular, equal-period payments. It is not a date-aware interest calculator, and it does not automatically handle a different rate for each day, a changing payment amount, or irregular deposits. If the balance earns different rates over time, the calculation has to represent those rate changes rather than applying one constant rate to every period.

For a single one-day balance, the core idea is simply to multiply the opening balance by one plus the applicable one-day rate. FV can still be convenient because it keeps the calculation in the same form as a longer savings or annuity model, and the same worksheet can be extended by changing nper. For irregular cash flows, use a cash-flow method that fits their timing rather than treating them as equal periodic payments.

Frequently Asked Questions

What rate should I enter in Excel FV for one day?
Enter the one-day rate, not the annual rate, when nper is 1. For a nominal annual rate divided into 365 equal daily periods, use the annual rate divided by 365. Follow the specific rate and day-count terms if you are modeling a real account or contract.

Can I use FV to calculate one day of interest?
Yes. Set nper to 1, pmt to 0, and pv to the opening balance with the opposite sign from the positive future value you want returned. Make sure the rate argument represents one day.

Why is my Excel FV result negative?
FV uses cash-flow signs. If your starting balance or payments have the wrong sign for the result you expect, Excel may return a negative future value. Enter contributions as negative cash flows when you want the accumulated amount returned as positive.

What does type mean in the FV annuity formula?
Type specifies payment timing. Use 0 for payments at the end of each period and 1 for payments at the beginning. For a daily annuity, that choice changes how many days each deposit earns interest.

Should I divide an annual rate by 365 or 360?
Use the convention specified by the rate or contract you are modeling. Neither denominator is correct for every situation. If you are making a general illustration, state the assumption clearly so the result is not mistaken for a contract-specific figure.

Does Excel FV use actual calendar dates?
No. FV uses a rate and a number of equal periods; it does not calculate the interval from start and end dates. For irregular dates or a specified day-count basis, use a date-aware approach that reflects those rules.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.