Modelyze InvestmentsFeb 104 min2022 Is A Year of Investing Focused on the Outlook for InflationAn overview of the Impact of Inflation on Financial Assets, Gold, Size, Value and Growth Factors
Modelyze InvestmentsJan 276 minHow to Value User or Subscriber Based CompaniesAn overview of Valuation of Existing and New Users of Subscriber Based Companies
Modelyze InvestmentsJan 611 min2021 Equity Markets In ReviewAn overview of North American Capital Markets and Equity Markets in 2021
Modelyze InvestmentsDec 13, 20213 minHow to Create Waterfall and Stacked Waterfall ChartsAn overview of Waterfall and Stacked Waterfall charts to show variances
Modelyze InvestmentsDec 12, 20215 minHow to Custom Format Cells with Symbols in MS ExcelAn overview of Custom Formatting in MS Excel and how Custom Formatting can be used to add symbols and text to numbers in cells
Modelyze InvestmentsJul 29, 20214 minPassive Equity Screens & Bargain Purchasesnvestors generally use screens to find attractive investing opportunities. The following describes an example of a passive equity screen.
Modelyze InvestmentsMay 30, 20216 minHostile Corporate TakeoversAn overview of Hostile Corporate Takeovers, the Defense mechanisms implemented by Targets and a real-life scenario of a corporate takeover
Modelyze InvestmentsMar 20, 20214 minHow 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
Modelyze InvestmentsFeb 23, 20214 minThe Best & Worst Performing Weekdays in the Currency Markets, Indices & Implied Volatility IndicesEver wondered which weekdays are the best and worst days for the daily returns of exchange rates of currencies, indices and implied vols?
Modelyze InvestmentsJan 17, 20212 minHow to Use the Lambda Function in MS ExcelAn Overview of the Newly Created Lambda() Function in MS Excel in Beta Channel and Office Insider
Modelyze InvestmentsDec 14, 20203 minWhy Would Inflation Rise Once the Pandemic Is OverAn outlook for inflation expectation post COVID-19 pandemic in 2020 and beyond
Modelyze InvestmentsNov 17, 20207 minHow to Value S&P 500 IndexValuation methodology of S&P500 Index and prediction of future economic recovery based on an analysis of stock market returns
Modelyze InvestmentsOct 26, 20207 minHow to Value Banks or Financial Services FirmsAn overview of banks business model, value drivers, regulation, risks and valuation methodologies
Modelyze InvestmentsOct 5, 20205 minSpecial Purpose Acquisition VehiclesAn overview of Special Purpose Acquisition Vehicles, their incentives, benefits, IPO process and current state in 2020
Modelyze InvestmentsAug 16, 20202 minWhy would a stock have no par value?Par value vs. no par value stocks
Modelyze InvestmentsJun 29, 20202 minHow to Align Primary and Secondary Axis at Zero in MS ExcelA very simple method to align the 0 line of primary and secondary axis in MS Excel for a presentable display of results.
Modelyze InvestmentsJun 23, 20207 minAn Investment Review of Alcon Inc. Since Its Spin-off from NovartisAn investment review of Alcon Inc. (NYSE: ALC; SWX: ALC), largest global eye care company in the Health Care Technology sector
Modelyze InvestmentsJun 13, 20202 minHow to create dynamic formulas in Microsoft Excel which updates daily as you add dataAn overview of dynamic ranges and dynamic formulas in MS Excel which updates automatically with added data
Modelyze InvestmentsJun 6, 20203 minHow to make chart data range dynamic in Microsoft ExcelAn overview of the usage of dynamic data ranges in MS Excel charts for creation of dynamic charts with automatic updates
Modelyze InvestmentsJun 5, 20203 minHow to Forecast Gold PricesGold market outlook and an overview of gold price macroeconomic drivers and its forecast