In Microsoft Excel, what formula would you use to pull information from another spreadsheet?
There are several ways to pull information from another spreadsheet. However, I believe the easiest way to do this is by using a VLOOKUP formula. This formula uses a unique identifier to pull the information. For example, if one column is 1/6 (date) and the other column is $200, the unique identifier might be 1/6$200. Excel knows to look for this particular reference and return the value in the cell for which you choose.
What are the different filing statuses available to those filing individual tax returns?
There are 5 statuses available to individual income tax filers. Each has a different exemption amount and have different requirements for each. They are Single, Married Filing Jointly, Married Filing Separately, Head of Household, and Surviving Spouse (Widow or Widower). Single is available to those individuals who are not married at the end of the tax year. This is the most common filing status. Married Filing Jointly or Separately are available to married individuals. Married Filing Separately requires that if one spouse itemizes, the other spouse must also. Head of Household is available to an individual who has a dependent child, and who provides the house and support for the dependent child in excess of 50%. The Surviving Spouse status applies to those individuals who lost their spouse during the year and have a dependent child. This status is available for the year in which the spouse dies, as well as two years after the year of death.
What are the various forms of business organizations available to entities wanting limited liability?
There are several forms of business organizations available to entities wanting limited liability. There are partnerships, C corporations, S corporations, limited liability companies, limited liability partnerships, and sole proprietorships; just to name a few. The selection of a particular type of business organization depends on several factors. The duration of an organization is relevant to the selection of an organization. Some have limited life, while others have unlimited life. The number of members or shareholders available to an organization is relevant also. In an LLC, there is no limit to the number of members allowed. Another factor present in deciding on the type of business organization is the type of stock or allowance of the stock to be issued publicly. Both partnerships and S corporations do not allow the stock of the entity to be listed publicly. Overall, each organization has its pros and cons. Each organizer must determine the best possible organization for its entity's needs.