Calculate the projects npv and put it in appropriate cell

Assignment Help Financial Management

Reference no: EM131913875

Problem:

Suppose you have been asked to analyze the following capital expenditure proposal:

Your company is considering the purchase of a fleet of energy-efficient delivery trucks.

• The trucks will reduce annual expenses by $320,000.

• The trucks will require a total initial investment of $1 million.

• Their useful life is five years, at which time they will be sold for 10% of original cost.

• For tax purposes, the trucks will be depreciated using MACRS and are classified as 5-year property.

• The investment will have no effect on net working capital.

• The cost of capital is 16% and the marginal tax rate is 21%.

Now, suppose you have begun the cash flow analysis, which is shown below. Many numbers are missing.

	0	1	2	3	4	5
Savings		320,000	320,000	320,000	320,000	320,000
Depreciation
EBIT
Tax
Depreciation
OCF
Investment	(1,000,000)
ANWC	0					0
Salvage						100,000
Tax on Salvage
Free Cash Flow	(1,000,000)
Net Present Value
MACRS%		20.00%	32.00%	19.20%	11.52%	11.52%
NBV (Ad!. Tax Basis)
Discount Rote	16%
Tax Rate	21%
Salvage %	10%

Assignment:

A) Complete the spreadsheet by writing the missing numbers in the empty cells (the cells that are not grey).

B) Calculate the project's NPV and put it in the appropriate cell.

C) How much could the $100,000 salvage value decline before the NPV goes to zero? Answer:

Show your work for part (C) in a neat and organized manner on the back of this page. Your response should clearly show how you arrived at the answer. An iterative (trial-and-error) solution is not acceptable.

This assignment will be collected on Friday, March 30, and will count toward your quiz grade.

You may work with other people but you may not copy each other's work as doing so will be considered cheating.

Reference no: EM131913875

Questions Cloud

What are some layout impacts of technological breakthroughs : How has the use of the assembly line by the industry changed over time? What are some layout impacts of technological breakthroughs?

Volatility for stock increases the value of option on stock : Explain why an increase in volatility for a stock increases the value of an option on the stock.

Write a summary of the benefits of adopting nists rmf : Write a summary of the benefits of adopting NIST's RMF as the company's risk management framework for IT risk management.

Reasons for volatility in the stock market : Given the current scenario, what would be your advice to someone, who's in their 60's, and is interested in investing in stocks?

Calculate the projects npv and put it in appropriate cell : Complete the spreadsheet by writing the missing numbers in the empty cells. Calculate the project's NPV and put it in the appropriate cell.

Capital gain-yield to maturity remains unchanged : what will be the approximate capital gain of this bond over the next year if its yield to maturity remains unchanged?

Systematic risk and not total risk : Why do we contend that only systematic risk and not total risk is important?

What is an ideal value of k for the vehicle silhouettes data : What is an ideal value of k for the Vehicle Silhouettes data? This is a subjective and open-ended question.

Why the market value of an option is greater than zero : Explain why the market value of an option is greater than zero, even when the option is out-of-the-money.

User Account

All Pages