Using the Excel sheet you were sent, calculate the NV for all projects for three different discount
Fantastic news! We've Found the answer you've been seeking!
Question:
Using the Excel sheet you were sent, calculate the NV for all projects for three different discount rates:3%, 7% and 11%.
Transcribed Image Text:
A B Exhibit 1 The Investment Detective Project Free Cash Flows (in $ Thousands) Project Number 1 2 3 I 5 גן 6 19 N 100 Initial Investment ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) Year 1 $330 $1.666 $160 280 $2,200 $1,200 ($350) 2 330 334 200 280 900 -60 3 330 165 350 280 300 60 330 395 280 90 350 330 432 280 70 700 6 330 440 280 1,200 7 330 442 280 2,250 8 1,000 444 280 9 446 280 10 448 280 11 450 280 12 451 280 13 451 280 14 452 280 15 10,000 -2,000 280 Sum of Cash Flow Benefits $3,310 $2,165 $10,000 $3.561 $4,200 $2.200 $2,560 $4,150 Excess of Cash Flow Over Initial Investment $1.310 $165 $8.000 $1.561 $2,200 $200 $560 $2,150 A B Exhibit 1 The Investment Detective Project Free Cash Flows (in $ Thousands) Project Number 1 2 3 I 5 גן 6 19 N 100 Initial Investment ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) Year 1 $330 $1.666 $160 280 $2,200 $1,200 ($350) 2 330 334 200 280 900 -60 3 330 165 350 280 300 60 330 395 280 90 350 330 432 280 70 700 6 330 440 280 1,200 7 330 442 280 2,250 8 1,000 444 280 9 446 280 10 448 280 11 450 280 12 451 280 13 451 280 14 452 280 15 10,000 -2,000 280 Sum of Cash Flow Benefits $3,310 $2,165 $10,000 $3.561 $4,200 $2.200 $2,560 $4,150 Excess of Cash Flow Over Initial Investment $1.310 $165 $8.000 $1.561 $2,200 $200 $560 $2,150
Expert Answer:
Answer rating: 100% (QA)
To calculate the Net Present Value NPV for all projects in the Excel sheet provided for discount r... View the full answer
Related Book For
Valuation The Art and Science of Corporate Investment Decisions
ISBN: 978-0133479522
3rd edition
Authors: Sheridan Titman, John D. Martin
Posted Date:
Students also viewed these finance questions
-
What are some viewpoints on Interpreting three data sets of nursing home quality initiatives: Staff, Quality of Care, and Safety?
-
While in the community, Miss Nelson records whether or not Ethan is able to independently perform each step of the shopping task analysis. This is an example of what recording procedure? Question 46...
-
Jacks Tracks sells 24,000 custom-designed GoKarts per year. These GoKarts are sold evenly throughout the year. The manufacturer charges Jack a $50 processing cost per order, and Jack incurs a...
-
You are provided with the following information for Lazuris Enterprises, effective as of its April 30, 2017, year-end. Accounts payable ...................................................... $ 834...
-
Air enters the compressor of a Brayton cycle at 250 K and 0.1 MPa. The pressure ratio is 4 to 1 and the maximum cycle temperature is 1300 K. The compressor and turbine efficiencies are 0.85. Using...
-
Microsoft considers six principles important to the ethical development and deployment of AI: faimess, reliability and safety, privacy and security, inclusiveness, transparency, and accountability....
-
The manager of The Cheesecake Factory in Boston reports that on six randomly selected weekdays, the number of customers served was 120, 130, 100, 205, 185, and 220. She believes that the number of...
-
After considerable research, a winter products line has been developed. However, Silven's president has decided to introduce only one of the new products for this coming winter. If the product is a...
-
What is the overall effect on the consolidated financial statements if the FC is the functional currency instead of the USD? What is the impact on the subsidiary's liquidity, solvency and...
-
Exercise 6-18 (Algo) Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio [LO6-1, LO6-3, LO6-5, LO6-6, LO6-7] Menlo Company distributes a single product. The company's sales and expenses...
-
What is the NOI, Net Cash Flow, Return on Equity and Loan Constant for a multifamily apartment building, given the following information? Number of Units:200 1 Br.60 2 Br.100 3br.40 Average Base...
-
Consider the following three stocks and use the Index Model. Assume the expected excess return on the S&P500 is 0.07 and its variance is 0.023. Form the optimal risky portfolio. How much of the...
-
Makina Company manufactures engines on a cost-plus basis. The cost of a particular machine follows: Direct materials, P400,000; Direct Labor, P300,000; Supervisor's salary, P40,000; Fringe benefits...
-
Describe the differences between a traditional project manager and a product owner, this should include the characteristics and work they do.
-
1.How would a company's cost of capital calculated from book values be affected if the company's bonds were selling for more than face value? 4.Assume the issuer incurs $1 million in other expenses...
-
4. (20 pts) One aspect of software-defined data routing is to select a cost-optimal end-to-end path for data transport, where the per-hop link costs depend on the data-flow characteristics itself....
-
Read the Forecasting Supply Chain Demand Starbucks Corporation case in your text Operations and Supply Chain Management on pages 484-485, then address the four questions associated with the...
-
This chapter demonstrated that the requirement that new projects be accretive to firm EPS sometimes results in accepting negative NPV projects and rejecting positive NPV projects. Under more...
-
Sarah Fluggel is considering the purchase of a home located at 2121 Tarter Circle in Frisco, Texas. The home has 3,000 square feet of heated and cooled living area, and the current owners are asking...
-
Google Inc. of Mountain View, California, operates the most popular and power-ful search engine on the Web. The company went public using an unconventional Dutch auction method on August 19, 2004....
-
Skyway Inc. identified a cost pool related to material handling costs for its manufacturing process. Using historical data and ordinary least squares regression, Skyway summarized two different...
-
Assume that a manufacturing company is determining the optimal minimum level of cash to maintain in a financial institution to cover short-term needs. Separately consider each of the following...
-
Prior to the Tax Cuts and Jobs Act of 2018 (TCJA), multinational firms domiciled in the United States did not have to pay U.S. income taxes on foreign earnings, unless those earnings were returned...
Study smarter with the SolutionInn App