[SOLVED] Prepare the simulation using a spreadsheet;

> Determine the required before-tax rate of return if an after-tax return of 9% per year is expected and the state and local tax rates total 6%. The effective federal tax rate is 35%.

> Determine (a) the before-tax ROR, and (b) approximate after-tax ROR for a project that has a first cost of $750,000, a salvage value of 25% of the first cost after 3 years, and annual (GI-OE) of $260,000. Assume the company has a Te of 37%.

> Dupont is considering licensing a low liquid discharge (LLD) water treatment system from a small company that developed the process and owns the license. Dupont can purchase a 1-year option for $100,000 that will provide time to pilot test the LLD proces

> Last month, HighPower, which specializes in wind power plant design and engineering, made a capital investment of $400,000 in physical simulation equipment that will be used for at least 5 years, then sold for approximately 25% of the first cost. By law,

> An in-place machine with B = $120,000 was depreciated by MACRS over a 3-year period. The machine was sold for $60,000 at the end of year 2 when the company decided to import the item that required the use of the machine. In year 2, GI = $1.4 million and

> If alternative 1A served 100% of the households instead of 95%, by how much would the monthly household cost decrease?

> In what alternative evaluation is it considered important that an anticipated capital loss (CL) on an in-place asset should be included in an after-tax analysis? Why?

> An asset purchased for $100,000 with S = $20,000 after 5 years was depreciated using the 5-year MACRS rates. Expenses averaged $18,000 per year and the effective tax rate is 30%. The asset was actually sold after 5 years of service for $22,000. MACRS rat

> The after-tax analysis for a $60,000 investment with associated gross income minus expenses (GI â OE) is shown below for the first 2 years only. If the effective tax rate is 40%, the values for depreciation D, taxable income TI, and tax

> A contractor who files as unmarried (single) to the IRS has an effective tax rate of 28%. His gross income is $155,000, other income is $4000, personal expenses are $45,000, and deductions and exemptions are $12,000. His total income tax due is closest t

> An after-market auto parts company sells a machining robot that had been depreciated to zero for $16,000. If the company’s effective tax rate is 36%, the sale will: (a) Increase the company’s taxes by $16,000 (b) Increase the company’s taxes by $5760 (c)

> A small manufacturing company with a gross income of $360,000 has the following operating expenses: M&O = $76,000, insurance = $7000, labor = $110,000, utilities = $29,000, debt service = $37,000, and taxes = $9000. The net operating income (NOI) is clos

> Pennington Oil is in the 50% effective tax bracket. It had gross income of $470 million in each of the last 2 years. In the first year, deductions were $160 million. In the second year, deductions were lower at $120 million. The difference in income taxe

> A capital gain is calculated by the equation: (a) Capital gain = book value – selling price (b) Capital gain = book value – first cost (c) Capital gain = market value – selling price (d) Capital gain = selling price – first cost

> Depreciation recapture occurs when a depreciable asset is sold for: (a) More than the current book value (b) More than the current market value (c) More than the estimated salvage value (d) More than the first cost

> All of the following are characteristics of a value added tax system, except: (a) Value-added taxes are taxes on consumption (b) The end user pays value-added taxes (c) Value-added taxes are charged at each stage of product development (d) Value-added ta

> Are the PW values for Plans A and B sensitive to changes in the MARR?

> A graduated income tax system means: (a) Only taxable incomes above a certain level pay any taxes (b) A higher flat rate goes with all of the taxable income (c) Higher tax rates go with higher taxable incomes (d) Rates are indexed each year to keep up wi

> If all values carry a + sign, cash flow before taxes (CFBT) is represented by the equation: (a) Gross income – operating expenses – depreciation – initial investment + salvage value (b) Gross income – operating expenses – depreciation + salvage value (c)

> If the federal tax rate is 36% and the state tax rate is 7%, the effective tax rate is closest to: (a) 40.5% (b) 37.3% (c) 35.4% (d) 31.8%

> If the after-tax ROR is 11.4% and the corporate Te is 39%, the approximate before-tax rate of return is closest to: (a) 6.8% (b) 15.4% (c) 18.7% (d) 19.7%

> Ajinkya Electronic Systems, a company in India that manufactures many different electronic products, has to purchase goods and services from a variety of suppliers (wire, diodes, LED displays, plastic components, etc.). The table below shows several supp

> Is the breakeven point for the first cost of Plan A sensitive to the changes in MARR as business goes from vigorous to receding?

> In Denmark, VAT is applied at a rate of 25%, with few exceptions. If vendor A sells raw materials to vendor B for $60,000 plus VAT, and vendor B sells a product to vendor C for $130,000 plus VAT, and vendor C sells an improved product to an enduser for $

> What is the primary difference between a sales tax and a value-added tax?

> For the decision tree branch shown, determine the expected values of the two outcomes if decision D3 is already selected and the maximum outcome value is sought. (This decision branch is part of a larger tree.)

> Calculate the expected flow rate (barrels per day) for each oil well using the estimated probabilities.

> A-Z Technologies, a manufacturer of amplified pressure transducers, is trying to decide between a dual-speed and a variable-speed machine. The engineers are not sure about the salvage value of the variable speed machine, so they have asked several differ

> Nationwide income from monthly sales data (rounded to the nearest $100,000) of Stay Flat vacuum hold-down tables for last year was collected. Estimate the expected value of monthly income if economic conditions remain the same. Income, $/Month

> An asset with a first cost of $300,000 is depreciated by the MACRS method using a 5-year recovery period. Determine the economic value added in year 2, if the net operating profit after taxes is $70,000 and the company uses an after-tax MARR of 15% per y

> (a) What does the term economic value added (EVA) mean relative to the bottom line of a corporation? (b) Why might an investor in a public corporation prefer to use the EVA estimates over the CFAT estimates for a project?

> The variable Y is defined by the relation 3n for n = 1, 2, 3, 4 with probabilities of 0.4, 0.3, 0.233, and 0.067, respectively. Determine the expected value of Y.

> Thermtech Science has performed an economic analysis of proposed service in a new region of the country. The three-estimate approach to sensitivity analysis has been applied. The optimistic and pessimistic values each have an estimated 15% chance of occu

> Are the PW values sensitive to varying life estimates?

> The cost of flood damage from significant storms varies as a function of the severity of the storm. Estimate the expected flood damage due to the next significant storm.

> In the recent past, the production output has been between 10,000 and 20,000 units per week 75% of the time; however, it may fall below 10,000 or go above 20,000 more frequently in the future. The production manager wants to use E(output) to make a decis

> For each situation below, determine (1) if the variable(s) is(are) discrete or continuous, and (2) if the information involves certainty, risk, and/or uncertainty. (a) A friend in real estate tells you the price per square foot for new houses will go up

> Identify the following variables as either discrete or continuous: (a) The number of times heads comes up in 100 tosses of a coin (b) The number of accidents occurring in a specified section of a freeway (c) The weight of boxes shipped from an Amazon war

> The defender in a multiple-effect solar cell manufacturing plant has a market value of $130,000 and expected annual operating costs of $70,000 with no salvage value after its remaining life of 3 years. The depreciation charges for the next 3 years will b

