W10 Excel Model-Cash Flow, Net Cost, and Capital Budgeting -Rita Rodriguez

Relevant Cash Flow Data for Year 2:Sales revenues Year 2 $100,000Cost of Goods Sold 20,000Depreciation Expense 10,000Tax Rate 40% Based on the above cash flow data: What is the operating cash flow for year two of this capital budgeting project? A.130,000 B.52,000 C.42,000 D. 78,000

Internal rate of return and modified internal rate of return. Quark Industries has three potential projects, all with an initial cost of $2,100,000. Given the discount rate and the future cash flow of each project in the following table, E, what are the IRRS and MIRRS of the three projects for Quark Industries?

this is Capital budgeting tools ch 12 p 25 build a model

How do you calculate the NPV and IRR   Project 1     Year Cashflows Discount Rate  10%     0  $                 (750,000.00)         1  $                   250,000.00         2  $                   300,000.00         3  $                   350,000.00         4  $                   200,000.00         5  $                   100,000.00                                             Project 2     Year Cashflows Discount Rate 10%     0  $             (1,000,000.00)         1  $                   200,000.00         2  $                   300,000.00         3  $                   400,000.00         4  $                   500,000.00         5  $                   700,000.00

Vd Subject: acounting

Consider the following data table for Projects A, B and C. Annual Initial Investmen Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Discount Inflation t Year 1 Year 3⚫ Year 3 Year 4 Year 5 Rate Rate PROJECT A $40,000 $20,000 $20,000 $30,000 $40,000 $40,000 10% 5% PROJECT B $100,000 $40,000 $50,000 $60,000 $65,000 $70,000 8% 3% PROJECT C $100,000 $50,000 $100,000 $15,000 $80,000 6% 5% a) Compare NPVs among Projects A, B and C (showing your calculations). Which project is the most profitable?

Question Content Area A project is estimated to cost $273,840 and provide annual net cash inflows of $60,000 for 7 years. Year 6% 10% 12% 1 0.943 0.909 0.893 2 1.833 1.736 1.690 3 2.673 2.487 2.402 4 3.465 3.170 3.037 5 4.212 3.791 3.605 6 4.917 4.355 4.111 7 5.582 4.868 4.564 8 6.210 5.335 4.968 9 6.802 5.759 5.328 10 7.360 6.145 5.650 Determine the internal rate of return for this project by using the above present value of an annuity table.fill in the blank 1 of 1%

Annual cash inflows from two competing investment projects are given below: Investment A $ 4,000 5,000 6,000 7,000 $ 22,000 Year 1234 The discount rate is 10%. Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor(s) using tables. Required: Compute the present value of the cash inflows for each investment. Year 1 2 3 4 $ Investment B $ 7,000 6,000 5,000 4,000 $ 22,000 Present Value of Cash Flows Investment A 0 $ Investment B 0 M ...

Year Project 1 Net Cash Flows Project 2 Initial investment $(60,000) $(55,500) 1. 2. 15,000 35,000 27,400 3. 22,000 15,000 22,000 a. Compute payback period for each project. Based on payback period, which project is preferred? b. Compute net present value for each project. Based on net present value, which project is preferred? Complete this question by entering your answers in the tabs below. Required A Required B Compute net present value for each project. Based on net present value, which project is preferred? Note: Round your present value factor to 4 decimals. Round your final answers to the nearest whole dollar. Net Cash Flows Present Value Present Value of Net Factor Cash Flows Project 1 Year 1 Year 2 Year 3 Totals Initial investment Net present value Project 2 Year 1 Year 2 Year 3 Totals Initial investment $ 0 $ 0 $ 0 $ 0 $ 0 Net present value Based on net present value, which project is preferred? $ 0

Baltusrol Inc. has the following three investment opportunities. A P70,000 10,000 B Initial investment Initial working capital required Cash inflows by year: Year 1 P70,000 5,000 P70,000 8,000 P35,000 35,000 10,000 5,000 8,000 P83.000 P1,250 P35,000 10,000 45.000 20,000 2,000 P112.000 P10,000 P4,000 8,000 10,000 98,000 5.000 P125.000 P12,500 Year 2 Year 3 Year 4 Released working capital Total Average annual income Required: 1. Rank the investment opportunities in order of desirability using. A. Payback period. B. Average book rate of return (use average net book value of the investment as the denominator), and C. NPV using a 16% discount rate. 2. Determine the profitability index for each opportunity and rank the investments based on these values.

What is Project A's Modified Internal Rate of Return with a WACC of 7.75%? YEAR 0 1 2 3 4 CASH FLOWS Project A -$1050 675 650 Project B -$1050 360 360 360 360

3. A company faces the following investment alternatives: Project Capital Investment Cash Flows from Investment $7 million II $12 million III $16 million IV $10 million V $11 million $1.2 million per year in perpetuity $1.5 million per year in perpetuity $2.2 million per year in perpetuity $1.4 million per year in perpetuity $1.6 million per year in perpetuity If the company's budget is $30 million, use the profitability index to determine the best combination of investments, given a cost of capital of 5%.

ST-2 CAPITAL BUDGETING CRITERIA You must analyze two projects, X and Y. Each project costs $10,000, and the firm's WACC is 12%. The expected net cash flows are as follows: 2 3 Project X -$10,000 Project Y -$10,000 $6,500 $3,500 $3,000 $3,500 $3,000 $3,500 $1,000 $3,500 a. Calculate each project's NPV, IRR, MIRR, payback, and discounted payback. b. Which project(s) should be accepted if they are independent? c. Which project(s) should be accepted if they are mutually exclusive? d. How might a change in the WACC produce a conflict between the NPV and IRR rankings of the two projects? Would there be a conflict if WACC were 5%? (Hint: Plot the NPV profiles. The crossover rate is 6.21875%.) e. Why does the conflict exist?

Year 0 $10,000.00 1 $ 3,000.00 Project A Cash Flow Project B Cash Flow $11,000.00 $5,000.00 2 $ 4,000.00 $ 4,000.00 3 $ 5,000.00 $ 4,000.00 4 $3,000.00 $ 3,000.00 Assuming that the relevant cost of capital for both projects is 10%, you should be able to determine the net present value (NPV) and the internal rate of return (IRR) for both project. Assume now that the firm has capital rationing, but knows that its true reinvestment rate is 21%, while its cost of capital is 10 percent. Given this information, determine the modified net present value (MNPV) for Project A. $3,811.27 O $3,622.02 O $4,280.07 O $4,162.90 O $4,404.83

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: Operating Income Net Cash Flow Investment Year Proposal A: $450,000 $ 30,000 1 $120,000 2 30,000 120,000 3 20,000 110,000 4 10,000 100,000 (30,000) $ 60,000 $ 60,000 40,000 60,000 $510,000 $100,000 Proposal B: $200,000 1 80,000 3 20,000 60,000 4 (10,000) 30,000 (20.000) $ 90,000 20.000 $290,000 (Continued)

Subject: acounting

General Accounting

Assume that an investment provides the following cash inflows over a three-year period: Year 1 Year 2 Year 3 Total $5,000 5,000 7,000 $ 17,000 Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor(s) using the tables provided. Assuming a discount rate of 17%, what is the present value of these cash inflows?

Calculate the IRR of a project requiring an investment outlay of $ 10,000 resulting in cash inflows of $2,000 at the end of Year 1, $5,000 at the end of Year 2, and $8,000 at the end of year 3. a. 19.79% b. 18.79% c. 20.79% d. 22.79%

Francoeur Co. has identified an investment project with the following cash flows: Year 1 2 3 4 Cash Flow $830 $1,150 $1,410 $1,550 If the discount rate is 8 percent, what is the present value of these cash flows as of Year O? $4,013.06 $3,406.47 $3,679.59 $4,549.11 $4,271.21

Question content area top Part 1 ​(IRR calculation​) Determine the IRR on the following​ projects:   a. An initial outlay of ​$13,000 resulting in a single free cash flow of ​$17,165 after 9 years b. An initial outlay of ​$13,000 resulting in a single free cash flow of ​$46,394 after 15 years c. An initial outlay of ​$13,000 resulting in a single free cash flow of $105,001after 25 years d. An initial outlay of ​$13,000 resulting in a single free cash flow of ​$13,653 after 4 years

D Question 10 What is the IRR of Project C if the outlay is $225,000 and the after-tax cash inflows for years one through four are: $45,000, $70,000, $80,000, and $105,000? O 13.21% 12.90 0 11.00 11.80 13.53. 1 pts

Task 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…