Transcribed Image Text
In: AccountingConsider the following alternative projects in the table below.Each project would last for five years....Consider the following alternative projects in the table below.Each project would last for five years.1) Findthe NPV for each project at a 10% discount rate.2) Findthe profitability index for each project at a 10% discountrate.3) What discount rate would make the NPV=0 (i.e. breakeven in time)for each project?Use excel to populate the table below. Show all cell references,show all formulas used, and show all calculationsclearly.Project AProject B Initial investment$80,000$60,000 Annual net cash inflows20,00016,000$5,000 in maintenanceYear 2Year 3 Salvage value10,0008,000
Other questions asked by students
Biology
Calculus
Accounting
Accounting
Accounting