Depreciation Calculation | |
Purchase cost of asset | 110,000 |
Add Installation charge | 25,000 |
Total Asset value | 135,000 |
Less Salvage value estimated | 24,000 |
Depreciable Value | 111,000 |
Asset life in years | 6 |
Annual Depreciation = | 18,500 |
Actual Salvage value after 6 yrs | 34,000 |
Capital Gain from asset sale after 6 yrs | 10,000 |
Tax on Capital Gain @25% | 2,500 |
Present Worth/NPV Calculation | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | |
Initial Investment | ||||||||
Capital Asset cost | (135,000) | |||||||
a | Total initial Investment | |||||||
Cash flow from operations | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | ||
Annual Revenue | ||||||||
O&M expenses | 6,000 | 7,000 | 8,000 | 9,000 | 10,000 | 11,000 | ||
Depreciation expense | 18,500 | 18,500 | 18,500 | 18,500 | 18,500 | 18,500 | ||
EBT | 500 | (500) | (1,500) | (2,500) | (3,500) | (4,500) | ||
Tax @25% | 125 | (125) | (375) | (625) | (875) | (1,125) | ||
Post Tax income | 375 | (375) | (1,125) | (1,875) | (2,625) | (3,375) | ||
Add back Depreciation | 18,500 | 18,500 | 18,500 | 18,500 | 18,500 | 18,500 | ||
b | Cash flow from Operations | 18,875 | 18,125 | 17,375 | 16,625 | 15,875 | 15,125 | |
Terminal Value | ||||||||
Salvage value less Tax on Capital gain | 31,500 | |||||||
c | Total Terminal Cash flow | 31,500 | ||||||
d | Total After Tax cash flows =a+b+c= | (135,000) | 18,875 | 18,125 | 17,375 | 16,625 | 15,875 | 46,625 |
e | PV factor @ 15% =1/1.15^n | 1 | 0.8696 | 0.7561 | 0.6575 | 0.5718 | 0.4972 | 0.4323 |
f | PV of Cash flows | (135,000) | 16,414 | 13,704 | 11,424 | 9,506 | 7,893 | 20,156 |
g | Present worth =NPV =Sum of PV of cash flows= | (55,903) | Ans b. | |||||
Ans c. |
If before tax present worth is -$67009, then the before tax PV of incremental sales revenue need to be $67,010 to have positive NPV/PW and |
the purchase can be justified. The PVIF value for 6 years @15% is 3.7845 |
Assume that annual sales increase required =x |
So x*3.7845=67010 |
x=17,706.43 |
So the annual sales to be increased by $17,716.43 so that the asset purchase can be justified. |
A company is considering the purchase of a capital asset for $110,000. Installation charges needed to...
A geometric gradient that increases at f= 8% per year for 14 years is shown in the accompanying diagram. The annual interest rate is 15%. What is the present equivalent value of this gradient? Click the icon to view the diagram for geometric gradient values. B) Click the icon to view the interest and annuity table for discrete compounding when i = 8% ner vear The present equivalent value of the gradient is $ . (Round to the nearest dollar.)...
Your company has just signed a three-year nonrenewable contract with the city of New Orleans for earthmoving work. You are investigating the purchase of heavy construction equipment for this job. The equipment costs $201,000 and qualifies for five-year MACRS depreciation. At the end of the three-year contract, you expect to be able to sell the equipment for $80,000. If the projected operating expense for the equipment is $63,000 per year, what is the after-tax equivalent uniform annual cost (EUAC) of...
The replacement of a planning machine is being considered by the Reardorn Furniture Company. (There is an indefinite future need for this type of machine.) The best challenger will cost $29,000 for installation and will have an estimated economic life of 12 years and a $2,200 MV at that time. It is estimated that annual expenses will average $11,000 per year. The defender has a present BV of $5,000 and a present MV of $3500. Data for the defender for...
The replacement of a planning machine is being
considered by the Reardom furniture company. the best challenger
will cost 32,000 for installation and will have an estimated
economic life of 11 years and a 1,500 MV at that time. it is
estimated that annual expenses will average 12,000 per year. the
defender has a present bv of 5,500 and a present mv of 4000. data
for the defender for the next three years are given below. using a
before tax...
Problem 12-12 (algorithmic) The tree diagram in figure below describes the uncertain cash flows for an engineering project. The analysis period is two years, and MARR 15 % per year . Based on this information, a. What are the E(PW), V(PW), and SD(PW) of the project? b. What is the probability that PW 20? Click the icon to view the tree diagram. Click the icon to view the interest and annuity table for discrete compounding when the MARR is 15...
Consider the following investment project. Calculate the net future worth of this investment at 15% and determine the acceptability of the investment An - $69,000 29,800 30,800 21,400 21,400 24,000 Click the icon to view the interest factors for discrete compounding when i 15% per year. The net future worth of this investment will be thousand. (Round to one decimal place.) Is the investment acceptable? Choose the correct answer below. o Yes O No Single Payment Compound Present Amount Worth...
Football Comm LLC is a manufacturer of devices for football coaches and their coaching staffs that enables them to quickly and effectively communicate with one another during a game through a wireless sideline headset system. Currently, the company purchases all of the headsets included in their systems from a China-based supplier, but they have experienced a significant decrease in overall headset quality. To correct the problem, the company is considering producing their own headsets in-house The company estimates that the...
Problem 12-2 (algorithmic) Question Help part of a new road. An analysis has shown that traffic density on the new road will justify a two-lane bridge at the present time. Because of uncertainty regarding future use of the structed n fhaving to widen the bridge to four lanes at various times in the future are as follows: Probability d. the time at which an extra two lanes will be required is currently being studied. The estimated probabilities Widen Bridge In...
Acme Delivery is considering a proposal for new package tracking technology. The system has an estimated initial cost of $1.9 million and will require upgrades and maintenance of $140,000 each year. Acme estimates that improved tracking will save approximately $680,000 per year. Acme has a MARR of 15% per year, and the study period for this technology is 6 years, after which time Acme expects the entire system will need to be replaced Determine how sensitive the decision to invest...
A company is considering investing $15,000 in a heat exchanger. The heat exchanger will last five years, at which time it will be sold for $2,000. The maintenance cost at the end of the first year is estimated to be $1,000 Maintenance costs for the exchanger are estimated to increase by $1,000 per year over its life. As an alternative, the company may lease the equipment for $X per year, including maintenance, with the annual payments to made at the...