Thursday, August 23, 2018

Capex vs. Opex


Capex, or capital expenditure, is a business expense incurred to create future benefit (i.e., acquisition of assets that will have a useful life beyond the tax year). For example, a business might buy new assets, like buildings, machinery, or equipment, or it might upgrade existing facilities so their value as an asset increases.

On the other hand, those expenditures required for the day-to-day functioning of the business, like wages, utilities, maintenance, and repairs, fall under the category of Opex, or operational expenditure. Opex is the money the business spends in order to turn inventory into throughput. Operating expenses also include depreciation of plants and machinery which are used in the production process.

Comparison chart

Capex versus Opex comparison chart
Edit this comparison chartCapexOpex
Definition Capital expenditures are expenditures creating future benefits. A capital expenditure is incurred when a business spends money either to buy fixed assets or to add to the value of an existing asset with a useful life that extends beyond the tax year. OpEx (Operational expenditure) refers to expenses incurred in the course of ordinary business, such as sales, general and administrative expenses (and excluding cost of goods sold - or COGS, taxes, depreciation and interest).
Also known as Capital Expenditure, Capital Expense Operating Expense, Operating Expenditure, Revenue Expenditure
Accounting treatment Cannot be fully deducted in the period when they were incurred. Tangible assets are depreciated and intangible assets are amortized over time. Operating expenses are fully deducted in the accounting period during which they were incurred.
In throughput accounting Money spent on inventory falls under capex. The money spent turning inventory into throughput is opex.
Examples Buying machinery and other equipment, acquiring intellectual property assets like patents. Wages, maintenance and repair of machinery, utilities, rent, SG&A expenses
In real estate Costs incurred for buying the income producing property. Costs associated with the operation and maintenance of an income producing property.
Procurement Involvement Purchasing rarely takes the lead, but only assist in the procurement of the item. The negotiation process also takes much longer. Everyday items bought on a regular basis and minimum stock levels kept. It also does not incur any maitenance cost or repair

Examples

Capital expenditures include acquiring fixed assets (tangible, e.g. machinery or intangible e.g. patents), fixing problems with an asset, preparing an asset to be used in business, restoring property so that value is added, or adapting it to a new or different use.

Operating expenditures include license fees, maintenance and repairs, advertising, office expenses, supplies, attorney fees and legal fees, utilities such as telephone, insurance, property management, property taxes, travel and vehicle expenses, leasing commissions, salary and wages, raw materials.

Accounting for Capex and Opex

The crux of the matter lies in the way these expenditures are accounted for in an income statement.

Since capital expenses acquire assets that have a useful life beyond the tax year, these expenses cannot be fully deducted in the year in which they are incurred. Instead, they are capitalized and either amortized or depreciated over the life of the asset. Intangible assets like intellectual property (e.g. patents) are amortized and tangible assets like equipment are depreciated over their lifespan.

Operating expenditure, on the other hand, can be fully deducted. "Deducted" means subtracted from the revenue when calculating the profit/loss of the business. Most companies are taxed on the profit that they make; so what expenses you deduct impacts your tax bill.

What is preferred: Capex or Opex?

From an income tax perspectives, businesses typically prefer OpEx to CapEx. For example, rather than buy laptops and computers outright for $800 apiece, a business may prefer to lease it from a vendor for $300 apiece for 3 years. This is because buying equipment is a capital expense. So even though the company pays $800 upfront for the equipment, it can only deduct about $250 as an expense in that year.

On the other hand, the entire amount of $300 paid to the vendor for leasing is operating expense because it was incurred as part of the day-to-day business operations. The company can, therefore, rightfully deduct the cash it spent that year.

The advantage of being able to deduct expenses is that it reduces income tax, which is levied on net income. Another advantage is the time value of money i.e. if your cost of capital is 5% then saving $100 in taxes this year is better than saving $104 in taxes next year.

However, tax may not be the only consideration. If a public company wants to boost its earnings and book value, it may opt to make a capital expense and only deduct a small portion of it as an expense. This will result in a higher value of assets on its balance sheet as well as a higher net income that it can report to investors.

Videos

Operating expenses are sometimes also called Revenue Expenditure. Here are two videos comparing capital and operational expenses.

Capex and Cash Flow

Investors often look not only at the revenue and net income of a company, but also at the cash flow. The reported profit, or net income, can be "manipulated" via accounting techniques and hence the idiom "Income is opinion but cash is fact." Operating expenses directly reduce the Operating Cash Flow (OCF) of the company. Capex does not figure in the calculation of OCF but capital expenditures reduce the Free Cash Flow (FCF) of the company. Some investors treat FCF as a "litmus test" and do not invest in companies that are losing money, i.e. have a negative FCF.

Amazon is an example of a company with very high capital expenses. The following chart, by Benedict Evans, shows the growth in OCF, capex and FCF for Amazon since 2003.

OCF, capex and FCF for Amazon from 2003 to 2014. Operating cash flow has grown significantly, but so has capex, leaving Free cash flow stagnant.
magnify
OCF, capex and FCF for Amazon from 2003 to 2014. Operating cash flow has grown significantly, but so has capex, leaving Free cash flow stagnant.

References


Courtesy: https://www.diffen.com/difference/Capex_vs_Opex

Security (Encryption and Decryption


Using a car analogy:

  • PGP is a car
  • OpenPGP is the design for the PGP car
  • GnuPG is another car using the same design
  • RSA is a diesel engine, and other engines are available
  • SSH isn't a car at all. But it uses engines.
  • RSA is a public-key cryptosystem. That is, it is an algorithm for encrypting, decrypting and signing data using a set of two keys (the public key and private key).
  • PGP and GnuPG both offer the use of RSA for general purpose encryption and signing of data. They also offer other options, like Elgamal and DSA.
  • SSH uses RSA for authentication, not encryption. The server has your public key, and you have the private key, and SSH uses this fact to make sure you are, well, you. SSH also supports other keypairs, for example, ECDSA.

Friday, August 3, 2018

Facts...


Here are some quick facts about email. First Email! – The first email message was sent by Ray Tomlinson in early 1971.

Why the @? – The ubiquitous @ symbol was chosen because of the rare use of the symbol and the complete lack of use in people’s names. This made sure there would be no mistaken emails sent.

SNDMSG – The first email protocol was SNDMSG. This allowed researchers and programmers to leave messages for each other.

Sunday, February 19, 2017

Datamartist gives you data profiling and data transformation in one easy to use visual tool.

« | »

Data Warehouse vs Data Mart

Very often, the question is asked- what's the difference between a data mart and a data warehouse- which of them do I need?

Data warehouse or Data Mart?

hello-im-a-datawarehouse
Data Warehouse:

  • Holds multiple subject areas
  • Holds very detailed information
  • Works to integrate all data sources
  • Does not necessarily use a dimensional model but feeds dimensional models.

Data Mart

  • Often holds only one subject area- for example, Finance, or Sales
  • May hold more summarised data (although many hold full detail)
  • Concentrates on integrating information from a given subject area or set of source systems
  • Is built focused on a dimensional model using a star schema.

More Info about Data mart models

More Detail regarding Data Warehouse Vs Datamart: and Inmon vs Kimball

As the concept of decisional systems, and data warehouses and data marts evolved, two major points of view came into existence. There are two giants in this field. Bill Inmon, and Ralph Kimball.

There are some that argue the best approach is to start with data marts, department by department, then merge them together to form a data warehouse- this is more in line with Kimballs approach.

Now, Bill Inmon is an advocate of the Data warehouse. Here's one of his articles, which contains the following quote that makes it clear what he thinks about the idea:

"You can catch all the minnows in the ocean and stack them together and they still do not make a whale," Bill Inmon, January 8, 1998.

Ralph Kimball, on the other hand, advocates what he calls a bus architecture data warehouse. His methodology specifies conformed dimensions, where multiple fact tables share common dimensional tables. For me, each of these fact tables represents a data mart. The row of dimensional tables that all the fact tables plug into is the bus, and because, for example, the finance and the sales data marts both use the same product dimension table there is integration between departments.

The more extreme data mart strategy is that of the completely stand alone data mart, the concept being that its fast, easy, cheap, and delivers value immediately. I'm a supporter of this at the desktop level- thats the point of the Datamartist tool afterall. But I don't buy this for server based architectures- what is really fast, easy and cheap when you have to buy servers, create a project and form a commitee? In my mind if you've decided you need a central server solution, some level of integration is needed, and don't pretend its going to be magic.

The interesting thing about these approaches, is that the harder you work on really conforming your dimensions, the more your data marts look like the data warehouse that Inmon advocates. (Data modellers in the know will be jumping up and down right now shouting NO they don't- but this is a high level conversation...) But the reality is, even in a data warehouse, issues will arise that require compromise- things that just don't map or conform, and budget, schedule and business reality will mean that nothing is ever perfect, and in the end the world is full of data warehouses that are less conformed than some data mart clusters. Its just not simple.

Generally, it is probably true that data warehouses provide a solution that is closer to the "single version of the truth", but they do take a HUGE amount of effort, and an ability to coordinate across the entire organisation. If you have not already built at least half a dozen data marts, don't think you can estimate how much effort a data warehouse will take. You can't. And bring your cheque book.

Whereas data marts might deliver some value early, if built without sufficient effort on cross functional mapping and data cleanup they are just more silo systems and have their own set of costs and issues. Don't measure payback on datamarts in years- nothing is the same in a few years, you'll be back to the drawing board shortly.

It's a real dilemma. So which one? Data warehouse? Data mart? In my view, the right answer is "it depends" and "yes". However, never launch a data warehouse project as your first shot. A successful strategy will balance the fast, pain point addressing solutions, with a medium and long term plan, and investment in infrastructure and competencies to build the technology, processes and culture that a company needs to manage information. Depending on your industry and how sucessful you are, a massive data warehouse might be in your future. But sorry, no magic bullet.

Build a multi-level data strategy

  • Level 1- Get the data to the people
  • Level 2- Build Departmental Data Marts
  • Level 3- Plan long term infrastructure and architecture

Don't do these things in order- this isn't step 1, 2, 3- actively work on all three levels at once and ensure the plans at each level are coordinated.

Data to the People

People are building spreadsheets, and spending money on data base development now- you know they are. Give them better tools, help them better use the spreadsheets, and formalize the way they do. The do-it-yourself exists- but it doesn't have to be completely informal.

The Datamartist tool is adding another capability that can accelerate the process- letting you move more quickly, proto-typing and analysing to determine which areas are ready for additional analysis capability.

In some cases Datamartist itself might simply be the best choice for certain types of analysis, cutting costs dramatically. In addition, if your end users are building their own data marts, when it comes time to build server based data marts they know the concept, they understand the structure, and can even provide concrete examples of the dimensions they need.

But whatever you do- don't make the mistake of thinking this is all you need. Work on all levels at once.

Build Departmental Data marts

If a whole department is flying blind, and big money is on the table, then don't launch a three year data warehouse project- create some departmental data marts. These projects should be designed to be 3-6 months long, and be sold to management honestly and clearly as being for short term gains, and as part of a broader discovery process. The hardware and software licenses will be reusable- but be clear that the data marts will have a limited lifespan- they always do.

And trust me, when you build these data marts you will discover all sorts of things about your data, your organisation, and your definitions and business processes. You will discover that the sales organisation needs to analyse product segments in a way that is fundamentally inconsistent with how finance has been reporting it for years- and neither group is willing to budge (and they may both be right). You will discover that 80% of your sales orders have errors on them or are incomplete. These discoveries will help you build the next data mart, and assess if a data warehouse is possible. They should also send you back to your transactional system and business processes to work to clean up the problems.

Build the infrastructure and deal with the foundation

There are lots of pitfalls in creating a decisional architecture- this short list of from Gartner resonates with me- I've seen and battled these issues on project after project.

Set standards in terms of tools, project management etc. Buy infrastructure for multiple projects, not on a project by project basis- don't have multiple servers when one with multiple data marts is radically cheaper.

And probably most important, I honestly think that you can build anything you want, any way you want, but it will not succeed if you don't have your definitions, both data and information, under control. (See Gartner issue #8) In the end, it's not what language you speak, it's if you have a dictionary or not, and if everyone is using the same dictionary across your organisation.

You should have common reference data sets that are used by all levels. Datamartist can load in and use reference data that is coordinated with departmental data marts and the eventual warehouse. Make these data sets available to everyone- you'll be amazed that if they are easy to get and use, people will put them in their spreadsheets, and things might actually start matching up.


Shutdown PC Automatically after Media or Playlist Ends in VLC player

Shutdown PC Automatically after Media or Playlist Ends in VLC

If you want your Windows PC to automatically shut down after your current media or playlist ends then there is a simple trick to do so. First, you have to configure VLC to exit after the current media or playlist finishes. Then you need Windows to detect that VLC has exited and follow up with the shutdown or even hibernation process.

The shutdown feature isn’t inbuilt in VLC but it can exit after a playlist ends. A simple .bat file can be used to turn off the PC after VLC has exited.

Here are the detailed steps:

Part I: Configuring VLC to Exit after Playlist ends

  • Go to Tools > Preferences [CTRL + P].
  • Click on All under Show settings.
  • Click on Playlist on the left.
  • Check the option that says Play and exit.
  • Click Save.

Shutdown PC Automatically after Media or Playlist Ends in VLC

Part II: Shutting Down PC after VLC Exits

  • Open up your notepad or any other text editor.
  • Copy and paste the following text in the file
START /WAIT "C:\Program Files\VideoLAN\VLC\vlc.exe" %1 vlc://quit shutdown -s -t 60
  • You want to save it as a .bat file like vlc.bat.
  • Click and drag your media files or playlist on top of the bat file.

VLC will launch, play every item from your playlist, exit when at the end of the list and initiate a windows shutdown process after 60 seconds.

Alternative bat file: You can also try this other bat file that requires you to input the full path to your individual media files. Here’s an example of the .bat file.

START /WAIT "C:\Program Files\VideoLAN\VLC\vlc.exe" D:\movies\video.mp4 D:\series\series.mp4 vlc://quit shutdown -s -t 30

If you need to cancel the shutdown process then:

  • Press Windows Key + R
  • Type cmd and press enter.
  • Input shutdown -a to abort the process.

Monday, November 28, 2016

Gratuity Calculator




Formula :



Gratuity Calculation= [ (Basic Pay + D.A) x 15 days x No. of years of service ] / 26 Gratuity Calculation= [ (Basic Pay + D.A) x 15 days x No. of years of service ] / 26



Where,

D.A = Dearness Allowance. End of Service Benefits Eligibility : 1. Any person employed on wages/salary. 2. At the time of retirement or resignation or on superannuation, an employee should have rendered continuous service of not less than five years. 3. Payable without completion of five years only when death and disablement. Related Calculator:


Tuesday, May 13, 2014

Shortcut keys for MS word

KeyBehavior
CTRL+SHIFT+Aconverts the selected text to capital letters or vice versa
CTRL+SHIFT+FDisplays the Font dialog box.
CTRL+SHIFT+GDisplays the Word Count dialog box.
CTRL+SHIFT+SDisplays the Apply Styles task pane.
ALT+RDisplays the Review tab
ALT+CTRL+1Apply Heading 1, Similarly ALT + CTRL + 2 will apply heading 2
CTRL+SHIFT+LApplies Bullets
CTRL+SHIFT+F5Bookmark
CTRL + BBold Text
CTRL + IItalic Text
CTRL + UUnderline Text
CTRL+PAGE DOWNBrowse Next
CTRL+ENavigate to the center Paragraph
CTRL+SHIFT+ENTERColumn Break
CTRL+SHIFT+CCopy Format
ALT+SHIFT+F7Dictionary
ALT+CTRL+SSplits the Document
CTRL+SHIFT+DDouble Underline
CTRL+ENDEnd of Document
ENDEnd of line
CTRL+SHIFT+PFont size select
SHIFT+F5 or ALT+CTRL+ZGo Back to previous state
CTRL+SHIFT+.Grow Font
CTRL+]Grow Font one point
ALT+SHIFT+RHeader Footer Link
CTRL+KHyperlink
CTRL+MIndentation
CTRL+JJustifies Paragraph
ALT+F8Inserts Macros
ALT+SHIFT+KMail Merge Check
F10Menu Mode
ALT+F7Moves to the Next Misspelling
CTRL+HReplace
CTRL+PPrint
CTRL+SHIFT+F12Also launches Print
ALT+SHIFT+BACKSPACERedo
F12Save As
CTRL+SHIFT+KSmall Caps
CTRL+SHIFT+SStyle
SHIFT+F7Thesaurus
ALT+SHIFT+TTime Field
CTRL+SHIFT+MUnindent
Alt+W, QZoom
Alt+W, JZoom to 100%