File Home Insert Share Formulas Data Review View Help Draw B24 ✓ Calibri (Body) Xfx NPV(B6, B17:B19) - B5 11 ✓ Α' Α' BIUab D A B C D E F G H 1 2 3 Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.18 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $1.645 million in annual sales, with costs of $610,000. The tax rate is 21 percent. If the required return is 12 percent, what is the project's NPV? 4 Input area: 56 6 Asset investment $2,180,000 7 Estimated annual sales $1,645,000 8 Costs $610,000 9 Tax rate 21% 10 Project and asset life 3 12% 11 Required return 12 13 (Use cells A6 to B10 from the given information to complete this question.) 14 15 Output area: 16 17 Sales $1,645,000 18 Costs $610,000 19 Depreciation 726,667 20 EBT $308,333 21 Taxes 64,750 22 Net income $243,583 23 OCF $970,250 24 NPV 25 $1

File Home Insert Share Formulas Data Review View Help Draw B24 ✓ Calibri (Body) Xfx NPV(B6, B17:B19) - B5 11 ✓ Α' Α' BIUab D A B C D E F G H 1 2 3 Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.18 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $1.645 million in annual sales, with costs of $610,000. The tax rate is 21 percent. If the required return is 12 percent, what is the project's NPV? 4 Input area: 56 6 Asset investment $2,180,000 7 Estimated annual sales $1,645,000 8 Costs $610,000 9 Tax rate 21% 10 Project and asset life 3 12% 11 Required return 12 13 (Use cells A6 to B10 from the given information to complete this question.) 14 15 Output area: 16 17 Sales $1,645,000 18 Costs $610,000 19 Depreciation 726,667 20 EBT $308,333 21 Taxes 64,750 22 Net income $243,583 23 OCF $970,250 24 NPV 25 $1

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter12: Valuation: Cash-flow Based Approaches

Section: Chapter Questions

Problem 14PC

See similar textbooks

Similar questions

Net Present Value versus Profitability Index Consider the following two mutually exclusive projects available to Global Investments, Inc.: C0 C1 C2 Profitability Index NPV A -$1,000 -$1,000 $500 1.32 $322 B -500 500 400 1.57 285 The appropriate discount rate for the projects is 10 percent. Global Investments chose to undertake Project A. At a luncheon for shareholders, the manager of a pension fund that owns a substantial amount of the firm’s stock asks you why the firm chose Project A instead of Project B when Project B has a higher profitability index. How would you, the CFO, justify your firm’s action? Are there any circumstances under which Global Investments should choose Project B?
Please show all parts or skip it I'll definitely rate for complete answer and negative if not complete
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Year 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $133 $133 $133 $133 $133 $133 $0 Open spreadsheet What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. Project A: $ fill in the blank 2 Project B: $ fill in the blank 3 What is each project's IRR? Round your answer to two decimal places. Project A: fill in the blank 4% Project B: fill in the blank 5% What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations. Project A: fill in the blank 6% Project B: fill in the blank 7%…
Begin with the partial model in the file Ch02 P21 Build a Model.xlsx on the textbooks Web site. a. Using the financial statements shown here for Lan Chen Technologies, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for 2020. The federal-plus-state tax rate is 25%. b. Assume there were 15 million shares outstanding at the end of 2019, the year-end closing stock price was 65 per share, and the after-tax cost of capital was 10%. Calculate EVA and MVA for 2020. Lan Chen Technologies: Income Statements for Year Ending December 31 (Millions of Dollars) Lan Chen Technologies: December 31 Balance Sheets (Thousands of Dollars)
Please show the solution.
Eco Don't upload any image please
ASAP!!
Correct answer Please
Please avoid solution image based thnku
ent question Time Left : 01:39:30 Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as follows: EXPECTED NET CASH FLOWS Year Project A Project B 0 -$290 -$400 1 -387 134 2 -193 134 3 -100 134 4 600 134 5 600 134 6 850 134 7 -180 134 What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places. Project A % Project B % Calculate the two projects' NPVs, if you were told that each project's cost of capital was 14%. Do not round intermediate calculations. Round your answers to the nearest cent. Project A $ Project B $ Calculate the two projects' NPVs, if the cost of capital was 17%. Do not round intermediate calculations. Round your answers to the nearest cent. Project A $ Project B $ What is each project's MIRR at a cost of capital of 14%? (Hint: Consider Period 7 as the end of Project B's life.) Do not round intermediate calculations.…
Armaan Incorporation, has two investment proposals, which have the following characteristics:PROJECT A PROJECT BPERIODCOSTPROFIT AFTER TAXNET CASH FLOWCOSTPROFIT AFTER TAXNET CASH FLOW 0$9,000--$12,000-- 1 $1,000$5,000 $1,000$5,000 2 $1,000$4,000 $1,000$5,000 3 $1,000$3,000 $4,000$8,000 For each project, compute its payback period, its net present value, and its proﬁtability index using a discount rate of 15 percent.
NEED the correct EXCEL INPUT, not just the number answer, please provide the excel code to get the answer from the image