Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me with my homework Previous 10. (M3) What is the internal rate of return for this stream of cash flows for a $32,000

image text in transcribedimage text in transcribed

please help me with my homework

image text in transcribedimage text in transcribed
Previous 10. (M3) What is the internal rate of return for this stream of cash flows for a $32,000 investment (-$32,000) and cash inflows of $9,000 per year for Years 14? Use the Excel IRRO function for your calculation. a. 3.25 percent b. 4.88 percent c. 7.18 percent CI. 2.39 percent 1 1. L0 9-3) What is the net present value for this stream of cash flows for a $32,000 investment (-32.000) and cash inflows of $9,000 per year for Years 14, assuming a 3 percent cost of capital? Use the Excel IRR() function for your calculation. a. -$1,312.66 b. $1,411.54 c. $1,312.66 d. $1,411.54 12. L0 9-3) What would be the Excel formula to compute the internal rate of return for this stream of cash flows for a $32,000 investment and cash inflows of $10,000 per year for Years 14? a. =|RR(32000,-1000O,-1000O,-1000O,-1000O) b. =|RR(-1000O,-1000O,-1000O,-1000O,32000) C. =|RR(10000,10000,1000O,1000O,-32000) d. =|RR(-32000,1000OJOOOOJOOOOJOOOO) 13. L0 9-3) What would be the Excel formula to compute the net present value for this stream of cash flows for an initial $50,000 investment and cash inflows of $18,000 per year for Years 14 with a 10 percent cost of capital? at. =NPV 0.1,-5000O,18000,18000,18000,18000) b. =NPV(O.1,+50000,-18000,-18000,-18000,-18000) V(O.1 ,18000,18000,18000,18000,-50000) V(-50000,18000,18000,18000,18000) c NP cl. NP

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

Step: 3

blur-text-image

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 Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

9th edition

1-119-49356-3, 1119493633, 1119493560, 978-1119493631

More Books

Students also viewed these Accounting questions