The date is Friday July 1, 2022. Your company, the Coastal Petroleum Company, is faced with...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The date is Friday July 1, 2022. Your company, the Coastal Petroleum Company, is faced with a critical decision, and your boss (who was instrumental in your hiring at Coastal) has been bragging about you (because of your considerable financial expertise from Cal Poly) as the person most able to help Coastal management carefully evaluate and make the best decision. Coastal management is currently considering construction of new terminal and tank farm facilities to supply its customers in Northeast Florida. Coastal has been receiving, storing, and distributing Bunker #2 Heating Oil using facilities leased from the Gateway Oil Company in Jacksonville, Florida. However, Coastal just learned that Gateway will likely not renew this throughput agreement when it expires in December 31, 2022. After investigating a number of possible arrangements, Coastal's management has concluded that there are basically two feasible alternatives. The company could either construct its own facilities, or cease operations in Northeast Florida. Although Coastal is reluctant to abandon its customers, the company policy clearly requires that all investments in new facilities must provide a minimum after tax return of 14% (Coastal's MARR). This is where you come in. Your assignment is to prepare an Authorization for Capital (AFC) report that will enable Coastal management to make the best decision. (and remember your boss's credibility is at stake.) Engineering estimates indicate that the new facilities will cost $8,500,000 to construct and will have a useful life of 20 years. For tax purposes, these new facilities can be depreciated over the MACRS 10-year class life allowed for other petroleum equipment. The terminal is to be built on land leased from the Jacksonville Port Authority. Rent and wharf charges to the Port Authority are expected to total $350,000 per year under the terms of a 10 year lease; and the lease has options to renew for an additional 10 year period at the same rate. If construction is started by August 1, 2022, then Engineering expects that the new facilities will be ready for operation by the end of the year 2022. As a simplifying assumption, you can assume that construction of the new facilities will be under a bid contract, and that all payments under the contract will be made at the end of the construction period - 12-31-22. Trucks and other vehicles that are now in use can be used at the new facility, if it is built. It is estimated that at the end of 2022 this equipment will have a fair market value of $500,000 and a book value of $325,000 depreciable over the following five years using the straight line method. New equipment for the facility will also be purchased during the life of the project. Computer systems will be upgraded every 5 years (initial systems are included in the initial facilities cost of $8.50 million). The cost of each subsequent new computer system is assumed to be $75,000 per installation. Depreciation on these systems will be using MACRS with an appropriate class life for computers. After the new facility is placed in service, it is expected that some additional equipment replacement (pumps and tanks) will have to take place half-way through the expected life of 20 years. This equipment is expected to cost $1,500,000, and may be depreciated using MACRS with a class life of 10 years. In addition, trucks will have to be purchased every year starting in the first year of operation. They will cost a total of $175,000 each year and will be depreciated with MACRS using a class life of 5 years. The sales volume of Bunker #2 Heating Oil is expected to total 2.0 million barrels in 2023 (as forecast for the Gateway facilities). In 2024, the sales volume is expected to remain the same as in 2023, and in subsequent years is expected to increase at a rate of about 3.5% per year for six years at which time the sales volume will be assumed to be level for the remainder of the life of the project. Coastal's profit is a function of the cost of oil when they sell to their own customers. A profit of 4.0% is added to the cost of oil. Initial planning shows the forecasted cost of oil to Coastal will be $85.00 per barrel (cost of goods sold), but you have seen recently in the news that oil prices have jumped all over the place. You believe that inflation and limited supply will probably cause the oil to go up in cost to Coastal by about 1.5% per year over a planning horizon of 20 years. Accounting says the effective tax rate for Coastal should be considered to be 30%, but you are concerned that this rate is dependent up the presidential administration in place. The company will need some working capital to sustain its operations for either alternative. A general formula for the level of working capital needed has been found to be about 12% of gross sales revenue forecasted for the year. This working capital is needed at the beginning of the year for which the forecast is made. The level of working capital needed will change depending on the forecasted change in sales revenue. You will need to calculate a schedule for the amount of working capital which will be needed over the 20 years of this project. Working capital is considered an additional necessary investment from after tax dollars, but is not tax deductible. In your cash flow analysis, you will need to distinguish between the following three types of expenditures: 1) expenses (which are tax deductible in the current year), 2) capital investments (which are "deductible" over multiple years through depreciation), and 3) working capital (which is like a capital investment, but is not deductible). Additional expenses for the project will include operating expenses, which are expected to be $525,000 per year to start, with an increase of 3.5% each year over the life of the project. (Note: depreciation is an expense for tax purposes only.) Your boss and Coastal Executive Management (CEM) expect you to complete the AFC within four weeks so they can make a timely decision. The AFC must clearly show the engineering economic analysis for the alternatives, clear recommendations for REM action, and an insightful uncertainty/sensitivity analysis that clearly shows under what conditions your recommendations to REM would be reversed. The results of your analyses and recommendations are to be presented in a professionally done, easy to read, comprehensive, written report. You will need to fully explain your results in text explanations and visuals, and not just provide tables of numbers. The date is Friday July 1, 2022. Your company, the Coastal Petroleum Company, is faced with a critical decision, and your boss (who was instrumental in your hiring at Coastal) has been bragging about you (because of your considerable financial expertise from Cal Poly) as the person most able to help Coastal management carefully evaluate and make the best decision. Coastal management is currently considering construction of new terminal and tank farm facilities to supply its customers in Northeast Florida. Coastal has been receiving, storing, and distributing Bunker #2 Heating Oil using facilities leased from the Gateway Oil Company in Jacksonville, Florida. However, Coastal just learned that Gateway will likely not renew this throughput agreement when it expires in December 31, 2022. After investigating a number of possible arrangements, Coastal's management has concluded that there are basically two feasible alternatives. The company could either construct its own facilities, or cease operations in Northeast Florida. Although Coastal is reluctant to abandon its customers, the company policy clearly requires that all investments in new facilities must provide a minimum after tax return of 14% (Coastal's MARR). This is where you come in. Your assignment is to prepare an Authorization for Capital (AFC) report that will enable Coastal management to make the best decision. (and remember your boss's credibility is at stake.) Engineering estimates indicate that the new facilities will cost $8,500,000 to construct and will have a useful life of 20 years. For tax purposes, these new facilities can be depreciated over the MACRS 10-year class life allowed for other petroleum equipment. The terminal is to be built on land leased from the Jacksonville Port Authority. Rent and wharf charges to the Port Authority are expected to total $350,000 per year under the terms of a 10 year lease; and the lease has options to renew for an additional 10 year period at the same rate. If construction is started by August 1, 2022, then Engineering expects that the new facilities will be ready for operation by the end of the year 2022. As a simplifying assumption, you can assume that construction of the new facilities will be under a bid contract, and that all payments under the contract will be made at the end of the construction period - 12-31-22. Trucks and other vehicles that are now in use can be used at the new facility, if it is built. It is estimated that at the end of 2022 this equipment will have a fair market value of $500,000 and a book value of $325,000 depreciable over the following five years using the straight line method. New equipment for the facility will also be purchased during the life of the project. Computer systems will be upgraded every 5 years (initial systems are included in the initial facilities cost of $8.50 million). The cost of each subsequent new computer system is assumed to be $75,000 per installation. Depreciation on these systems will be using MACRS with an appropriate class life for computers. After the new facility is placed in service, it is expected that some additional equipment replacement (pumps and tanks) will have to take place half-way through the expected life of 20 years. This equipment is expected to cost $1,500,000, and may be depreciated using MACRS with a class life of 10 years. In addition, trucks will have to be purchased every year starting in the first year of operation. They will cost a total of $175,000 each year and will be depreciated with MACRS using a class life of 5 years. The sales volume of Bunker #2 Heating Oil is expected to total 2.0 million barrels in 2023 (as forecast for the Gateway facilities). In 2024, the sales volume is expected to remain the same as in 2023, and in subsequent years is expected to increase at a rate of about 3.5% per year for six years at which time the sales volume will be assumed to be level for the remainder of the life of the project. Coastal's profit is a function of the cost of oil when they sell to their own customers. A profit of 4.0% is added to the cost of oil. Initial planning shows the forecasted cost of oil to Coastal will be $85.00 per barrel (cost of goods sold), but you have seen recently in the news that oil prices have jumped all over the place. You believe that inflation and limited supply will probably cause the oil to go up in cost to Coastal by about 1.5% per year over a planning horizon of 20 years. Accounting says the effective tax rate for Coastal should be considered to be 30%, but you are concerned that this rate is dependent up the presidential administration in place. The company will need some working capital to sustain its operations for either alternative. A general formula for the level of working capital needed has been found to be about 12% of gross sales revenue forecasted for the year. This working capital is needed at the beginning of the year for which the forecast is made. The level of working capital needed will change depending on the forecasted change in sales revenue. You will need to calculate a schedule for the amount of working capital which will be needed over the 20 years of this project. Working capital is considered an additional necessary investment from after tax dollars, but is not tax deductible. In your cash flow analysis, you will need to distinguish between the following three types of expenditures: 1) expenses (which are tax deductible in the current year), 2) capital investments (which are "deductible" over multiple years through depreciation), and 3) working capital (which is like a capital investment, but is not deductible). Additional expenses for the project will include operating expenses, which are expected to be $525,000 per year to start, with an increase of 3.5% each year over the life of the project. (Note: depreciation is an expense for tax purposes only.) Your boss and Coastal Executive Management (CEM) expect you to complete the AFC within four weeks so they can make a timely decision. The AFC must clearly show the engineering economic analysis for the alternatives, clear recommendations for REM action, and an insightful uncertainty/sensitivity analysis that clearly shows under what conditions your recommendations to REM would be reversed. The results of your analyses and recommendations are to be presented in a professionally done, easy to read, comprehensive, written report. You will need to fully explain your results in text explanations and visuals, and not just provide tables of numbers.
Expert Answer:
Answer rating: 100% (QA)
The following is an Authorization for Capital AFC report that will enable Coastal management to make ... View the full answer
Related Book For
Statistics for Business and Economics
ISBN: 978-0321826237
12th edition
Authors: James T. McClave, P. George Benson, Terry T Sincich
Posted Date:
Students also viewed these accounting questions
-
More than 20 years after Costco opened its first warehouse club store in Seattle, Washington, the companys philosophy can still be summed up as pile em high, price em low. Costco stores are anything...
-
For more than 20 years, the Fed has used the federal funds rate as its monetary policy target. Why doesn't the Fed target the money supply at the same time?
-
Victor Hernandez had worked for more than 20 years as a custodian at a public power plant and had received training in health and safety rules from the Occupational Safety and Health Administration...
-
9. Let x = (1.11... 111000...) 26, in which the fractional part has 26 1's followed by O's. For the Marc-32, determine x, x+, f(x), x-xx-x, xx, and lx-fl(x)/x.
-
The Klein Corporation's marketing department, using regression analysis, estimates the firm's demand function, the result being Q = - 104 - 2.1P + 3.2I + 1.5A + 1.6Z R2 = 0.89 Standard error of...
-
Analyzing and Interpreting Income Manipulation Under the LIFO Inventory Method Atlantic Company sells electronic test equipment that it acquires from a foreign source. During the year 2011, the...
-
Consider the following cash flow profile, and assume MARR is 10 percent/year and the finance rate is 4 percent/year. a. Determine the MIRR for this project. b. Is this project economically...
-
Arabelle is considering expanding the floor area of her high-fashion import clothing store, The French Prints of Arabclle, by increasing her leased space in the upscale Cherry Creek Mall from 2,000...
-
Let the widget industry demand curve be given by P= 200 - Q, where Q is the industry output. There are two firms, Firm 1 and Firm 2. Each has a marginal cost of $20. 1. Assume that these two firms...
-
Dakota Company experienced the following events during Year 2: 1. Acquired $20,000 cash from the issue of common stock. 2. Paid $22,500 cash to purchase land. 3. Borrowed $8,000 cash. 4. Provided...
-
1. According to the fundamental assumption of statistical thermodynamics, the probability P(N, S) for a large N binary magnet system with spin excess 2s is given by P(N, s) = (/2 exp(-2). (a) Plot...
-
A test which investigates whether publicly available financial accounting information can be used to generate abnormal returns is a direct test of: Question 15 options: weak form market efficiency....
-
The Long-Term Debt Coverage Ratio tells consumers if they can meet their long-term debt obligations in relation to their current income. What is the recommendation for this ratio? More than 1 3 to 6...
-
What is a hostel? Select one: It is a home made with natural materials obtained from the environment. It is a place that offers refuge to pilgrims or care to vulnerable groups. It is a maritime or...
-
La nica forma de cumplir con la obligacin de la fraccin III del artculo 99 de la Ley del Impuesto sobre la Renta, los contribuyentes enviarn a sus trabajadores el CFDI en un archivo con el formato...
-
Cobra, Incorporated, a sporting goods retailer, estimates to sell 50,000 units in the next quarter. The beginning inventory is 4,000 units and ending inventory is estimated to be 20 percent of...
-
Obtain the marginal distributions of errors for module 1 and module 2 from the Table below. Recall that the marginal distributions are obtained by summing the rows (for X) and summing the columns...
-
The figure shows a bolted lap joint that uses SAE grade 8 bolts. The members are made of cold-drawn AISI 1040 steel. Find the safe tensile shear load F that can be applied to this connection if the...
-
In addition to the qualitative variable, use of ethics consultation in the future ("yes" or "no"), one of the quantitative variables measured in the survey of physicians was length of time in...
-
Find the rejection region for a test of independence of two classifications where the contingency table contains r rows and c columns. a. r = 5, c = 5, = .05 b. r = 3, c = 6, = .10 c. r = 2, c = 3,...
-
Behavioral Research in Accounting (January 2008) published a study of Machiavellian traits in accountants. Machiavellian describes negative character traits that include manipulation, cunning,...
-
A summary of the Balgreen Bowling Club's cash book is shown below. From it, and the additional information, you are to construct an income and expenditure account for the year ending 31 December...
-
Why do you think non-profit-oriented organizations prepare receipts and payments accounts when they have all this information in the cash book already?
-
The following trial balance of the Grampian Golf Club was extracted from the books as on 31 December 2016: (1) Bar purchases and sales were on a cash basis. Bar inventory at 31 December 2016 was...
Study smarter with the SolutionInn App