Question

Question 1 1 pts Calculate the NPV of the following project cash flows using a discount rate of 6%. Yro = -900.00 Yr1 = -80.0

0 0
Add a comment Improve this question Transcribed image text
Answer #1

F1143 fx =SUM(F1137:F1142) Pv@6% 1134 1135 1136 1137 1138 1139 $ Cashflows (900.00) (80.00) 100.00 300.00 500.00 500.00 PvcfF1143 fr =SUM(F1137:F1142) 1134 1135 1136 Year Cashflows Pv@6% -900 1137 1138 100 300 =E1137/1.06 =E1138/1.06 =E1139/1.06 =E1

Add a comment
Know the answer?
Add Answer to:
Question 1 1 pts Calculate the NPV of the following project cash flows using a discount...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Your company wants to invest $250,000 in a new machine. Cash flows that result are: Yr1: 50,000; Yr2: 121,000; Yr3: 86,0...

    Your company wants to invest $250,000 in a new machine. Cash flows that result are: Yr1: 50,000; Yr2: 121,000; Yr3: 86,000; Yr4: 100,000. Cost of capital is 14%. What is the NPV? Calculate the NPV: Investment amount: ($8,250,000). Cash flows: Yr1: 2,500,000; Yr2: 3,500,000; Yr3: 4,500,000; Yr4: 5,500,000. Cost of capital: 24% For the following, calculate the NPV: Investment amount: ($1,000,000). Cash flows: Yr1: 251,000; Yr2: 289,000; Yr3: 582,000; Yr4: 456,000. Cost of capital: 16%. For the following cash flows,...

  • New Home, Inc. invested in the following bond issued by Old Home, Inc. on January 1,...

    New Home, Inc. invested in the following bond issued by Old Home, Inc. on January 1, Yr1. The company’s amortization schedule appears below: Date Cash Flow Interest Revenue Amortized Discount Bond Discount Book Value of Bond Fair Value 1/1/Yr1 $16,158 ? 6/30/Yr1 ? $11,692 $1,692 $14,466 $235,534 $240,000 12/31/Yr1 ? $11,777 $1,777 $12,689 $237,311 $242,000 6/30/Yr2 ? $11,866 $1,866 $10,824 $239,176 $244,000 12/31/Yr2 ? $11,959 $1,959 $ 8,865 $241,135 $246,000 6/30/Yr3 ? $12,057 $2,057 $ 6,808 $243,192 $248,000 12/31/Yr3 ?...

  • 8. Given the following cash flows, what equation would a financial manager solve to determine the...

    8. Given the following cash flows, what equation would a financial manager solve to determine the IRR? yr0 = -1,050,000 yrl = 220,000 yr2 = 400,000 yr3 = 650,000 yr4 = 180,000 9. If a project has a year 0 cash flow of -9,350, a year 1 cash flow of zero, a year two cash flow of “X”, and no other cash flows, how would you calculate the IRR of this investment in terms of “X”?

  • 1. Calculate the NPV of the following project cash flows which come in at the end...

    1. Calculate the NPV of the following project cash flows which come in at the end of the year: $500 in Year 1, $700 in Year 2, and $1000 in Year 3; using a discount rate of 7%. The firm has a net expense of $1700 at the beginning of the project. (Round to the nearest whole number.) 2. What is the NPV if we use a discount rate of 3% instead? (Round to the nearest whole number.) 3. What...

  • What is the NPV of a project with the following cash flows and a discount rate...

    What is the NPV of a project with the following cash flows and a discount rate of 12% Initial Investment (1,000,000) Cash Flow Year 1 400,000 Year 2 300,000 Year 3 400,000 Year 4 200,000

  • 1. Given the following set of cash flows for a project, calculate the NPV, PI, IRR,...

    1. Given the following set of cash flows for a project, calculate the NPV, PI, IRR, MIRR, Payback, Discounted Payback and Accounting Rate of Return. Assume a cost of capital of 10%. Assuming that this is an independent project, should the project be accepted? Why or why not? (20 pts.) Year                Cash Flow                 Net Profit                   Depreciation 0                    -$125,000 1                    $22,000                     $15,000                      $10,000 2                    $58,000                     $43,000                      $25,000 3                    -$30,000                   $24,000                      $21,000 4                    $35,000                     $28,000                      $18,000 5                    $28,000                     $20,000                      $15,000 6                    $60,000                     ...

  • Question 1 2 pts A project costs $100,000, will be depreciated straight-line to zero over its...

    Question 1 2 pts A project costs $100,000, will be depreciated straight-line to zero over its 4 year life, and will require a networking capital investment of $5.000 up-front. The firm has a tax rate of 35% and a required return of 15%. The project generates an annual operating cash flow (OCF) of $45,000. What is the project's NPV? $-18,633.12 $ 23,474.03 o $ 26,332.79 $ 28,474.03 O $ 45,603.09 Question 2 2 pts Calculate the NPV of the following...

  • Ashley Products Inc. is considering a new project with the following cash flows. The discount rate...

    Ashley Products Inc. is considering a new project with the following cash flows. The discount rate is 10% for the cash flows. Year Cash Flow -$2,000 0 1 2 0 3 3,877 What is the NPV of the project? 1026.33 1058.62 912.85 1041.86 1079.20 Ashley Products Inc. is considering a new project with the following cash flows. The discount rate is 10% for the cash flows. Year Cash Flow -$2,000 0 1 2 0 3 3,877 What is the NPV...

  • (NPV calculation​) Calculate the NPV given the following free cash​ flows, YEAR   CASH FLOWS 0   -50...

    (NPV calculation​) Calculate the NPV given the following free cash​ flows, YEAR   CASH FLOWS 0   -50,000 1   30,000 2   30,000 3   30,000 4   -30,000 5   30,000 6   30,000 if the appropriate required rate of return is 12 percent. Should the project be​ accepted? What is the​ project's NPV​?

  • QUESTION 30 Calculate the NPV of a project having the following annual cash flows:-165/30/40/50/50/50. Use a...

    QUESTION 30 Calculate the NPV of a project having the following annual cash flows:-165/30/40/50/50/50. Use a discount rate of 10.2%.

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT