Asked Oct 9, 2019

A project requires an initial investment of $40 million. It generates cash flows of $25 million in one year and $27 million in two years. The projects required rate of return is 8% what is the project's profitability index?


Expert Answer

Step 1

Calculation of Profitability Index:

The profitability index is 1.16.

Excel Spreadsheet:


Image Transcriptionclose

в C D Year Cash Flows FVIF@ 8%| PV of Cash Flows 1 $25,000,000 2 $27,000,000 Total PV of Cash Flows 1.08 2 $23,148,148.15 1.1664 $23,148,148.15 $46,296,296.30 $40,000,000 3 4 Initial Investment 5 Profitability Index 6 1.16


Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in



Capital Budgeting

Related Finance Q&A

Find answers to questions asked by student like you
Show more Q&A

Q: Find the interest rates earned on each of the following. Round your answers to the nearest whole num...

A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and s...


Q: Northeastern costs approximately $50,000 per year for a four-year program, whether completed in four...

A: Cost of per year for four-year program (pmt) = $50,000Interest rate (rate) = 10%Number of Years (npe...


Q: What is the future value of $7,200 deposited at the beginning of each year for 7 years earning 8% in...

A: Calculation of Future Value:The future value is $69,383.72.Excel Spreadsheet:


Q: Susan Jones has a job as a pharmacist earning $45,000 per year, and she is deciding whether to take ...

A: Part 1:As per the given conditions, the expenses are expected to grow at 3%. The fourth year revenue...


Q: Bank A pays 6% simple interest annually on its investment accounts. If Bank B pays interest on its a...

A: Bank A: Simple Interest Rate (r) = 6% or 0.06 (Annually)Time Period (t) = 10 years Assumption:Princi...


Q: What is the difference between life insurance and annuity?

A: Meaning:Life insurance is a cover on financial loss, and it is a contract between insurer and a poli...


Q: Discuss what the liquidity ratios reveal about Starbucks financial health, including any description...

A: As per the given information, the current ratio and quick ratio of the firm SB increased in 2018 com...


Q: Problem 2-1 Balance Sheet (LG2-1) You are evaluating the balance sheet for Goodman's Bees Corporati...

A: Calculation of Current Assets:


Q: New-Project Analysis Madison Manufacturing is considering a new machine that costs $350,000 and woul...

A: As per the guidelines, we can answer the first question as it has multiple sub-parts. Request you to...