Compute appropriate net present value, Finance Basics

Imagine Joy is the project coordinator in a company where four projects are running concurrently. He's employed you as the senior business analyst to perform some financial calculations for him. Below are specific instructions on how to prepare a report for Joy.

  • A2: Project 1
  • A3: Project 2
  • B1: Time
  • C1:I1: 1 2 3 4 5 6 7
  • C2:I2 → -400 200 600 -900 1000 250 230 (cash flow amounts)
  • C3:I3 → -200 150 150 200 300 100 80 (cash flow amounts)
  • J1: NPV (r=0.2)
  • K1: NPV (r=0.01)
  • Compute appropriate NPV's in J2, J3, K2, K3. Format this in blue.
  • B4: IRR Proj 1 No Guess
  • C4: IRR Proj 2 No Guess
  • In B5 and C5, compute the no-guess IRR's.
  • Add a comment in B5 explaining what this # signifies.
  • Next, Joy wants to check if Project 1 and 2 have more than one IRR. Set up a schedule to check this. Use the spreadsheet area between rows 7-19 to do your work. Use appropriate headings. If more than one IRR, format them in red.
  • A20: Project 3
  • B20:E20 → -20 82 -60 2 (cash flow amounts)
  • C21: Plain IRR
  • Compute the no-guess IRR in D21.
  • Now, Joy wants you to check if Project 3 has a unique IRR. Set up a schedule to check this. Use the spreadsheet area below rows 21 to do your work. Use appropriate headings. If there's a unique IRR, format them in yellow. Else, flag in red.
  • A36: Project 4
  • B36:D36 → 10 -30 35 (cash flow amounts)
  • Finally, Joy wants you to check if Project 4 has an IRR at all. Set up a schedule to check this. Use the spreadsheet area below rows 36 to do your work. Use appropriate headings. If there's an IRR, format them in blue. Else, flag the results in red.

 

Posted Date: 2/23/2013 2:28:14 AM | Location : United States







Related Discussions:- Compute appropriate net present value, Assignment Help, Ask Question on Compute appropriate net present value, Get Answer, Expert's Help, Compute appropriate net present value Discussions

Write discussion on Compute appropriate net present value
Your posts are moderated
Related Questions
A bond that has $1000 face value and a contract interest rate of 11.4%. The bonds have a current value of $1124 and will mature in 10 years. The firms marginal tax rate is 34%. The

if you won the publisher''s clearing house $10 million prize (payable as 30 pmts of $250,000 and $2.5m in yr. 30) and could invest the money at 8%, would you accept an offer of $3.

$1,000 of insurance had not been used up by January 31. $325 of insurance had been used up in January

Comparison between Debt Finance and Ordinary Share Capital Differences between Debt Finance and Ordinary Share Capital as Equity Finance as   Ordina

What you meant by monetary function in financial system? A significant function of a financial system is the monetary function. The introduction about money in the economy enab

Evaluate the probability of 10 or more customers arriving within 2 hours if on average 7 customers arrive within one hour. Customers arrive independently.

Objectives of Business Entity The Main objectives of a business entity are clarified in detail below. Any business firm would have specific objectives that it aims at achievin

mony is differnt from wealth and income

Risk Adjusted Discounting Rate - Methods of Computing Cost of Capital This method is used to establish the discounting rate to be used for a provided project. The cost of capi

Accounting Rate of Return Method or ARR This method utilizes accounting profits from financial status to assess the viability of investment proposal via diving the average inc