Based on the Income statement for 5 years below, what is the projects NPV at WACC of 12%? Fill in all the blank highlighted cells and please show all work.

Income Statement Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Total Machines/Equipment Cost $ Other Construction/Renovation Cost $ (3,100,000) (800,000) Gross Patient Revenue $ 9,671,000 $ 10,258,997 $ 10,135,889 $ 10,014,258 $ 9,894,087 $49,974,231 Net Patient Revenue $ 3,497,180 $ 3,674,137 $ 3,201,852 $ 3,133,012 $ 3,065,652 $16,571,833 $ $ Expenses: Salaries & Wages Employee Benefits Supplies Utilities Rent Other Department Expenses Depreciation Expense Direct Overhead Expenses Allocation - Corporate Office Overhead Expenses Total Expenses before Corporate Overhead Operating Income $ $ $ $ $ $ $ $ $ $ $ 911,040 273,312 $ 96,000 $ 240,000 $ 120,000 48,000 $ 780,000 $ 403,500 $ 418,370 $ 3,290,222 $ 206,958 $ 947,482 284,244 99,840 249,600 124,800 49,920 780,000 11,57 433,491 3,380,947 $ $ $ $ $ $ $ $ 985,381 $ 295,614 103,834 $ 259,584 129,792 $ 51,917 780,000 $ 390,992 443,423 3,440,536 $ (238,684) $ $ 1,024,796 $ 307,439 107,987 $ 269,967 134,984 $ 53,993 $ 780,000 $ 371,442 454,122 3,504,730$ (371,718) $ 1,065,788 $ 4,934,487 319,736 $ 1,480,346 112,306 519,967 280,766 $ 1,299,917 140,383 $ 649,959 56,153 $ 259,983 780,000$ 3,900,000 352,870 $ 1,930,373 465,601 $ 2,215,006 3,573,603 $17,190,039 (507,951) $ (618,206) $ $ 293,190 $ $ $ 206,958 780,000 $ $ 293,190 780,000 (238,684) $ 780,000 $ $ Net operating income Depreciation Net salvage value Net cash flow $ Cost of Capital Net Present Value (using the excel NPV function) (371,718) $ 780,000 $ $ 408,282 $ (507,951) 780,000 500,000 772,049 $ (3,900,000) $ 986,958 $ 1,073,190 $ 541,316 12% =NPV(B31,C30:30)+B30 (entered in cell B32) Using alternative method Discount rate factor at the project's cost of capital of 12% Net Present value (Cash Flow*Discount Rate Factor) $ 0.89286 881,212 0.71178 385,298 (3,900,000) $ To calculate the discount factor for a cash flow one year from now, divide 1 by the interest rate plus 1 $ (2,633,490) $ $ $ $