Канал: Ronald Moy, Ph.D., CFA, CFP

Downloading Excel Workbooks From Office 365 and Google Sheets

Downloading Excel Workbooks From Office 365 and Google Sheets

Tbill Calculations in Google Sheets

Tbill Calculations in Google Sheets

How to Evaluate Extended Warranties

How to Evaluate Extended Warranties

Using Data Table for Creating Annuity Tables in Excel

Using Data Table for Creating Annuity Tables in Excel

NPV Profile in Excel

Using Goal Seek in Google Sheets

Using Goal Seek in Google Sheets

Equity and Debt Payoffs in Excel

Equity and Debt Payoffs in Excel

Using Excel to Solve Homework from Word and PDF Files

Using Excel to Solve Homework from Word and PDF Files

Calculating Free Cash Flow and Firm Value

Calculating Free Cash Flow and Firm Value

Total Wealth Ratio Cumulative and Geometric Returns

Total Wealth Ratio Cumulative and Geometric Returns

Ratio Analysis Profitability Measures

Ratio Analysis Profitability Measures

Ratio Analysis Liquidity Ratios

Ratio Analysis Liquidity Ratios

Ratio Analysis Leverage and Coverage Ratios

Ratio Analysis Leverage and Coverage Ratios

Ratio Analysis Efficiency Ratios

Ratio Analysis Efficiency Ratios

Mergent Online

Mergent Online

Using the Duration and MDuration functions in Google Sheets

Using the Duration and MDuration functions in Google Sheets

Federal Reserve Data (FRED )

Federal Reserve Data (FRED )

SP NetAdvantage

SP NetAdvantage

Stock Price and VIX Data from Yahoo Finance

Stock Price and VIX Data from Yahoo Finance

Computing Portfolio Beta in Excel

Computing Portfolio Beta in Excel

Forecasting Stock Prices in Excel using Regression

Forecasting Stock Prices in Excel using Regression

Scenario Manager in Excel - Capital Budgeting Example

Scenario Manager in Excel - Capital Budgeting Example

Annualized Returns in Excel

Annualized Returns in Excel

NPV and IRR in Google Sheets

NPV and IRR in Google Sheets

Annualized Returns with Periodic Investments in Excel

Annualized Returns with Periodic Investments in Excel

Data Table for Retirement Savings in Excel

Data Table for Retirement Savings in Excel

Simulating a Seven Game NBA Series in Excel

Simulating a Seven Game NBA Series in Excel

Monte Carlo Simulation - Expected Price

Monte Carlo Simulation - Expected Price

Monte Carlo Simulation - Cumulative Stock Returns in Excel - Revised

Monte Carlo Simulation - Cumulative Stock Returns in Excel - Revised

Monte Carlo Simulation - Proforma Income Statement

Monte Carlo Simulation - Proforma Income Statement

Easy Payback and Discounted Payback Period in Excel - Revised

Easy Payback and Discounted Payback Period in Excel - Revised

Bond Valuation Price Function in Google Sheets

Bond Valuation Price Function in Google Sheets

Computing IRR Using Goal Seek in Excel

Computing IRR Using Goal Seek in Excel

Value at Risk in Google Sheets

Value at Risk in Google Sheets

PV and FV of Annuities on TI BA II Plus

PV and FV of Annuities on TI BA II Plus

PV and FV on the TI BA II Plus Financial Calculator

PV and FV on the TI BA II Plus Financial Calculator

Bond Valuation in Google Sheets

Bond Valuation in Google Sheets

EAR vs APR on HP 12c

EAR vs APR on HP 12c

Expected Return and Variance in Google Sheets

Expected Return and Variance in Google Sheets

Odd Price and Yield in Excel

Odd Price and Yield in Excel

Using Solver in Google Sheets to find the Minimum Variance Portfolio

Using Solver in Google Sheets to find the Minimum Variance Portfolio

Yield Functions in Excel

Yield Functions in Excel

Compound Annual Growth Rate in Google Sheets

Compound Annual Growth Rate in Google Sheets

Fractional and Decimal Stock Quotes in Excel

Fractional and Decimal Stock Quotes in Excel

Payback and Discounted Payback Period in Google Sheets

Payback and Discounted Payback Period in Google Sheets

Optimizing the Sharpe Ratio Using Solver in Google Sheets

