Corporate Finance #8 Time Value of Money (PV & FV)

Explore multiple methods to calculate future value, including the formula, Excel, and future value tables, using a $10,000 investment over 3 years at 8% with year-by-year analysis.

Learn to calculate present value using math formula, Excel-style functions, and present value tables, examining rate, period, and rounding effects across multiple practice problems.

Explore how the time value of money changes when interest is compounded annually vs semiannually in a corporate finance PV and FV context, using formulas and Excel tables.

compare receiving money today versus in the future using present value and a chosen discount rate to determine the optimal lump-sum versus waiting for future payments.

Compare present value at different discount rates side by side, applying the time value of money to convert 100,000 in 30 years to today, using Excel, tables, and financial calculators.

Explore present value planning with scenarios for the present value of a lump sum and annuities, using a twelve percent rate to reach fifteen thousand in nine years.

Explore the future value of an annuity by computing a $12,000 per-period investment over nine years at 7%, using the formula, tables, and Excel to illustrate a running balance.

Explore how to compute the future value of uneven investments using formulas and Excel, via a two-stage case from 14,000 at 11% for 10 years to 15% for 12 years.

Calculate the present value of an annuity with eleven thousand per year for eighteen years at fourteen percent, using the annuity formula, tables, and Excel to compare results.

Understand the present value of an annuity with uniform $40,000 payments over 14 years, using formulas, Excel, and tables, and blend present value of one when needed.

Explore the present value of uneven payments by breaking into annuity and balloon components, applying present value of one and annuity formulas with Excel and tables.

Compute the future value of a collectible using the future value formula with pv 35,000, r 11%, and n 14 years; compare running balance, Excel, and tables methods.

Compute the future value of an annuity by applying the formula, running balances, and Excel and table methods, using 2,500 per period for 12 periods at 9%.

Learn how to determine when an investment doubles or triples using future value, present value, and rate, with excel methods like goal seek and table estimates.

Compute the present value of stock investments over three years by discounting dividends and sale, using pv, fv, annuity, and present-value-of-one calculations, with Excel support.

Compute the future value of a 150 present value with quarterly compounding at 16% over five years using PV × (1+r)^n, and apply Excel for calculations.

Compare future value calculations for a $15,000 investment at 8% over 10 years using annual, semiannual, and quarterly compounding, and learn period-specific rate adjustments.

Compare lump-sum present value and annuity calculations to reach a $30,000 goal at 12% over 10 years, using one payment or eight payments with Excel tools.

Use annuity calculations to find the interest rate in a future value problem. The stock example shows solving for rate with FV = PV(1+r)^n and using Excel's goal seek tool.

Apply the present value of an annuity formula to solve for the interest rate given a 60,000 present value, 5,500 payments, and 20 periods, using algebra, Excel, and goal seek.

Explore solving for the annuity payment when the present value is 500,000 at 10% over 25 years, using present value formulas and Excel tools.

Apply present value and future value annuity calculations to retirement planning: determine the lump sum for 26,000 for 24 years and the annual savings needed for 25 years.

Present value uneven payments by valuing cash flows and a seven-year twelve thousand annuity at 10 percent. Compare PV of one and annuity methods using Excel and tables, noting rounding.

Explore how to value a deferred annuity two years out using present value techniques, converting payments to present value either as an annuity or as individual payments at 14 percent.

Explore a corporate finance time value of money: 455,000 loan with an eight-year no-payment period at 10%, followed by sixteen payments at 14% to amortize uneven repayments, pv and fv.

Learn how to compute a home loan payment using present value of an annuity, explore monthly versus yearly payments, and build an amortization table in Excel.

Demonstrate reaching 400,000 with a 15-year semiannual annuity at 10%, then adjust after six payments for a 12% rate using goal seek and the FV and PMT functions in Excel.

Compute present and future values of a college savings plan using annuity methods at nine percent, projecting four payments of forty thousand starting in year five and identifying additional contributions.

