Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Is this correct? Year 0 1 2 3 4 NPV Commodity A CF Discounted CF -90,000 -90,000 30,000 26,087 40,000 30,246 50,000 32,876 60,000 34,305

image text in transcribed

Is this correct?

Year 0 1 2 3 4 NPV Commodity A CF Discounted CF -90,000 -90,000 30,000 26,087 40,000 30,246 50,000 32,876 60,000 34,305 33,514 Commodity B CF Discounted CF -90,000 -90,000 30,000 26,087 30,000 22,684 30,000 19,725 20,000 11,435 -10,068 Question 3.a. Complete the table above to calculate NPV for commodity A and B without using NPV function. Assume a discount rate of 15%. Question 3.b. Use NPV function to calculate net present values for commodity A in Cell N23 for commodity B in Cell N25. Assume a discount rate of 15%. NPV for A 33,514 NPV for B -10,068 Question 3.c. Based on your NPV calculation, which commodity would you produce and why? Answer 3.c. The commodity to produce would be commodity A. As Commoity B is giving a lower present value of $10,068 compared to commoidty A which is 33,514

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

Financial Accounting

Authors: Jane L. Reimers

1st Edition

0131492012, 978-0131492011

Students also viewed these Accounting questions

Question

Calculate a mean and standard deviation for each variable.

Answered: 1 week ago