Question

In: Finance

You have a $10 million capital budget and must make the decision about which investments your...

You have a $10 million capital budget and must make the decision about which investments your firm should accept for the coming year. The firm’s cost of capital is 12 percent. Use the information on the four projects to determine what project(s) your firm should accept on the basis of NPV?

Project 1 Project 2 Project 3 Project 4
Initial CF -4,000,000 -5,000,000 -10,000,000 5,000,000
Year 1 CF

1,000,000

2,000,000 4,000,000 2,700,000
Year 2 CF 2,000,000 3,000,000 6,000,000 2,700,000
Year 3 CF 3,000,000 3,000,000 5,000,000 2,700,000

A) Projects 3, 4

B) Projects 1, 2

C) Project 3

D) Projects 2, 4

Please cross reference https://www.chegg.com/homework-help/questions-and-answers/10-million-capital-budget-must-make-decision-investments-firm-accept-coming-year-firm-s-co-q58576072 and https://www.chegg.com/homework-help/questions-and-answers/project-1-project-2-project-3-project-4-initial-cf-4-000-000-5-000-000-10-000-000-5-000-00-q58583555 before you finalize your answer

Solutions

Expert Solution

Correct Answer is option D

NPV = Pv value of inflow - outflow
Pv of inflow is calculated in excel
=Pv(rate,nper,pmt,fv)

Discount rate 12%
Project 1 Project 2 Project 3 Project 4
Year Cashflow Pv of cashhflow Cashflow Pv of cashhflow Cashflow Pv of cashhflow Cashflow Pv of cashhflow
0 -4000000 -4000000 -5000000 -5000000 -10000000 -10000000 -5000000      -50,00,000.00
1 1000000 892857.1429 2000000 1785714.286 4000000 3571428.571 2700000 2410714.29
2 2000000 1594387.755 3000000 2391581.633 6000000 4783163.265 2700000 2152423.47
3 3000000 2135340.743 3000000 2135340.743 5000000 3558901.239 2700000 1921806.67
NPV 622585.6414 NPV 1312636.662 NPV 1913493.076 NPV 1484944.24
NPV of Project
Project 1
          6,22,585.64
Project 2        13,12,636.66
Project 3        19,13,493.08
Project 4 1484944.424
Highest NPV(Under 10million) Project 4 + Project 2
       27,97,581.09
Project 4 + Project 1   
       21,07,530.07
Project 3        19,13,493.08
Project 2 + Project 1        19,35,222.30

I hope this clear your doubt.

Feel free to comment if you still have any query or need something else. I'll help asap.

Do give a thumbs up if you find this help


Related Solutions

Your startup is currently cash-constrained, and you must make a decision about whether to delay paying...
Your startup is currently cash-constrained, and you must make a decision about whether to delay paying one of its suppliers, or take out a loan. You owe the supplier $11000 with terms of 5/10 Net 40, so the supplier will give you a 5% discount if you pay today (when the discount period expires). Alternatively, you can pay the full $11000 in one month when the invoice is due. You are considering three options: Alternative A: Forgo the discount on...
Topics: Construction Accounting & Finances Capital Investments: 1.) Before you make a decision to acquire a...
Topics: Construction Accounting & Finances Capital Investments: 1.) Before you make a decision to acquire a large piece of equipment what tools would you use to determine if this investment is really worth the cost and how would you finance this large investment? (Please give a one paragraph brief detailed example.) Budgets: 2.) Discuss the importance of budgeting. Then give an example of how you would control your budget as a construction manager. (Please give a one paragraph brief detailed...
   1.   You have been asked to make a short presentation at your company’s annual capital budget...
   1.   You have been asked to make a short presentation at your company’s annual capital budget meeting to present an analysis of the strengths and weaknesses of the following capital budgeting selection methodologies:  NPV, payback, IRR.  Describe how you would respond to this request at the meeting. 2.  The senior executives were impressed with your presentation on capital budgeting methodologies. They have asked you to present a follow-up discussion regarding the company’s weighted average cost of capital (WACC).  Specifically, they want to know how...
As a corporate manager, you have been given an investment budget of $24 million. You must...
As a corporate manager, you have been given an investment budget of $24 million. You must choose from among the following three independent projects: Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 A -$12 $10 $10 $14 B -$12 $8 $8 $8 $8 $2 C -$12 $6 $6 $6 $6 $6 (All dollar amounts are in millions.) The appropriate hurdle rate for all three projects is 12% per year. Given your investment budget of $24...
As the owner of a restaurant, you must make decisions about the location of your restaurant...
As the owner of a restaurant, you must make decisions about the location of your restaurant and the equipment and furniture needed to operate your restaurant. Would you prefer to buy or lease your building? Also, discuss whether you would prefer to buy or lease your equipment and furniture. What benefit do you see in your choices?
As the owner of a restaurant, you must make decisions about the location of your restaurant...
As the owner of a restaurant, you must make decisions about the location of your restaurant and the equipment and furniture needed to operate your restaurant. Would you prefer to buy or lease your building? Also, explain whether you would prefer to buy or lease your equipment and furniture. What benefit do you see in your choices? 200 words or more
As the owner of a restaurant, you must make decisions about the location of your restaurant...
As the owner of a restaurant, you must make decisions about the location of your restaurant and the equipment and furniture needed to operate your restaurant. Would you prefer to buy or lease your building? Also, discuss whether you would prefer to buy or lease your equipment and furniture. What benefit do you see in your choices?
If the goal of your decision making is to make the optimum decision or make the...
If the goal of your decision making is to make the optimum decision or make the best choice, you should utilize the bounded rationality model of decision making. the intuitive decision-making model. the creative decision-making model. the rational decision making model.
You have $1 million to invest, and you must invest all your money. The following are...
You have $1 million to invest, and you must invest all your money. The following are assets you can invest: Expected Return Beta Risk-free asset 6% Not given Stock X 30% 1.8 Stock Y 20% 1.3 (a) Suppose you want to create a portfolio that has an expected return of 12% by investing in the risk-free asset and Stock X. Calculate how much money you will invest in Stock X. (b) Suppose you want to create a portfolio with a...
A firm has a capital budget of $100 which must be spent on one of two...
A firm has a capital budget of $100 which must be spent on one of two projects, which any unspent balance being placed in a bank deposit earning 15%. Project A involves a present outlay of $100 yields $321.76 after 5 years. Project B involves a present outlay of $40 yields $92 after one year. Calculate: i. the IRR of each project ii. the B/C ratio of each project, using a 15% discount rate What are the project rankings on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT