Please write equations in google sheets to calculate the following values:

a.Calculate the NPV

b. IF the cost of capital for this project is 17 % what is your estimate of the value of the new project?

You are a manager at Northern Fibre, which is considering expanding its operations in synthetic fibre manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $2.1 million for this report, and I am not sure their analysis makes sense. Before we spend the $31 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates (in millions of dollars): Sales revenue - Cost of goods sold =Gross profit - General, sales, and administrative expenses - Depreciation = Net operating income - Income tax = Net income 1 36.000 21.600 14.400 2.480 3.100 8.8200 3.087 5.733 2 2 36.000 21.600 14.400 2.480 3.100 8.8200 3.087 5.733 9 9 36.000 21.600 14.400 2.480 3.100 8.8200 3.087 10 36.000 21.600 14.400 2.480 3.100 8.8200 3.087 5.733 5.733 You are a manager at Northern Fibre, which is considering expanding its operations in synthetic fibre manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $2.1 million for this report, and I am not sure their analysis makes sense. Before we spend the $31 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates (in millions of dollars): Sales revenue - Cost of goods sold =Gross profit - General, sales, and administrative expenses - Depreciation = Net operating income - Income tax = Net income 1 36.000 21.600 14.400 2.480 3.100 8.8200 3.087 5.733 2 2 36.000 21.600 14.400 2.480 3.100 8.8200 3.087 5.733 9 9 36.000 21.600 14.400 2.480 3.100 8.8200 3.087 10 36.000 21.600 14.400 2.480 3.100 8.8200 3.087 5.733 5.733