Question


in314 Exam II X G Bulk Purchases just purchased X + c ps i Cloud 1314 Exam II e zto.mheducation.com/hm.tpx Y Yahoo G Google N
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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.

Add a comment
Know the answer?
Add Answer to:
in314 Exam II X G Bulk Purchases just purchased X + c ps i Cloud 1314...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • ? X Calculating NPV and IRR - Excel FORMULAS DATA REVIEW - Sign In FILE HOME...

    ? 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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT