Tag: The Informer

How to Use Hyperlinks in Microsoft Excel

When navigating the web, we have all clicked on blue hyperlinks that send us to another web page. In this article, we will show you how to use hyperlinks in Excel to create links in your workbook to web pages or locations in your current workbook. Our work is in the file...


Understanding the Substance Over Form Doctrine

Substance over form. For tax practitioners this can be a big issue. Is that a real business loss your client has or is it just a hobby? Do you get to deduct all of your expenses related to the Becker Annual Tax Conference or is that merely a disguised gambling trip to Las Vegas? Two recent court...


Top Three Questions for Implementing the New Nonprofit Reporting Model

ASU 2016-14, Not-for-Profit Entities (Topic 958): Presentation of Financial Statements for Not-for-Profit Entities, made targeted improvements to the financial reporting model. The ASU was effective for fiscal years beginning after December 15, 2017. All calendar year-end entities have adopted the...


Excel’s Stock Data Types

Office 365’s new stock data types allow you to type a company name or stock ticker symbol in Excel and write formulas that extract information about the company to a different cell. The file Stockdatatypes.xlsx contains our work. To begin we typed in the company names and ticker symbols shown...


The Joint Committee on Taxation Publishes Data on New BEAT Provision

The Tax Cuts and Jobs Act added a new provision to the Internal Revenue Code called the “Base Erosion and Anti-abuse Tax” (BEAT). In April 2019, the Joint Committee on Taxation (JCT) published a report that offers insight into the number of corporations that will be impacted by the BEAT...


An Auditor’s Responsibility for Cybersecurity Risks

Cybersecurity has rapidly become a significant risk to businesses as breaches of information may result in financial and reputational damage, diminished investor confidence, and exposure to potential regulatory fines. Cybersecurity risks and controls are within the scope of the financial statement...


Joint Committee on Taxation Publishes Distributional Effects of TCJA

The Joint Committee on Taxation (JCT) recently published a series of documents tied to the Tax Cuts and Jobs Act. One of the documents receiving a great deal of attention is the “Distributional Effects of Public Law 115-97.” The document provides distributional tables and analysis of the Tax...


Excel’s New Geographic Data Types

Office 365’s new geographic data types allow you to type a location in Excel and write formulas that extract information about the location to a different cell. For example, if you enter “Paris” in cell E4, entering the formula “E4.Population” in a different cell will...