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
What are the types of financial assets? Types of Financial Assets: a. Loans b. Bank Deposits c. Stocks A share of ownership within a company d. Bonds A promis

Benefits of Payback Period 1. use simply and understand and it has created it popular among in ascertaining the viability of venture executives, mainly traditional financial m

Imagine Joy is the manager of a bank named Money Talks Bank of Virginia . This bank has recently issued new loans to customers. Joy wants you, the business analyst to prepare a re

Berick Ltd is a relatively small engineering company that manages to compete effectively with larger companies by adapting to changing market requirements and specialising in innov

Ask lajgkjasbgksabgbaskjbaskjbasjgbhjabgjbjgbskjgbkasbgjkabksgbksbgkabkhvakkvbaoygfyabkbkkye#Minimum 100 words accepted#

As the Chief Financial Officer for the wholly Australian owned, Australian Stock Exchange listed company, Toy Show Ltd., an importer and manufacturer of a range of quality children

Say that a buyer of bonds values good bonds at $500 and values bad bonds at $250. Sellers of both good and bad bonds value them at $350. If the fraction of good sellers and bad s

#The following is the existing capital structure of Company XYZ Ltd. Ordinary shares at Shs.10 par 1,000,000 Retained 800,000 12% preference shares Shs.10 par 400,000 16% loan Shs.

In mergers, acquisitions, or other relationships between hospitals and physician groups, what are the benefits to each party from entering into an arrangement with the other? What

Determinants of Required Rate of Return 1.Risk free rate - This is the interest rate such would exist on default free securities like Treasury bills and bonds. Risk free