money sectionmoney section
In order to calculate sales tax with Excel, type in the amount of a purchase and multiply it by the state's sales tax, which has to be converted into decimal form. Calculate sales tax through simple multiplication with help from an employee of an IT company in this free video on calculating sales tax in Microsoft Excel.
A circular reference occurs when a spreadsheet cell refers to itself directly or via another cell. Unless the default settings are changed, creating a circular reference results in an error message. Most spreadsheet programs, such as Microsoft Excel, OpenOffice Calc and LibreOffice Calc, contain an iterative calculation feature. This feature works with circular references by repeating calculations a specified number of times using the previous iteration's results. This method sometimes produce unpredictable results or errors if no acceptable results are found. A better method of fixing circular references is to remove them altogether.
The Internal Revenue Service requires you to pay tax on any capital gain that results from the sale of your house. A capital gain is the difference between the sales price and your acquisition cost. The exact tax you will owe the IRS also depends on the length of time you owned the house and if you actually occupied the house as your primary residence during the time you owned the property.
North Carolina sales tax returns are due monthly or quarterly, depending on the amount of your sales tax liability. Penalties for late sales tax payments are assessed based on the amount you owe and how late your payment is when you remit the tax. In addition to the late payment penalty, the North Carolina Department of Revenue also assesses a separate penalty for filing your sales tax return late. If you can’t pay your sales tax on time, you can still save money by filing your sales tax return when it’s due.
When you go out to a restaurant to eat, you typically have to add both sales tax and a gratuity for the server to the price of the bill. The sales tax will always be added to your bill for you. Depending on the size of your party, the restaurant may add the gratuity automatically. For example, a restaurant may add a 19 percent gratuity if you have eight or more in your party. Otherwise, it is up to you to add the gratuity. To figure the total price, you need to know the percentages for both the sales tax…
In Pennsylvania, as in most states, you don't pay sales tax when you purchase a motor vehicle but you do so when you decide to rent a vehicle. Sales taxes are applied to your monthly payment rate, taking into account state, county and local rates. The state sales tax in Pennsylvania is six percent but some counties and cities add an additional surtax to this amount.
FIFO and LIFO are two common accounting acronyms used to determine the order of shares, inventory or other items that are sold. FIFO stands for "first-in, first-out" while LIFO means "last-in, first-out." If you sell shares using FIFO, it means that for accounting purposes, when you sell shares you match the sales price with the purchase price for the first shares you bought. With LIFO, you match the sales price with the most recent purchase price you paid. Depending on the prices you paid, using FIFO or LIFO can affect the gain you realize and the resulting tax you owe.
Unemployment compensation helps tide over the laid-off worker until new employment is found. The contributions to the New Jersey unemployment compensation fund are made by both workers and employees. New Jersey employers are responsible for unemployment tax withholding from their employees' paychecks, up to the annual limit established by law. As of July 2011, each worker contributes 0.385 percent of wages to the New Jersey unemployment compensation fund.
When mining or pumping operations retrieve mineral or petroleum deposits from a certain piece of land, various parties may have claim on the revenues coming from the sale of those deposits other than the parties who directly own the mineral rights. When someone has overriding royalty interest on a piece of land, he does not own the actual mineral rights for that piece of land, but he does have the right to collect on a certain percentage of all oil or mineral revenue that comes from that piece of land during a specific period of time.
Construction companies fulfilling government contracts that cost more than $2,000 must pay laborers the prevailing wage and fringe benefits as workers performing the same job at other government job sites in the surrounding area. The Davis Bacon and Related Acts contain the information regarding the prevailing wage laws that exist to prevent wage discrimination. The Secretary of Labor determines the prevailing wage and benefits and includes the information in all contracts where applicable. The Department of Labor's Wage and Hour Division oversees compliance with DBRA laws.
Employers typically pay overtime wages by the employee's next regularly scheduled paycheck. State law might allow employers a different time frame, such as by the payroll for the next regular pay period after the overtime wages were earned. Overtime wages are usually paid with an employee's regular wages and are subject to the same taxes as regular earnings. As an employer, you calculate overtime taxes as you would for regular wages.
New Jersey employers must comply with any court order for wage garnishments issued against employees. Failure to comply with a wage garnishment order, also referred to as a wage execution order, may result in penalties or fines. You may not garnish an employee's paycheck without official notice from the court, and you may not garnish the entire amount of your employee's paycheck. Only a portion of your employee's pay is subject to garnishment, and a calculation must be made to determine the amount to remit to the judgment creditor.
By law, Michigan businesses have to file specific forms with the state's Unemployment Insurance Agency or else risk facing penalties, fines and sanctions by both the state and federal government. Common forms that businesses must file include wage reporting and state unemployment tax act, or SUTA, and federal unemployment tax act, or FUTA, forms.
Most states, including Georgia, regard state unemployment insurance as an employer-paid tax; in rare cases, such as New Jersey and Pennsylvania, employees are also required to pay this tax. Each state has an agency that administrates the state unemployment insurance laws. The Georgia Department of Labor oversees state unemployment policies, which require you to pay SUI tax on employee wages.
Employers are required to take taxes out of their employees' paychecks. This includes federal income tax, Social Security tax and Medicare tax. As a self-employed individual, you do not have an employer to withhold taxes from your paychecks and must therefore do so yourself by making estimated tax payments. Abide by the Internal Revenue Service's requirements for withholding your own estimated tax payments.
State Unemployment Tax Authority is a type of insurance used to protect the employee in case of unemployment. This is a tax that state governments take from employers without deducting any amount from employee wages. The employer pays SUTA to create a fund that will pay qualified employees benefits in the event of unemployment. The employer pays the tax based on a percentage of the employee's salary, capped at an annual pay level.
Employee benefits are a large component of both small and large business costs; accounting for these costs incorrectly can greatly distort the financial picture of your business. Accounting for these costs, with a few exceptions, follows the basics rules of expense recognition, so by remembering to match the period the company incurs the cost with the period that the company receives the benefits you'll be over halfway there.
State unemployment insurance (SUI) or tax is mostly an employer-paid tax. In rare cases, such as Pennsylvania and New Jersey, the employee is also required to pay state unemployment insurance. State unemployment insurance and federal unemployment insurance are joint programs, which provide unemployment benefits to eligible terminated employees. While federal unemployment tax rates are standard for all employers, an employer's SUI rate depends on various factors.
The Federal Unemployment Tax Act, or FUTA, imposes a tax on employers to provide benefits for workers who lose their jobs. As of early 2011, that tax was 6.2 percent of the first $7,000 of each worker's wages, dropping to 6.0 percent in July 2011. Employers generally must pay FUTA taxes four times a year: by January 31, April 30, July 31 and October 31. Only employers pay FUTA taxes, not employees.
The unemployment compensation system in the United States is organized into individual unemployment insurance programs administered by each state. These programs are largely funded by premiums paid by employers in that state, but are eligible for matching federal funds. Employers in all 50 states are required to pay premiums to their state's unemployment insurance funds. In most states, like Texas and Florida, there are only financial penalties for nonpayment of unemployment insurance premiums, but the fines can add up, and could even eventually lead to the seizure of the business for unpaid taxes.
Each state requires most employers who do business in the state to pay unemployment tax, which is a separate requirement from the federal unemployment tax the Internal Revenue Service requires employers to pay. Employers in Texas pay state unemployment if they meet the state's criteria, such as paying at least $1,500 in wages in a quarter or having a minimum of one employee during 20 different weeks in a year. A Texas employer pays state unemployment taxes to the Texas Workforce Commission based on the state's calculation requirements.
Goods and Services Tax is collected by Canadian-based business owners, corporations and organizations that provide goods or services for sale. It is then remitted to the federal government on a payment schedule set up when registration for the GST was completed. Failure to remit the GST promptly results in penalties and interest. Providing incorrect information during GST filing is also penalized with interest. Registrants who do not comply with a Demand to File Notice are penalized an additional $250.
The state of New Jersey is one of the many states that require employers to withhold state income tax from employees' paychecks. In addition, federal law requires employers to withhold federal income tax, Social Security tax and Medicare tax. The New Jersey Division of Taxation oversees the policies for calculating state income tax. The Internal Revenue Service regulates federal withholding. As a New Jersey employer, keep all the rules in mind when calculating withholding tax.
Every item sold in Florida is subject to the Florida Sales and Use tax. Whether you sell or rent goods or charge admission to events, you must collect sales tax and send the money to the Florida Department of Revenue. If you are a sales tax collector, you are entitled to a Florida Sales and Use Tax Collection Allowance of up to $30 to offset your costs to collect and transmit the tax.
In the Quebec province of Canada, most goods and services are subject to two different taxes. The goods and services tax (GST) is assessed at 5 percent of the purchase price, and the Quebec sales tax is assessed at 7.5 percent of the total purchase price, including the GST. Both taxes are collected by the seller at the time of purchase. Certain products and services such as prescription drugs and health services are either taxed at a rate of zero or are tax-exempt.
The employer alone is required to pay state unemployment, or SUTA, tax, which funds the state unemployment compensation program. Each state has its own tax rates, which vary by employer. The state of Michigan's Unemployment Insurance Agency, or UIA, administrates and enforces the state unemployment tax laws. Michigan's SUTA tax rate depends on various factors.
If you make money or operate a business in the U.S., you have to pay taxes. Federal taxes are due every year on April 15. If you're an employee of a company, taxes will be automatically deducted from your paycheck, however, if you're an independent contractor or self-employed, you will need to pay your taxes on your own. Some people pay taxes every quarter, however, one way to ensure you set aside the correct amount is by calculating taxes every week.
The Internal Revenue Service requires your employer to withhold federal income tax from your paychecks. Medicare tax and Social Security tax are forms of payroll taxes that the federal government requires your employer to withhold from your wages. In most cases, the state revenue/taxation agency requires state income tax withholding; on occasion, city or local income tax applies. Your employer includes your tax deductions on your pay stub. Your total deductions plus your take-home pay equals your gross earnings. Knowing how to calculate the taxes deducted from your paycheck helps you to determine if you were appropriately paid.
The state of Maryland charges state and local income tax to employees. Maryland employers are required to withhold both taxes from employees' wages. The Comptroller of Maryland administrates state income tax withholding laws and also provides employers with the procedures for local income withholding. Employers are also required to withhold federal income tax, Social Security tax and Medicare tax from Maryland employees' wages. To ensure compliance, apply the appropriate calculation when figuring withholding taxes in Maryland.
Licensees negotiate royalty payments to the author or artist (licensor) for the use and license of copyrighted materials, trademarked products, and other intellectual property. Licensees may negotiate royalties based on gross revenues, in which the licensor receives a percentage of royalties without deductions. On the other hand, licensees typically negotiate standard royalty contracts based on net revenues in which the licensor receives royalty payments after overhead deductions and expenses related to production, shipping, taxes, and discounts. Negotiating a royalty requires the licensee to include certain provisions in the agreement and allow for standard deductions. Parties to the contract may negotiate…
In the world of finance, terminology is everything. This is also the case for taxation. Taxes are listed as a deduction on the income statement. That is, they are deducted from operating income, along with interest expense, to arrive at net income. Since most companies report income on an annual and quarterly basis, the exact amount of tax to deduct from operating income is still an unknown. For this reason, accountants use an estimate to account for real taxes. This estimate is referred to as the tax provision.
The Internal Revenue Service, IRS, requires employers to give newly hired employees a W-4 form to complete. The form is instrumental in figuring the amount of federal income tax to withhold from employees' wages. The IRS allows the employee to claim allowances on the W-4, which significantly influences the federal income tax withholding amount. Each employee's situation is different, so employers must use the respective W-4 to calculate the tax.
The U.S. Department of Labor requires employers to pay overtime to qualified workers. The employee must actually work more than 40 hours during the workweek to receive overtime pay. Therefore, if he has more than 40 hours due to vacation or sick time taken, the employer does not have to pay him overtime. The employer pays overtime at one and one-half times the employee's regular pay rate. The Internal Revenue Service regards overtime pay as wages that are subject to taxation. Overtime pay is taxed in the same manner as regular wages.
The Internal Revenue Service is the statutory organization that regulates federal payroll tax withholding. Employers are required to withhold federal income tax from employees' paychecks. Social Security tax and Medicare are payroll taxes that employers must withhold as well -- both taxes are collected under the authority of the Federal Insurance Contributions Act. The IRS enforces the collection of federal income tax, Social Security and Medicare tax withholding. The employer calculates each tax according to federal regulations.
Fringe benefits are forms of compensation in addition to the stated pay for performance of services. This may include extra insurance, membership in a country club or moving expenses. The Internal Revenue Service assumes that all fringe benefits are taxable and then has exclusions applied to some fringe benefits. Cafeteria plans usually cover exclusions that an employee may choose as part of the benefits of employment, so these are not taxable. The IRS provides a long list of what cannot be included in a cafeteria plan, restricting the employer's use of this tax exclusion tool.
Indiana's Department of Revenue levies a sales tax on good and servics sold in the state and mandates its merchants collect the taxes and forward them to the state. Merchants must remit sales taxes to the state monthly. As an incentive to pay on-time, Indiana offers a sales tax "collection allowance" to those merchants who furnish payment in a timely manner. The state also includes a "tire fee" allowance in this amount if you're a merchant who sells new tires. You can determine the amount of your collection allowance by making a few simple calculations.
Adhere to the matching principle when using accrual accounting. According to this principle, expenses are to be recognized when obligations are incurred and offset by revenues that stem from those expenses. But this relatively simple concept can become more complicated in some instances, such as an acquisition with resulting tax amortization benefits. A tax amortization benefit is the cash flow generated from an asset as a result of being able to write off the full fair value of that asset for tax purposes. This benefit can affect the fair value of an asset by as much as 20 to 30…
Many state and local governments levy a sales tax. Often, this can be a primary source of revenue for government activities. Most merchants pass the cost of sales tax on to the consumer by adding the tax to the cost of merchandise. But if, as a merchant, you sell merchandise on a tax-included basis, you will need to calculate sales tax in reverse. Merchants that handle product returns without a point-of-sale system also use this calculation to recover taxes already paid, in the form of tax deductions.
The R&D tax credit is a dollar-for-dollar reduction against a company's income tax liability. Because of its potentially significant benefit, it is important to know how to calculate it correctly. With the correct form, filing instructions and records, businesses are able to accurately and efficiently determine their current-year R&D tax credit.
If you want $19,000 in profits, it will be helpful to know exactly how many units you need to sell to reach this goal. Using the cost-volume-profit analysis, you will be able to make this calculation. The main ingredient for the calculation is the contribution margin on the product. The contribution margin shows how much of the sales price will go to cover a company's fixed costs of production. The fixed costs are those that do not change based on the level of production.
It is important to understand how to calculate your company's taxes if you manage a business. Companies must pay income taxes at the federal and state levels. These taxes reduce your company's profits and, therefore, owners' equity. Calculating your business' taxes will allow you to see what your company's final profits will look like. Calculating taxes does not need to be complicated.
The federal government requires employers to withhold federal payroll taxes from workers' paychecks and to report and pay such taxes to the Internal Revenue Service (IRS). Federal withholding taxes include federal income tax, Social Security tax and Medicare tax. While most states require the employer to withhold state income tax, states such as Alaska, Florida, New Hampshire, Nevada, South Dakota, Tennessee, Wyoming and Washington do charge this tax. The employer cannot withhold federal and state payroll taxes according to its own formula. It must use the calculations the respective government institution sets for each withholding tax.
When you import most goods, you can look forward to paying customs duties or customs taxes on those items. If you're arranging for the importation yourself, calculating the import taxes on the goods you plan to import may make a significant difference in the price, depending on the kind of goods being imported. The United States International Trade Commission offers an online interactive version of the complete Harmonized Tariff Schedule of the United States to assist in calculating the import taxes on specific items.
Tax shields are reductions in taxes that stem from a reduced taxable income. In business, interest expenses are deducted from the overall income of a corporation before it is taxed. Due to this, some theories go so far as to claim that the optimum capital structure for a corporation is 100 percent debt. This, of course, is not the case; debt becomes more expensive to a corporation with each new issuing. At some point, the benefits of the tax shield will be outweighed by the cost of issuing new debt. Corporations, however, will issue debt up until that point.
SUI tax (alternately known as Unemployment Insurance Tax and Unemployment Insurance Compensation tax) is typically withdrawn by an employee's employer with each paycheck. The rate is set by the state government and generally changes from year to year. This has been true in Pennsylvania. Fortunately, calculating SUI tax rate is quite simple and can be completed in minutes.
Sales taxes, according to Investopedia, are revenues assessed on goods by a government entity. The seller is responsible to collect these taxes and forward the funds to the proper revenue-collecting agency. Rates and regulations vary from state to state, and municipality to municipality, so be sure to research the rules for the place you are doing business. You may need a certificate to collect taxes; if you don't have the right paperwork, fines can be steep.
Import taxes--also called import duties--constitute the largest source of revenue for the U.S. government after income taxes. Import taxes are a percentage of the declared value of the product you're importing. The tax rate is based on two criteria: where the product is being imported from and the type of product being imported. The product types and their tax rates are found in a 3,123-page book published by the U.S. International Trade Commission.
Calculating sales tax can be very simple, but it's important to know the sales tax of a particular area. Find out how to use decimals and multiplication to calculate sales tax with help from an experienced teacher in this free video on basic math.
At the time of closing it is often necessary to make an adjustment between the Buyer and Seller for property taxes. The annual property tax amount can be obtained from the local tax assessors office. The property tax amount will be prorated between the Buyer and Seller for the portion of the year that each owned the property. For example if a Seller owned the property for half of the year and you owned it for the other half of the year, an adjustment would be made so that each party pays their part, which is half the property tax…
Some state and local municipalities require that vendors collect sales tax on items sold at flea markets. The taxing authorities may differ on the exact items that should incur a sales tax charge, and rates will differ based on the locale of the flea market, but the method of calculating sales tax at flea markets is the same for every vendor. Every sale should be properly recorded so that you can complete the sales tax paperwork on the filing due date and remit payment to the taxing authority for all sales tax collected.
No matter what you do for a living, you will need to compute the taxes you owe and pay those taxes. If you work for someone else, your employer should automatically withhold federal income taxes, Social Security taxes and other applicable taxes from your paycheck. If you work for yourself or do business as a consultant, you will need to make these calculations on your own. Whether you work a traditional job or are self-employed, it is important to know how to calculate your federal income tax liability. Knowing what you are paying and what you may still owe will…
Businesses are subject to sales tax. The applicable sales tax rate is based on the state and county where the business is conducted. Many states do not require the collection of sales tax on sales of clothing, food and over-the-counter and prescription drugs. Quarterly sales tax is due March 15 for the period Dec. 1 through Feb. 28; June 15 for the period March 1 through May 30; Sept. 15 for the period June 1 through Aug. 31; and Dec. 15 for the period Sept. 1 through Nov. 30.
In the United States, the Internal Revenue Service (IRS) collects retirement taxes on behalf of the Social Security Administration. There are two taxes. FICA (Federal Insurance Contributions Act) tax, better known as Social Security tax, is used to provide direct cash payments to persons who are retired, disabled and, in some cases, children or spouses. Medicare tax pays part of the cost of the Medicare health insurance. Employers must match the retirement withholding taxes dollar for dollar.
Three states--New Mexico, Delaware and Arizona--charge "Gross Receipts Tax." Other states charge "Sales Tax"--and they are two different things. The gross receipts tax is levied on businesses, while a sales tax is levied on the consumer. We'll use New Mexico as an example. It charges a gross receipts tax to all entities doing business in the state. Most businesses pass the tax onto their customers--thus, it closely resembles a sales tax. Tax rates differ by city and county. Each county and city may also charge a gross receipts tax. The state collects all tax revenues on behalf of all entities,…
FUTA, or the Federal Unemployment Tax Act, requires that employers pay a certain amount of tax per employee toward Unemployment Tax. This money then goes toward state unemployment systems. In addition, most states require that employers pay state unemployment tax. As an employer, you need to make sure you are paying both sets of tax.
State income tax can add up to an undesired amount unless you attend to all of your deductions. The basic parts in state income tax are state income, income deductions, income exemptions, tax and tax credits. With a W-2 Form and a federal tax return in hand, calculate state tax using simple addition and subtraction.
Medicare tax rates are established yearly by anticipating the monetary needs of the Medicare system covering the hospital portion of medical expenses for those who qualify for Medicare. All U.S. wage earners pay into the trusts that have been established to fund the program. Employees receiving paychecks from an employer, as well as self-employed individuals, pay a calculated percentage of their earnings to support Medicare. After calculating the gross earnings of an hourly employee, it is easy to determine the Medicare tax withholding amount.
Calculating California's sales tax can be a confusing issue when trying to determine how much to tax to charge your customers or figuring out how much tax you will pay as a consumer. Fortunately, by discovering the current sales and use tax rate for your area and by using a simple mathematical process, you can accurately figure out what this charge will be ahead of time.
Unless you have a dedicated point of sale system, your business will need to calculate sales tax when a customer makes a purchase. When a customer returns an item, you'll need to calculate reverse sales tax for your records. By using a good business calculator, this mathematically tricky process will take much less time.
Michigan levies a flat percentage income tax rather than using a progressive (tax bracket) system used by the federal government. All employers who are required to withhold federal income taxes must withhold Michigan state income tax. To calculate withholding taxes in Michigan, you need to get Form 446 from the Michigan Department of the Treasury (see Resources). Be sure you have an up-to-date Form 446, because the tax rate and exemption amounts change. If you have questions, contact the Michigan Department of the Treasury helpline at 517-636-4730 or for TTY (hearing impaired) 517-636-4999.
FUTA (Federal Unemployment Tax Act) tax is one of several payroll taxes. FUTA tax is not deducted from an employee's paycheck like income tax or the employee's contribution to Social Security. Paying the FUTA tax is the employer's responsibility. You need to figure the state unemployment tax (SUTA) when you calculate FUTA taxes. That's because you may take a tax credit for SUTA taxes paid. Be sure to remit the FUTA and SUTA taxes on time or you may lose the tax credit.
Sales taxes are taxes added to the purchase of goods and services. In the United States, each individual state can determine the tax rate to be charged for goods and services. Sales taxes can differ depending on locality within a state, such as Wisconsin, which includes an additional county tax. Taxes can also depend on the type of good or service, such as Tennessee, which charges more tax on non-grocery items than on grocery items. With all of the variations on taxes, it is convenient to set up a spreadsheet in Excel to automatically calculate tax due on purchases.
To prepare a federal income tax return, three types of income are calculated: total income, adjusted gross income and taxable income. Taxable income is used to calculate your tax liability, or the amount of income tax you owe the IRS. The IRS imposes penalties on these tax payments for a handful of different situations. Learn to avoid penalties by calculating and making estimated tax payments.
Employers are required to pay both state unemployment payroll taxes (SUTA) and federal unemployment payroll taxes (FUTA). The percentage of the SUTA tax varies from state to state. However, it is always a simple percentage of the employee's pay up to a yearly earnings limit. It's important to calculate SUTA taxes in conjunction with the FUTA tax. Doing so will allow you to get a credit that reduces the FUTA tax based on how much SUTA tax you pay.
Maintaining a good credit score helps your ability to obtain financing for a home or business, but it also impacts many other areas of your life. Your interests rates are higher, insurance rates are higher, and deposits for utilities are higher if your credit score is low. Judgments are one of the factors that can cause your credit score to drop. Judgments are nasty items to have on your credit report as they can cause problems whether or not they are paid.
Each time you receive a paycheck from your employer, a bit of your pay is withheld to cover your income tax liability. This is so that you pay your income taxes gradually throughout the course of a year instead of all at once at the end of the year. You can calculate how much will be withheld from your paycheck or from the paychecks of those you employ.
Sales tax differs from state to state, and sometimes from item to item. But the process of calculating sales tax remains the same. This article will explain how to calculate sales tax through a standard methodology using a calculator.
