Homework Help Question & Answers

PLEASE ONLY SHOW HOW TO DID IN EXCEL AND ONLY HARD CODED FORMULAS D 1 Year...

D 1 Year 2 Cash flow -750,000 500,000 500,000 3 500,000 4 500,000 500,000 -2,000,000 5% 10% 45% 4 Cost of capital,r 5 NPV 6 A
project assuming the reinvestment or financing rate is also the disco rate (10%)? 11. (Multiple IRRs) You would like to open

PLEASE ONLY SHOW HOW TO DID IN EXCEL AND ONLY HARD CODED FORMULAS

D 1 Year 2 Cash flow -750,000 500,000 500,000 3 500,000 4 500,000 500,000 -2,000,000 5% 10% 45% 4 Cost of capital,r 5 NPV 6 Accept/reject? 3 Part d: to decide on a range of cost of capital to accept/reject, make a table of NPV for different r NPV AFAMAA 10 Cost of capital, 0% 2% 4% 6% 8% 10% 12% 14% 16% 18% 20% 22% 24% 26% 30% 34% 38% 42% 46% 50% 54%
project assuming the "reinvestment or financing rate is also the disco rate (10%)? 11. (Multiple IRRs) You would like to open an investment company named Rip’em. The cost of building up the company is $750,000. You offer your clients the following deal: For five annual deposits of $500,000 for the next 5 years, you will pay them $2 million at year 6. Your cash flow is expected to be as follows: Τ Α Ι Β Ι CI DI EI FI G Ι Η 2 A 5 6 1 Year 2 Cash flow |-750.000 500,000500,000500,000 500,000 1500.000-2.000.000 a. If your cost of capital is 5%, should you make the investment? b. If your cost of capital is 10%, should you make the investment? c. If your cost of capital is 45%, should you make the investment? d. For what range of cost of capital should you accept the project? Explain. c inactment
0 0
Add a comment
Answer #1

For your spreadsheet formulas are as follows

NPV for a to c =NPV(B4,$C$2:$H$2)+$B$2

NPV for d =NPV(A11,$C$2:$H$2)+$B$2

Still I have solved whole as follows:-

