Please help me. Thankyou. Perit Industries has $100,000 to invest. The company is trying to decide between twoalternative uses of the funds. The alternatives are:Cost of equipment requiredWorking capital investmentrequiredAnnual cash inflowsSalvage value of equipment in sixyearsLife of the projectProject A Project B$100,000$0Project AProjectThe working capital needed for project B will be released at the end of six years forinvestment elsewhere. Perit Industries' discount rate is 14%. (Ignore income taxes.)$0$21,000$8,000$06 years 6 years$100,000$15,750Required:(a)Using Excel, calculate net present value for each project. (Negative amount shouldbe indicated by a minus sign. Round your answer to the nearest dollar amount.Omit the "$" sign in your response.)(Click to select)Project BProject ANet present value$$(b)Which investment alternative (if either) would you recommend that the companyaccept?

>Please refer to the below spreadsheet for calculation and answer. Cell reference was also…

Answered: Perit Industries has $100,000 to…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter12: Capital Investment Analysis

Section: Chapter Questions

Problem 5PA

See similar textbooks

Similar questions

Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year’s capital budget. The projects are independent. The cash outlay for the truck is $17,100, and that for the pulley system is $22,430. The firm’s cost of capital is 14%. After-tax cash flows, including depreciation, are as follows: Calculate the IRR, the NPV, and the MIRR for each project, and indicate the correct accept/reject decision for each.
Clearcast Communications Inc. is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated operating income, and net cash flow for each proposal are as follows: The companys capital rationing policy requires a maximum cash payback period of three years. In addition, a minimum average rate of return of 12% is required on all projects. If the preceding standards are met, the net present value method and present value indexes are used to rank the remaining proposals. Instructions 1. Compute the cash payback period for each of the four proposals. 2. Giving effect to straight-line depreciation on the investments and assuming no estimated residual value, compute the average rate of return for each of the four proposals. Round to one decimal place. 3. Using the following format, summarize the results of your computations in parts (1) and (2). By placing the computed amounts in the first two columns on the left and by placing a check mark in the appropriate column to the right, indicate which proposals should be accepted for further analysis and which should be rejected. 4. For the proposals accepted for further analysis in part (3), compute the net present value. Use a rate of 12% and the present value table appearing in Exhibit 2 of this chapter. 5. Compute the present value index for each of the proposals in part (4). Round to two decimal places. 6. Rank the proposals from most attractive to least attractive, based on the present values of net cash flows computed in part (4). 7. Rank the proposals from most attractive to least attractive, based on the present value indexes computed in part (5). 8. Based on the analyses, comment on the relative attractiveness of the proposals ranked in parts (6) and (7).
Staten Corporation is considering two mutually exclusive projects. Both require an initial outlay of 150,000 and will operate for five years. The cash flows associated with these projects are as follows: Statens required rate of return is 10%. Using the net present value method and the present value table provided in Appendix A, which of the following actions would you recommend to Staten? a. Accept Project X and reject Project Y. b. Accept Project Y and reject Project X. c. Accept Projects X and Y. d. Reject Projects X and Y.
The management of Ryland International Is considering Investing in a new facility and the following cash flows are expected to result from the investment: A. What Is the payback period of this uneven cash flow? B. Does your answer change if year 6s cash inflow changes to $920,000?
Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the following cash flows over the next five years: $99,000, $88,000, $92,000. $87,000, and $72,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel. see Appendix C.
Jasmine Manufacturing is considering a project that will require an initial investment of $52,000 and is expected to generate future cash flows of $10,000 for years 1 through 3, $8,000 for years 4 and 5, and $2,000 for years 6 through 10. What is the payback period for this project?
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects’ NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 12%. Which project would be selected, assuming they are mutually exclusive, using each ranking method? Which should actually be selected?
Manzer Enterprises is considering two independent investments: A new automated materials handling system that costs 900,000 and will produce net cash inflows of 300,000 at the end of each year for the next four years. A computer-aided manufacturing system that costs 775,000 and will produce labor savings of 400,000 and 500,000 at the end of the first year and second year, respectively. Manzer has a cost of capital of 8 percent. Required: 1. Calculate the IRR for the first investment and determine if it is acceptable or not. 2. Calculate the IRR of the second investment and comment on its acceptability. Use 12 percent as the first guess. 3. What if the cash flows for the first investment are 250,000 instead of 300,000?
Perit Industries has $110,000 to invest. The company is trying to decide between two alternative uses of the funds. The alternatives are: Cost of equipment required Working capital investment required Annual cash inflows i Salvage value of equipment in six years Life of the project Project A $ 110,000 $0 $ 20,000 $ 8,600 1. Net present value project A 2. Net present value project B 3. Which investment alternative (if either) would you recommend that the company accept? 6 years Project B $0 $ 110,000 $ 68,000 $0 6 years The working capital needed for project B will be released at the end of six years for investment elsewhere. Perit Industries' discount rate is 16%. Click here to view Exhibit 148-1 and Exhibit 148-2, to determine the appropriate discount factor(s) using tables. Required: 1. Compute the net present value of Project A. (Enter negative values with a minus sign. Round your final answer to the nearest whole dollar amount.) 2. Compute the net present value of Project B. (Enter…
Perit Industries has $155.000 to invest. The company is trying to decide between two alternative uses of the funds. The altematives are: Project A Project B $155,000 Cost of equipment required Working capital investment required Annual cash inflows Salvage value of equipment in six years Life of the project $ 20,000 $ 9,400 6 years $155, 000 $ 55,000 24 6 years The working capital needed for project B will be released at the end of six years for investment elsewhere. Perit Industries' discount rate is 14%. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor(s) using tables. Requlred: 1. Compute the net present value of Project A. (Enter negative value with a minus sign. Round your final answer to the nearest whole dollar amount.) 2 Compute the net present value of Project B. (Enter negative value with a minus sign. Round your final answer to the nearest whole dollar amount.) 3. Which investment alternative (if either) would you recommend…
Perrot Industries has $325,000 to Invest. The company is trying to decide between two alternative uses of the funds. The alternatives follow: Cost of equipment required Working capital investment required Annual cash inflows Salvage value of equipment in six years Life of the project Project A Project B Project Net Present Value A $270,000 67,650 21, 200 6 years O Project A Project B B The working capital needed for project B will be released at the end of six years for Investment elsewhere. Perrot Industries discount rate is 14%. Click here to view Exhibit 10-1 and Exhibit 10-2, to determine the appropriate discount factor(s) using tables. $ 270,000 54,400 Required: 1-a. Calculate net present value for each project. (Round discount factor(s) to 3 decimal places. Round other Intermediate calculations and final answer to the nearest whole number.) 6 years 1-b. Which investment alternative (if elther) would you recommend that the company accept?
Perit Industries has $155,000 to invest. The company is trying to decide between two alternative uses of the funds. The alternatives are: Cost of equipment required Working capital investment required Annual cash inflows Salvage value of equipment in six years Life of the project $ 155,000 Project A $ 0 Project B $ 0 $ 155,000 $ 25,000 $ 8,600 $ 40,000 6 years $ 0 6 years The working capital needed for project B will be released at the end of six years for investment elsewhere. Perit Industries' discount rate is 14%. Click here to view Exhibit 12B-1 and Exhibit 12B-2. to determine the appropriate discount factor(s) using tables. Required: 1. Compute the net present value of Project A. (Enter negative values with a minus sign. Round your final answer to the nearest whole dollar amount.) 2 Compute the net present value of Project B. (Enter negative values with a minus sign. Round your final answer to the nearest whole dollar amount.) 3. Which investment alternative (if either) would you…

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

SEE MORE TEXTBOOKS