Calculate NPV, IRR and Payback based on the information given in the problem except for the specific numbers below

Manufacturing Equipment Cost 1,220,000 Sales Revenue increase by 2% per year

Capital Budgeting for Project X Based on the following information for project X, should we undertake the venture? To answer, first prepare a pro forma income statement for each year. Next calculate operating cash flow. Finish the problem by determining total cash flow and then calculating NPV assuming a 28 percent required return. Use a 34 percent tax rate throughout. For help, look back at our shark attractant and power mulcher examples. Project X involves a new type of graphite composite in-line skate wheel. We think we can sell 6,000 units per year at a price of $1,000 each. Variable costs will run about $400 per unit, and the product should have a four-year life. Fixed costs for the project will run $450,000 per year. Further, we will need to invest a total of $1,250,000 in manufacturing equipment. This equipment is seven-year MACRS property for tax purposes. In four years, the equipment will be worth about half of what we paid for it. We will have to invest $1,150,000 in net working capital at the start. After that, net working capital requirements will be 25 percent of sales.

I need the numbers put into this Excel chart. The exact layout as the example that is written in the chart.

B17 SUM (B14:B16 Pro Forma Income Statements Year Sales 6,000,000 6,060,000 6,120,600 6,181,806 5 Variable Costs 2.400.000 2,424,000 2,448,240 2,472,722 6 Gross Profit 3600000 3636000 3672360 3709083.6 Fixed Costs 450000 450000 450000 450000 332310 8 Depreciation 269390 237310 157190 2992810 EBIT 2916610 2890050 3021773.6 10 Taxes 982617 1027403.024 1017555.4. 991647.4 11 Net Income 1975254.6 1924.962.6 1907433 1994370.576 12 Cash Flows 13 14 Operating Cash Flow 2132444.6 2194352.6 223 9743 2231680 576 15 Changes in NWC -1150000 350000 15000 15150 1545451.5 16 Net Capital Spen 1310000 545270 17 Cash Flow From (2,460,000) 1,782,445 2.179,353 2.224,593 4322.402 18 19 Net Present Valu $3,910,682 20 IRR 79.86% 21 Payback Period 1.31 1+(ABS(B17)-C17)/D17 22 23 Working Capital 1150000 1500000 1515000 1530150 1545451.5 1150000 350000 15000 24 Change in NWC 15301.5 15150