Find the present value of the streams of cash flowsshown in the following table. Assume thatthe firm's opportunity cost is 12%.ABCYearCash FlowYearCash FlowYearCash Flow1-$2,0001$ 10,0001-5$ 10,000/yr2345523,0002-55,000/yr6-108,000/yr4,00067,0006,0008,000

Calculate the present value of the streams of cash flows using Excel as follows:Formula…

Answered: Find the present value of the streams…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Find teh present value of the streams of cash flows shown in the following table. Assume that the firms opportunity cost is 14% A: Year Cash Flow 1 -$2100 2 2900 3 4000 4 5900 5 8200 B: Year Cash Flow 1 $9000 2-5 $5000/yr 6 $7200 C: Year Cash Flow 1-5 $12000/yr 6-10 $8000/yr The presevent vaule of stream A, B, and C
Calculate the HPR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Period Cashflow 0 -14100 1 3300 2 3300 3 3100 4 2800
For the cash flows shown, determine: (a) the number of possible i* values (b) the i* value displayed by the IRR function (c) the external rate of return using the MIRR method if ii = 18% per year and ib = 10% per year. Year 0 1 2 3 4 Revenues, $ 0 25,000 19,000 4000 18,000 Costs, $ −6000 −30,000 −7000 −6000 −12,000
Find the NPV for the following cash flows assuming a WACC of 10%. YR CF 0 -15,000 1 6,000 2 4,000 3 2,000 4 3,000 5 2,000
What is the yield on the following set of cashflows? Time Cashflow (£) t = 0 t=1 H 400 t=2 t = 3 -100 -120 t = 4 -140 t = 5 -160
26. (ts) For the following set of cash flows, calculate the NPV, IRR, MIRR, Profitability Index and Payback Period. Assume the WACC is 8%. NPV: IRR: MIRR: Profitability Index Payback Period: Year Cash Flow 0 $ (580,000.00) 1 $ 120,000.00 2 $ 132,000.00 3 $ 139,920.00 4 $ 151,190.00 5 $ 145,150.00 6 $ 148,250.00 Is this project acceptable? Why or why not? I
A project is being analyzed with the following set of cash flows. Calculate the internal rate of return (IRR). (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Cash Year Flow 0 16,000 123 6,700 8,000 6,500 IRR %
Value of mixed streams Find the present value of the streams of cash flows shown in the following table, Assume that the firm's opportunity cost is 14%. a. The present value of stream A is $ b. The present value of stream B is $ (Round to the nearest dollar.) c. The present value of stream C is $ (Round to the nearest dollar.) (Round to the nearest dollar.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) A B C Year 1 Cash Flow -$2,000 Year Cash Flow Year Cash Flow 1 $10,000 1-5 $12,000/yr 2 $3,000 2-5 $5,200/yr 6-10 $7,900/yr 3 $3,900 6 $7,200 4 $6,100 5 $8,000 Print Done
Find the present value of the stream of cash flows shown in the follwing tables. Assume that the firms opportunity cost is 15% A: Year Cash Flow 1 -$2000 2 $3000 3 $3900 4 $6100 5 $8100 B: Year Cash Flow 1 $11000 2-5 $5000/yr 6 $7000 C: Year Cash Flow 1-5 $12000/yr 6-10 $8100/yr
2. For the cash flow diagram below, solve for the Future Value, using the "FV" function in Excel, i = 8.5%. (Column titles: Year, Years Until Year 16, Amount, FV.) 10,000 0 T 2 34 11,500 17,000 MILLI 5 6 7 8 9 10 11 12 13 14 15 16 15,000 F = ?? 7,000
Q#03: Suppose you have cash flows as follows: End of Year Cash Flows ($) 1 8000 7000 3 6000 4 5000 Calculate present equivalent at i= 15% per year using gradient conversion factor.
Consider the following cash flow year cash flow -1000 TL 2 +300 TL 3 +300 TL 4 +300 TL +300 TL Calculate the rate of return for an investment of 1000 TL

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

Find the present value of the streams of cash flows shown in the following table. Assume that the firm's opportunity cost is 12%. A B C Year Cash Flow Year Cash Flow Year Cash Flow 1 -$2,000 1 $ 10,000 1-5 $ 10,000/yr 2345 5 2 3,000 2-5 5,000/yr 6-10 8,000/yr 4,000 6 7,000 6,000 8,000