Calculate the project cash outflow in initial outlay

Assignment Help Finance Basics
Reference no: EM131237256

Assignment- Capital Budgeting

• Open a new (fresh) excel workbook to perform you calculations.
• You are allowed only one submission, so please make sure it is the correct one.
• Work independently and do not use class exercise template (or any other template)
• This assignment is due before midnight on 10/8

Consider the following project being evaluated by your company:

• Initial price of the asset is $200,000 will require $15,000 transportation and $5,000 installation.
• Will be depreciated S/L over 4 years to a $5,000 salvage.
• Market value for the asset at end of 5 years is expected to be $12,000 (the asset will be operated for 5 years)
• Net investment in NWC in year 0 (at the initial period) of $30,000
• Sales, first year, expected to be generated by the project $130,000
• Annual cost of goods sold 60% of sales
• Annual sales growth rate 4%
• Marginal tax rate 30%
• Cost of capital 10%

1) Calculate the project cash outflow in year 0 (initial outlay)
2) Calculate annual operating cash flows for year 1-5 (OCF)
3) Calculate the project's terminal cash flow in year 5 (TCF)
4) Calculate the project's NPV, IRR

Reference no: EM131237256

Questions Cloud

Prove the result in given equation : Prove the result in equation. - a portfolio consisting of a European call plus an amount of cash equal to D þ K, and a portfolio consisting of an American put option plus one share.
What determines the phase of a substance : Why does a vinyl or tile floor feel colder to the bare feet than does a rug, even though both are in contact and at the same temperature? What determines the phase of a substance?
Describe the concepts of groupthink and focalism : Describe the concepts of groupthink and focalism and the similarities and differences that exist between the two.
What makes a substance a conductor or an insulator : Compare the SI units of specific heat and latent heat and explain any differences. Give two examples each of good thermal conductors and good thermal insulators. In general, what makes a substance a conductor or an insulator?
Calculate the project cash outflow in initial outlay : Calculate the project cash outflow in year 0 (initial outlay). Calculate annual operating cash flows for year 1-5 (OCF). Calculate the project's terminal cash flow in year 5 (TCF). Calculate the project's NPV, IRR.
At what temperature (fahrenheit) should the oven be set : While in Europe, a tourist hears on the radio that the temperature that day will reach a high of 17°C. What is this temperature on the Fahrenheit scale? A recipe calls for a cake to be baked at 180°C. At what temperature (Fahrenheit) should the ov..
Structural unemployment something macroeconomic policymakers : Is structural unemployment something macroeconomic policymakers should be concerned about?How does it differ from cyclical unemployment?
Implementation of a security plan : You need to provide the selected organisation with the necessary guidelines for implementation of a security plan based on four main components outlined above
What is this temperature on the fahrenheit scale : Normal room temperature is about 68°F. What is the equivalent temperature on the Celsius scale? A person running a fever has a temperature of 39.4°C. What is this temperature on the Fahrenheit scale?

Reviews

Write a Review

Finance Basics Questions & Answers

  Define the term self-supporting growth rate

Define the term self-supporting growth rate. What is Hatfield's self-supporting growth rate? Would the self-supporting growth rate be affected by a change in the capital intensity ratio or the other factors mentioned in the previous question? ..

  Selecting useful financial ratios

Suppose you are an upper-level manager in a company. Which financial ratios would you consider most useful? Would these ratios be different than the ones you would consider useful as an investor?

  Calculate the net present value (npv)

Calculate the net present value (NPV) for the following 20-year projects. Comment on the acceptability of each. Assume that the firm has an opportunity cost of 14%.

  What is the coupon rate on the bonds

A firm has bonds on the market with 9 years to maturity, YTM of 7.1% and a current price of $915. The bonds make semiannual payments. What is the coupon rate on the bonds?

  Compare the calculated financial ratios against the industry

Compare the calculated financial ratios against the industry benchmarks for the industry of your assigned company

  How much would you have to invest now to meet your goal

An investment opportunity offers to pay out $116 two years for now. In order to receive this payout, you must invest $81 today. What annual rate of return is this investment offering? Put your answer in decimal form and round to four decimal pl..

  Determine the total cost to company

Pension Fund project which will be offered in 5 years, company purchases zero coupon U.S. Treasury Trust Certificates which mature in five years, when originally issued they were 12 percent coupons.

  How the u.s. financial markets impact the economy

Describe how the U.S. financial markets impact the economy, businesses and individuals. Explain the role of the U.S. federal reserve, the federal reserve chairman, the board, indicating it's effectiveness in today's ecnomic environment, provide su..

  What is the clinic dollar growth in assets during 2012

What is the clinic's dollar growth in assets during 2012, and how is the growth financed?

  Present value-pv of multiple cash flows

Present value: Tommie Harris is considering an investment that pays 6.5 percent annually. How much must he invest today such that he will have $25,000 in seven years? (Round to the nearest dollar.)

  Calculate the values for the four formulas

Assume that total fixed cost equals $1,000,000. Calculate the values for the following four formulas:

  Identify and explain the four factors that influence asset

answer each of the 2 essay questions below with a response that is at least 300 words in length. the total submission

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!

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