finance doc

Click on the quadrant that will yield the best capital budgeting decision. - NPV Hi IRR Low IRR + NPV

QUESTION 5 Invest in any or all of the four projects whose relevant cash flows are given in the following table. The firm has RM7,000,000 budgeted to fund these projects, all of which are known to be acceptable. Initial investment for each project is the same for all projects which is RM1,600,000. The rate of retum for all projects is equivalent to 8%. Operating cash outflow Project X Project Y Year 1 Cash Outflow RM1,600,000 (for each project) RM 440,000 340,000 220,000 (110,000) ( 95,000 ) 105,000 Operating Cash Inflows RM 140,000 180,000 250,000 260,000 370,000 460,000 1 2. 3. 4. 5. 6. 7. 220,000 388,000 8. 9. Use this table for PROJECT X and Y Period PVIF 8% 0.9259 0.8573 3 0.7938 4 0.7350 0.6806 0.6302 7 0.5835 8 0.5403 0.5002 10 0.4632

questions to be answered

You have been assigned to perform a project selection based on profitability index. You have collected data on the three project alternatives A1, A2, and A3 and your team has calculated the following (table) present worth equivalent for the benefits, costs, and investments at a social discount rate of 10%. The service life of each alternative is identical. (a) Find the PI(i) for each project alternative (b) Find the best alternative based on incremental PI(i) analysis (c) Why is the profitability index referred to as a measure of capital efficiency?

Instructions: Your hospital is considering the purchase of a CT scanner. You, as the administrator for the Imaging Department, have been asked to conduct a financial analysis on the proposed purchase. Given the information and assumptions below, use Microsoft Excel to conduct a net present value analysis of a capital equipment request. When complete, think of some areas of the analysis where you might be able to make changes to improve the performance of the project. What are your thoughts on how you can positively influence this project? The information below is provided for your use in conducting the analysis on the CT Scanner. All prices and expenses are current as of year 0. Any planned growth will occur in year 1. CT Scanner Initial Purchase price Delivery, installation, and training Annual maintenance contract Estimated annual volume Supply cost per scan¹ Technician salary and benefits² Average charge per scan³ Discount rate 4 1,750,000 175,000 25,000 2,000 130 84,000 325 - 8.00%…

Barnard Manufacturing is considering three capital investment proposals. At this time, Barnard only has funds available to pursue one of the three investments. |(Click the icon to review the proposals.) Which investment should Barnard pursue at this time? Why? Since each investment requires a different initial investment and presents a positive NPV, Barnard Manufacturing should use the profitability index to compare the profitability of each investment. Select the labels for the evaluation measure you determined above. Enter the amounts into the formula, beginning with Equipment A, and calculate the amount you will use to evaluate each investment. (Enter all amounts as positive numbers. Round the evaluation measure to two decimal places, X.XX.) - X Data Table Equipment A Equipment B Equipment C Present value of net cash inflows 1,832,478 S 1,865,471 $ 2,169,724 (1,650,881) (1,516,643) (1,749,777) Initial Investment 181,597 S 348,828 S 419,947 NPV Print Done

Pls show complete steps all the parts pls.

All parts are under one questions and per your policy therefore all parts can be answered.  1. Concepts used in cash flow estimation and risk analysis You can come across different situations in your life where the concepts from capital budgeting will help you in evaluating the situation and making calculated decisions. Consider the following situation: The following table contains five definitions or concepts. Identify the term that best corresponds to the concept or definition given.   A. Concept or Definition Term A computer-generated probability simulation of the most likely outcome, given a set of probable future events      The most likely scenario in a capital budgeting analysis      A measure of the project’s effect on the firm’s earnings variability      A method to determine market risk by using the betas of single-product companies in a given industry      The risk that is measured by the project’s beta coefficient        B. Marston…

