Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the formula to get the NET PRESENT VALUE? Thank you I need excel function please 108 112 106 107 Year Cash flow A
What is the formula to get the NET PRESENT VALUE? Thank you
I need excel function please
108 112 106 107 Year Cash flow A 1090 $-307,108 110 1 $ 50,000 111 2 $ 50,000 3 $ 50,000 113 4 $ 50,000 114 5 $ 50,000 1156 $ 50,000 116 7 $ 50,000 117 8 $ 50,000 118 9 $ 50,000 119 10 $ 50,000 120 11 $ 50,000 121 121 $ 50,000 122 13 $ 50,000 123 14 $ 50,000 124 15 $ 50,000 PV of cash flows PVIF@14% PVIF@10% PVIF @14% PVIF@10% | | Ax 1.000 1.000 $ -307,108 $ -307,108 0.877 0.909 $ 43,860 $ 45,455 0.769 0.826 $ 38,473 $ 41,322 0.675 0.751 $ 33,749 $ 37,566 0.592 0.683 $ 29,604 $ 34,151 0.519 0.621 $ 25,968 $ 31,046 0.456 0.564 $ 22,779 $ 28,224 0.400 0.513 $ 19,982 $ 25,658 0.351 0.467 $ 17,528 $ 23,325 0.308 0.424 $ 15,375 $ 21,205 0.270 0.386 $ 13,487 $ 19,277 0.237 0.350 $ 11,831 $ 17,525 0.208 0.319 $ 10,378 $ 15,932 0.182 0.290 $ 9,103 $ 14,483 0.160 0.263 $ 7,985 $ 13,167 0.140 0.239 $ 7,005 $ 11,970 125 126 Net present value $ 73,196
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started