Question: can someone answer this question with formulas, but not with excel. thumbs up will be given. Assume that the required yearly return of both projects

can someone answer this question with formulas, but not with excel. thumbs up will be given.

Assume that the required yearly return of both projects are 5%. a) Calculate the payback period of the two projects. Given the target payback period is 3 years, which project should the company choose? Explain your answer. (4 marks) b) Calculate the discount payback period of the two projects. Given the target payback period is 4 years, which project should the company choose? Explain your answer. (6 marks) c) Calculate the NPV of the two projects. Which project should the company choose? Explain your answer. (6 marks) d) Based on your answers in parts (a) (c), which project should the company choose? Explain, (3 marks) e) Instead of choosing one out of the two projects, Silicon Co. has just realized that they can implement projects A and B simultaneously if they install a new machine. The installation cost is $200,000. Explain whether Silicon Co. should install this new machine. (Hint: Justify your answer base on the NPV of the two projects.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Consider the following two-stage entry-pricing game between an incumbent firm and a potential entrant: 2 players: {incumbent, entrant} Two-stage game: Stage-1: Potential entrant makes its entry...

Can someone answer these question using formulas in excel? Thank you Solution Chapter: Problem: 7/16/2015 9 18 INPUTS USED IN THE MODEL P0 Net Ppf Dpf D0 g B-T rd Skye's beta Market risk premium, RPM...

Hello, having some issues with this weeks homework. Would appreciate it if you show me how its done. In the instructions it asks for these questions to be done in Excel using formulas. Thank you in...

Alaska Oil Corporation Capital Budgeting Directed David Fay, Alaska Oil's financial vice president, is preparing a report for the monthly directors' meeting. An important issue is on the agenda, a...

Please answer this question with extreme detail for an immediate thumbs up. I don't get credit unless it is detailed please help. Thank you for your time in advance. REQUIRED TEXT POSTED WITH...

Question 2 (23 marks) Silicon Co. is a start-up company. It is now considering going ahead with one of the following projects next month. The details about the two mutually exclusive projects are as...

Question 2 (23 marks) S ilicon Co. is a start-up company. It is now considering going ahead with one of the following projects next month. The details about the two projects are as follows: Project A...

can you please give excel formulas and explain them? i have no idea what to do. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 51,000 units per...

Using excell sheets and Data for group (31) , please solve the followibg project 3. They should study "Appendix A' and the following book examples on how to use spreadsheets to solve specific...

please explain your answer using formula Silicon Co. is a start-up company. It is now considering going ahead with one of the following projects next month. The details about the two mutually...

1 . Five years ago, you bought a $ 7 0 , 0 0 0 house by putting 1 0 % down and financing the rest at a rate of 8 . 5 % for 3 0 years. What is your monthly payment? How much interest did you pay on...

Methane (CH 4 ) gas flows into a combustion chamber at a rate of 200. L/ min at 1.50 atm and ambient temperature. Air is added to the chamber at 1.00 atm and the same temperature, and the gases are...

Calculate the average kinetic and potential energies of a 25 electron in a hydrogenic atom of atomic number Z.

Assuming the adjusted trial balance has total debits equal to total credits, does this mean that the adjusting entries have been recorded correctly? Explain.

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

3-11 In this exercise, you will use software at car Web sites to find product information about a car of your choice and use that information to make an important purchase decision. You will also...

3-12 In MyMISLab, you will find a Collaboration and Teamwork Project dealing with the concepts in this chapter. You will be able to use Google Drive, Google Docs, Google Sites, Google+, or other...

3-8 Marks & Spencer Group is a leading department store chain in the United Kingdom. Its retail stores sell a range of merchandise. Senior management has decided that Marks & Spencer should tailor...