> The last annual report of Harrison Engineering’s 3-D Imaging Division showed GI = $4.9 million, OE = $2.1 million, and D = $1.4 million. If the average federal tax rate is 31% and state/local tax rates total 9.8%, estimate (a) federal income taxes, and (

> Four mutually exclusive alternatives are evaluated using three estimates or strategies (pessimistic, most likely, and optimistic) for several parameters. The resulting PW values over the LCM are determined as shown. If none of the strategies is more like

> Four mutually exclusive alternatives are evaluated using three estimates or strategies (pessimistic, most likely, and optimistic) for several parameters. The resulting PW values over the LCM are determined as shown. The best alternative to select under t

> A real options analysis is most valuable when: (a) The risk is low and stakes are high (b) The stakes are low and risk is high (c) The stakes are high and risk is high (d) The stakes are low and risk is low

> A decision tree includes all of the following except: (a) Probability estimates for each outcome (b) Measure of worth as the selection criterion (c) Expected results from a decision at each stage (d) The MARR

> A recent sensitivity analysis of a public works project indicates that the expected present worth is $83,000. If there is a 20% chance that the PW will be the pessimistic one of $45,000 and 50% chance that it will be the most likely one of $72,000, the o

> Revenue into the general fund of the state of Texas for any biennium is highly dependent on the price of oil. At a price average of $50 per barrel, general revenue will be $95 billion. At $68 and $75 per barrel, the revenue will be $118 billion and $125

> When conducting a sensitivity analysis using three estimates for each parameter, all of the following are estimates that should be made, except: (a) Pessimistic (b) Improbable (c) Optimistic (d) Most likely

> When the sensitivity of several parameters is considered for one alternative using a single measure of worth and the measure of worth is plotted against percentage change for each parameter, the resulting graph is called a: (a) Spider graph (b) Distribut

> In conducting a sensitivity analysis of a proposed project, the present worth values of $–10,000, $40,000, and $50,000 were believed to have chances of 25%, 40%, and 35%, respectively. The expected PW is closest to: (a) $19,000 (b) $26,000 (c) $28,500 (d

> When the measure of worth is plotted versus percentage change for several parameters, the parameter that is the most sensitive in the economic analysis is the one: (a) That has the steepest curve (b) That has the flattest curve (c) With the largest prese

> All of the following are steps in the procedure for conducting a sensitivity analysis, except: (a) Determine which parameters might vary from the most likely estimated value (b) Change the parameters in the range of −100% to +100% (c) Select a measure of

> In evaluating the sensitivity of an alternative to its first cost, its AW was calculated for changes in the estimated first cost by –10%, +5%, and +15%. The resulting AW values were $+21,000, $–2410, and $–34,000, respectively. On the basis of these valu

> Freeman Engineering paid $28,500 for specialized equipment for use with their new GPS/GIS system. The equipment was depreciated over a 3-year recovery period using MACRS depreciation. The company sold the equipment after 2 years for $5000 when it purchas

> A couple of years ago, the company Health4All purchased land, a building, and two depreciable assets from another corporation. These have all recently been disposed of. Use the information shown to determine the presence and amount of any capital gain, c

> After deciding on the 50-50 split of debt and equity financing, Charles wants to know what additional bottomline contributions to the economic worth of the company may be added by the new Victoria site. What are the best estimates at this time?

> Global Foundries (GF), a privately held company that invests in companies producing essential components for high-volume data storage, is valued at $4.0 billion dollars. A computer company that wants to get into cloud computing is considering the purchas

> A touch-sensitive assembly robot that costs $300,000 had a depreciable life of 5 years with an expected $50,000 salvage value when purchased 3 years ago. Using MACRS depreciation, determine any DR, CG, or CL if the company sold the robot after 3 years fo

> (a) Use the RAND function in Excel© to generate 100 values from a U(0,1) distribution. Calculate the average and compare it to 0.5, the expected value for a random sample between 0 and 1. (b) For the RAND function sample, cluster the results into cells o

> The dispersion of values about the sample average is represented by the: (a) Variance (b) Expected value (c) Probability distribution (d) Standard deviation

> A survey of the types of cars parked at an NFL football stadium revealed that there were equal probabilities of finding cars identified as Type A, B, C, and D. If Type A cars were assigned random numbers 0 through 24, Type B numbers 25 through 49, Type C

> The net revenue from a candy product called Mummies- Lite has averaged $15,000 per month for the past 12 months. If the value of Σ(Xi −X )2 is $4,680,000, the standard deviation value is closest to: (a) $381 (b) $652 (c) $958 (d) $1265

> For the income and probability values shown, the probability that the income in any year will be greater than $8500 is closest to: (a) 0.38 (b) 0.49 (c) 0.70 (d) 0.92

> The following temperatures (in oF) were recorded inside the building of a remote pumping station: 99, 87, 93, 90, and 96. The variance of these readings is closest to: (a) 11.7 (b) 22.5 (c) 31.1 (d) 38.6

> In a table of two-digit random numbers, the probabilities of 0.16 to 0.20 can be represented by the numbers: (a) 16 to 20 (b) 0 to 4 (c) 1 to 5 (d) 15 to 19

> The shipping costs for fresh fruit items have been estimated and assigned the probabilities shown below. The expected value of the shipping costs is closest to: (a) $36.33 (b) $39.21 (c) $41.28 (d) $45.11

> Charles noticed that the CFAT total and PW values go in opposite directions as the equity percentage increases. He wants to know why this phenomenon occurs. How should you explain this to Charles?

> When there are at least two values for a parameter and it is not possible to estimate the chance that each may occur, this situation is known as: (a) Uncertain (b) Risk (c) Deterministic (d) Cost estimating

> When single-value or single-point estimates are used exclusively in an economic analysis, the decision-making process is said to be: (a) Probabilistic (b) Uncertain (c) Deterministic (d) Monte Carlo

> Equipment associated with manufacturing small railcars had a first cost of $180,000 with an expected salvage value of $30,000 at the end of its 5-year life. The revenue was $620,000 in year 2, with operating expenses of $98,000. If the company’s effectiv

> Explain why minimizing PW of taxes is equivalent to maximizing PW of depreciation when corporate taxes are calculated.

> There are four estimates made for the anticipated cycle time to produce a subcomponent. The estimates, in seconds, are 10, 20, 30, and 70. If the first two estimates have equal weights, which total 70%, and the last two are weighted equally with the rema

> A discrete variable T can take on integer values of 1 to 5. A sample of size 100 results in the following probability estimates: (a) Use the 40 random numbers (RN) below to estimate the probabilities for each value of T, and (b) determine the sample prob

> An online patient diagnostics system for surgeons has the following point estimates: A first cost of $200,000 to install and $5000 annually to maintain over its expected life of 5 years. Added revenue is estimated to average $60,000 per year. Examine the

> Estimate the gross income for Lopez Enterprises when it had a CFAT of $2.5 million, $900,000 in expenses, $900,000 in depreciation charges, and an effective tax rate of 26.4%.

> Observe the changes in the total 6-year CFAT as the D-E percentages change. If the time value of money is neglected, what is the constant amount by which this sum changes for every 10% increase in equity funding?

> Knorr & Associates paid total taxes of $72,000 in the first year of their consulting business. (a) What was the company’s taxable income? (b) What was the average tax rate? (c) What was the estimated NOPAT for the year?

> If PSK Engineering had a CFAT of $750,000, charged depreciation of $400,000, and had a Te of 36%, what was PSK’s CFBT?

> MAG Industrial needs 1000 square meters of storage space. Purchasing land for $80,000 and erecting a temporary metal building at $70 per square meter is one option. The president expects to sell the land for $100,000 and the building for $20,000 after 3

> Hemisphere Electric may purchase equipment to manufacture a new line of wireless devices for home appliance control. The first cost will be $80,000, and the life is estimated at 6 years with a salvage value of $10,000. Different people in marketing have

> The AW of the current process to make motion controllers is $–62,000 per year. A replacement process under consideration has estimates of P = $64,000, AOC = $38,000, and n = 3 years. Three engineers have given their opinions about what the salvage value

> A company that manufactures high-speed submersible rotary-indexing spindles is considering an upgrade of production equipment to reduce costs over the next 5 years. The company can invest $80,000 now, 1 year from now, or 2 years from now. Depending on wh

> For a corporation that has a taxable income of $250,000, determine (a) the marginal tax rate, (b) the total taxes, and (c) the average tax rate.

> Over a 1-week period, an officer of the state lottery commission sampled ticket purchasers at a single high-traffic location. The amounts labeled W for winnings, distributed back to the purchasers/ winners, and the associated probabilities for 5000 ticke

> An engineer collected monthly operating expenses for the past 3 years for a micro-finishing department. Use the midpoints of each range in preparing your answers. (a) Develop a plot of the probability distribution by hand or using a spreadsheet, as instr

> Royalties received by an investor in an oil well vary according to the price of oil. Data collected from stripper wells in a West Texas oilfield were used to develop the royalty probability relationships shown. (a) Is the variable discrete or continuous

> Repeat Problem 19.26, except use the normal distribution for the CFAT in years 7 through 10 with an expected value of $2 million and a standard deviation of $500,000. Problem 19.26: Jennifer, a senior project manager, estimated net cash flow after taxes

> Jennifer, a senior project manager, estimated net cash flow after taxes (CFAT) for a large project she is working on. The additional CFAT of $2,800,000 in year 10 is the salvage value, estimated at 9% of the $31 million first cost for all capital assets.

> Estimate the CFAT for a company that has taxable income of $120,000, depreciation of $133,350, and an effective tax rate of 35%.

> A newsstand manager is tracking Y, the number of weekly magazines left on the shelf when the new edition is delivered. Data collected over a 30-week period are summarized by the following probability distribution. Use a spreadsheet to plot the distributi

> Calculate the expected value of the variable N in Problem 19.10. Problem 19.10: Bob is working on two separate probabilityrelated projects. The first involves the variable N, which is the number of consecutively filled bottles of an anticancer drug that

> (a) Use the relations in Section 19.4 for continuous variables to determine the expected value and standard deviation for the distribution of f(DY) in Problem 19.11. (b) It is possible to calculate the probability of a continuous variable Y between two p

> A discrete variable Q, extra inventory units, has integer values from 1 to 10. When sampled 100 times, the following observed probability distribution was obtained: (a) Determine the sample average and standard deviation by hand. (b) Determine the sample

> Monthly maintenance costs, MC, for conveyor belts in an airport’s centralized baggage collection and distribution facility are clustered into cell midpoints with associated frequencies as shown. (a) Estimate the expected value and standard deviation of

Question: Prepare the simulation using a spreadsheet;