Question: please include a formula that will work on excel, thank you. Net present value method The following data are accumulated by Geddes Company in evaluating
Net present value method The following data are accumulated by Geddes Company in evaluating the purchase of equipment, having a four-year useful life: Year 1 Year 2 Year 3 Year 4 DATA Net Income Net Cash Flow $42,500 $75,000 23,500 56,000 14,500 47,000 2,000 34,500 2 3 Cost of equipment Desired rate of return $130,000 10% Using formulas and cell references, perform the required analysis, and input your answer into the Amount column. Transfer the numeric result for the green entry cell (D18) into the appropriate fields in CNOWv2 for grading. Amount Formula -8 a. Net present value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
