Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone explain the steps of how to find the Present Value in Excel. Please. Windhoek Mines, Ltd., of Namibia, is contemplating the purchase of
Can someone explain the steps of how to find the Present Value in Excel. Please.
Windhoek Mines, Ltd., of Namibia, is contemplating the purchase of equipment to exploit a mineral deposit on land to which the company has mineral rights. An engineering and cost analysis has been made, and it is expected that the following cash flows would be associated with opening and operating a mine in the area: Cost of new equipment required and timbers Working capital required Annual net cash inflows* Cost to construct new roads in three years Salvage value of equipment in four years $410,000 $100,000 $150,000 $ 47,000 $ 72,000 *Receipts from sales of ore, less out-of-pocket costs for salaries, utilities, insurance, etc. The mineral deposit would be exhausted after four years of mining. At that point, the working capital would be released for reinvestment elsewhere. The company's required rate of return is 18%. Required: a. Determine the net present value of the proposed mining project. (Hint: Use Microsoft Excel to calculate the discount factor(s).) (Any cash outflows should be indicated by a minus sign. Do not round your intermediate calculations.) Item Cost of equipment required Working capital required Net annual cash receipts Cost of road construction Salvage value of equipment Working capital released Net present value Amount of Year(s) Cash Flows of Cash F Present Value Now $ (410,000) $ (410,000) Now $ (100,000) (100,000) 1-4 | $ 150,000 3 $ (47,000) 4 $ 100,000 $ (510,000)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started