Question

In: Finance

Investment A: Year: 0 1 2 3 4 5 Cash flow: -$14,000 $6,000 $6,000 $6,000 $6,000...

Investment A:
Year: 0 1 2 3 4 5
Cash flow: -$14,000 $6,000 $6,000 $6,000 $6,000 $6,000

Investment B:
Year: 0 1 2 3 4 5
Cash flow: -$15,000 $7,000 $7,000 $7,000 $7,000 $7,000

Investment C:
Year: 0 1 2 3 4 5
Cash flow: -$18,000 $12,000 $4,000 $4,000 $4,000 $4,000

The cash flows for three projects are shown above. The cost of capital is 7.5%. If an investor decided to take projects with a payback period two years or less, which of these projects would he take?

Select one:

A. Investment A

B. Investment B

C. Investment C

D. none of these investments

Expert Solution

Pay back period is the period in which initial investment is recovered.

Investment A:

Payback Peiord = Iniital Investment / CF per anum

= $ 14,000 / $ 6000

= 2.333

Investment B:

Payback Peiord = Iniital Investment / CF per anum

= $ 15,000 / $ 7000

= 2.13

Investment C:

Year	Opening Balance	Amount	Amount to be recovered
1	$ 18,000.00	$ 12,000.00	$ 6,000.00
2	$ 6,000.00	$ 4,000.00	$ 2,000.00
3	$ 2,000.00	$ 4,000.00	$ -2,000.00
4	$ -2,000.00	$ 4,000.00	$ -6,000.00
5	$ -6,000.00	$ 4,000.00	$ -10,000.00

Payback Peiord = Period in which least +ve BBalance to be recovered + [ Amount to be recovered in that Year / Amount Receovered in Next Year ]

= 2 Years + [ 2000 / 4000 ]

= 2 Years + 0.5 Years

= 2.5 Years

Expected Payback period is 2 Years. However all these investments has Payback period is more than 2 Years.

Thus do not select any Investment.

OPtion D is correct.

jeff jeffy answered 1 year ago

Year Cash flow (€) 0 - Investment -? 1 150,000 2 150,000 3 4 150,000 ?...

Year Cash flow (€) 0 - Investment -? 1 150,000 2 150,000 3 4 150,000 ? Some years ago X AG paid €15’000 for a vacant lot with planning permission. The plot could easily be sold today for 10 times that amount. X AG has however a project in mind that would occupy the plot and require investment of €200,000 but generate positive cash flows of €150,000 for the next 4 years. X AG will be able to sell the...

Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5...

Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B

Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5

Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B

Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000...

Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000 $2,200 $3,300 $2,500 $2,500 $2,300 $2,100 A. Payback The company requires all projects to payback within 3 years. Calculate the payback period. Should it be accepted or rejected? B. Discounted Payback Calculate the discounted payback using a discount rate of 10%. Should it be accepted or rejected? C. IRR Calculate the IRR for this project. Should it be accepted or rejected? D. NPV Calculate...

Year Cash Flow 0 –$ 15,900 1 7,930 2 9,490 3 8,970 4 7,210 5 –...

Year Cash Flow 0 –$ 15,900 1 7,930 2 9,490 3 8,970 4 7,210 5 – 3,580 Required: The company uses an interest rate of 12 percent on all of its projects. Calculate the MIRR of the project using all three methods. (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).) MIRR Discounting approach % Reinvestment approach % Combination approach %

Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What...

Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What is the present (Year 0) value if the opportunity cost (discount) rate is 10 percent? Add an outflow (or cost) of $1,000 at Year 0. What is the present value (or net present value) of the stream?

Case 2 Geo Tech Cash Flow Template (Base Case) Year 0 1 2 3 4 5...

Case 2 Geo Tech Cash Flow Template (Base Case) Year 0 1 2 3 4 5 $600,000.00 $1,080,000.00 $1,050,000.00 $750,000.00 $570,000.00 Revenues Cash Costs Set up $280,000.00 $420,000.00 $280,000.00 $140,000.00 $140,000.00 Other operating $240,000.00 $240,000.00 $360,000.00 $360,000.00 $240,000.00 Depreciation $280,000.00 $280,000.00 $280,000.00 EBIT -$200,000.00 $140,000.00 $130,000.00 $250,000.00 $190,000.00 Taxes -$70,000.00 $49,000.00 $45,500.00 $87,500.00 $66,500.00 Net Operating Income After Taxes -$130,000.00 $91,000.00 $84,500.00 $162,500.00 $123,500.00 Add Depreciation $280,000.00 $280,000.00 $280,000.00 Net Operating Cash Flows $150,000.00 $371,000.00 $364,500.00 $162,500.00 $123,500.00 Recovery of...

Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000...

Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000 $200,000 $200,000 DCF @ 11% ∑DCF @11% DCF @ 13% ∑DCF @13% DCF @ 15% ∑DCF @15% Notes: DCF = Discounted Cash Flow ∑DCF = Cumulative Discounted Cash Flow Refer to the following video on how to calculate IRR with Excel. Provide your completed spreadsheet in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above....

TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash...

TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow A -15000 6000 7000 6000 6000 6000 B -15000 7000 7000 7000 7000 7000 C -18000 12000 2000 2000 2000 2000 "Consider the cash flow of the three projects depicted in Table 4. The cost of capital is 7.5%. If an investor decided to take projects with a payback period of 2 years...

Consider the following investment cash flows: Year Cash Flow 0 ($16,000) 1 3,000 2 4,000 3...

Consider the following investment cash flows: Year Cash Flow 0 ($16,000) 1 3,000 2 4,000 3 5,000 4 6,000 5 7,000 a. What is the return expected on this investment measured in dollar terms if the opportunity cost is 6%. b. What is the return on this investment measured in percentage terms? c. Is the investment profitable? Explain your answer.