3 Year cash flow 01 -750000 1 500000 500000 500000 500000 500000 61 -2000000 5% Cost of capital (r) NPV 10% $16,445.52 45% ($

Formulas used

NPV for a to c =NPV(K9,$M$5:$R$5)+$L$5

NPV for d =NPV(K14,$M$5:$R$5)+$L$5

(a) project is not acceptable at 5% cost of capital

(b) project is acceptable at 10% co of capital

(c) project is not acceptable at 45% cost of capital

(d)10%-38% cost of capital is acceptable

I hope my efforts will be fruitful to you...?

Add a comment
Know the answer?
Add Answer to:
PLEASE ONLY SHOW HOW TO DID IN EXCEL AND ONLY HARD CODED FORMULAS D 1 Year...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coin

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
  • ONLY SHOW HOW TO DO IN EXCEL. please no hard coded formulas A. If the appropriate...

    ONLY SHOW HOW TO DO IN EXCEL. please no hard coded formulas A. If the appropriate discount rate is 12%, rank the two projects. B. Which project is preferred if you rank by IRR? C. Calculate the crossover rate, namely, the discount rate r at which the NPVs of both projects are equal. D. Should you use NPV or IRR to choose between the projects? Give a brief description. 1 Section a. 2 Discount rate 12% 3 4 Year 5...

  • Important: Show your solutions! QUESTION 1: Consider the following two projects: Year Cash Flow (A) Cash...

    Important: Show your solutions! QUESTION 1: Consider the following two projects: Year Cash Flow (A) Cash Flow (B) -$364,000 -$52,000 25,000 46,000 68,000 22,000 68,000 21,500 458,000 17,500 Whichever project you choose, if any, you require a return of 11 percent on your investment. 1) Suppose these two projects are independent. Which project(s) should you accept based on: a. The Payback rule? Explain. (1096) b. The Profitability Index rule? Explain. (10%) c. The IRR rule? Explain. (10%) d. The NPV...

  • 1. Investment consideration of $2,225,000 Cash flows Year 1-   300,000 Year 2-   475,000 Year 3-&nb...

    1. Investment consideration of $2,225,000 Cash flows Year 1-   300,000 Year 2-   475,000 Year 3-   500,000 Year 4-   500,000   WACC  10% when evaluation proposed capital budgeting projects. Determine the Projects PI based on these cash flow A     .6834 B     .7456 C      .6213 D     .5902   2. The company’s decision to accept or reject this project is independent of its decision on other projects.  Based on the projects PI should theiform accept or reject this project? 3. By comparison, the...

  • 1. undersatnd how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b)...

    1. undersatnd how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR (c) Develop problem-solving and critical thinking skills and make long-term investment decisions 1) Life Period of the Equipment = 4 years 2) New equipment cost $(200,000) 3) Equipment ship & install cost $(35,000) 4) Related start up cost $(5,000) 5) Inventory increase $25,000 6) Accounts Payable increase $5,000 7) Equip. salvage value before tax $15,000 8) Sales...

  • Suppose Pheasant Pharmaceuticals is evaluating a proposed capital budgeting project (project Beta) that will require an...

    Suppose Pheasant Pharmaceuticals is evaluating a proposed capital budgeting project (project Beta) that will require an initial investment of $2,225,000. The project is expected to generate the following net cash flows: Year Year 1 Year 2 Year 3 Year 4 Cash Flow $325,000 $450,000 $500,000 $500,000 Pheasant Pharmaceuticals's weighted average cost of capital is 9%, and project Beta has the same risk as the firm's average project. Based on the cash flows, what is project Beta's NPV? $1,417,225 O -$807,775...

  • Problems with IRR White Rock Services Inc. has an opportunity to make an investment with the...

    Problems with IRR White Rock Services Inc. has an opportunity to make an investment with the following projected cash flows. Year         Cash Flow 0              $1,680,000 1              -3,885,000 2              2,225,021 a. Calculate the NPV at the following discount rates and plot an NPV profile for this​ investment: 0​%, 5​%, 7.5​%, 10​%, 15%​, 20​%, 22.5​%, 25​%, 30​%. b. What does the NPV profile tell you about this​ investment's IRR? c. If the company follows the IRR decision rule and their cost of...

  • 1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value...

    1. Net present value (NPV) Evaluating cash flows with the NPV method The net present value (NPV) rule is considered one of the most common and preferred criteria that generally lead to good investment decisions. Consider this case: Suppose Cute Camel Woodcraft Company is evaluating a proposed capital budgeting project (project Alpha) that will require an initial investment of $600,000. The project is expected to generate the following net cash flows: Cash Flow Year Year 1 $300,000 $500,000 $425,000 $475,000...

  • EXCEL ONLY, PLEASE SHOW FORMULA WORK A company is considering three capital budgeting projects. Data relative...

    EXCEL ONLY, PLEASE SHOW FORMULA WORK A company is considering three capital budgeting projects. Data relative to each is given below. Each project has a life of 5 years. The company uses the NPV method to evaluate capital budgeting projects and its discount rate is 9%. Project A Project B Project C Initial cash outlay (cost) -$5,000,000 -$6,000,000 -$3,000,000 Cash inflows per year $1,500,000 $1,800,000 $ 600,000 Residual value $ 500,000 0 $100,000 1. If the projects are mutually exclusive,...

  • Please show the steps to the last question. The question is: What is the net present...

    Please show the steps to the last question. The question is: What is the net present value of the project if inventories must be increased at the start of the project (year 0) by $450,000 and will be recovered at the end (year 10), given that the NPV of the project ignoring changes in net working capital is $1,107,972.98?   Thank you :) A company will sell Gizmos to consumers at a price of $112 per unit. The variable cost to...

  • Suppose Blue Hamster Manufacturing Inc. is evaluating a proposed capital budgeting project (project Beta) that will...

    Suppose Blue Hamster Manufacturing Inc. is evaluating a proposed capital budgeting project (project Beta) that will require an initial investment of $2,500,000. The project is expected to generate the following net cash flows: Cash Flow Year Year 1 $325,000 $500,000 Year 2 $475,000 Year 3 $500,000 4 Blue Hamster Manufacturing Inc.'s weighted average cost of capital is 10%, and project Beta has the same risk as the firm's average project. Based on the cash flows, what is project Beta's NPV?...

Free Homework 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.