Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The prompt is in the document. The wording in the second part is difficult to understand. I understand #1, but am having trouble with #2.
The prompt is in the document. The wording in the second part is difficult to understand. I understand #1, but am having trouble with #2.
1. Use the VLOOKUP function to calculate the marginal tax rate based on the current taxable income. Use t calculate the marginal tax rate if the new project is accepted. (25 points) 2. Construct a spreadsheet that automatically calculates the taxes owed on a new project's taxable income current taxable income. (75 points) This second problem can be done through careful use of compound IF statements, but you may use other m need to identify the marginal rate based on the firm's current taxable income. You'll also need to check if th to taxable income is enough to push you into a different marginal tax bracket. Besuretocheckyouranswerbyhandafterchangingthetwocells\"Current TaxableIncome\"and\"NewPr TaxableIncome.\"Sometimes you may find a solution that works for the numbers I initially give you, but tha change the numbers (which is what I'll do when grading the assignment). $ $ 7,500,000.00 Current Taxable Income 5,000,000.00 Addition to Taxable Income from Proposed Project Taxable Income $ 50,000 $ 75,000 $ 100,000 $ 335,000 $ 10,000,000 $ 15,000,000 $ 18,333,333 Above $18,333,333 Tax Rate 15% 25% 34% 39% 34% 35% 38% 35% Current Marginal Tax Rate Marginal Tax Rate if Project is Accepted Tax owed on Addition to Taxable Income d on the current taxable income. Use the VLOOKUP function to points) wed on a new project's taxable income given the company's statements, but you may use other methods. Note that you'll income. You'll also need to check if the new project's addition bracket. Current TaxableIncome\"and\"NewProject'sAdditionto he numbers I initially give you, but that doesn't work if I nt). e from Proposed Project ct is Accepted axable IncomeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started