Microsoft Excel for Accounting, Finance & Financial Analysis

Explore the double declining balance method and how doubling the straight-line rate yields depreciation in Excel using the DB function with cost, salvage value, life, period, and factor.

Explore the time value of money by calculating present value and future value using simple and compound interest, and learn how to apply Excel formulas for these conversions.

Compute the present value of an annuity using an Excel PV formula with a 10% rate over five periods, paying at the end of each period, yielding 379,079.

Calculate the future value of five annual payments of 100,000 at 10%, using the fv function to accumulate to year five, totaling 610,510.

Calculate the future value of a 100,000 principal over five years with changing annual rates using excel's fv schedule, and confirm with a year-by-year compounding method.

Learn to compute the discount rate using Excel's rate function from present value and future value across five periods, including annuities and negative cash flows.

Learn to calculate the number of periods with the NPER function using rate, present value, future value, and optional payments, demonstrated by converting 1000 to 1611 at 10% discount rate.

Reinforce the net present value concept by converting all cash flows to present value, then netting them to measure project profitability, with an Excel formula to calculate NPV.

Calculate the net present value of a four-year project in Excel at a 10% discount rate, including year zero ($50,000) and yearly cash flows, noting NPV ignores year zero.

Explore how the xnpv formula in Excel overcomes limitations of standard npv by entering cash flows with dates and a discount rate to compute net present value in one step.

Explain how MIRR overcomes IRR limitations by incorporating financing costs and reinvestment rates, using Excel's MIRR formula on a four-year project.

Calculate the rate of return needed to grow 50,000 to 100,000 in five years using the Excel rate function, revealing a required return of about 14.87%.

Apply the PMT function in Excel to compute annual loan payments, including principal and interest, using a $50,000, 12% over 10 years, with optional monthly conversion.

Learn how to use the PMT function in Excel to calculate principal payments on a $50,000 loan, with rate 12% over 10 periods, using absolute references.

Use the Excel CUMIPMT function to calculate cumulative interest for any loan term. Enter rate, nper, pv, start_period, end_period, and type to get total interest quickly.

learn to compute the interest portion of each fixed equal principal loan payment using excel pmt, with a 50,000 loan over 10 years at 12%.

Convert nominal rate to effective rate using an Excel formula, and see how monthly compounding makes 12% nominal become 12.68% effective, illustrating npery and compounding basics.

Calculate the price, or market value, of a redeemable bond by discounting its future cash flows to present value at the investor's required rate, using coupon payments and yield.

Compute the bond yield, the investor's required rate or cost of debt, from market value and cash flows using IRR or Excel's yield function, illustrated with a 3-year case.

Use Excel's what-if analysis to evaluate project sensitivity by applying Goal Seek to reach a target NPV, adjusting discount rate, annual cash flow, or project duration.

Apply the goal seek function to set the selling price to achieve a 40% ROI, using a fully linked P&L and what-if analysis.

Use Excel scenario manager to analyze outputs for multiple inputs and compare current, best case, and worst case scenarios. Generate a concise ROI report from the P&L.

Plot trendlines in Excel using sparklines to visualize revenue and expense trends on the profit and loss statement, enabling quick horizontal analysis from 2016 to 2019.

Learn to perform horizontal analysis on the balance sheet in Excel by adding trendlines, calculating year-over-year percentage changes, and using IFERROR to handle data gaps and identify exceptions.

Apply vertical analysis to the profit and loss statement by expressing each item as a percentage of revenue, then compare across years using absolute references and data bars.