You have been asked by your client, Alpha Dog LLC, to determine the best possible route to expand their business enterprise into a new state. Alpha Dog LLC was formed in the State of Florida and is owned 100% by John Smith. John is considering adding a new location by the end of 2022. Following is the forecasted revenue for the first three years: Annual Gross Revenue Annual Expenses Year 0 $1,500,000 $1,100,000 Year 1 $2,000,000 $1,300,000 Year 2 $2,500,000 $1,500,000 The initial investment of $400,000 will be for building and equipment in the new state. The building and equipment in Florida have a cost basis of $800,000. 75% of the increase in revenues in years 1 and 2 are sourced to the new state. The increase in expenses in years 1 and 2 is all for payroll costs related to the new state. The Florida payroll is $300,000 in Year 0 and increases 15% each year. Any discount factor to be used is 8%. Please use Excel for Part 1 and Part 2 so that I can see your work. You can use Appendix A or formulas to calculate NPV. For research on state corporate income tax rates and apportionment factors, you will us Select the Databases tab, enter tax, then select RIA Checkpoint.