User Account

All Pages

Initial fixed asset investment

Assignment Help Finance Basics
Reference no: EM132185318

All answers must be entered as a formula in excel

1. Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life. The project is estimated to generate $2,190,000 in annual sales, with costs of $815,000. The project requires an initial investment in net working capital of $300,000, and the fixed asset will have a market value of $210,000 at the end of the project. What is the project's Year 0 net cash flow? Year 1? Year 2? Year 3? The tax rate is 21 percent. If the required return is 12 percent, what is the project's NPV?

Asset investment                    $         2,900,000

Estimated annual sales          $         2,190,000

Costs                                      $            815,000

Net working capital                 $            300,000

Pretax salvage value              $            210,000

Tax rate                                                          21%

Project and asset life                                       3

Required return                                              12%

Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to calculate the NPV.

Aftertax cash flow

Sales

Costs

Depreciation

EBT

Taxes

Net income

Capital spending

Net working capital

OCF

Net cash flow

NPV

Reference no: EM132185318

Questions Cloud

Define difference between mandatory and benchmark practices : What is the difference between mandatory and benchmark practices? In proper APA format, write a minimum of 2 paragraphs. The response must be typed.
Define how would you implement the different types of glass : You are the Executive Safety Officer (ESO) and was tasked to ensure that the facility is secure. In this assignment discuss "How does the different types.
Evaluate the efficiency and reliability : Evaluate the efficiency and reliability of both the most common nonpreemptive dispatch algorithms and the most common preemptive dispatch algorithms.
Explore what this means for consumers : Create a video on the given topic, so no need of the references, In your video, explore what this means for consumers
Initial fixed asset investment : Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million.
How can you avoid making the visual misleading : What are your most important considerations when you are composing a data visualization. List at least 3 considerations.
Create a hierarchy of given topics : Create a hierarchy of no more or no less than five (5) of the most important topics that you believe that a one-day course entitled "Advanced Computer.
Indifferent between accepting the project and rejecting : What is the NPV if the required return is 8 percent? What if it's 20 percent? At what discount rate would you be indifferent between accepting the project
Market value of the equity of thompson : The market value of the equity of Thompson, Inc. is $610,000. The balance sheet shows $39,000 in cash and $204,000 in debt, while the income statement has EBIT

Reviews

Write a Review

Finance Basics Questions & Answers

  Contract negotiations and risks and operating margins

In the scenario, the contract negotiations between North Creek Healthcare and the community hospital concluded with an agreement on non-financial (legal) terms. Suggest the most critical element of the contract and the impact to the short-term and..

  What is price printing company asset turnover

Price Printing Co. had sales of $10 million, operating income of $3 million, after-tax income of $1 million, assets of $8 million, stockholders'.

  Should mercy lease surgical device or borrow money

The before tax lease payments per year would be $90,000. The tax rate is 35%. From a financial perspective, should Mercy lease the surgical device or borrow the money to purchase it? Show your work.

  What is the times interest earned for this company

Sawaya Company had depreciation and amortization expenses of $522,311, interest expenses of $114,077, and an EBITDA of $1,521,087 for the year ended June 30, 2010. What is the Times Interest Earned for this company?

  Suppose the interest rate r is constant given s0 find the

suppose the interest rate r is constant. given s0 find the price s1 of the stock after one day such that the marking

  Calculate the expected value of the high risk project

Calculate the expected value of the high and low risk project to MarCher Industries' stockholders if the firm remains unlevered.

  Securities in developed and developing markets

What are the features of various financial securities in developed and developing markets?

  How many different schedules are there for eight customers

In how many different ways can he select the eight? As the salesman has to travel between customers, the order in which his visits are scheduled is important. How many different schedules are there for eight customers?

  What is the company operating cash flow

A company has a net income of 232,610, a tax rate of 35%, interest expense of 77,863, and depreciation expense of 95,313.

  An article reported the following data on oxygen

an article reported the following data on oxygen consumption mlkgmin for a sample of ten firefighters performing a

  What is the annual ocf for the project

Variable costs are 56 percent of sales, depreciation on the equipment to produce the new board will be $1,510,000 per year, and fixed costs are $1,410,000 per year.

  What is the volume hurdle

Instead of a sale management is considering a price increase to $59. What would be the maximum allowable loss in the number of units sold?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd