Tutor profile: Vishal B.
Subject: SQL Programming
Suppose we have 2 SQL tables, how can we combine them in such a way that only common entries to both tables remain?
For this, we have the SQL inner join keyword which performs this same function. Syntax- SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name;
Subject: Basic Math
There are 49 dogs signed up for a dog show. There are 36 more small dogs than large dogs. How many small dogs have signed up to compete?
To figure out how many small dogs are competing, you have to subtract 36 from 49 and then divide that answer, 13 by 2, to get 6.5 dogs, or the number of big dogs competing. But you’re not done yet! You then have to add 6.5 to 36 to get the number of small dogs competing, which is 42.5. Of course, it’s not actually possible for half a dog to compete in a dog show, but for the sake of this math problem let’s assume that it is.
Subject: Corporate Finance
If a company buys an asset equivalent to $5 million; what is the impact on the 3 financial statements?
The purchase of Assets is a transaction done by the company which will impact all three statements of the company. Financial Statements of a company are statements, in which the company keeps a formal record about the company’s position and performance over time. If you want to know what these 3 financial statements are, they are as follows, else skip to the direct answer- 1. Income Statement – It tells us about the performance of the company over a specific account period. Financial performance is given in terms of revenue and expense generated through operating and non-operating activities. 2. Balance Sheet – The Balance Sheet tells us about the position of the company at a specific point in time. The Balance Sheet consists of Assets, Liabilities, and Owner’s Equity. The basic equation of Balance Sheet: Assets = Liabilities + Owner’s Equity. 3. Cash Flow Statement – Cash Flow Statement tells us the amount of cash inflow and outflow. The Cash Flow Statement tells us how the cash present in the balance sheet changed from last year to the current year. Direct Answer- 1. In the Balance Sheet, cash will go down by $5million; decreasing the asset side of the balance sheet and at the same time the asset will be recorded as equipment of $5million which will increase the asset side of the balance sheet by the same amount. Hence, the balance sheet of the company will be tallied. 2. In the Income Statement, there will be no impact on the first year of the income statement but after the first year, the company will have to charge depreciation expense on the purchased equipment which the company will have to show in the Income Statement of company. 3. Cash Flow Statement, assuming that only cash has been paid by the company to purchase the equipment. The Cash Flow from Investing will result in a cash outflow of $5million.
needs and vishal will reply soon.