Patrick Louie

Bookkeeping, Tax & Revenue Specialist

Patrick has 10 yrs of experience in Finance, Bookkeeping and Accounting working for companies both in the USA and outside of the USA, including Bureau of Internal Revenue.

Patrick contributes weekly to Fundsnet with his long list of experience in Bookkeeping and forensic accounting, as he has first hand, real-world experience in many accounting related subjects.

Price-to-Rent Ratio

How to Remove Commas in Excel (from Numbers or Text String)

Apply the Short Date Format in Excel

Even More Things You Can DO With Excel’s SORT Function

Residual Value

Rounding Up or Down to the Nearest 5 (or Any Multiple) in Excel

Pricing Power

Operating Earnings

Production Volume Variance

Enter Sequential Numbers in Excel

Operating Cycle

Ending Inventory

Profit Before Tax

Calculate Confidence Interval in Excel

Use Wildcards With VLOOKUP in Excel

After-Tax Profit Margin

Apply Horizontal Filter in Excel

Incremental Cost

Sort by Date in Excel

Extrinsic Value