Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134067254
Author: Braun
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 12.47BE
To determine
The IRR of project A and B.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
This fourth, and final, project for the semester will involve the following items to turn in:
1) A statement of cash flows from information I will provide you.
You can turn in the information in excel, best choice, word or hand written and scanned. All files need to be uploaded to this assignment.
Please set the following capital budgeting problem up in excel. Upload your answer. Include formulas where appropriate.
You are responsible to make a recommendation to the college regarding the upcoming capital projects. Be sure to evaluate each project using payback, NPV, IRR and PI capital budgeting techniques. We do not have enough money to do both projects, please evaluate both and make your recommendation. Both projects will require an original cash investment of $1,500,000. We are considering a renovation to the classrooms (project A) and a renovation to the library (Project B). The classroom update will provide revenue of $700,000 and the library $900,000 year one. For the classroom update, cash inflow will be $300,000 years 1 & 2, $400,000 years 3 & 4 and $100,000 each year 5 and beyond. The library will have cash inflow of $500,000 years 1, 2, &3 and 100,000 each additional year after that. The college has a payback policy of 5 years and our cost…
Working with your assigned group, please determine your answer to the questions below. We will discuss your group's responses during the live session this week.
Consider the following two mutually exclusive projects:
Year
Cash Flow ($) - A
Cash Flow ($) - B
0
-4,55,000
-65,000
1
58,000
31,000
2
85,000
28,000
3
85,000
25,500
4
5,72,000
19,000
Whichever project you choose, if any, you require a return of 11% on your investment.
If you apply the payback criterion, which investment will you choose?
If you apply the discounted payback criterion, which investment will you choose?
If you apply the NPV criterion, which investment will you choose?
If you apply the IRR criterion, which investment will you choose?
If you apply the profitability index criterion, which investment will you choose?
Based on your answers, which project will you finally choose?
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
- MGMT2023 - Financial Management 1-UWI Open Campus Stephanie Carter has been gifted a sum of $50,000 by her grandparents on completing her graduation successfully. She is a fresh finance graduate and is excited to invest some money in the capital market, for which she intends to use the gifted sum of $50,000. However, instead of committing this money to the market immediately, she decides to wait for some time, work in the field and acquire some experience before proceeding with her intended investment. She thus contemplates an extremely conservative investment in a portfolio of stocks and bonds, at the start of year 5 from now. For now, she will leave the $50,000 in a fixed deposit with the bank which promises an interest rate of 6% per annum. She will require a return of at least 9% on her stock investments and 4% on bond investments. Stephanie would have to pay 25% taxes on any interest income. Dividends will be tax-free. Stephanie's research has allowed her to narrow down on the…arrow_forwardThis homework submission should include all calculations for part (a), completed on the designated tab of the Homework Student Workbook, and a document explaining the implications of your findings for the business or business transaction. After reading this week’s resources, respond to the following: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. Expected Net Cash Flows Year Project X Project Y 0 – $10,000 – $10,000 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500 Use the 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). Which project or projects should…arrow_forwardhe 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_forward
- What are the benefits of capital budgeting tools to educational institutions? How does they use capital budgeting tools? Provide examples and explain. Minimum 200 wordsarrow_forward**Please solve using Excel and show formulas.** Consider the following projects: Project Cash Flows A -4 5 2.3 0 0 1,000 B -5,600 2,800 2,800 5,800 2,800 2,800 C -7,000 2,800 2,500 0 2,800 2,800 Question: What is the payback period for Project C? Multiple Choice 3.4 3.9 3.2 3.6 3.8arrow_forwardAnswer the following question with a clear explanation, showing any steps or processes used to reach the answer. Explain your process as though you are teaching the concept to a student who is a beginner at finance.A corporation makes an investment of $20,000 that will provide the following cash flows after the corresponding amounts of time:Year 1 - $10,000Year 2 - $10,000Year 3 - $2,000Should the company make this investment?* What is the net present value at a 7 percent discount rate? Round your answer to two decimal points. Provide a step-by-step explanation for how you arrived at your solution as though you were teaching a student to solve this type of problem.*arrow_forward
- Please help me solve this question using Excel. To Find What the project's net cash flow is for Year 0, 1, 2 and 3 and the project's NPV.arrow_forwardTask 2A business has two projects to invest in, as follows:Create a new spread sheet, calculate NPV for the following projects at discount rates of 3% and 7%, respectively, by creating a dynamic process. Project 1 Project 2Year Cash inflows Cash outflows Cash inflows Cash outflows0 0.00 70,000.00 0.00 70,000.001 24,000.00 13,000.00 25,000.00 15,000.002 22,000.00 1,000.00 25,000.00 03 25,000.00 0 20,000.00 04 25,000.00 0 43,000.00 21,000.005 17,500.00 7,500.00 20,000.00 5,000.00 P1: NPV P2: NPVThen, a) by using a built-in/Excel function, calculate the NPV for each project with discount rates of 3% and 7%, respectively;b) By comparing the NPVs at the rate of…arrow_forwardFinancial Manager of Timmy Company is considering two projects (project A and project H), which have cash flows as follows: Year Cash Flow of Project A (in $) Cash Flow of Project H (in $) 0 -100 -100 1 10 70 2 60 50 3 80 20 Timmy Company’s cost of capital is 10 percent. Calculate payback, NPV, IRR, and MIRR for both projects. (Please have a step by step format to your answer with explainations. Thanks (=)arrow_forward
- Can someone help me figure out this problem? Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your…arrow_forwardYou 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 IRRarrow_forwardYou 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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage