Blog | Modelyze Investments

Oil & Gas and Gold Mining Stocks Among the Most Undervalued with Strong Fundamentals in Jan 2023

Jan 9, 20234 min read

Oil & Gas and Gold Mining Stocks Among the Most Undervalued with Strong Fundamentals in Jan 2023

A screen of North American equity markets in Jan 2023 shows Oil&Gas, Gold Mining companies to be the most undervalued w strong fundamentals

An Inverse Relationship, CAPE and Long Term Interest Rates

Modelyze Investments

Sep 13, 20221 min read

An Inverse Relationship, CAPE and Long Term Interest Rates

The inverse relationship between level of long-term interest rates and PE ratios of the market

2022 Is A Year of Investing Focused on the Outlook for Inflation

Modelyze Investments

Feb 10, 20224 min read

2022 Is A Year of Investing Focused on the Outlook for Inflation

An overview of the Impact of Inflation on Financial Assets, Gold, Size, Value and Growth Factors

How to Value User or Subscriber Based Companies

Modelyze Investments

Jan 26, 20226 min read

How to Value User or Subscriber Based Companies

An overview of Valuation of Existing and New Users of Subscriber Based Companies

Modelyze Investments

Jan 6, 202211 min read

2021 Equity Markets In Review

An overview of North American Capital Markets and Equity Markets in 2021

How to Create Waterfall and Stacked Waterfall Charts

Modelyze Investments

Dec 13, 20213 min read

How to Create Waterfall and Stacked Waterfall Charts

An overview of Waterfall and Stacked Waterfall charts to show variances

How to Custom Format Cells with Symbols in MS Excel

Modelyze Investments

Dec 12, 20215 min read

How to Custom Format Cells with Symbols in MS Excel

An overview of Custom Formatting in MS Excel and how Custom Formatting can be used to add symbols and text to numbers in cells

Passive Equity Screens & Bargain Purchases

Modelyze Investments

Jul 28, 20214 min read

Passive Equity Screens & Bargain Purchases

nvestors generally use screens to find attractive investing opportunities. The following describes an example of a passive equity screen.

Modelyze Investments

May 30, 20216 min read

Hostile Corporate Takeovers

An overview of Hostile Corporate Takeovers, the Defense mechanisms implemented by Targets and a real-life scenario of a corporate takeover

How to Create Dynamic Charts with Drop Down Lists and Name Managers?

Modelyze Investments

Mar 20, 20214 min read

How to Create Dynamic Charts with Drop Down Lists and Name Managers?

An overview of a Dynamic Chart that adjusts based on user input date ranges and user defined input from a drop-down lists

The Best & Worst Performing Weekdays in the Currency Markets, Indices & Implied Volatility Indices

Modelyze Investments

Feb 22, 20214 min read

The Best & Worst Performing Weekdays in the Currency Markets, Indices & Implied Volatility Indices

Ever wondered which weekdays are the best and worst days for the daily returns of exchange rates of currencies, indices and implied vols?

How to Use the Lambda Function in MS Excel

Modelyze Investments

Jan 16, 20212 min read

How to Use the Lambda Function in MS Excel

An Overview of the Newly Created Lambda() Function in MS Excel in Beta Channel and Office Insider

Why Would Inflation Rise Once the Pandemic Is Over

Modelyze Investments

Dec 13, 20203 min read

Why Would Inflation Rise Once the Pandemic Is Over

An outlook for inflation expectation post COVID-19 pandemic in 2020 and beyond

Modelyze Investments

Nov 16, 20207 min read

How to Value S&P 500 Index

Valuation methodology of S&P500 Index and prediction of future economic recovery based on an analysis of stock market returns

How to Value Banks or Financial Services Firms

Modelyze Investments

Oct 26, 20207 min read

How to Value Banks or Financial Services Firms

An overview of banks business model, value drivers, regulation, risks and valuation methodologies

Modelyze Investments

Oct 4, 20205 min read

Special Purpose Acquisition Vehicles

An overview of Special Purpose Acquisition Vehicles, their incentives, benefits, IPO process and current state in 2020

Modelyze Investments

Aug 16, 20202 min read

Why would a stock have no par value?

Par value vs. no par value stocks

How to Align Primary and Secondary Axis at Zero in MS Excel

Modelyze Investments

Jun 29, 20202 min read

How to Align Primary and Secondary Axis at Zero in MS Excel

A very simple method to align the 0 line of primary and secondary axis in MS Excel for a presentable display of results.

An Investment Review of Alcon Inc. Since Its Spin-off from Novartis

Modelyze Investments

Jun 22, 20207 min read

An Investment Review of Alcon Inc. Since Its Spin-off from Novartis

An investment review of Alcon Inc. (NYSE: ALC; SWX: ALC), largest global eye care company in the Health Care Technology sector

How to create dynamic formulas in Microsoft Excel which updates daily as you add data

Modelyze Investments

Jun 13, 20202 min read

How to create dynamic formulas in Microsoft Excel which updates daily as you add data

An overview of dynamic ranges and dynamic formulas in MS Excel which updates automatically with added data