Question

. The following is a list of four projects that Capital Corporation must choose from for...

. The following is a list of four projects that Capital Corporation must choose from for the coming year: Project Project Price Annual Net Inflows A 700,000 118,861 B 670,000 109,039 C 184,000 32,549 D 273,000 48,305

(a) Given a uniform rate of interest of 9% and a uniform life of the projects of 10 years each, calculate the NPVs of each Project (To calculate NPV, calculate the Present Value of a 10 year annuity, and subtract the project price. You can use Excel to do this calculation - it is the easiest process. Open excel, go to formula button (fx), select category financial, select PV or present value, Rate is the rate of interest (9% or .09) NPER is the number of years (10) and Pmt is negative of the yearly Net Inflows (Its negative because excel assumes that Pmt means you are making payments, whereas in this problem you are receiving net revenues). Once you input that for each project excel will give you the Present Values for each project. Once you get the present values or PV subtract from each the Project Price to get the NPV.

(b) Should we choose Projects A, C, D or Projects A, B, D. Explain

Homework Answers

Know the answer?
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
Similar Questions
Note: Please answer the second question (b) Should we choose Projects A, C, D or Projects...
Note: Please answer the second question (b) Should we choose Projects A, C, D or Projects A, B, D. Explain The following is a list of four projects that Capital Corporation must choose from for the coming year: Project Project Price Annual Net Inflows A                   700,000                      118,861 B                   670,000                      109,039 C                 184,000                       32,549 D                  273,000                      48,305 Given a uniform rate of interest of 9% and a uniform life of the projects of 10 years each, calculate the NPVs of each...
Annual cash inflows that will arise from two competing investment projects are given below:      Year...
Annual cash inflows that will arise from two competing investment projects are given below:      Year Investment A Investment B 1 $ 4,000       $7,000       2 5,000       6,000       3 6,000      5,000       4 7,000       4,000       Total $22,000       $22,000       The discount rate is 12%. Required: Compute the present value of the cash inflows for each investment. Each investment opportunity will require the same initial investment. (Use Microsoft Excel to calculate present values. Do not round intermediate calculations.) Investment A: Item RATE...
A company is considering the purchase of a piece of equipment that would cost $400,000 and...
A company is considering the purchase of a piece of equipment that would cost $400,000 and would last for 9 years. At the end of 9 years, the equipment would have a salvage value of $93,000. The equipment would provide annual cost savings of $73,000. The company requires a minimum pretax return of 17% on all investment projects. (Ignore income taxes.) Required: Provide your Excel input and the final net present value amount you calculated. (If a variable is not...
The attached printout of an Excel spreadsheet shows the use of six financial formulas related to...
The attached printout of an Excel spreadsheet shows the use of six financial formulas related to the time-value-of-money concepts discussed in Chapter 5. Your task is to reproduce the spreadsheet using Excel financial formulas in the red cells, which have the names shown in blue in the adjacent cells. You can find the financial formulas in Excel by clicking on Formulas at the top of the spreadsheet, and then clicking on Financial. You will submit your spreadsheet through D2L, and...
William Industries is attempting to choose the better of two mutually exclusive projects for expanding the...
William Industries is attempting to choose the better of two mutually exclusive projects for expanding the firm’s production capacity. The relevant cash flows for the projects are shown in the following table. The firm’s cost of capital is 15%. PROJECT B PROJECT C YEAR Cash Flow Cash Flow 0 350000 50000 1 45000 24000 2 65000 22000 3 65000 19500 4 440000 14600 a) Calculate the period back of each project, assess its acceptability, and indicate which project is best,...
Evaluate the following projects, using the Net Present Value (NPV). Assume a cost of capital of...
Evaluate the following projects, using the Net Present Value (NPV). Assume a cost of capital of 6%.    Project A    Project B Initial Cash Outflow $200,000 $160,000 Year 1 Cash flow 69,000 80,000 Year 2 Cash flow 71,000 80,000 Year 3 Cash flow 85,000 50,000 Calculate the NPV for each project. Which project would you accept according to the NPV?
Capital Budgeting BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows...
Capital Budgeting BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows:                                                                                                                               Expected Net Cash Flows                                                                                                Time     Project A          Project B                                                                                    0          ($405)                ($705)                                                                            1          ($285)              $200                                                                              2          ($205)              $205                                                                              3          ($105)              $210                                                                              4          $605                 $215                                                                              5          $650                 $220                                                                              6          $925                 $225                                                                              7          ($200)              $230                                                                  In your report, identify which project would be selected (assuming they are mutually exclusive) for each investment criterion. Note that cash outflows (costs) are given in parenthesis. Employ the Excel file to answer the following questions Part 1: Net Present Value Use the Excel NPV function...
The company that just hired you is trying to choose between two innovation projects using net...
The company that just hired you is trying to choose between two innovation projects using net present value. The two projects have the following cash flows: Project 1: year 1 - $1,500; Year 2 - $2,000; Year 3 - $5,000; Year 4 - $3,000; Project 2: year 1 - $5,000; Year 2 - $3,000; Year 3 - $1,500; Year 4 - $2,000; Interest rate: 10% Assignment a: Calculate the NPVs for each project Assignment b: Which of these projects should...
The Bosa Corporation is trying to choose between the following two mutually exclusive design projects: Year...
The Bosa Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (I) Cash Flow (II) 0 –$66,000 –$ 17,800 1 29,000 9,600 2 29,000 9,600 3 29,000 9,600 a-1 If the required return for both projects is 10 percent, what is the profitability index for both projects? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) Profitability Index Project I Project II b-1 What is the NPV...
Suppose you can choose between the following projects. Calculate Net Present Value for each and make...
Suppose you can choose between the following projects. Calculate Net Present Value for each and make a decision concerning which is best. Assume the relevant interest rate is 5%. I. A die cast machine that costs $1,000.00 and provides an income stream of $200.00 per year for six years. II. A plastic molding machine that costs $1,000.00 and provides an income stream of $250.00 per year for five years. Better project is: Its NPV is: B) Suppose you are offered...