Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 12.49BE
To determine
The IRR of the project M for company F.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
You are contemplating to invest in your classmate’s business, use IRR to evaluate the project whether to accept or reject. Use the following info: Cost of Capital: 10%; Initial Investment: ₱20,000; Cash Flows over the past 5 years: Years 1 & 2: ₱5,000; Years 3 & 4: ₱1,000; Year 5: ₱1,250. Use Excel Method in finding the IRR
For each requirement, change the values of the given information as shown and keep all other original data the same. Then enter your updated final answers for each scenario.
Scenario A:
Future value to be received
$
10,000
Future date received
3
years
Discount Rate
6%
10%
16%
Scenario B:
Annual Cash Receipt
$
5,000
Number of Years
6
years
Discount Rate
6%
10%
16%
Scenario C:
Discount Rate 8%
Investment Project
Cash Flow
Initial Investment
$
(6,500)
Year 1
$
700
Year 2
$
800
Year 3
$
1,400
Year 4
$
3,600
Year 5
$
6,800
Required:
a. A company is expecting to receive a lump sum of money at a future date from now. Using the PV formula in Excel, what is the Present Value of that money at three different rates? (Round your answers to 2 decimal places.)
Lynch Pin in Learning is considering investing $411,000 in equipment to expand their operation. They anticipate this investment will save them $68,500 per year for each of the 8 years of its useful life.What will be the payback for this investment?
Amount Invested
/
Expected annual net cash inflow
=
Payback (Years)
/
=
Chapter 12 Solutions
Managerial Accounting (5th Edition)
Ch. 12 - Prob. 1QCCh. 12 - (Learning Objective 2) After identifying potential...Ch. 12 - Prob. 3QCCh. 12 - Prob. 4QCCh. 12 - Prob. 5QCCh. 12 - Prob. 6QCCh. 12 - Prob. 7QCCh. 12 - Prob. 8QCCh. 12 - Prob. 9QCCh. 12 - (Learning Objective 5) Which of the following...
Ch. 12 - Order the capital budgeting process (Learning...Ch. 12 - Prob. 12.2SECh. 12 - Prob. 12.3SECh. 12 - Prob. 12.4SECh. 12 - Prob. 12.5SECh. 12 - Prob. 12.6SECh. 12 - Prob. 12.7SECh. 12 - Prob. 12.8SECh. 12 - Prob. 12.9SECh. 12 - Prob. 12.10SECh. 12 - Prob. 12.11SECh. 12 - Prob. 12.12SECh. 12 - Prob. 12.13SECh. 12 - Prob. 12.14SECh. 12 - Prob. 12.15SECh. 12 - Identify ethical standards violated (Learning...Ch. 12 - Prob. 12.17AECh. 12 - Compute payback period and analyze changes...Ch. 12 - Prob. 12.19AECh. 12 - Prob. 12.20AECh. 12 - Prob. 12.21AECh. 12 - Prob. 12.22AECh. 12 - Calculate the payback and NPV for a sustainable...Ch. 12 - Prob. 12.24AECh. 12 - Prob. 12.25AECh. 12 - Prob. 12.26AECh. 12 - Prob. 12.27AECh. 12 - Prob. 12.28AECh. 12 - Prob. 12.29AECh. 12 - Prob. 12.30AECh. 12 - Prob. 12.31AECh. 12 - Prob. 12.32AECh. 12 - Prob. 12.33AECh. 12 - Prob. 12.34AECh. 12 - Prob. 12.35AECh. 12 - Prob. 12.36BECh. 12 - Prob. 12.37BECh. 12 - Prob. 12.38BECh. 12 - Prob. 12.39BECh. 12 - Prob. 12.40BECh. 12 - Prob. 12.41BECh. 12 - Prob. 12.42BECh. 12 - Prob. 12.43BECh. 12 - Prob. 12.44BECh. 12 - Prob. 12.45BECh. 12 - Prob. 12.46BECh. 12 - Prob. 12.47BECh. 12 - Prob. 12.48BECh. 12 - Prob. 12.49BECh. 12 - Prob. 12.50BECh. 12 - Prob. 12.51BECh. 12 - Prob. 12.52BECh. 12 - Prob. 12.53BECh. 12 - Prob. 12.54BECh. 12 - Prob. 12.55APCh. 12 - Prob. 12.56APCh. 12 - Prob. 12.57APCh. 12 - Prob. 12.58APCh. 12 - Prob. 12.59BPCh. 12 - Prob. 12.60BPCh. 12 - Evaluate an investment using all four methods...Ch. 12 - Prob. 12.62BPCh. 12 - Prob. 12.63SCCh. 12 - Discussion Questions 1. Describe the capital...Ch. 12 - Prob. 12.65ACTCh. 12 - Prob. 12.66ACTCh. 12 - Prob. 12.67ACT
Knowledge Booster
Similar questions
- You are a financial analyst for the Brittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments: Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects' expected net cash flows are shown in the table below. Use the Homework Student Workbook to calculate each project's net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), and profitability index (PI). NPVx = NPVy = IRRx = IRRy = TVx = TVy = MIRRx = MIRRy = PVx = PVy = PIx = PIy = 2. Which project or projects should be accepted if they are independent? 3.Which project or projects should be accepted if they are mutually exclusive?arrow_forwardProblem. Assume the following cash flow for 2 projects. Assuming that the cash flows are occurring at the end of the year. Find the payback period for both these projects. Year Project 1 Project 2 -1000 600 400 -1000 100 400 1 2 and for the exclusive use of SLU. Reproduction, storing in a retrieval system, distributing, uploading or posting online, or transmitting in any form or by tronic, mechanical, photocopying, recording, or otherwise of any part of this document, without the prior written permission of SLU, is stricty prohibitec 3 200 200 600 4 600 5 100 700 Solution:arrow_forwardYou are asked to evaluate the following two projects for the Norton corporation. Use a discount rate of 13 percent. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. Project X (Videotapesof the Weather Report)($28,000 Investment) Project Y (Slow-MotionReplays of Commercials)($48,000 Investment) Year Cash Flow Year Cash Flow 1 $ 14,000 1 $ 24,000 2 12,000 2 17,000 3 13,000 3 18,000 4 12,600 4 20,000 a. Calculate the profitability index for project X. (Do not round intermediate calculations and round your answer to 2 decimal places.) b. Calculate the profitability index for project Y. (Do not round intermediate calculations and round your answer to 2 decimal places.) c. Which project would you select based on the profitability index? multiple choice Project X Project Yarrow_forward
- Help please, 2. Perform a financial analysis for a project using the format provided in Figure 4-5 in your textbook (attached business_case_financials template). Assume that the project costs and benefits for this project are spread over four years as follows: Estimated costs are $200,000 in Year 1 and $30,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $100,000 each year in Years 2, 3, and 4. Use a 9 percent discount rate, and round the discount factors to two decimal places. Using the attached business case financials template, calculate and clearly display the NPV, ROI, and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this project, based on your financial analysis.Business case financial spreadsheet for Task 2 and paragraphexplaining your recommendations for investing or not in the project.arrow_forwardYou are a project manager for your company and you are faced with five potential projects that you can invest in. Free cash flow projections and additional relevant data are given for each project in the table below. Assume that there are no cash flows after year 3. Assume that you can only take each project once and that you can only choose one project. Which project would you invest in? Select the best answer. Project Project A Project B Project C Project D Project E O I. Project A II. Project B III. Project C IV. Project D O V. Project E FCF Forecasts by Year (in $1,000) 0 2 1 500 (400) (400) (300) (250) (300) 75 60 75 135 115 175 3 650 210 190 200 Interest Rate (EAR) 8.0% 10.0% 10.0% 12.0% 12.0% IRR 25.00% 17.57% 15.92% 17.81% 19.96%arrow_forwardYou work for an outdoor play structure manufacturing company and are trying to decide between the following two projects: (Click on the following icon in order to copy its contents into a spreadsheet.) Year-End Cash Flows ($ thousands) 1 19 39 Project Playhouse Fort You can undertake only one project. If your cost of capital is 8%, use the incremental IRR rule to make the correct decision. 0 - 27 - 78 2 20 50 IRR 28.2% 8.9% The incremental IRR is %. (Round to two decimal places.) With the incremental IRR at - 1.23% and the cost of capital of 8%, you should undertake the ▼ (Select from the drop-down menu.)arrow_forward
- he capital investment committee of Iguana Inc. is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows: Year Robotic AssemblerOperating Income Robotic AssemblerNet Cash Flow WarehouseOperating Income WarehouseNet Cash Flow 1 $50,400 $157,000 $106,000 $251,000 2 50,400 157,000 81,000 212,000 3 50,400 157,000 40,000 149,000 4 50,400 157,000 18,000 102,000 5 50,400 157,000 7,000 71,000 Total $252,000 $785,000 $252,000 $785,000 Each project requires an investment of $480,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 10% for purposes of the net present value analysis. Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 7 0.665 0.513 0.452 0.376 0.279 8…arrow_forwardAn IT company receives two new project proposals. Project A will cost $250,000 to develop and is expected to have an annual net cash flow of $50,000. Project B will cost $350,000 to develop and is expected to have an annual net cash flow of $60,000. Analyzing the two projects from a cashflow perspective using the payback period, which project is better? Why? Write the answers in the “Payback" tab of the attached EXCEL template. You may use the Payback Period template if you wish to. Note: Enter the discounted costs and benefits for your project below. Add and delete rows as needed. Year Costs Benefits Cumulative Costs Cumulative Benefits 1 2 3 4arrow_forwardAn IT company receives two new project proposals. Project A will cost $250,000 to develop and is expected to have an annual net cash flow of $50,000. Project B will cost $350,000 to develop and is expected to have an annual net cash flow of $60,000. Analyzing the two projects from a cashflow perspective using the payback period, which project is better? Why? Write the answers in the “Payback" tab of the attached EXCEL template. You may use the Payback Period template if you wish to. Note: Enter your criteria, weights, and scores in the template below Insert or clear rows and columns as needed. Double check formulas and results. Criteria Project 1 Project 2 Project 3 Project 4 Project 5 Sponsor Support Strategic Alliance Urgency Fills a market gap Sales Competition Weighted Project Scores 0.00 0 0 0 0 0arrow_forward
- Findell Corporation is considering two projects, A and B, and it has gathered the following estimates for the projects Project A Project B Useful life 5 years 5 years Present value of cash inflows $84,440 $53,300 Present value of cash outflows $79,000 $46,000 What is the present value index for Project A? Multiple Choice 1.069 0.862 1.097 0.886arrow_forwardA project has cash flows of -$35,000, $0, $10,000, and $42,000 for Years 0 to 3, respectively. The required rate of return is percent, you should the project. 15 percent. Based on the internal rate of return of O 24.76; accept O 13.96; accept O 14.92; reject O 15.21; accept A Click Submit to complete this assessment. Question 30 of 30 Save and Submitarrow_forwardBelow are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College