Find the NPV for Project B. The discount rate is 10% (0.10), the expected cash flow...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Find the NPV for Project B. The discount rate is 10% (0.10), the expected cash flow for year one is $50,000, the expected cash flow for year two is $25,000, and the cost of project is $40,000. First, find the present value using the financial function =NPV(discount rate, cash flow for year one, cash flow for year two) in cell B5. Then, find the NPV using the Excel formula for subtraction: present value-cost of project in cell B7. Use the NPV function to calculate the present value: NPV(discount rate, cash flow for year one, cash flow for year two) Find the NPV for Project B. The discount rate is 10% (0.10), the expected cash flow for year one is $50,000, the expected cash flow for year two is $25,000, and the cost of project is $40,000. First, find the present value using the financial function =NPV(discount rate, cash flow for year one, cash flow for year two) in cell B5. Then, find the NPV using the Excel formula for subtraction: present value-cost of project in cell B7. Use the NPV function to calculate the present value: NPV(discount rate, cash flow for year one, cash flow for year two)
Expert Answer:
Answer rating: 100% (QA)
Certainly To calculate the Net Present Value NPV for Project B with a ... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these finance questions
-
7) (i) If k is a positive integer, A is an eigenvalue of a matrix A, and v is a corresponding eigenvector, then A is an eigenvalue of A* and v is a corresponding eigenvector. (ii) use 6(i) to find...
-
Hazelnut Corporation manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $183,054 in overhead. The company has identified the following...
-
PROJECT STEPS 1. Lizzy is the manager of Cozy Movies, a small local movie theater that has been in business for a very long time. She would like to keep track of the theater's sales and expenses from...
-
Use the Ratio Test to determine the values of x 0 for which each series converges. 00 X' k=0
-
Cisco Systems, the networking equipment firm, reported a tax benefit from the exercise of stock options of $537 million in its fiscal 2004shareholders' equity statement. Over the previous years, the...
-
Simplify. Assume that all variables represent positive real numbers. V50+ V8
-
Maribel Baltazar was hired by clothing retail merchandiser Forever 21 in 2007. During the hiring process, Baltazar was given an 11-page document to sign, two pages of which contained an arbitration...
-
For Eckert Inc., variable manufacturing overhead costs are expected to be $20,000 in the first quarter of 2011, with $4,000 increments in each of the remaining three quarters. Fixed overhead costs...
-
Find the solution of the equation coth x = a, assuming that a > 1. Express the result in terms of elementary functions of a. [Hint: The result should have the form x = f(a), where f(a) is a specific...
-
An inexperienced accountant for Zoeng Company, Ltd. made the following errors in recording merchandising transactions. 1. A HK$1,750 refund to a customer for faulty merchandise was debited to Sales...
-
n Kyoto Sdn. Bhd. is a small manufacturing company in Perlis. Alex, the financial controller has been preparing aging schedules and found that company's invoices are not being sent out in a timely...
-
Create a statechart with multiple orthogonal states (similar to that in Figure 5.6 ) for the elevator control system.
-
For an MA(2) model, the parameters have been estimated as 1 = 0. 8 and 2 = 0. 45. Check whether the parameters pass the invertibility condition.
-
How much economic rent will a talented chef get?
-
Construct a simple P&L statement like the one shown in exhibit 5.5 and discuss its elements. Exhibit 5.5 Total revenues ($100 75,000) $7,500,000 Total variable costs ($28.18 x 75,000) 2,113,500 Total...
-
What is the meaning of a four-firm concentration ratio of 60 percent? 90 percent?
-
The rate law for the reaction 2NO( g ) + Cl 2 ( g ) ? 2NOCl( g ) is given by R = k [NO][Cl 2 ] If the following is the mechanism for the reaction, NO( g ) + Cl 2 ( g ) ? NOCl 2 ( g ) NOCl 2 ( g ) +...
-
Let X be a random variable taking on values a1, a2, . . . , pr with probabilities p1, p2, . . . , pr and with E(X) = μ. Define the spread of X as follows: This, like the standard deviation, is a...
-
Suppose you believe that the price of a particular stock goes up each day with probability p and goes down with probability 1 - p. You also believe the daily price changes are independent of one...
-
Your manufacturing process makes parts such that each part meets specifications with probability 0.98. You need a batch of 250 parts that meet specifications. How many parts must you produce to be at...
-
Based on past sales experience, an appliance store stocks five window air conditioner units for the coming week. No orders for additional air conditioners will be made until next week. The weekly...
-
One of the secondary aims of the PreEMPt study was to assess the safety of the prehabilitation exercise programme. A serious adverse event was defined as any adverse event or adverse reaction that...
-
What about the economic benefits of producing accounting information? Do you think it is easier, or harder, to assess the economic benefits of accounting information than to assess the costs of...
-
Can you think of at least four types of organisation that are not primarily concerned with making profits?
Study smarter with the SolutionInn App