What is the excel formula to solve the below:

Given the following cash flows, what is the project's payback period? Answer is 2.4

Year 0: -100 Year 1: 40

Year 2: 40

Year 3: 50

Year 4: 50

What is the discounted payback for the following project?

WACC 0.13

Year Cash Flow

1. -200
2. 100
3. 150
4. 80

Answer is 1.95 years

What is the NPV of the following project? The project is considered lower-than-average risk.

Year	Project A
0	-1000
1	700
2	600
3	600

WACC brackets:

Higher-than-average risk: 9%

Average risk: 6%

Lower than average risk: 3%

Answer 794.25

Answer rating: 100% (QA)

Here are the Excel formulas to solve the problems you provided Project 1 Payback ... View the full answer