Compare and Contrast the four capital budgeting methods. Show Future Value examples of a) Lump Sum b) annuity. Show Present value of a) Lump Sum and b) annuity Compare Payback Period Method and ARR. What is a valid criticism of the Payback Period Method Rank the four projects in order of preference by the four methods in no. 1 Explain the rankings and which method is best for evaluating all capital investment projects

From the Case Study"DISTRICT HEADQUARTER HOSPITAL: FINANCIAL FEASIBILITY STUDY" Prepare in as much detail as possible, the projected financial statements, for District Headquarter Hospital for the next six years. The financial statements should comprise projected Balance Sheets, Income Statements and Cash Flow Statements for each of these years.

Scenario: Capital budgeting is utilized to determine if a project is worthwhile. The net present value (NPV), payback period, and internal rate of return (IRR) methods are used to rank and select which project to undertake. The following video outlines the NPV and IRR method of capital budgeting:   Explain how to calculate the NPV, IRR, and payback period for each project. Utilizing the capital budgeting calculations, you will need to select the best investment for the company. These calculations will be based on the following scenario: Hunter Shipyard Industries has 3 potential projects to consider, all with an initial cost of $1,250,000. The company prefers to reject any project with a 4-year cut-off period for recapturing initial cash outflow. Given the cost of capital rates and the future cash flow for each project, determine which project the company should accept.   Cash Flow Project A Project I Project U         Year 1 250,000 450,000 250,000 Year 2 250,000…

Capital Budgeting and Risk Analysis Post a Response Describe the most important capital budgeting techniques and how they are used to arrive at investment decisions. Name at least two capital budgeting techniques (for example, NPV, IRR, Payback Period, et cetera) How does a manager differentiate when to use capital budgeting versus simple return on investment (ROI) techniques? Respond to a Peer Be sure to respond to at least one of your classmates' posts. Read a post by one of your peers and provide a substantive response, making sure to extend the conversation by asking questions, offering rich ideas, or sharing personal connections.

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…

Which of the following procedures does the text say is used most frequently by businesses when they do capital budgeting analyses?   a. Monte Carlo simulation uses a computer to generate random sets of inputs, those inputs are then used to determine a trial NPV, and a number of trial NPVs are averaged to find the project's expected NPV. Sensitivity and scenario analyses, on the other hand, require much more information regarding the input variables, including probability distributions and correlations among those variables. This makes it easier to implement a simulation analysis than a scenario or sensitivity analysis, hence simulation is the most frequently used procedure.     b. Differential project risk cannot be accounted for by using "risk-adjusted discount rates" because it is highly subjective and difficult to justify. It is better to not risk adjust at all.     c. The firm's corporate, or overall, WACC is used to discount all project cash flows to…

a. Using the data in the table below and calculate the following performance measures

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…

You have been asked by your manager to review three potential investment opportunities.  As part of your investigation, you are asked to provide calculated data for three different methods of comparison.  What three methods do you decide to use for your calculations?  Explain why you are choosing each of these methods.  (Explain your answer in a minimum of 3 complete sentences.)

can you answer this question for me as Excel formula ?

The following table contains information about four projects in which Reynolds Corporation has the opportunity to invest. This information is based on estimates that different managers have prepared about their potential project. (Click the icon to view the projects information.) Requirements 1. Rank the four projects in order of preference by using the a. net present value. d. payback period. b. project profitability index. e. accounting rate of return. c. internal rate of return. 2. Which method(s) do you think is best for evaluating capital investment projects in general? Why? Data table Requirement 1. Rank the projects in order of preference. (a) (b) Net Present Profitability Value Index (c) Internal Rate of Return (d) Payback Period (e) Net Internal Payback Accounting Accounting of Retur 5 Investment Present Life of Rate of Profitability Period in Project Required Value Project Return Project A $205,000 $ 61,770 Rate of Index Years Return 24% 1.30 2.77 19% 1st preferred Project B…

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 decision. The methods are presented and the decision…

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 decision. The methods are presented and the decision…

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 decision. The methods are presented and the decision…