Hi there,
I am working on this problem and trying to figure out how to find the present value of net working capital. Can you please show me, without using excel, how to calculate it step-by-step?
firm has decided to replace a major piece of industrial equipment. The equipment costs $690,000 to
purchase and install and is expected to have a useful life of 5 years, after which it will be sold on the open
market and is expected to have a salvage value of $200,000. The firm has a cost of capital of 9.1%.
The new equipment will be one of a large group of assets with a CCA rate of 20%. The corporate tax rate is
40%. The company is responsible for maintenance and insurance costs of $40,000 per year. The new
equipment will allow the firm to increase production, and sales will increase by $270,000 per year.
The firm also anticipates that it will have to maintain its working capital requirements above its regular
levels as follows:
Year 0: $50,000; Year 1: $60,000; Year 2: $70,000; Year 3: $60,000; Year 4: $50,000. It is further
anticipated that at the end of the fifth year, working capital requirements will return to pre-project levels.
Step by stepSolved in 2 steps
- Help mearrow_forwardA Company has an opportunity to produce and sell a new product. Your team has been asked to use capital budgeting analysis to determine whether this would be a profitable venture for the company. New equipment would have to be acquired to produce the product. The equipment would cost $155,000 and be usable for 10 years. After 10 years, it would have a salvage value equal to 5% of the original cost. The asset will be sold at salvage value at the end of the asset's life. The discount rate for the company is 7%. See below for the forecasted net income per year from this project. Year Net Income per year Year 1 2,144 Year 2 3,531 Year 3 5,133 Year 4 6,113 Year 5 10,243 Year 6 10,500 Year 7 12,546 Year 8 12,600 Year 9 12,600 Year 10 12,600 Required: 1. Calculate the Payback period and explain the results. (note, you can only use the formula with even cash flows, research how to calculate it with uneven cashflows) 2. Calculate ARR and explain the results (use average net income for this…arrow_forwardGive me answerarrow_forward
- I need help solving this problem below on excel. Suppose you purchased equipment and agreed to pay the manufacturer $100,000 in 4 years for the equipment. What should you record the cost of the equipment today if your cost of capital is 5%?arrow_forwardThe NPV of the replacement is $ ?arrow_forwardFalkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated revenue producing life of 4 years. Falkland has a cost of capital of 8%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?arrow_forward
- Mason, Inc., is considering the purchase of a patent that has a cost of $85000 and an estimated revenue producing lite of 4 years. Mason has a required rate of return that is 12% and a cost of capital of 11%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?arrow_forwardFriedman Company is considering installing a new IT system. The cost of the new system is estimated to be 2,250,000, but it would produce after-tax savings of 450,000 per year in labor costs. The estimated life of the new system is 10 years, with no salvage value expected. Intrigued by the possibility of saving 450,000 per year and having a more reliable information system, the president of Friedman has asked for an analysis of the projects economic viability. All capital projects are required to earn at least the firms cost of capital, which is 12 percent. Required: 1. Calculate the projects internal rate of return. Should the company acquire the new IT system? 2. Suppose that savings are less than claimed. Calculate the minimum annual cash savings that must be realized for the project to earn a rate equal to the firms cost of capital. Comment on the safety margin that exists, if any. 3. Suppose that the life of the IT system is overestimated by two years. Repeat Requirements 1 and 2 under this assumption. Comment on the usefulness of this information.arrow_forwardThe Scampini Supplies Company recently purchased a new delivery truck. The new truck cost $22,500, and it is expected to generate net after-tax operating cash flows, including depreciation, of $6,250 per year. The truck has a 5-year expected life. The expected salvage values after tax adjustments for the truck are given here. The company’s cost of capital is 10%. Should the firm operate the truck until the end of its 5-year physical life? If not, then what is its optimal economic life? Would the introduction of salvage values, in addition to operating cash flows, ever reduce the expected NPV and/or IRR of a project?arrow_forward
- 9. Lt. Dan Corporation invested S$80,000 in a manufacturing equipment. The salvage value of the asset is expected to be $0. The company is expected to add $9,600 per year to the net income. Using the original cost of the asset, the unadjusted rate of return on the investment will be? Hint: If the problem does not give you enough information to determine the net values, keep your calculations simple!arrow_forwardYou need to estimate the value of Laputa Aviation. You have the following forecasts (in millions of dollars) of its profits and of its future Investments in new plant and working capital: Earnings before interest, taxes, depreciation, and amortization (EBITDA) Depreciation Pretax profit Tax at 30% Investment Check my work mode: This shows what is correct or incorrect for the work you have comp Answer is complete but not entirely correct. 757 a. Total value b. Laputa's equity $ $ ⓇⓇ 1 $.73 33 40 12 19 70 Year From year 5 onward, EBITDA, depreciation, and investment are expected to remain unchanged at year-4 levels. Laputa is financed 60% by equity and 40% by debt. Its cost of equity is 18%, its debt yields 9%, and it pays corporate tax at 30% 2 $93 43 50 15 22 a. Estimate the company's total value. Note: Do not round Intermediate calculations. Enter your answer in millions rounded to the nearest whole amount. b. What is the value of Laputa's equity? Note: Do not round Intermediate…arrow_forwardI only need help on D and E. Please show me how you go your answer. Thank you!arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning