Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information: • She received $73,000 in salary. • She received $11,000 of dividend income. • She received $6,500 of interest income on Home Depot bonds. • She received $22,000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $6,100. • She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale at a cost of $4,400. • Mary receives one exemption ($4,000), and she has allowable itemized deductions of $7,500. These amounts will be deducted from her gross income to determine her taxable income. Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Oren spreadsheet a. What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermediate calculations. b. What is her marginal tax rate? Round your answer to 1 decimal place. % c. What is her average tax rate? Round your answer to 2 decimal places. Personal taxes Salary $73,000.00 Tax Table for Single Individuals: Percentage on Excess over Base Amount Paid on Base S0.00 $922.50 $5,156.25 S18,481.25 $46,075.25 $119,401.25 $119,996.25 Dividend Income Interest Income $11,000.00 $6,500.00 $22,000.00 $6,100. 00 Taxable Income $0.00 $9,225.00 $37,450.00 590,750.00 $189,750.00 $411,500.00 10.00% 15.00% LT Stock Sale LT Stock Cost ST Stock Sale ST Stock Cost Personal Exemption Itemized Deductions Aplicable Tax Rate on Dividends & LT Capital Gains 25.00% $10,000.00 28.00% $4.400.00 33.00% $4,000.00 $7,500.00 15.00% 35.00% 39.60% $413,200.00 3 a. Calculation of Federal Tax Liability Calculation of Taxable Income Salary 7 Interest Income ST Capital Gains Income before Exemption and Deductions Personal Exemption I Itemized Deductions Taxable Income before Dividends & LT Capital Gains Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A Taxes on Taxable Income Before Dividends & LT Capital Gains Tax Liability on Base of BracCket Tax Liability on Excess over Base Tax on Taxable Income before Dividends & LT Capital Gains #N/A 5. #N/A #N/A Taxes on Dividends & LT Capital Gains Dividend Income LT Capital Gains Income Total Dividend & LT Capital Gains Income Tax on Dividends & LT Capital Gains Income #N/A #N/A 2 #N/A #N/A 5 Total Federal Tax Liability #N/A b. Calculation of Marginal Tax Rate Marginal Tax Rate #N/A C. Calculation of Average Tax Rate Average Tax Rate #N/A I Video Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information: • She received $73,000 in salary. • She received $11,000 of dividend income. • She received $6,500 of interest income on Home Depot bonds. • She received $22,000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $6,100. • She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale at a cost of $4,400. • Mary receives one exemption ($4,000), and she has allowable itemized deductions of $7,500. These amounts will be deducted from her gross income to determine her taxable income. Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermediate calculations. b. What is her marginal tax rate? Round your answer to 1 decimal place. c. What is her average tax rate? Round your answer to 2 decimal places. Check My Work Reset Problem Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information: • She received $73,000 in salary. • She received $11,000 of dividend income. • She received $6,500 of interest income on Home Depot bonds. • She received $22,000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $6,100. • She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale at a cost of $4,400. • Mary receives one exemption ($4,000), and she has allowable itemized deductions of $7,500. These amounts will be deducted from her gross income to determine her taxable income. Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Oren spreadsheet a. What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermediate calculations. b. What is her marginal tax rate? Round your answer to 1 decimal place. % c. What is her average tax rate? Round your answer to 2 decimal places. Personal taxes Salary $73,000.00 Tax Table for Single Individuals: Percentage on Excess over Base Amount Paid on Base S0.00 $922.50 $5,156.25 S18,481.25 $46,075.25 $119,401.25 $119,996.25 Dividend Income Interest Income $11,000.00 $6,500.00 $22,000.00 $6,100. 00 Taxable Income $0.00 $9,225.00 $37,450.00 590,750.00 $189,750.00 $411,500.00 10.00% 15.00% LT Stock Sale LT Stock Cost ST Stock Sale ST Stock Cost Personal Exemption Itemized Deductions Aplicable Tax Rate on Dividends & LT Capital Gains 25.00% $10,000.00 28.00% $4.400.00 33.00% $4,000.00 $7,500.00 15.00% 35.00% 39.60% $413,200.00 3 a. Calculation of Federal Tax Liability Calculation of Taxable Income Salary 7 Interest Income ST Capital Gains Income before Exemption and Deductions Personal Exemption I Itemized Deductions Taxable Income before Dividends & LT Capital Gains Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A Taxes on Taxable Income Before Dividends & LT Capital Gains Tax Liability on Base of BracCket Tax Liability on Excess over Base Tax on Taxable Income before Dividends & LT Capital Gains #N/A 5. #N/A #N/A Taxes on Dividends & LT Capital Gains Dividend Income LT Capital Gains Income Total Dividend & LT Capital Gains Income Tax on Dividends & LT Capital Gains Income #N/A #N/A 2 #N/A #N/A 5 Total Federal Tax Liability #N/A b. Calculation of Marginal Tax Rate Marginal Tax Rate #N/A C. Calculation of Average Tax Rate Average Tax Rate #N/A I Video Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information: • She received $73,000 in salary. • She received $11,000 of dividend income. • She received $6,500 of interest income on Home Depot bonds. • She received $22,000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $6,100. • She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale at a cost of $4,400. • Mary receives one exemption ($4,000), and she has allowable itemized deductions of $7,500. These amounts will be deducted from her gross income to determine her taxable income. Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermediate calculations. b. What is her marginal tax rate? Round your answer to 1 decimal place. c. What is her average tax rate? Round your answer to 2 decimal places. Check My Work Reset Problem
Expert Answer:
Related Book For
Fundamentals of Financial Management
ISBN: 978-1337395250
15th edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these general management questions
-
Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information: She received $82,000 in salary. She received...
-
Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information: She received $116,000 in salary. She received...
-
Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information: She received $82,000 in salary. She received...
-
Jake's office building is destroyed by a fire on September 15, 2022. Jake receives insurance proceeds on April 15, 2023 in the amount of $300,000. Jake's adjusted basis in the building was $250,000....
-
(a) Would you expect d-glucitol to be optically active? (b) Write Fischer projection formulas for all of the d-aldohexoses that would yield optically inactive alditols.
-
Garfun, Inc., owns all of the stock of Simon, Inc. For 2018, Garfun reports income (exclusive of any investment income) of $480,000. Garfun has 80,000 shares of common stock outstanding. It also has...
-
What are the major forms of a business? Why would there need to be any difference between them? What are some advantages and disadvantages to each form?
-
A piece of equipment that cost $32,400 and on which $18,000 of accumulated depreciation had been recorded was disposed of on January 2, the first day of business of the current year. For each of the...
-
Terry and Terri did not know a lot about each other before they got married so they did not find out that one of them has poor credit. The interest rate will be higher because of a low credit score....
-
Let F be the language of all strings over {0,1} that do not contain a pair of 1s that are separated by an odd number of symbols. Give the state diagram of a DFA with five states that recognizes F....
-
What impact does money laundering have on the economy? It increases GDP because the criminals tend to spend the money here. An insignificant impact except to financial institutions . It has no impact...
-
ABC Bank Business Loan Calculations Monthly Payment Annual Payment Loan Amount (PV) Annual Interest Rate Payments per Year nterest Rate per Period (RATE) Number of Years Total Payments (NPER) Part 6...
-
You are proposing a $80MM term loan at LIBOR + 20 b.p. for a corporate borrower that has a BIS weight of 20% and the capital adequacy is 8%. What is the required capital amount?
-
How do organizations balance the needs and preferences of their employees with the constraints and goals of the organization when designing a compensation and benefits program?
-
A top-rated multinational company requires short-term unsecured finance for general working capital requirements that can vary, but can be in excess of $100M at any one time. What type of funding...
-
Suppose you are the credit officer reviewing a credit proposal for a noncollateralized $10MM overdraft facility that is stated will be used to formalize an outstanding overdraft. What is our...
-
Consider a reaction involving oxygen (O), hydrogen (H), and water (H2O) molecules O+2H H2O taking place in a volume V and in thermal equilibrium at temperature T. Consider that the hydrogen density...
-
Government is advised to tax goods whose demand curves are inelastic if the goal is to raise tax revenues. If the goal is to discourage consumption, then it ought to tax goods whose demand curves are...
-
Table 19.1 lists foreign exchange rates for August 25, 2017. On that day, how many dollars would be required to purchase 1,000 units of each of the following:British pounds, Canadian dollars, EMU...
-
Assume that interest rate parity holds and that 90-day risk-free securities yield a nominal annual rate of 3% in the United States and a nominal annual rate of 3.5% in the United Kingdom. In the spot...
-
Adamson Corporation is considering four average-risk projects with the following costs and rates of return: The company estimates that it can issue debt at a rate of rd = 10%, and its tax rate is...
-
Define and distinguish between an open and a closed adoption.
-
Define and distinguish between an independent and an agency adoption.
-
Define and give an example of an equitable adoption.
Study smarter with the SolutionInn App