Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need this entire spreadsheet filled out. I attached a word doc with cell input available, thanks. fP 11-12A Basic Net Present Value Analysis Save

I need this entire spreadsheet filled out. I attached a word doc with cell input available, thanks.

image text in transcribed
\fP 11-12A Basic Net Present Value Analysis Save & Exit Submit Question 1 (of 1) 1. value: 8.00 points 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 and timbers Working capital required Annual net cash receipts Cost to construct new roads in three years Salvage value of equipment in four years $ 275,000 $ 100,000 $ 120,000* $ 40,000 $ 65,000 *Receipts from sales of ore, less out-of-pocket costs for salaries, utilities, insurance, and so forth. 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 20%. Click here to view Exhibit 11B-1 and Exhibit 11B-2, to determine the appropriate discount factor(s) using tables. Required: a Determine the net present value of the proposed mining project. (Any cash outflows should be . indicated by a minus sign. Use the appropriate table to determine the discount factor(s).) Now Purchase of equipment Working capital investment Annual net cash receipts Road construction Working capital released Salvage value of equipment Total cash flows Discount factor (20%) Present value Net present value 1 2 3 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 b. Should the project be accepted? Yes No References eBook & Resources Expanded tableDifficulty: 1 EasyLearning Objective: 11-02 Evaluate the acceptability of an investment project using the net present value method

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Industrial Relations in Canada

Authors: Fiona McQuarrie

4th Edition

978-1-118-8783, 1118878396, 9781119050599 , 978-1118878392

Students also viewed these Accounting questions

Question

How is the NDAA used to shape defense policies indirectly?

Answered: 1 week ago