PLEASE ONLY SHOW HOW TO DID IN EXCEL AND ONLY HARD CODED FORMULAS
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:-
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...?
PLEASE ONLY SHOW HOW TO DID IN EXCEL AND ONLY HARD CODED FORMULAS D 1 Year...
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 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- 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) 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 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 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 (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 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 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 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?...