The Lost in Space corporation is trying to finally build a space ship that won't end...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Lost in Space corporation is trying to finally build a space ship that won't end up stranding everyone on it in some random part of the galaxy. To do so they are considering a new three-year project that will require an initial investment of $400 million. These initial assets will be depreciated straight-line to zero over their three-year tax life. The firm will be able 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% of the projects same year revenues. They expect that project net working capital (in the form of inventory required) will be equal to 10.25% of the next year's revenue. The firms tax-rate is 21%. What are the project's cash flows from assets for years 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 means that every cell must be calculated inside of excel! Do not use your calculator and then just type in numbers. Revenue t=1 Revenue t=2 Revenue t=3 Investment Depr. years Final book value FA Sale value NWC req't Costs Tax rate Revenue Expenses Depreciation EBIT Taxes Net Income (NI) OCF NWC total Change in NWC Net Capital Spending CFFA $ $ $ $ $ $ $ Year 0 SL You may use positive or negative numbers in this section below in any consistent manner. Please make sure your Excel formulas are consistent and that your cash flow numbers are correct. Year 1 Year 2 Year 3 Project IRR Total Cash Flow Discount rate a) NPV b) Accept/Reject c) IRR $ Year 0 (525,000) $ Year 1 215,230 $ Year 2 226,369 $ < ok if consistent with above - hardcoded OK Year 3 294,100 12.50% The Lost in Space corporation is trying to finally build a space ship that won't end up stranding everyone on it in some random part of the galaxy. To do so they are considering a new three-year project that will require an initial investment of $400 million. These initial assets will be depreciated straight-line to zero over their three-year tax life. The firm will be able 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% of the projects same year revenues. They expect that project net working capital (in the form of inventory required) will be equal to 10.25% of the next year's revenue. The firms tax-rate is 21%. What are the project's cash flows from assets for years 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 means that every cell must be calculated inside of excel! Do not use your calculator and then just type in numbers. Revenue t=1 Revenue t=2 Revenue t=3 Investment Depr. years Final book value FA Sale value NWC req't Costs Tax rate Revenue Expenses Depreciation EBIT Taxes Net Income (NI) OCF NWC total Change in NWC Net Capital Spending CFFA $ $ $ $ $ $ $ Year 0 SL You may use positive or negative numbers in this section below in any consistent manner. Please make sure your Excel formulas are consistent and that your cash flow numbers are correct. Year 1 Year 2 Year 3 Project IRR Total Cash Flow Discount rate a) NPV b) Accept/Reject c) IRR $ Year 0 (525,000) $ Year 1 215,230 $ Year 2 226,369 $ < ok if consistent with above - hardcoded OK Year 3 294,100 12.50%
Expert Answer:
Answer rating: 100% (QA)
Heres the Lost in Space capital budgeting model with best practices using Excel formulas Revenue Yea... View the full answer
Related Book For
Managerial Accounting Tools for business decision making
ISBN: 978-1118096895
6th Edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
26. With its current leverage, Impi Corporation will have net income next year of 4.5 million. If Impis corporate tax rate is 35% and pay 8% interest on its debt, how much additional debt can Impi...
-
In order to increase its market penetration and boost profitability, Coles Group (COL) is evaluating investing in a "Mega Automated Convenience Store" (MACS). COL has already identified a facility...
-
Three charges are arranged as shown in the figure. Find the (a) magnitude and (b) direction (angle with the x axis) of the electrostatic force on the 6.00- nC charge. In the figure, q= 3.64 nC. 0.500...
-
What is the difference between schedule and non-schedule injuries?
-
A contour map is shown for a function f on the square R = [0, 4] [0, 4]. (a) Use the Midpoint Rule with m = n = 2 to estimate the value of R f(x, y) dA. (b) Estimate the average value of f . y4 4...
-
Good internal control procedures for cash include which of the following? (a) All cash disbursements, other than those for very small amounts, are made by check; (b) One employee should count cash...
-
Use data in Table B.2 to calculate the following: (a) The heat capacity (Cp) of liquid benzene at 40C. (b) The heat capacity at constant pressure of benzene vapor at 40C. (c) The heat capacity at...
-
3 7 + 8 12 +7= (Type an integer or a fraction. Simplify your answer.) 12 38
-
In this exercise you will be assuming the role of an Account Manager working within our Personal Care Appliances category during Amazon Black Friday. You act as a general manager responsible for...
-
Suppose a firm follows the cost minimization rule in choosing the amount of labor and capital to use in producing the product. When the marginal product of labor is 600, the marginal product of...
-
Explain the 5 Ps and 5 Rs in personal Leadership.
-
Discuss in your group what are the ground rules for your discussion of the Federal Tax rules. This can include topics such as: what is the definition of "fairness", what additional information can be...
-
In the game in the table below, each player (A and B) has three possible actions. These actions are labelled X, Y and Z. Player B X Y Z Player A X 100,100 900,0 200,300 Y 500,900 700,300 100,700 Z...
-
Explain words define globalization. Explain how trade and labor market policies can help make globalization socially sustainable. Discuss the United States' recent policy measures and how these...
-
Craigwood Ltd acquired all the issued shares (cum div.) of Grandburn Ltd for consideration of $3,700,000 on 1 January 2023. On the date of acquisition Grandburn Ltd's Statement of Financial Position...
-
5.2 EVALUATE the potential for using direct sales techniques andstrategies 5.2.1 In relation to the specific projects and targetmarkets that you service in bank 0 answers
-
A test car is driven a fixed distance of n miles along a straight highway. (Here n Z+.) The car travels at one mile per hour for the first mile, two miles per hour for the second mile, four miles...
-
Steiner Corporation manufactures water skis through two processes: Molding and Packaging. In the Molding Department, fiberglass is heated and shaped into the form of a ski. In the Packaging...
-
Mordica Company identifies three activities in its manufacturing process: machine setups, machining, and inspections. Estimated annual overhead cost for each activity is $150,000, $325,000, and...
-
Mendle and Kiner is an architectural firm that is contemplating the installation of activity-based costing. The following activities are performed daily by staff architects. Classify these activities...
-
The chapter says that a measurement system can affect a business in several ways. As an example, consider a worldwide company with headquarters in New York City and divisions in many different...
-
Under the No Child Left Behind Act, passed in 2001, every public elementary school that receives some federal funding is required to give its students certain tests of reading and math every year....
-
Consider a college transcript as the output of a measurement system. A. Identify the: a. Object being measured b. Attribute of the object being measured c. Rules for measurement d. Standard-setters...
Study smarter with the SolutionInn App