Undo17PasteYear(1Clipboard01234BCalibriOption A,Product AB V-4000008.71%AProblem 1 of 3Assume a company is going to make an investment of $400,000 in a machine and the followingare the cash flows that two different products would bring in years one through four. For eachof the two options calculate the payback, IRR, and NPV. Assume that you require a 10% rateof return on all investments. To complete the NPV calculation you will need to add the initialinvestment in year zero (hint: Excel expects investments/outflows of cash as negative numbersand inflows of cash as positive numbers). Record your responses in the grey cells below(show your work in calculations).210,000190,00050,00010,000CFontOption B,Product B-400000160,000170,00070,000100,000DEAlignmentFGPercentageHNumb

Payback period is the total period in which a company can recover its total cost or expenses which…

Answered: are the cash flows that two different…

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

Jiminez Company has two investment opportunities. Both investments cost $5,000 and will provide the following net cash flows: Year 1 2 3 4 What is the total present value of Investment A's cash flows assuming an 10% minimum rate of return? Use Appendix Table 2. (Do not round your intermediate calculations. Round your answer to the nearest whole dollar.) Multiple Choice O O Investment A $3,000 3,000 3,000 3,000 O O $4,510. $3,452. $3,000. Investment B $3,000 4,000 2,000 1,000 $10,628.
d. Determine the minimum annual net cash flow necessary to generate a positive net present value, assuming a desired rate of return of 12%. Round to the nearest dollar.Annual Net Cash Flow fill in the blank 1 of 1$
Calculate the interest rate that gives a present value of 0 to the following cash flow diagram. Please show your work. Answer is 15.4%
uring the initial cash outflow? For payback period calp pack period for project A? i Data Table nd to one decimal place.) (Click on the following icon in order to copy its contents into a spreadsheet) Cash Flor B. $15,000 S7,500 S7.500 S7,500 S7.500 S7,500 S7.500 $90,000 $36,000 $27,000 $18,000 $9,000 SO Cost Cash flow year 1 Cash flow year 2 Cash flow year 3 Cash flow year 4 Cash flow year 5 Cash flow year 6 $0 Print Done
Cannonier, In., has identified an investment project with the following cash flows: Year Cash Flow 1 $1,050 2 1,280 3 1,500 4 2,240 If the discount rate is 7 percent, what is the future value of these cash flows in Year 4?
An investment has an installed cost of $787,350. The cash flows over the four-year life of the investment are projected to be $312,615, $304,172, $245,367, and $229,431. a. If the discount rate is zero, what is the NPV? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) b. If the discount rate is infinite, what is the NPV? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations
Which of the following comes closest to the net present value (NPV) of a project whose initial investment is $5 and which produces two cash flows: the first at the end of year 2 of $3 and the second at the end of year 4 of $7? The required rate of return is 13%? Select one: a. $1.84 b. $0 c. $1.64 d. $2.05 e. $2.26
Assume a project has cash flows of -$54,300, $18,200, $37,300, and $14,300 for Years 0 to 3, respectively. What is the profitability index given a required return of 12.6 percent? 1.02 .95 .98 1.06 ☐ 1.00
A project has the following cash flows : Year Cash Flows 0 −$ 12,100 1 5,350 2 7,720 3 5,120 4 −1,560 Assuming the appropriate interest rate is 7 percent, what is the MIRR for this project using the discounting approach?
Please help me with this question (picture below) 1. Calculate the payback period, accounting rate of return, net present value of each project. Based on your calculations, discuss whether the projects should go ahead. Assume that the target value for payback is 3 years for project A and 2 years for project B.2. List advantages and disadvantages of payback period, accounting rate of return, net present value of each project.
There is a project with the following cash flows : Year Cash Flow 0 −$ 29,300 1 8,600 2 8,500 3 7,900 4 6,700 What is the payback period?
ternal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $1,900,000. Given the discount rate and the future cash flow of each project in what are the IRRS and MIRRS of the three projects for Quark Industries? Vhat is the IRR for project M? %3D Data Table % (Round to two decimal places.) (Click on the following icon in order to copy its contents into a spreadsheet.) Projoct O $1,000,000 S800,000 $600,000 $400,000 $200 000 15% Project M $500,000 $500.000 Cash Flow Project N Year 1 $600,000 $600.000 S600.000 S600.000 $600.000 11% Year 2 Year 3 $500.000 $500,000 S500,000 Year 4 Year 5 Discount rate 7%

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

are the cash flows that two different products would bring in years one through four. For each of the two options calculate the payback, IRR, and NPV. Assume that you require a 10% rate