Question 1 3 pts Consider the following cash flows: End of Month 1 2 3 4...

Question

Question

Question 1 3 pts Consider the following cash flows: End of Month 1 2 3 4 5 6 Cash Flow $700 $800 $600 $900 $200 $2,200 If the

Answer 1

Answer #1

Discount Rate = 0.09/12 = 0.0075

D50 B A 43 Month 44 45 fac =SUM(D44:049) с D pv@0.75% Present value 0.9926 $ 694.79 0.9852 $ 788.13 0.9778 $ 586.70 0.9706 $

D50 fc =SUM(D44:D49) A B с D 43 Month Cash flows 700 44 1 800 45 2 46 3 pv@0.75% =1/1.0075 =C44/1.0075 =C45/1.0075 =C46/1.007

Answer 2

Similar Homework Help Questions

QUESTION : The appropriate discount rate for the following cash flows is 10 percent compounded quarterly....

QUESTION : The appropriate discount rate for the following cash flows is 10 percent compounded quarterly. Year Cash Flow 1 $700 2 800 3 0 4 1,200 What is the present value of the cash flows?
The appropriate discount rate for the following cash flows is 9 percent compounded quarterly. Year Cash...

The appropriate discount rate for the following cash flows is 9 percent compounded quarterly. Year Cash Flow 1 $1,000 2 600 3 0 4 1,200 What is the present value of the cash flows?
Remaining Time: 1 hour, 08 minutes, 27 seconds. Question Completion Status: 1 2 3 4 5...

Remaining Time: 1 hour, 08 minutes, 27 seconds. Question Completion Status: 1 2 3 4 5 6 7 8 9 10 11 12 Question 4 For a company that uses a year as its interest period, determine the net cash flow that will be recorded at the end of the year from the cash flows she Receipts, $1000 Month 500 800 200 Disbursements, $1000 300 500 400 400 500 600 120 600 Jan Feb Mar Apr May June July Aug...

The appropriate discount rate for the following cash flows is 6 percent compounded quarterly. Year Cash...

The appropriate discount rate for the following cash flows is 6 percent compounded quarterly. Year Cash Flow 1 $600 2 600 3 0 4 1,300 What is the present value of the cash flows? Multiple Choice $967.94 $2,122.18 $2,079.74 $2,129.76 $2,164.62
The appropriate discount rate for the following cash flows is 9 percent compounded quarterly. Year Cash...

The appropriate discount rate for the following cash flows is 9 percent compounded quarterly. Year Cash Flow 1 $1,000 2 600 3 0 4 1,200 What is the present value of the cash flows? Multiple Choice $2,257.48 $2,272.55 $639.03 $2,212.34 $2,302.63
The appropriate discount rate for the following cash flows is 6 percent compounded quarterly. Year Cash...

The appropriate discount rate for the following cash flows is 6 percent compounded quarterly. Year Cash Flow 1 $800 2 500 3 0 4 1,400 What is the present value of the cash flows? Multiple Choice $2,254.63 $2,308.65 $2,346.65 $1,079.36 $2,300.64

16) You are offered an investment that will pay the following cash flows at the end...

16) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the Net Present Value (NPV) if the required rate of return is 12% per year? Period Cash Flow 0 $0 1 $100 2 $200 3 $300 4 $400 5 $500 Remember that Excel’s NPV function doesn't really calculate the net present value. Instead, it simply calculates the present value of...
The appropriate discount rate for the following cash flows is 14 percent compounded quarterly Year Cash...

The appropriate discount rate for the following cash flows is 14 percent compounded quarterly Year Cash Flow 2 3 4 $800 500 0 1,100 Required: What is the present value of the cash flows?
Question 4 3 pts At a discount rate of 3.47% compounded monthly, the present value of...

Question 4 3 pts At a discount rate of 3.47% compounded monthly, the present value of the cash flow stream below is $10,121.2063. End of Year 1 2. 3 4 Cash Flow $1,216/? $3,110 $2,367 What is the value of the Year 2 cash flow rounded to the nearest dollar? $4,376 O $3,486 $3,506 $4,083

5 pts Question 18 An investment promises the following cash flow stream: $1,000 at Time 0; $2,000 at the end of...

5 pts Question 18 An investment promises the following cash flow stream: $1,000 at Time 0; $2,000 at the end of Year 1 (or att = 1); $3,000 at the end of Year 2:; and $5,000 at the end of Year 3. At a discount rate of 6.5 %, what is the present value of the cash flow stream? Your answer should be between 8343.00 and 11,000.00, rounded to 2 decimal places, with no special characters Question 19 5 pts...