In: Finance
Lucy purchased two trucks for her warehouse for a total of $53,000. This investment saved her $15,000 every year for 11 years. At the end of year 11, she sells both the trucks for a total of $12,000.
a. What is the Net Present Value (NPV) of the investment if the required rate of return is 7%?
Round to the nearest cent
b. Does the investment meet the required rate of return?
Yes
No
Part A:
NPV :
NPV = PV of Cash Inflows - PV of Cash Outflows
If NPV > 0 , Project can be accepted
NPV = 0 , Indifference point. Project can be accepted/
Rejected.
NPV < 0 , Project will be rejected.
| Year | CF | PVF @7% | Disc CF | 
| 0 | $ -53,000.00 | 1.0000 | $ -53,000.00 | 
| 1 | $ 15,000.00 | 0.9346 | $ 14,018.69 | 
| 2 | $ 15,000.00 | 0.8734 | $ 13,101.58 | 
| 3 | $ 15,000.00 | 0.8163 | $ 12,244.47 | 
| 4 | $ 15,000.00 | 0.7629 | $ 11,443.43 | 
| 5 | $ 15,000.00 | 0.7130 | $ 10,694.79 | 
| 6 | $ 15,000.00 | 0.6663 | $ 9,995.13 | 
| 7 | $ 15,000.00 | 0.6227 | $ 9,341.25 | 
| 8 | $ 15,000.00 | 0.5820 | $ 8,730.14 | 
| 9 | $ 15,000.00 | 0.5439 | $ 8,159.01 | 
| 10 | $ 15,000.00 | 0.5083 | $ 7,625.24 | 
| 11 | $ 15,000.00 | 0.4751 | $ 7,126.39 | 
| 11 | $ 12,000.00 | 0.4751 | $ 5,701.11 | 
| NPV | $ 65,181.23 | 
Part B:
As NPV >0, Return from Investment is greater than Required Ret.
OPtion A - Yes is correct
Pls do rate, if the answer is correct and comment, if any further assistance is required.