Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

2 Principles Of Financial And Managerial Accounting

Authors: Pollard, Sherry T. Mills, Walter T. Harrison Jr.

0136009891, 978-0136009894

More Books

Students also viewed these Accounting questions

Question

What is noise?

Answered: 1 week ago