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

Compute NPV using excel. Discount rate - 10%
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
Determine the PW (Present Worth) at 7% and at 8% of the given cash-flow diagram. Use MS Excel
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

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