Hello Sir/ Mam
(a)
Time | Cashflows | PVF | PV |
0 | -$10,400.00 | 1 | -$10,400.00 |
1 | $3,100.00 | 0.892857143 | $2,767.86 |
2 | $3,100.00 | 0.797193878 | $2,471.30 |
3 | $3,100.00 | 0.711780248 | $2,206.52 |
4 | $3,100.00 | 0.635518078 | $1,970.11 |
5 | $3,100.00 | 0.567426856 | $1,759.02 |
6 | $3,100.00 | 0.506631121 | $1,570.56 |
7 | $3,100.00 | 0.452349215 | $1,402.28 |
8 | $3,100.00 | 0.403883228 | $1,252.04 |
9 | $3,100.00 | 0.360610025 | $1,117.89 |
NPV | $6,117.57 |
(b)
Time | Cashflows | PVF | PV |
0 | -$10,400.00 | 1 | -$10,400.00 |
1 | $3,100.00 | 0.78125 | $2,421.88 |
2 | $3,100.00 | 0.610351563 | $1,892.09 |
3 | $3,100.00 | 0.476837158 | $1,478.20 |
4 | $3,100.00 | 0.37252903 | $1,154.84 |
5 | $3,100.00 | 0.291038305 | $902.22 |
6 | $3,100.00 | 0.227373675 | $704.86 |
7 | $3,100.00 | 0.177635684 | $550.67 |
8 | $3,100.00 | 0.138777878 | $430.21 |
9 | $3,100.00 | 0.108420217 | $336.10 |
NPV | -$528.94 |
(c)
Time | Cashflows |
0 | -$10,400.00 |
1 | $3,100.00 |
2 | $3,100.00 |
3 | $3,100.00 |
4 | $3,100.00 |
5 | $3,100.00 |
6 | $3,100.00 |
7 | $3,100.00 |
8 | $3,100.00 |
9 | $3,100.00 |
IRR | 26.11% |
I hope this solves your doubt.
Feel free to comment if you still have any query or need something else. I'll help asap.
Do give a thumbs up if you find this helpful.
in314 Exam II X G Bulk Purchases just purchased X + c ps i Cloud 1314...
? X Calculating NPV and IRR - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW Calibri Paste B IU A Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font A1 д в E F G H I A project that provides annual cash flows of $15,400 for nine years costs $67,000 today. What is the NPV if the required return is 8 percent? What if it's 20 percent? At...
I have the answers I just don't know how to input the answers into a formula in the excel solver so that it can accept my answers. Thank you. EXCEL 4 - CHAPTER 8 X C T Have The Answers I Just Don X + → C newconnect.mheducation.com/flow/connect.html EXCEL 4 - CHAPTER 8 Saved Help Save & Exit Submit ? X - Sign In FILE HOME Calibri % Calculating NPV and IRR - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW...
CHAPTER 8 GRADED HOMEWORK Saved For the given cash flows, suppose the firm uses the NPV decision rule. 10 points Cash Flow -$ 157,300 74,000 87,000 46,000 ( 8 00:38:53 eBook a. At a required return of 9 percent, what is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. At a required return of 21 percent, what is the NPV of the project? (A negative answser should...