Can someone show me how to do these in excel? Project X has an initial cost of $19,800 and a cash inflow of $25,000 in Y

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Can someone show me how to do these in excel? Project X has an initial cost of $19,800 and a cash inflow of $25,000 in Y

Post by answerhappygod »

Can someone show me how to do these in excel?
Project X has an initial cost of $19,800 and a cash inflow of$25,000 in Year 3. Project Y costs $40,700 and has cash flows of$12,000, $25,000, and $10,000 in Years 1 to 3, respectively. Thediscount rate is 6 percent and the projects are mutually exclusive.Based on the individual project's IRRs you should accept Project_____; based on NPV you should accept Project ____; the finaldecision should be to accept Project _
A- Y, Y, Y
B- X,X,X
C- X,Y,Y
D-Y,X,X
Luke proposed project has an initial cost of $120,000 and cashflows of $64,500, $98,300, and −$15,500 for Years 1 to 3respectively. If all negative cash flows are moved to Time 0 at adiscount rate of 10 percent, what is the modified internal rate ofreturn?
A- 10.00
B- 10.04
C- 9.69
D- 9.97
E- 14.32
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply