finance help! Prepare the financial section of a business case for the Video Game Delivery Project. Assume this project will take 12 months to complete and cost about $500,000 and monthly operating costs would be about $50,000 per month for year one and $60,000 per month for years two and three. Estimated benefits are about $1 million the first year after implementation and $2 million the following two years. Use the business case spreadsheet template from Templates link to help calculate the NPV, ROI, and year in which payback occurs. Assume a 7 percent discount rate. Any help is greatly appreciated thanks!! I have added in a picture as well as the data in text.

Note: Change the inputs, such as interest rate, number of years, costs, and benefits.

Financial Analysis for Game Sync Created by: Date: Note: Change the inputs, such as interest rate, number of years, costs, and benefits. Formulas are entered in the Excel file used to create this template. Be sure to double-check the formulas based on the inputs. Discount rate 7% Assume the project is completed in Year 1 Year 0 1 2 3 Total Costs 100 100 100 100 Discount factor 1.00 0.93 0.87 0.82 Discounted costs 100 93 87 82 362 Benefits 0 200 200 200 Discount factor 1.00 0.93 0.87 0.82 Discounted benefits 0 187 175 163 525 Discounted benefits - costs (100) 93 87 82 162 NPV Cumulative benefits - costs (100) (7) 81 162 ROI 45% Payback before Year X Assumptions Enter assumptions here

Financial Analysis for Game Sync Ceated by years, cests and berets Fomms lo double check the formdri