Prepare the tax formula in a worksheet in column

Assignment Help Financial Accounting

Reference no: EM13827050

Part 1: Prepare the tax formula in a worksheet in column A. In column B next to each element of tax formula, show the lines on Form 1040 to which the tax formula line item links.

Part 2: Find a tax rate schedule for 2013. Input the values for the schedule into a MS Excel worksheet. Calculate the tax liability assuming that the Single taxpayers had incomes of:

$5,000

$20,000

$40,000

$100,000

Go to the IRS website and access the Individual Income Tax Tables for 2013. Compare your calculated results with those from the tables. Enter the results from the tax table next to your calculated results in the Excel worksheet.

Requirements:

Clearly identify the requirements being addressed. Show all calculations within the cells of the provided Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well. No hard coding of solutions. Submit a single MS Excel file for grading.

Reference no: EM13827050

Questions Cloud

Companys predetermined overhead rate for the year : Logan Products computes its predetermined overhead rate annually on the basis of direct labor hours. At the beginning of the year, it estimated that 27,000 direct labor-hours would be required for the period's estimated level of production. Compute t..

Report on building sales team for selling : Report on Building Sales team for selling

Calculation of compounded interest rate for a deposit : Determine the value at the end of four years of a $10,000 investment (today) in a bank certificate of deposit (CD) that pays a nominal annual interest rate of 12 percent, compounded.

Record the transactions listed above in journal entry form : Seles Corporation’s charter authorized issuance of 100,000 shares of $10 par value common stock and 50,000 shares of $50 preferred stock. The following transactions involving the issuance of shares of stock were completed. Each transaction is indepen..

Prepare the tax formula in a worksheet in column : Prepare the tax formula in a worksheet in column A. In column B next to each element of tax formula, show the lines on Form 1040 to which the tax formula line item links. Find a tax rate schedule for 2013. Input the values for the schedule into a MS ..

Influence on rates of pay provided to usa workers : Over the past decade, which factor has had the least influence on rates of pay provided to USA workers? 1. minimum wage 2. foreign competition 3. deregulation 4. leveraged buyouts and takeovers

Calculation of annual cash flow with a nominal rate : You are looking to invest in a security that will provide an annual return of $38,000. How much would you have to invest at a nominal rate of 8% to fund this annual cash flow?

Show the likely short-term impact of the flood on the price : The assignment question economics, particularly to macroeconomics and it is explain about how the concepts of demand and supply interact and arrive at equilibrium prices of perishables such as fruits and vegetables.

Amount of cash flows from operating activities reported : Investments in stocks that are expected to be held for the long term are listed in the stockholder's equity section of the balance sheet. Purchased $400,000 of ABC Co. 5% bonds at 100 plus accrued interest of $4,500. Sold $250,000 of bonds at 97 plus..

User Account

All Pages