Question

Oakdale Fashions, Inc., had $315,000 in 2015 taxable income. Use the tax schedule in Table 2.3 to calculate the companys 201Taxable income $ 315,000 table 2.3 Corporate Tax Rates as of 2015 25% Plus this Percentage Taxable Income (Bottom of TaxableComplete the following analysis. Do not hard code values in your calculations. Tax on base income of bracket Tax on income wi

the answers must be as a formula

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SUM - X fx =ROUND(IF(B3<0,0,1F(B3<50001,83*0.15,1F(B3<75001, (+33-50000)*0.25+7500,1F(B3<100001, (B3-75000)*0.34+13750,1F(B3<

3,15,000 3 Oakdale Fashions Inc. Taxable Income 4. 5 Tax Payable 1,06,100 9 Tax on base income of bracket =50000*15% 7,500 10

=ROUND(IF(B3<0,0,IF(B3<50001,B3*0.15,IF(B3<75001,(+B3-50000)*0.25+7500,IF(B3<100001,(B3-75000)*0.34+13750,IF(B3<335001,(B3-100000)*0.39+22250,IF(B3<1000001,(B3-335000)*0.34+113900)))))),0)

Add a comment
Know the answer?
Add Answer to:
the answers must be as a formula Oakdale Fashions, Inc., had $315,000 in 2015 taxable income....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Hunt Taxidermy, Inc. is concerned about the taxes paid by the company in 2018. In addition...

    Hunt Taxidermy, Inc. is concerned about the taxes paid by the company in 2018. In addition to $7.5 million of taxable income, the firm received $614,000 of interest on state-issued bonds and $340,000 of dividends on common stock it owns in Oakdale Fashions, Inc. (Use Table 2.3.) Calculate Tax Liability: Calculate the Average Tax Rate: Calculate Marginal Tax Rate: Plus this Percentage on Anything Over the Base table 2.3 Corporate Tax Rates as of 2015 Pay this Amount Taxable income...

  • table 2.3 Corporate Tax Rates as of 2015 Pay this Amount on Base Income Plus this...

    table 2.3 Corporate Tax Rates as of 2015 Pay this Amount on Base Income Plus this Percentage on Anything Over the Base Taxable Income $0-$50,000 $50,001-$75,000 $75,001-$100,000 $100,001-$335,000 $335,001-$10,000,000 $10,000,001-$15,000,000 $15,000,001-$18,333,333 Over $18,333,333 0 7,500 13,750 22,250 113,900 3,400,000 5,150,000 6,416,667 15% 25 34 39 34 35 38 35 Hunt Taxidermy, Inc. is concerned about the taxes paid by the company in 2018. In addition to $4.4 million of taxable income, the firm received $309,000 of interest on state-issued bonds...

  • 1. Calculate the average tax rate and marginal tax rate Corporate Taxes - Excel HOME INSERT...

    1. Calculate the average tax rate and marginal tax rate Corporate Taxes - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial E伯 B 1 u , m. Cr. A. Alignment Number Conditional Format as. Cell Cells Editing Paste Clipboard D25 Formatting TableStyles- Font Styles A B Oakdale Fashions, Inc., had $315,000 in 2015 taxable income Use the tax schedule in Table 2.3 to calculate the company's 2015 income taxes. What is the average tax rate? (Round...

  • The Dakota Corporation had a 2015 taxable income of $30,500,000 from operations after all operating costs...

    The Dakota Corporation had a 2015 taxable income of $30,500,000 from operations after all operating costs but before (1) interest charges of $8,300,000, (2) dividends received of $730,000, (3) dividends paid of $5,150,000, and (4) income taxes. a. Use the tax schedule in Table 2.3 to calculate Dakota's income tax liability. (Round your answer to the nearest dollar amount.) Income tax liability | $ 8,542,500 b. What are Dakota's average and marginal tax rates on taxable income? (Round your answers...

  • The Anberlin Co. had $272194 in 2015 taxable income. Use the tax rates from Table 2.3....

    The Anberlin Co. had $272194 in 2015 taxable income. Use the tax rates from Table 2.3. Calculate the company’s marginal tax rate. Taxable Income      Tax rate $0-50,000                                15% 50,001-75,000                         25% 75,001-100,000                       34% 100,001-335,000                     39% 335,001-10,000,000                34% 10,000,001-15,000,000           35% 15,000,001-18,333,333            38% 18,333,334 +                           35%

  • Inc. is concerned about the taxes paid by the company in 2018. In addition to $4.3...

    Inc. is concerned about the taxes paid by the company in 2018. In addition to $4.3 million of taxable income, the firnm received $304,000 of interest on state-issued bonds and $140,000 of dividends on common stock it owns in Oakdale Fashions, Inc (Use Iable23) Calculate Hunt Taxidermy's tax liability (Enter your answer in dollars not in millions. Round your answer to the nearest dollar amount.) Calculate Hunt Taxidermy's average tax rate. (Round your answer to 2 decimal places.) tax rate...

  • Hunt Taxidermy, Inc. is concerned about the taxes paid by the company in 2018. In addition...

    Hunt Taxidermy, Inc. is concerned about the taxes paid by the company in 2018. In addition to $14.2 million of taxable income, the firm received $1,560,000 of interest on state-issued bonds and $1,210,000 of dividends on common stock it owns in Oakdale Fashions, Inc. (Use Table 2.3.) table 2.3 Corporate Tax Rates as of 2015 Taxable income Pay this Amount on Base Income Plus this Percentage on Anything Over the Base 15% 25 34 39 $0-$50,000 $50,001-$75,000 $75,001-$100,000 $100,001-$335,000 $335,001-$10,000,000...

  • regardless of the chart saying 2015 it still has to be used Help Hunt Taxidermy, Inc....

    regardless of the chart saying 2015 it still has to be used Help Hunt Taxidermy, Inc. is concerned about the taxes paid by the company in 2018. In addition to $12.6 million of taxable income, the firm received $1,255,000 of interest on state-issued bonds and $740,000 of dividends on common stock it owns in Oakdale Fashions, Inc. (Use Table 2.3.) Calculate Hunt Taxidermy's tax liability. (Enter your answer in dollars not in millions. Round your answer to the nearest dollar...

  • The Anberin Co. had $280925 in 2015 taxable income. Use the tax rates from Table 2.3....

    The Anberin Co. had $280925 in 2015 taxable income. Use the tax rates from Table 2.3. Calculate the company's average tax rate. TABLE 2.3 Taxable Income Tax Rate Corporate Tax Rates 50,000 75,000 100,000 100,001-335,000 335,001-10,000,000 10,000,001-15,000,000 15,000,001-18,333,333 15% 25 34 39 34 35 38 35 50,001 75,001 18,333,334+

  • "Florida Citrus Inc. (FCI) estimates its taxable income at $7,100,000. Use the Corporate Tax Schedule, Table...

    "Florida Citrus Inc. (FCI) estimates its taxable income at $7,100,000. Use the Corporate Tax Schedule, Table 9.12, to calculate how much FCI will pay in federal income taxes." TABLE 9·12 Corporate Tax Schedule for 2015 Taxable Income (X) $0-$50,000 50,001-75,000 75,001-100,000 100,001-335,000 335,001-10,000,000 10,000,001-15,000,000 15,000,001-18,333,333 18,333,334 and up Tax Rate 15% 25% 34% 34% + 5% 34% 35% 35% + 3% 35% Tax Computation Formula $0 + 0.15X 7,500 + 0.25(X - $50,000) 13,750 + 0.34(X - 75,000) 22,250 +...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT