Question
A startup Internet company has generated the following cash balance for the first six years of its IS projects: -$250,000, -$180,000, $225,000, $340,000, $410,000, and
A startup Internet company has generated the following cash balance for the first six years of its IS projects: -$250,000, -$180,000, $225,000, $340,000, $410,000, and $425,000. Using the NPV function in Excel, calculate the net present value of this project at an 8.5 percent interest rate. What is the IRR of this project? If a bank is willing to give the company a loan at 15 percent to implement these projects, should the company accept the loan (assuming there are no other conditions)? Why or why not?
POST SCREEN SHOTS SO I CAN SEE HOW YOU DID IT IN EXCEL.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started