Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Mathematics

Authors: Cacildo Marques

1st Edition

8741574710, 979-8741574713

More Books

Students also viewed these Finance questions

Question

Respect various limitations when making an argument

Answered: 1 week ago