I need help with question A. specifically how do I find the tax @ 20% to help finish the excel sheet.

Case Study: K-Viro, Inc. You are Chief Financial Officer at K-Viro, Inc., the leading inventor of the Covid-19 chewable gummy vaccine, shown to be 101% effective. The media has called this product "the most revolutionary scientific discovery since the iPhone". Given the positive sentiment around the company, your firm's Chief Marketing Officer, Roberto Santos, wants to do a massive advertising campaign around the world. The campaign will cost $50,000,000. Currently, sales at K-Viro are $0 as the chewable vaccine is the first product to make it through FDA approval for the company. Your financial analyst, Frederick Smith, projects Sales to be $1,500,000 with total costs to be $600,000 next year. It is expected that sales will grow 50% in year 2,30% in years 3 & 4, and then 5% year 5 and beyond. Costs will grow similarly. Your tax rate is 20% for all years. Part 1 Case Study Problems: A. What is the NPV of the project if the borrowing rate to fund the project was 7%? Would you accept the Chief Marketing Officer, Roberto Santos' plan - why or why not? *remember to use after tax cash flows for the project 1 2 Year 3 Sales 4 Costs 5 Before Tax Cash Flow 6 Tax @ 20% 7 After Tax Cash Flow 8 K Viro Inc. 1 2 3 $1,500,000 $2,250,000.0 $2,925,000.0 $600,000 $900,000.0 $1,170,000.0 $900,000 $1,350,000.0 $1,755,000.0 4 5. $3,802,500.0 $3,992,625.0 $1,521,000,0 $1,597,050.00 $2,281,500.0 $2,395,575.00 00