You are managing a small software firm producing games for mobile devices and are considering introducing a new adventure game to customers. You plan to sell the game for the next 3 years and then exit before the competition catches up. Based on the market research done last year for $30,000, you believe that, in year 1, the project will generate $4,800,000 of revenues with the cost of goods sold of $2,850,000. The revenues and the costs will diminish by 2% each year after that. The project will immediately require new computer equipment valued at $1,800,000. This equipment will be depreciated to $0 over 3 years using the straight-line method. The net working capital will increase immediately by $400,000 from the current level, stay at the new level in year 1 and then decrease by $250,000 in year 2, and again decrease by $150,000 in year 3, returning to the current level. The introduction of the new game will affect the revenues from your other existing adventure games negatively by $190,000 per year. You will have to hire additional sales professionals to market the new product during the project, and their combined annual salary will be $250,000 each year. Forecast all of the annual free cash flows for this project, and then compute its net present value and IRR using a discount rate of 9%. Is this project worth taking? Your company's tax rate is 35%. Instructions: Please use the Excel template titled "LASTNAME, FIRSTNAME_BUS314_Assignment1.xlsx" (downloadable Assignments) to complete the assignment. on A B D E F H I Excel Take-home Assignment #1: Due 1:30PM, April 6 2 3 4 * INSTRUCTIONS: 6 Read the Take-Home Assignment posted on Laulima and enter the correct values for each of the following items in this Excel template. 8 When finished, name your Excel file as LASTNAME, FIRSTNAME_BUS314_Assignment1.xlsx, log on to Laulima, and submit the file by uploading it in Assignments. 9 10 VALUES 11 12 (1) Project Length: 13 (2) Corporate Tax Rate(%): You are managing a small software firm producing games for mobile devices and are considering introducing a new adventure game to customers. You plan to sell the game for the next 3 years and then exit before the competition catches up. Based on the market research done last year for $30,000, you believe that, in year 1, the project will generate $4,800,000 of revenues with the cost of goods sold of $2,850,000. The revenues and the costs will diminish by 2% each year after that. The project will immediately require new computer equipment valued at $1,800,000. This equipment will be depreciated to $0 over 3 years using the straight-line method. The net working capital will increase immediately by $400,000 from the current level, stay at the new level in year 1 and then decrease by $250,000 in year 2, and again decrease by $150,000 in year 3, returning to the current level. The introduction of the new game will affect the revenues from your other existing adventure games negatively by $190,000 per year. You will have to hire additional sales professionals to market the new product during the project, and their combined annual salary will be $250,000 each year. Forecast all of the annual free cash flows for this project, and then compute its net present value and IRR using a discount rate of 9%. Is this project worth taking? Your company's tax rate is 35%. Instructions: Please use the Excel template titled "LASTNAME, FIRSTNAME_BUS314_Assignment1.xlsx" (downloadable Assignments) to complete the assignment. on A B D E F H I Excel Take-home Assignment #1: Due 1:30PM, April 6 2 3 4 * INSTRUCTIONS: 6 Read the Take-Home Assignment posted on Laulima and enter the correct values for each of the following items in this Excel template. 8 When finished, name your Excel file as LASTNAME, FIRSTNAME_BUS314_Assignment1.xlsx, log on to Laulima, and submit the file by uploading it in Assignments. 9 10 VALUES 11 12 (1) Project Length: 13 (2) Corporate Tax Rate(%):