hello in the first picture you have the data and in the second you have the questions i know the first picture is a little blurried but hope you can still help me
Table income is greater than or equal to 50,001 75,000 100.001 335.001 10.000.000 15.000,001 18.333.334 $ 50 000 75,000 100.000 335.000 10.000.000 15.000.000 18.331133 a. Create a tax table in Excel for corporate taxes similar to the individual tax table shown above. Your spreadsheet should then calculate the marginal tax rate the average tax rate, and the tax bill for any level of taxable income input by a user. b. For a taxable income of $1,350,000, what is the marginal tax rate! c. For a taxable income of $1,350,000, what is the total tax bill? d. For a taxable income of $1.350,000, what is the average tax rate? MINICASE Cash Flows and Financial Statements at Sunset Boards, Inc. Sunset Bourds is a wall company that manufactures and sells After rooking through old bank statement, sales receitas Surfhoards in Malibu Marks, the founder of the compu t er records Chen is in charge of the design and sale of the surfboards, but his following in t o background is in surfing, business. As a result, the compa my's facial records are not well maintained The initial investment in Sonnet Boards was provided by Tad and his friends and family. Because the initial investment 2017 2018 was relatively small and the company has made surfhounds Cost of goods sold only for its own store, the investors haven't required detailed Cash 5572 financial statements from Tad But thanks to word of mouth Dection 7215 81.559 among pussional surfers, sales have picked up recently, and 15 E 17.980 Tad is com ing a major expansion. His plans include open Song and administrative ing her and store in Harwal as well as supplying his 50.258 65.610 sticks (surferlingo for boards) to other sellers Accounts payable 26.136 4031 Tad's expansion plans require a significant imvestment Net feed assets 318345 387555 which he plans to finance with a combination of tonal Sales 501.441 511.224 funds from outsiders plus some money bowed from banks Accounts receivable 26.136 33.901 Naturally, the new investors and creditos require more orga Notes payable 29.712 3241 nind de ledancial statements than whas previously Long term debe 150.589 175 340 pread. Al the urging of this investors, Tad has hired finan cial Christina Wolv 67 674 e 50318 the performance of the c ancer the past year 19.500 wory New equity of Corporate France PART 1 Sunset Boards currently pas out 40 percent of net income as dividends to Tad and the other original investors it has 2 percent tax rate. You are Christina's assistant and she has asked you to prepare the following 1. An income statement for 2017 and 2018 QUESTIONS How would you describe Sunset Boards's cash 2018? Write a brief discussion. 2 la light of your discussion in the previous question, do you think about Tad's expansion plans? 2. A balance sheet for 2017 and 2018 3. Operating cash flow for each year, 4. Cash flow from assets for 2018 5. Cash flow to creditors for 2018 6. Cash flow to stockholders for 2018. But less than... Tax Rate $. Taxable income is greater than or equal to .. $. 0 $. 50 001 $. 75 001 $. 100 001 $. 335 001 $. 10 000 001 | $. 15 000 001 $. 18 333 334 50 000 75 000 100 000 335 000 10 000 000 15 000 000 18 333 333 15% 25 % 34 % 39 % 34% 35% 38% 35% a- Create a tax table in excel for corporate taxes similar to the individual tax table shown above. Your spreadsheet should then calculate the marginal tax rate, the average tax rate, and the tax bill for any level of taxable income input by a user. b- For a taxable income of $1 350 000 what is the marginal tax rate? C- For a taxable income of $1 350 000 what is the total tax bill? d-For a taxable income of $1 350 000 what is the average tax rate? Table income is greater than or equal to 50,001 75,000 100.001 335.001 10.000.000 15.000,001 18.333.334 $ 50 000 75,000 100.000 335.000 10.000.000 15.000.000 18.331133 a. Create a tax table in Excel for corporate taxes similar to the individual tax table shown above. Your spreadsheet should then calculate the marginal tax rate the average tax rate, and the tax bill for any level of taxable income input by a user. b. For a taxable income of $1,350,000, what is the marginal tax rate! c. For a taxable income of $1,350,000, what is the total tax bill? d. For a taxable income of $1.350,000, what is the average tax rate? MINICASE Cash Flows and Financial Statements at Sunset Boards, Inc. Sunset Bourds is a wall company that manufactures and sells After rooking through old bank statement, sales receitas Surfhoards in Malibu Marks, the founder of the compu t er records Chen is in charge of the design and sale of the surfboards, but his following in t o background is in surfing, business. As a result, the compa my's facial records are not well maintained The initial investment in Sonnet Boards was provided by Tad and his friends and family. Because the initial investment 2017 2018 was relatively small and the company has made surfhounds Cost of goods sold only for its own store, the investors haven't required detailed Cash 5572 financial statements from Tad But thanks to word of mouth Dection 7215 81.559 among pussional surfers, sales have picked up recently, and 15 E 17.980 Tad is com ing a major expansion. His plans include open Song and administrative ing her and store in Harwal as well as supplying his 50.258 65.610 sticks (surferlingo for boards) to other sellers Accounts payable 26.136 4031 Tad's expansion plans require a significant imvestment Net feed assets 318345 387555 which he plans to finance with a combination of tonal Sales 501.441 511.224 funds from outsiders plus some money bowed from banks Accounts receivable 26.136 33.901 Naturally, the new investors and creditos require more orga Notes payable 29.712 3241 nind de ledancial statements than whas previously Long term debe 150.589 175 340 pread. Al the urging of this investors, Tad has hired finan cial Christina Wolv 67 674 e 50318 the performance of the c ancer the past year 19.500 wory New equity of Corporate France PART 1 Sunset Boards currently pas out 40 percent of net income as dividends to Tad and the other original investors it has 2 percent tax rate. You are Christina's assistant and she has asked you to prepare the following 1. An income statement for 2017 and 2018 QUESTIONS How would you describe Sunset Boards's cash 2018? Write a brief discussion. 2 la light of your discussion in the previous question, do you think about Tad's expansion plans? 2. A balance sheet for 2017 and 2018 3. Operating cash flow for each year, 4. Cash flow from assets for 2018 5. Cash flow to creditors for 2018 6. Cash flow to stockholders for 2018. But less than... Tax Rate $. Taxable income is greater than or equal to .. $. 0 $. 50 001 $. 75 001 $. 100 001 $. 335 001 $. 10 000 001 | $. 15 000 001 $. 18 333 334 50 000 75 000 100 000 335 000 10 000 000 15 000 000 18 333 333 15% 25 % 34 % 39 % 34% 35% 38% 35% a- Create a tax table in excel for corporate taxes similar to the individual tax table shown above. Your spreadsheet should then calculate the marginal tax rate, the average tax rate, and the tax bill for any level of taxable income input by a user. b- For a taxable income of $1 350 000 what is the marginal tax rate? C- For a taxable income of $1 350 000 what is the total tax bill? d-For a taxable income of $1 350 000 what is the average tax rate