Optimizing the Sharpe Ratio Using Solver in Google Sheets

Constructing a Variance Covariance Matrix in Google Sheets

Constructing a Variance Covariance Matrix in Google Sheets

Computing Portfolio Variance in Google Sheets with Matrices

Computing Portfolio Variance in Google Sheets with Matrices

Portfolio Risk and Return in Google Sheets

Portfolio Risk and Return in Google Sheets

Computing Portfolio Variance in Excel using Matrices

Computing Portfolio Variance in Excel using Matrices

APR vs EAR

APR vs EAR

Monte Carlo Simulation Capital Budgeting in Google Sheets

Monte Carlo Simulation Capital Budgeting in Google Sheets

Monte Carlo Simulation Retirement Withdrawals in Google Sheets

Monte Carlo Simulation Retirement Withdrawals in Google Sheets

Using Goal Seek in Excel

Using Goal Seek in Excel

Terminal or Horizon Value

Terminal or Horizon Value

Fisher Effect - Revised

Fisher Effect - Revised

Three More Useful Financial Functions in Excel

Three More Useful Financial Functions in Excel

Dupont Analysis - Revised

Dupont Analysis - Revised

Three Useful Financial Functions in Excel

Three Useful Financial Functions in Excel

Computing Black Scholes in Excel

Computing Black Scholes in Excel

Creating a Cash Flow Statement in Excel

Creating a Cash Flow Statement in Excel

Importing Data from an Image into Excel

Importing Data from an Image into Excel

Using the Duration and MDuration functions in Excel

Using the Duration and MDuration functions in Excel

Computing Portfolio Variance in Excel using Matrices

Computing Portfolio Variance in Excel using Matrices

Monte Carlo Simulation Retirement Savings in Google Sheets

Monte Carlo Simulation Retirement Savings in Google Sheets

Monte Carlo Simulation of Option Value in Google Sheets

Monte Carlo Simulation of Option Value in Google Sheets

Monte Carlo Simulation Option Values in Excel

Monte Carlo Simulation Option Values in Excel

NPV and IRR on the HP bii Plus Calculator

NPV and IRR on the HP bii Plus Calculator

Call Bull Spread in Excel Revised

Call Bull Spread in Excel Revised

FV Multiple CFs on HP 10bii Plus

FV Multiple CFs on HP 10bii Plus

Computing the Value of the DJIA

Computing the Value of the DJIA

FV Multiple CFs on TI BAII Plus

FV Multiple CFs on TI BAII Plus

YTM on HP 10bii plus Calculator

YTM on HP 10bii plus Calculator

YTM in Excel and TI BA II Plus

YTM in Excel and TI BA II Plus

YTM on HP 12C Calculator

YTM on HP 12C Calculator

FV Multiple CFs on HP 12 Calculator

FV Multiple CFs on HP 12 Calculator

ISPMT Function in Excel

ISPMT Function in Excel

IPMT and PPMT Functions in Excel

IPMT and PPMT Functions in Excel

CUMIPMT and CUMPRINC Functions in Excel

CUMIPMT and CUMPRINC Functions in Excel

Creating a Stock Portfolio in Google Sheets and Exporting to Excel

Creating a Stock Portfolio in Google Sheets and Exporting to Excel

Computing Compound Annual Growth Rate in Excel

Computing Compound Annual Growth Rate in Excel

Clean and Dirty Bond Prices

Clean and Dirty Bond Prices

Historical Stock Price Data in Google Sheets

Historical Stock Price Data in Google Sheets

Computing After Tax Salvage Value

Computing After Tax Salvage Value

Equity Account Changes for Stock Dividend

Equity Account Changes for Stock Dividend

Millers Theory of Capital Structure with Corporate and Personal Taxes

Millers Theory of Capital Structure with Corporate and Personal Taxes

Computing Profitability Index in Excel

Computing Profitability Index in Excel

Computing Theoretical Spot Rates in Excel

Computing Theoretical Spot Rates in Excel

Payback and Discounted Payback Period in Excel

Payback and Discounted Payback Period in Excel

Plotting Efficient Frontier for Four Securities in Excel

Plotting Efficient Frontier for Four Securities in Excel

Computing the Sortino Ratio Excel

Computing the Sortino Ratio Excel

Getting Historical Currency Quotes in Excel 365

Getting Historical Currency Quotes in Excel 365

Getting Historical Stock Prices in Excel 365

Getting Historical Stock Prices in Excel 365

Computing Depreciation in Excel

Computing Depreciation in Excel

Contango vs Backwardation

Contango vs Backwardation

Valuing a Currency Swap

Valuing a Currency Swap

Valuing an Interest Rate Swap

Valuing an Interest Rate Swap

Visualizing Utility of Wealth in Excel

Visualizing Utility of Wealth in Excel

Synthetic Put Payoff in Excel

Synthetic Put Payoff in Excel

Synthetic Call Payoff in Excel

Synthetic Call Payoff in Excel

Short Sale vs Long Put in Excel

Short Sale vs Long Put in Excel

Long Stock vs Long Call Payoff in Excel

Long Stock vs Long Call Payoff in Excel

Butterfly Spread Payoff in Excel

Butterfly Spread Payoff in Excel

Strip and Strap Payoff in Excel

Strip and Strap Payoff in Excel

Straddle Payoff in Excel

Straddle Payoff in Excel

Put Bear Spread Payoff in Excel

Put Bear Spread Payoff in Excel

Call Bull Spread Payoff in Excel

Call Bull Spread Payoff in Excel

Forward Rate Agreements

Forward Rate Agreements

Put and Call Payoffs in Excel

Put and Call Payoffs in Excel

Foreign Exchange Bid Ask Spreads

Foreign Exchange Bid Ask Spreads

Lease vs Buy Decision

Lease vs Buy Decision

Monte Carlo Simulation Retirement Withdrawals

Monte Carlo Simulation Retirement Withdrawals

Vector Autoregression VAR

Vector Autoregression VAR

ARCH and GARCH Models

ARCH and GARCH Models

ARIMA Time Series Model

ARIMA Time Series Model

ARMA Time Series Models

ARMA Time Series Models

Time Series Stationarity

Time Series Stationarity

Moving Average (MA) Time Series Model

Moving Average (MA) Time Series Model

Autoregressive (AR) Time Series Models

Autoregressive (AR) Time Series Models

Value at Risk in Excel Historical vs Monte Carlo Methods

Value at Risk in Excel Historical vs Monte Carlo Methods

Monte Carlo Simulation in Excel - Capital Budgeting

Monte Carlo Simulation in Excel - Capital Budgeting

Monte Carlo Simulation in Excel - Retirement Savings

Monte Carlo Simulation in Excel - Retirement Savings

Present Value of Growth Opportunities

Present Value of Growth Opportunities

Fama French Three Factor Model

Fama French Three Factor Model

Estimating Alpha and Beta in Excel

Estimating Alpha and Beta in Excel

Where to Put Retirement Savings for Recent Graduates

Where to Put Retirement Savings for Recent Graduates

Computing the Information and Sharpe Ratios in Excel

Computing the Information and Sharpe Ratios in Excel

Accounting The Lemonade Stand

Accounting The Lemonade Stand

Finding the Risk Premium for a Utility Function

Finding the Risk Premium for a Utility Function

Computing Value at Risk Using Excel

Computing Value at Risk Using Excel

Getting Currency Quotes in Microsoft Excel 365

Getting Currency Quotes in Microsoft Excel 365

Importing Data from the Web into Excel

Importing Data from the Web into Excel

Forecasting in Excel

Forecasting in Excel

Create a Stock Portfolio in Excel 365

Create a Stock Portfolio in Excel 365

Ipmt and Ppmt Functions in Excel

Ipmt and Ppmt Functions in Excel

Sharing References in Zotero

Sharing References in Zotero

Constructing a Variance Covariance Matrix in Excel

Constructing a Variance Covariance Matrix in Excel

Covariance and Correlation in Excel

Covariance and Correlation in Excel

Zotero Reference Management Software

Zotero Reference Management Software

Two Approaches for Computing Portfolio Variance in Excel

Two Approaches for Computing Portfolio Variance in Excel

Portfolio Optimization in Excel - Revised

Portfolio Optimization in Excel - Revised

Portfolio Optimization in Excel

Portfolio Optimization in Excel

Maximizing the Sharpe Ratio Using Solver in Excel

Maximizing the Sharpe Ratio Using Solver in Excel

Using Solver to Find Minimum Variance Portfolio in Excel

Using Solver to Find Minimum Variance Portfolio in Excel

Minimum Variance Portfolio in Excel

Minimum Variance Portfolio in Excel

Portfolio Risk and Return in Excel

Portfolio Risk and Return in Excel

NPV and IRR in Excel

NPV and IRR in Excel

Loan Amortization on HP 12c

Loan Amortization on HP 12c

Percentage Calculations on the HP 12c

Percentage Calculations on the HP 12c

Weighted Average on the HP 12c Financial Calculator

Weighted Average on the HP 12c Financial Calculator

Date Calculations on HP 12c

Date Calculations on HP 12c

Depreciation on HP 12c

Depreciation on HP 12c

Computing NPV and IRR on HP 12c

Computing NPV and IRR on HP 12c

Bond Pricing and YTM on HP 12c

Bond Pricing and YTM on HP 12c

Time value of money on HP 12c

Time value of money on HP 12c

Intro to HP 12c Financial Calculator

Intro to HP 12c Financial Calculator

Weighted Average on the HP bII+ calculator

Weighted Average on the HP bII+ calculator

Date Calculations on HP bII+ financial calculator

Date Calculations on HP bII+ financial calculator

Bond Worksheet HP bII+ Financial Calculator

Bond Worksheet HP bII+ Financial Calculator

Statistics on the HP bII+ financial calculator

Statistics on the HP bII+ financial calculator

HP 10bII+ calculator modes

HP 10bII+ calculator modes

Loan Amortization on HP bII+ Financial Calculator

Loan Amortization on HP bII+ Financial Calculator

Depreciation on HP bII+ Financial Calculator

Depreciation on HP bII+ Financial Calculator

EAR vs APR on HP bII

EAR vs APR on HP bII

Break Even on HP bII+ Financial Calculator

Break Even on HP bII+ Financial Calculator

Financial Calculator Intro - TI BA II Plus vs HP 10bii+

Financial Calculator Intro - TI BA II Plus vs HP 10bii+

Equity Valuation

Equity Valuation

Modern Portfolio Theory

Modern Portfolio Theory

Capital Market Line (CML) vs Security Market Line (SML)

Capital Market Line (CML) vs Security Market Line (SML)

Expected Utility and Insurance

Expected Utility and Insurance

Why are Exchange Rates so Confusing?

Why are Exchange Rates so Confusing?

FV Schedule Function in Excel

FV Schedule Function in Excel

Using Sumproduct Function to Compute Expected Return and Variance

Using Sumproduct Function to Compute Expected Return and Variance

XNPV and XIRR Functions in Excel

XNPV and XIRR Functions in Excel

Rule of 72

Rule of 72

TI BA II Plus Calculator - Which Version Should I Purchase?

TI BA II Plus Calculator - Which Version Should I Purchase?

TI BA II Plus Calculator Modes

TI BA II Plus Calculator Modes

Tbill Calculations in Excel

Tbill Calculations in Excel

Bond Valuation Price Function in Excel

Bond Valuation Price Function in Excel

Time Value of Money Annuities

Time Value of Money Annuities

Time Value of Money Present Value

Time Value of Money Present Value

Time Value of Money Future Value

Time Value of Money Future Value

Short Selling

Short Selling

Buying on Margin

Buying on Margin

Relative Valuation

Relative Valuation

CFA Study Tips

CFA Study Tips

Stock Splits Stock Dividends and Stock Repurchases

Stock Splits Stock Dividends and Stock Repurchases

Prospect Theory

Prospect Theory

Interest Rate Parity: A Caveat

Interest Rate Parity: A Caveat

GRETL Limited Dependent Variable Models

GRETL Limited Dependent Variable Models

International Money Market

International Money Market

Forward Rate Agreement

Forward Rate Agreement

International Banking

International Banking

Thinking About Exchange Rates

Thinking About Exchange Rates

Operating Exposure

Operating Exposure

Economic Exposure

Economic Exposure

Translation Exposure

Translation Exposure

Transaction Exposure Options Hedge

Transaction Exposure Options Hedge

Transaction Exposure Money Market Hedge

Transaction Exposure Money Market Hedge

Transaction Exposure Forward Market Hedge

Transaction Exposure Forward Market Hedge