Please show the formula to be inputed on C,D,E,F10

B3 X fx A project has an initial cost of $10,000. This project is expected to bring in $2,611 per year for 4 years. If money can earn 2% compounded annually, what is the net present value of this project? If your NPV is less than 0, enter a negative for your answer. A F G H 1 K L M N 0 P Q R 5 1 B Student Number 2754 2754 3% D E Loan Amount Nominal Periodic # of Payments Payment 4 A project b 60 Payment Amount Interest Amount Principal Amount Balance Payment Number D 1 2 3 4 $49.49 2 3 Step 1 5 Calolate the periodic Interest based on 3X 6 compounded monthly in F3. Consider monthly 7 payments. & Step 2 9 Calolate the payment amount to 2 decimals in F5 using the PMT function. 11 Step 12 Fill in rows 0-60 accordingly. Remember, the 13 last payment will be caloulated differently 14 15 Step 4 16 Using the SUM function in D70, calculate the 17 amount of interest paid for this laan 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Amortization 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Sinking Fund +