You are a Financial Analyst with Bloom Lake Railway Corporation. The management of the company is....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a Financial Analyst with Bloom Lake Railway Corporation. The management of the company is. considering upgrading the company's station equipment to meet increased demand and lower operating costs as the new station equipment is more energy efficient. You are tasked to perform analysis for the company's upgrading plan. Below is the key information needed for The old station equipment was purchased four years ago at a capital cost of $240,000. When purchased, the old equipment was expected to last ten years with a salvage value of $28,000. New station equipment will cost $365,000, including installation costs. The new equipment is expected to last six years along with a salvage value of $107,000. The old station equipment could be sold for $110,000 at present. Both the old and new equipment fall into CCA asset class 8 and they follow the CRA requirement of using the declining balance method at a CCA rate of 20 percent. For simplicity, changes in net working capital will be ignored. The railroad's weighted average cost of capital is 14 percent taking into account all opportunity costs. The corporate tax rate is 37 percent. The projections for annual pre-tax revenues and annual pre-tax costs with the new station equipment are: Lower Bound Annual Pre-tax Revenues Annual Pre-tax Cost $ Base Case Upper Bound 197,430.00 $ 87,430.00 $ 216,723.00 $ 105,786.00 $ 135,786.00 46,723.00 Required: 1) Under which scenario(s) of base-case, best-case or worst-case would you recommend upgrading the railroad company's station equipment on the basis of NPV? (13 marks) 2) Find the IRR for the base-case using goal-seek. For this part (of your answer only) take a print of the calculation of base-case NPV and another print when goal-seek finds the IRR. (7 marks) You are a Financial Analyst with Bloom Lake Railway Corporation. The management of the company is. considering upgrading the company's station equipment to meet increased demand and lower operating costs as the new station equipment is more energy efficient. You are tasked to perform analysis for the company's upgrading plan. Below is the key information needed for The old station equipment was purchased four years ago at a capital cost of $240,000. When purchased, the old equipment was expected to last ten years with a salvage value of $28,000. New station equipment will cost $365,000, including installation costs. The new equipment is expected to last six years along with a salvage value of $107,000. The old station equipment could be sold for $110,000 at present. Both the old and new equipment fall into CCA asset class 8 and they follow the CRA requirement of using the declining balance method at a CCA rate of 20 percent. For simplicity, changes in net working capital will be ignored. The railroad's weighted average cost of capital is 14 percent taking into account all opportunity costs. The corporate tax rate is 37 percent. The projections for annual pre-tax revenues and annual pre-tax costs with the new station equipment are: Lower Bound Annual Pre-tax Revenues Annual Pre-tax Cost $ Base Case Upper Bound 197,430.00 $ 87,430.00 $ 216,723.00 $ 105,786.00 $ 135,786.00 46,723.00 Required: 1) Under which scenario(s) of base-case, best-case or worst-case would you recommend upgrading the railroad company's station equipment on the basis of NPV? (13 marks) 2) Find the IRR for the base-case using goal-seek. For this part (of your answer only) take a print of the calculation of base-case NPV and another print when goal-seek finds the IRR. (7 marks)
Expert Answer:
Answer rating: 100% (QA)
To determine whether upgrading the railroad companys station equipment is financially viable we need to calculate the net present value NPV of the pro... View the full answer
Related Book For
Financial Management for Decision Makers
ISBN: 978-0138011604
2nd Canadian edition
Authors: Peter Atrill, Paul Hurley
Posted Date:
Students also viewed these accounting 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...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
A special-purpose milling machine was purchased four years ago for $20,000. It was estimated at that time that this machine would have a life of 10 years, a salvage value of $ 1.000, and a cost of...
-
Why is ultraviolet light, but not infrared light, effective in making certain materials fluoresce?
-
Irish Products makes wheels for a variety of toys and sports equipment. Irish Products sells the wheels to manufacturers who assemble and sell the toys and equipment. The companys market research...
-
At Elliott's dog-walking service, the only input is labor. Elliott's labor costs are $300 per day and his service walks 30 dogs per day. To walk 31 dogs per day, his labor costs would increase to...
-
Describe situations in which an organization should buy rather than build software components.
-
Refer to the information in Exercise 10-4. Prepare a table showing depreciation and book value for each of the four years assuming double-declining-balance depreciation.
-
Case Study Read the below Strait Times (March 2023) article and answer the questions that follow. The authorities in many countries have destroyed unused Covid-19 vaccine stocks that have expired, or...
-
Tea has been in the limelight recently thanks to increasing global demand, especially in emerging economies like China and India. China, India, Kenya, and Sri Lanka are some of the largest producers...
-
The financial information for the past two years (2018 and 2019) is provided. Using a spreadsheet application, such as Microsoft Excel, and the information from the previous years, provide the...
-
Which statement is true? a) Although our economy was not performing well, college graduates from the class of 2012 received more job offers than any other graduating class in history. b) The economic...
-
Compared to our economic history between 1870 and 1945, our economic history since 1945 could be considered _____. a) much more stable b) about as stable c) much less stable
-
Each of the following was a major contributing factor to suburbanization except ______. a) low-interest federal loans b) a federal highway building program c) the pent-up demand for housing d) the...
-
Which statement is true? a) Twenty-five million Americans were officially unemployed in 1933. b) Our economy expanded steadily from 1933 to 1945. c) Once the Great Depression began in 1929, our...
-
During World War II most of the people who got jobs in defense plants were ______who had _________experience building planes, tanks, and warships. a) men, substantial b) men, no c) women, substantial...
-
1.6 Tim purchased some new computer equipment at the beginning of 2013 with a cost of R40 000. The equipment has a residual value of R5 000, and Tim has elected to use the declining balance (reducing...
-
Chloroplasts are illuminated until the levels of the Calvin cycle intermediates reach a steady state. The light is then turned off. How does the level of RuBP vary after this point?
-
Pizza Shack Ltd. operates a chain of pizza restaurants in the Maritimes. The business started operations five years ago and has enjoyed rapid growth. The directors of the business believe, however,...
-
How might each of the following affect the level of inventory held by a business? (a) An increase in the number of production bottlenecks experienced by the business (b) A rise in the level of...
-
You are an analyst at Oil Patch Semiconductors Inc. (OPS), a small high-tech firm specializing in the design of proprietary chips used by oil companies to help find new sources of oil and natural...
-
Debate: Survey feedback can be a problematic OD technique because it permits people who are affected by organizational policies to generate data that speak against those policies.
-
You have been charged with staffing and organizing an R&D group in a new high-tech firm. What will you do to ensure that the group is innovative?
-
Discuss: The best organizational structure to generate innovative ideas might not be the best structure to implement those ideas.
Study smarter with the SolutionInn App