The Lost in Space corporation is trying to finally build a space ship that won't end up stranding everyone on it in somerandom part of the galaxy. To do so they are considering a new three-year project that will require an initial investmentof $400 million. These initial assets will be depreciated straight-line to zero over their three-year tax life. The firm will beable to sell these assets at the end of the project for $45,250,000.The project is estimated to generate the following revenues during it's three year life: $315,485,369 in year one,$325,690,023 in year two, and $344,555,000 in year three. The firm expects that their costs will be equal to 47.75% ofthe projects same year revenues. They expect that project net working capital (in the form of inventory required) will beequal to 10.25% of the next year's revenue. The firms tax-rate is 21%. What are the project's cash flows from assets foryears 0-3? What is the IRR on this project?Use available Excel template and complete using "best practices" (use formulas - no hardcoding in model). This meansthat every cell must be calculated inside of excel! Do not use your calculator and then just type in numbers.Revenue t=1Revenue t=2Revenue t-3InvestmentDepr. yearsFinal book valueFA Sale valueNWC req'tCostsTax rateRevenueExpensesDepreciationEBITTaxesNet Income (NI)OCFNWC totalChange in NWCNet Capital SpendingCFFA$$$$$$$Year 0SLYou may use positive or negative numbers in thissection below in any consistent manner. Please makesure your Excel formulas are consistent and that yourcash flow numbers are correct.Year 1Year 2Year 3 Project IRRTotal Cash FlowDiscount ratea) NPVb) Accept/Rejectc) IRR$Year 0(525,000) $Year 1215,230 $Year 2226,369 $< ok if consistent with above - hardcoded OKYear 3294,10012.50%

The Internal Rate of Return (IRR) is a financial metric used to measure the profitability of an…

Answered: The Lost in Space corporation is trying…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 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 $2,190,000 in annual sales, with costs of $815,000. The tax rate is 35%. What is the NPV of the project if the required rate of return is 12% O $47,523 O $59,255 O $68.991 O $52.648
The Perez Company has the opportunity to invest in one of two mutually exclusive machines that will produce a product it will need for the foreseeable future. Machine A costs $10 million but realizes after-tax inflows of $4 million per year for 4 years. After 4 years, the machine must be replaced. Machine B costs $15 million and realizes after-tax inflows of $3.5 million per year for 8 years, after which it must be replaced. Assume that machine prices are not expected to rise because inflation will be offset by cheaper components used in the machines. The cost of capital is 10%. A. By how much would the value of the company increase if it accepted the better machine? B. What is the equivalent annual annuity for each machine?
Your company is about to undertake a major investment project. The project will require an initial investment of $200 million in a machine plus another $35 million for working capital. Tax authorities will allow you to depreciate the machine on a straight-line basis over four years to a salvage value of zero. In fact, however, you expect that you can sell the machine for $30 million at the end of Year 4. You will need to have a working capital balance on hand at the end of each year equal to 30% of that year’s sales. The working capital can be fully recovered at the end of the project’s life. You expect that the project will generate $100 million in sales and $40 million in cash operating expenses (excluding depreciation) during each of the next four years. The corporate tax rate is 40%. The discount rate is 7.25%. What is NPV of this project?
Carlson Inc. is evaluating a project in India that would require a $6.0 million after-tax investment today (t = 0). The after-tax cash flows would depend on whether India imposes a new property tax. There is a 50-50 chance that the tax will pass, in which case the project will produce after-tax cash flows of $1,100,000 at the end of each of the next 5 years. If the tax doesn't pass, the after-tax cash flows will be $2,100,000 for 5 years. The project has a WACC of 10.2%. The firm would have the option to abandon the project 1 year from now, and if it is abandoned, the firm would receive the expected $1.10 million cash flow at t = 1 and would also sell the property and receive $4.95 million after taxes at t = 1. If the project is abandoned, the company would receive no further cash inflows from it. What is the value (in thousands) of this abandonment option? Do not round intermediate calculations. a. $1,124 b. $739 c. $705 d. $671 e. $34
Please answer very fast then i ll upvote. XYZ Limited is considering two projects. Each requires an immediate cash outlay: $10,000 for A, $9,000 for B. Project A has a life of four years, project B five years; neither will have any salvage value at the end of its life. For tax purposes, each would be depreciated by the straight-line method, project A at 30 percent, project B at 24 percent. The company’s tax rate is 40 percent, and its required rate of return after tax is 11 percent. Net cash flows before taxes have been projected as follows. Year 1 2 3 4 5 Project A 3200 3200 4000 4100 Project B 4000 4000 1900 1800 1800 a)calculate the net cash flows after tax for each project. (Assume that XYZ Limited has a substantial taxable income so that,where a project has a negative taxable income in a particular year, this will give rise to a tax saving by the firm.) b) Compute the payback for each investment. c) Compute the average rate of return for each investment. d) Compute…
Carlson Inc. is evaluating a project in India that would require a $5.5 million after-tax investment today (t = 0). The after-tax cash flows would depend on whether India imposes a new property tax. There is a 50-50 chance that the tax will pass, in which case the project will produce after-tax cash flows of $1,150,000 at the end of each of the next 5 years. If the tax doesn't pass, the after-tax cash flows will be $1,950,000 for 5 years. The project has a WACC of 12.0%. The firm would have the option to abandon the project 1 year from now, and if it is abandoned, the firm would receive the expected $1.15 million cash flow at t-1 and would also sell the property and receive $4.85 million after taxes at t-1. If the project is abandoned, the company would receive no further cash inflows from it. What is the value (in thousands) of this abandonment option? Do not round intermediate calculations. O a $87 b. 5781 c. $606 O d. 1963 Oe. $693
Vijay
Your facility is undergoing a major expansion, which will require significant capitalinvestment into new machinery. The total cost of the machinery will be $7.2 Million, and theywill be purchased outright immediately. This machinery is considered a 7-year MACRSasset. However, you expect to use it for only six years before selling it for $1.5 Million. What is the gains tax owed on the machinery sale at the end of year 6 if the tax rate is 21%? a. $45,108b. $169,692c. $315,000d. $0
Kolby's Korndogs is looking at a new sausage system with an installed cost of $735,000. The asset qualifies for 100 percent bonus depreciation and can be scrapped for $101,000 at the end of the project's 5-year life. The sausage system will save the firm $215,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $67,000. If the tax rate is 21 percent and the discount rate is 8 percent, what is the NPV of this project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV =
Your firm is considering investing in a new capital project that requires an initial investment of $8,000,000. This equipment will be depreciated by the straight-line over four years down to a value of zero. The machinery also has an operation life of four years. At the end of that life, you estimate it will have a salvage value of $120,000. Any gain or loss on the resell will be taxed at the firm's marginal tax rate. During the four-year life, the project should generate annual cash flows of $225,000 per year. The firm has a marginal tax rate of 22%, and it requires a return of 8.50% on projects of such risk. What is the Net Present Value of this project?
A corporation is considering purchasing a machine that will save $150,000 per year before taxes. The cost of operating the machine (including maintenance) is $30,000 per year. The machine will be needed for five years, after which it will have a zero salvage value. MACRS depreciation will be used, assuming a three-year class life. The marginal income tax rate is 25%. If the firm wants 15% return on investment after taxes, how much can it afford to pay for this machine? Click the icon to view the MACRS depreciation schedules Click the icon to view the interest factors for discrete compounding when /- 15% per year. If the firm wants 15% return on investment after taxes, it can afford to pay thousand for this machine. (Round to one decimal place.)
Karsted Air Services is now in the final year of a project. The equipment originally cost $27 million, of which 100% has been depreciated. Karsted can sell the used equipment today for $6 million, and its tax rate is 30%. What is the equipment's after-tax salvage value? Write out your answer completely. For example, 13 million should be entered as 13,000,000. Round your answer to the nearest dollar.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS