Time Value of Money with Excel

Calculate the future value of investments using compounding and compound interest, via the formula fv = pv*(1+i)^n, from a present value of 20000 at 8% for 3 years.

Learn to calculate future value in Excel by inputting present value, rate, duration, and payment, then use the future value function on practical examples.

Explore how to compute future value from present value when interest is paid multiple times a year by adjusting the formula for semiannual and monthly compounding, with practical examples.

Learn to compute future value for a single payment with multiple compounding periods in Excel using the FV function, with semiannual, monthly, and quarterly examples.

Learn to calculate present value using discounting, compare with future value, and apply the formula present value equals future value divided by (1 plus discount rate) for five-year car goals.

Demonstrates present value in excel using the pv function with rate, nper, and fv to determine today's deposit for future sums (10 lakh, 5 years; 75 lakh, 15 years).

Calculate the annual growth rate or rate of return from present value and future value using present value times (1+r)^n equals future value, with a 2000 to 10000 investment example.

Calculate the interest or growth rate in Excel using the rate function with present value, future value, duration, and payments, illustrated by a 2000 to 10000 ten-year example.

Compute the number of periods needed for a present value to reach a future value using natural logs, applying the formula n = ln(FV/PV)/ln(1+i) with examples.

Apply Excel's nper function to determine the number of periods needed to accumulate a future value, using rate, present value, future value, and payments or lump-sum inputs.

Explore annuities as streams of equal cash payments over a fixed period, differentiate ordinary annuity and annuity due, and compare future value and present value calculations.

Calculate the future value of an ordinary annuity with annual compounding at 8% over five years, using a yearly deposit of 48,000 rupees.

Demonstrate calculating the future value of an ordinary annuity in excel using the FV function. End-of-year payments of 20,000 for nine years at 6.25% compounded annually yield 232,217.

Explain the future value of an annuity due with payments at the beginning. Using 12 percent per annum, rupees five thousand yearly over 30 years yields rupees 1,351,462.

Calculate the future value of an annuity due in Excel by modeling deposits at the beginning of each year, using a 5.75% rate over ten years.

Calculate the future value of an annuity with other compounding periods by splitting the annual rate into per-period rate and adjusting the duration, illustrated with quarterly, monthly, and semiannual examples.

Compute the future value of an annuity with other compounding periods in Excel using monthly deposits, a 6.5% rate, and the FV function for 30 years to reach 53,089 rupees.

Learn to calculate the future value of an annuity due across different compounding periods, comparing ordinary and due payments with an 8% monthly example.

Explore future value of an annuity due with monthly compounding in Excel, using rate per period, total periods, and the beginning-of-period type to compare with ordinary annuities.

Calculate the present value of an ordinary annuity to determine how much you can borrow today and the required loan payments under a given interest rate.

Learn to calculate the present value of an ordinary annuity in Excel by entering rate, periods, and end-of-year payments. See how the example determines a loan amount.

Learn to calculate the present value of an annuity due by converting from ordinary annuity, using a six percent rate over eight years with a 100,000 payment at period start.

Calculate the present value of an annuity due in Excel using the PV function, with rate 7%, 20 periods, 50,000 per year, first payment today.

Calculate the present value of an annuity with multiple compounding periods using Excel, illustrated by a $90,000 loan at 4.5% paid monthly over 15 years.

Explore how to calculate the present value of an annuity with different compounding periods using Excel's PV function, illustrated by monthly loan payments and converting annual rates to monthly periods.

Compute the present value of an annuity due with monthly compounding at 14 percent, using 24 monthly payments of 5000 as a practical example.

Learn to calculate the present value of an annuity due in Excel using the PV function with type 1 for beginning payments across 60 monthly periods with different compounding.

Learn how to calculate loan installments in excel using the payment function, including yearly and monthly payments for a 100,000 loan over 10 years at 9.5% interest.

Apply the Excel rate function to calculate the rate of return on annuity payments, comparing present value and annual payments to reveal a 6% return.

Use Excel's NPER function to compute the finite number of periods in annuity payments needed to reach a financial goal, given an initial deposit, annual savings, and 12 percent return.

Learn to calculate the interest portion of each loan installment using Excel's IPMT function, showing how early payments are mostly interest and later payments are principal.

In time value of money with Excel, compute the principal component of each loan installment using an Excel principal payment function with the monthly rate derived from the annual rate.

learn to calculate cumulative interest paid on a loan using Excel's CUMIPMT, for the first year or last year, and reflect it as a profit and loss account expense.

Learn to calculate cumulative principal paid on a loan in Excel using the cumulative principal function, illustrated with an eight million, 30 year loan and monthly payments.

Calculate the effective annual rate from nominal rates and compounding using Excel's EFFECT function. Understand how semiannual and monthly compounding affect the EAR to compare bank offers.

Calculate the present value of a perpetuity by dividing annual income by the discount rate, demonstrated with eight percent and sixteen percent scenarios.

Learn to compute a borrower’s loan amortization schedule in Excel, using quarterly installments, and track interest and principal components along with cumulative interest.

Learn to compute a loan amortization schedule from the lender’s perspective using excel functions like pmed and ibm to determine the installment, interest portion, and principal portion.