Question: B U 1 Chapter 14: Applying Excel N 3 4 5 6 7 Data Example E Cost of equipment needed Working capital needed Overhaul of

B U 1 Chapter 14: Applying Excel N 3 4 5 6 7 Data Example E Cost of equipment needed Working capital needed Overhaul of equipment in four years Salvage value of the equipment in five years Annual revenues and costs Sales revenues Cost of goods sold Out-of-pocket operating costs Discount rate Aeon 290,000 50,000 20.000 30,000 CO 9 10 11 $ $ $ 420,000 245,000 90,000 14 % 12 13 What is the net present of the project Negative amount should be indicated by minus sign Round your presente factor to decimals and round all other intermediate calculations to nearest whole dollar The internal rate of returns between what two whole discount rates between 10% and between and 12between and between 13 and 14% etc)? d. Reset the discount rate to 14% Suppose the selvage value is uncertain. How large would the savage value have to be to result in a positive net present value? Marage valoared to get positive patient
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
