Question: ONLY USE EXCEL! DO NOT HARD CODE NUMBERS. A. what is the NPV of the project at a discount rate r=6%? B. Do you want

ONLY USE EXCEL! DO NOT HARD CODE NUMBERS. A. what is

ONLY USE EXCEL! DO NOT HARD CODE NUMBERS.

A. what is the NPV of the project at a discount rate r=6%?

B. Do you want to invest in the project at r=6%?

C. Would you chnage your mind if r=4%?

D. What is the IRR of the project?

V fx | B8 x A 1 Time 2 Cash flow H B 1 -1000 C 2 100 D 3 E 4 F 5 300 G 6 200 300 300 3 4 [Note: Cash-flows start one year from today] 5 NPV, r=6% 6 NPV, r=4% 7 IRR 8 9 10 11 12

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The attached file contains explanations on how to complete the excel assignment. You MUST follow all rules and formulas to get the solutions...etc/ Please send me the completed excel sheet that...

Instructions: Identifying Relevant Cash Flows Suppose a beverage company is considering adding a new product line. Currently the company sells apple juice and they are considering selling a fruit...

Identifying Relevant Cash Flows Suppose a beverage company is considering adding a new product line. Currently the company sells apple juice and they are considering selling a fruit drink. The fruit...

BD Corporation has 8,000,000 shares of common stock outstanding, 800,000 shares of preferred stock outstanding and 187,500 bonds outstanding. The common stock currently sells for $37.50 and just paid...

1 You are the same CFO as in the example question. Instead of the investment lasting 5 years, suppose it lasts 10 years. You invest 100k today, get back 10k every year for 10 years, then get all of...

L You are the same CFO as in the sample question. Instead of the investment lasting 10 years. You invest 100 today, wtback 10 every year for 10 years, then t o your back, White NPV and IRR. Your...

Calculating NPV and IRR-Excel Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PasteB I U A Alignment Number Conditional Format as CellCells Editing Clipboard C3 Formatting Table Styles...

Suppose you randomly select a engineers repeatedly of salaries. distribution Created annual and Samples annual percentile distribution salaries chemical Lind of sample A the salary of the their...

Fifty numbers are rounded off to the nearest integer and then summed. If the individual roundoff errors are uniformly distributed over (.5, .5), approximate the probability that the resultant sum...

if 4 \ cdot x ^ 2 + 3 \ cdot x + x \ cdot y = 4 and y = 4 = - 1 8 f y ' ( 4 ) ind by implicit differentiation.

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Using the information gathered in Application Exercise 7, prepare a combination general rsum that could be used with at least three of the advertised positions. Partner with a classmate to proofread...

Technology. Assume you worked for your father at his car dealership while attending school. Because you have limited work experience, you want to include this on your rsum. You have written the...

What content should go in the closing paragraph of an application letter? (Objective 1)