Calculate the net present value of an item

Reference no: EM1344626

I need to have my answer verified and to solve using a short formula if possible. The answer was not completed using Excel. Does using Excel help complete net present value problems? For the other 5 problems, calculate it by using .021.

Question #1 What is the net present value of an item that has a purchase price of $20,000, requires $1,000 maintenance at the end of each year except year 4, and is expected to have a salvage value of $1,000 at the end of the 5 year useful life?

Projected Salvage Value $1000 after 5 years
DF= 1 1 1 1 0.9013
(1+i)t (1+.021)5 (1.021)5 1.1095

t Cash Flow DF PV
0 $(20,000) 1.0000 $(20,000)
1 $(1,000) 0.9794 $(979)
2 $(1,000) 0.9593 $(959)
3 $(1,000) 0.9396 $(940)
4 $- 0.0000 $0
5 $(1,000) 0.9013 $(901)
5 $1,000 0.9013 $901

Reference no: EM1344626

Questions Cloud

Analysis of executive management team : Give a one to two page analysis summarizing the results to the executive management team of Omega.

What is the mechanical energy lost due to friction : Suppose an ideal gas is in a container 3L in volume and allowed to expand by having a piston move. The final volume after the piston moves is 15L. If the gas is at first at a pressure of 1×10^5 Pa and a temperature of 300 K, and temperature is mai..

Interpreting relationship between net income and cash flow : Kroger a retail grocery store chain growing at approximately the same rate as the population. Find each firm and explain your reasoning.

Find the magnitude and direction of elevator acceleration : Assume that we suddenly discovered that all these years we would be wrong about the distance from Earth to the Sun, and it is actually 10 percent greater than we would think. How would that affect our approximation of the distance to the Andromeda..

Calculate the net present value of an item : Calculate the net present value of an item that has a buying value of $20,000, needs $1,000 maintenance at the end of each year except year 4.

Benefits of organized securities exchanges : What major benefits do corporations and investors enjoy due to the existence of organized security exchanges?

How long does it take to double your money : Explain how much will your collection be worth when you retire in 2058, assuming they appreciate at an annual rate of 6.1%

How long does it take for the last car to come : Do you agree with IBM's employment response to competition from software development contractors in India, like Wipro, that are expanding into IT consulting services? Why or why not.

Creating use case to describe typical sales process : Create use case to describe a typical sales process. Then make a sequence diagram for use case.

User Account

All Pages