Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are considering the projects below and can take only one. Your cost of capital is 11%. Complete the steps below using cell references to

image text in transcribed

You are considering the projects below and can take only one. Your cost of capital is 11%. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. a. What is the NPV of each project at your cost of capital? b. What is the IRR of each project? c. At what cost of capital are you indifferent between the two projects? d. What should you do? Project A Project B $ -100 $ 50 $ 40 $ 30 $ Cost of capital 11% a. What is the NPV of each project at your cost of capital? NPV project A NPV project B b. What is the IRR of each project? IRR project A IRR project B c. At what cost of capital are you indifferent between the two projects? Projects A-B IRR of difference d. What should you do? You should invest in project: Requirements 1 In cell D18, by using the NPV function and cell references, calculate the NPV of project A (1 pt.). 2 In cell D19, by using the NPV function and cell references, calculate the NPV of project B (1 pt.). 3 In cell D23, by using cell references, calculate the IRR of project A (1 pt.). 4 In cell D24, by using cell references, calculate the IRR of project B (1 pt.). 5 In cell range D29:H29, by using cell references, calculate the difference between the cash flows of project A and project B (1 pt.). 6 In cell D31, by using cell references, calculate the IRR of the difference in cash flows (1 pt.). 7 In cell E35, type A or B depending on whether you should take project A or project B (1 pt.)

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

Public Finance In Canada

Authors: Harvey S. Rosen, Ted Gayer, Jean-Francois Wen, Tracy Snoddon

5th Canadian Edition

1259030776, 978-1259030772

More Books

Students also viewed these Finance questions