Learn to compute future value in Excel using multiple formats—formula, running balance, Excel functions, and tables—for a three-year, eight percent investment of ten thousand, illustrating PV and FV concepts.

Master present value calculations in Excel with multiple formats, using the PV function and table methods to convert future values into today’s dollars under varying discount rates.

Explore how to calculate future value with annual versus semiannual compounding in Excel, using the formula for future value and practices with running balances and tables.

Explore time value of money in decision making by calculating present value with discount rates in Excel, using future value and break-even analysis.

Explore present value and the time value of money in Excel, using different discount rates side-by-side and goal seek to equate 100,000 in 30 years to 20,000 today.

Learn present value planning by solving PV and annuity problems with Excel formulas and tables, including scenarios like 15000 in 9 years at 12% and 8000 per period.

Explore the future value of an annuity using Excel and traditional methods, including a formula, running balance tables, and annuity tables, with examples at 7% over 9 years.

Learn to compute the future value of uneven investments using present and future value methods, breaking cash flows into components or annuities, with table and Excel approaches.

Calculate the present value of an annuity using a mathematical formula and Excel PV, for 11,000 per year over 18 years at 14 percent.

Develop the present value of an annuity using a formula, Excel's pv function, and table methods for a 40,000 per year, 14-year cash flow at 14%.

Explore how to compute present value for uneven payments by separating into an annuity and a balloon payment, using present value of one and annuity formulas in Excel.

Calculate the future value of an annuity using the Excel future value function and the annuity formula. Practice with a $2,500 payment for 12 periods at 9%.

Apply the future value formula to find how long to double or triple an investment, using Excel with Goal Seek, running balance tables, and present value, rate, and periods.

Explore a corporate finance practice problem in Excel, calculating present value of one for year-by-year stock returns and a three-year sale, and compare math, PV function, and table methods.

Compute the future value of a present value of 150,000 with a 16% annual rate, compounded quarterly for five years, using formula, running balance, Excel functions, and table methods.

Explore how future value changes with annual, semiannual, and quarterly compounding using Excel, running balances, and table methods for a 15,000 payment over 10 years at 8 percent.

Compute the present value of an annuity due with payments at the beginning of each period using Excel PV, running-balance, and annuity tables at 12% for 4500 per period.

Compare and contrast current payments, annuities, and future payments using present value, discount rate, and Excel calculations; evaluate options and determine the best choice under time value of money.

Explore how to reach a 30,000 goal in 10 years by comparing a lump-sum present value to an annuity, using Excel present value formulas, with goal seek to solve unknowns.

Learn to back into the rate of return using the future value formula in excel, solving present value and future value with goal seek, trial-and-error, and tables.

Explore how to back into the interest rate from an annuity using the present value of an annuity formula in Excel, and apply algebra, goal seek, and what-if analysis.

Apply the annuity payment calculation using present value, rate, and periods with algebraic formulas and Excel Goal Seek. Compute payments for a 500,000 investment over 25 years at 10 percent.

Use Excel to model a retirement scenario with present value and future value of annuities, sizing the retirement lump sum and annual savings via goal seek.

Examine present value of uneven payments by computing value of one and of an annuity in Excel, using a 10% rate for three years plus seven years of 12k payments.

Learn to value a two-year deferred annuity of 25,000 payments over ten years at 14 percent using Excel, via annuity-to-lump-sum and PV of one methods.

Analyze the time value of money (pv & fv) by computing the future value of one and present value of an annuity for uneven loan repayments using Excel.

Learn to compute home loan payments using Excel, PV & FV concepts, annuities, and amortization for yearly vs monthly payments at 7% over 30 years.

Explore time value of money by computing the future value of a semiannual annuity with a rate change from 10% to 12% and reaching 400,000 in 15 years using Excel.

Explore the present value and future value of an annuity within a college savings plan, using Excel to project needed contributions and the impact of a 9% rate.