Please use Excel to show work. Thank you!

Sally Evans runs an Etsy shop where she makes custom wood art pieces. She has gotten very popular and is growing into a small business. She is moving out of her garage and into an actual production facility. The new facility costs $250,000 and is expected to depreciate over 39 years at 2.564% each year using straight line depreciation. She wants to update her equipment. The new table saw is $8,000 and the new suite of power tools is $12,000. She can claim depreciation on this equipment using a 3-year class MACRS table. She is expecting to spend about $12,000 annually on maintenance and assumes that will go up by 3% per year based on wear and tear on the facility and tools. Her revenue predictions are below. The state tax is 4.75% and the federal tax uses the table below. What is the ATCF for each year for the next 5 years? What is the PV using an MARR of 20%? What is the IRR of her investment in her new facility and tools? Based on the calculated IRR and the MARR she would like to see from her new business what can you conclude about the new business? Taxable Income Tax Rate Income $0-$50,000 15% Year Sales $50,001 - $75,000 25% $92,000 $75,001 - $100,000 34% 2 $102,000 $100,001 - $335,000 39% 3 $112,000 $335,001 - $10 Million 34% $122,000 $10 Million - $15 Million 35% $132,000 > $15 Million 38% 1 2 4 5 Sally Evans runs an Etsy shop where she makes custom wood art pieces. She has gotten very popular and is growing into a small business. She is moving out of her garage and into an actual production facility. The new facility costs $250,000 and is expected to depreciate over 39 years at 2.564% each year using straight line depreciation. She wants to update her equipment. The new table saw is $8,000 and the new suite of power tools is $12,000. She can claim depreciation on this equipment using a 3-year class MACRS table. She is expecting to spend about $12,000 annually on maintenance and assumes that will go up by 3% per year based on wear and tear on the facility and tools. Her revenue predictions are below. The state tax is 4.75% and the federal tax uses the table below. What is the ATCF for each year for the next 5 years? What is the PV using an MARR of 20%? What is the IRR of her investment in her new facility and tools? Based on the calculated IRR and the MARR she would like to see from her new business what can you conclude about the new business? Taxable Income Tax Rate Income $0-$50,000 15% Year Sales $50,001 - $75,000 25% $92,000 $75,001 - $100,000 34% 2 $102,000 $100,001 - $335,000 39% 3 $112,000 $335,001 - $10 Million 34% $122,000 $10 Million - $15 Million 35% $132,000 > $15 Million 38% 1 2 4 5