What is the project payback period if the initial cost

Assignment Help Financial Management
Reference no: EM131088047

An investment project provides cash inflows of 200, 400, 670, 890, 1130, 1040, 880, 740, 530, 200, 110, 30 each year starting in year 1. What is the project payback period if the initial cost is $5,600? this must done in excel.

Reference no: EM131088047

Questions Cloud

Securities or creating distinctive two-factor portfolios : Jane is considering investing in three different securities or creating three distinctive two-factor portfolios. Determine, using the appropriate Excel function the covariances between securities A&B; B&C; A&C. Determine the betas Security A, a utili..
What is its self-supporting growth rate : Maggie's Muffins, Inc., generated $2,000,000 in sales during 2013, and its year-end total assets were $1,100,000. Also, at year-end 2013, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and ..
Vehicle expected life of three years as delivery vehicle : You are trying to pick the least-expensive car for your new delivery service. You have two choices: the Scion xA, which will cost $18,000 to purchase and which will have OCF of –$2,000 annually throughout the vehicle’s expected life of three years as..
Cash flows for three mutually exclusive projects : Consider the following cash flows for three mutually exclusive projects. What is the IRR of the project you should accept? Assume an interest rate of 12% Year A B C 0 −$950,000 −$1,790,000 -$1,000,000 1 370,000 800,000 660,000 2 510,000 800,000 550,0..
What is the project payback period if the initial cost : An investment project provides cash inflows of 200, 400, 670, 890, 1130, 1040, 880, 740, 530, 200, 110, 30 each year starting in year 1. What is the project payback period if the initial cost is $5,600? this must done in excel.
Risk-free rate have to for two stocks to be correctly priced : Stock Y has a beta of 1.2 and an expected return of 15.3 percent. Stock Z has a beta of 0.8 and an expected return of 10.7 percent. What would the risk-free rate have to be for the two stocks to be correctly priced?
Decision contradict the normal backwardation theory : Suppose the basis spread, S-F, is falling. How can you use this fundamental information to take an investment decision in iotions and swaps? Further, does your decision contradict the normal backwardation theory of keynes? why or why not?
What is the portfolio beta : You own a stock portfolio invested 24 percent in Stock Q, 21 percent in Stock R, 44 percent in Stock S, and 11 percent in Stock T. The betas for these four stocks are .86, .92, 1.32, and 1.77, respectively. What is the portfolio beta?
What is the effect on the stock price of an announcement : An unlevered firm has a market value of $10 million, with $1 million of its assets incash. With 500,000 shares outstanding, its current stock price is $20. Find the new stock price after the ex-dividend date. Under the assumptions of Modigliani-Mille..

Reviews

Write a Review

Financial Management Questions & Answers

  What is the present value of the interest payments on bond

Investment banks will oftentimes "split" the interest and principal payments on US government bonds into two parts and sell each part separately. Consider a vanilla government bond with 30 years to maturity, a coupon rate of 10 percent, a face value ..

  Use and ultimate sale of their primary residences

What are the three primary tax benefits homeowners enjoy in their purchase, use and ultimate sale of their primary residences?

  Annual interest rate on fixed rate

If the spot rate for Euro is .81 Euro is equal to 1 US $, and the annual interest rate on fixed rate one-year deposits of Euro is 2.5% and for US$ is 1.5%, what is the nine-month forward rate for one Euro in terms of dollars? Assuming the same intere..

  Estimate of the stocks current price

A company currently pays a dividend of $3.75 per share (D0 = $3.75). It is estimated that the company's dividend will grow at a rate of 21% per year for the next 2 years, then at a constant rate of 7% thereafter. The company's stock has a beta of 1.0..

  Firm pays out its excess cash as cash dividend

A firm has a market value equal to its book value. Currently, the firm has excess cash of $10,200 and other assets of $28,800. Equity is worth $39,000. The firm has 900 shares of stock outstanding and net income of $3,600. What will the stock price p..

  What is the net income

Last year, DJ's Soda Fountains, Inc. reported an ROE = 27 percent. The firm's debt ratio was 50 percent, sales were $9 million, and the capital intensity ratio was 1.5 times. What is the net income for DJ's last year?

  Outstanding puckett corporation bond-yield to maturity

It is now January 1st 2008 and you are considering the purchase of an outstanding Puckett corporation bond that was issued on January 1 2006. The Puckett bond has a 9.5 percent annual coupon and a 30-year original maturity (it matures on December 31,..

  Which security is considered more risky

Security A has a 9% expected return, 65% standard deviation. Security B has a 7% return, 50% standard deviation. Using standard deviation data alone, which security is considered more risky? You are looking at investing in SML Industries stock. Risk ..

  Security with no maturity-default or liquidity risk

An analyst is evaluating securities in a developing nation where the inflation rate is very high. As a result, the analyst has been warned not to ignore the cross-product between the real rate and inflation. If the real risk-free rate is 4.91% and in..

  Calculate the share price for bills bakery

Bill’s Bakery expects earnings per share of $3.22 next year. Current book value is $5.2 per share. The appropriate discount rate for Bill’s Bakery is 14 percent. Calculate the share price for Bill’s Bakery if earnings grow at 4 percent forever.

  Calculate the annual end of year loan payment amount

Messineo LLC borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal annual end of year payments. Calculate the annual end of year loan payment amount. Prepare a one page executive summary f..

  Future value for various compounding periods

You borrow $240,000; the annual loan payments are $36,552.05 for 30 years. What interest rate are you being charged? Round your answer to two decimal places. Find the amount to which $300 will grow under each of these conditions:

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