Reference no: EM131052281
Cochrane, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2,430,000. The fixed asset falls into the three-year MACRS class (MACRS Table). The project is estimated to generate $2,260,000 in annual sales, with costs of $1,250,000. The project requires an initial investment in net working capital of $161,000, and the fixed asset will have a market value of $186,000 at the end of the project. Assume that the tax rate is 40 percent and the required return on the project is 8 percent.
Requirement 1: What is the net cash flow of the project for the following years? (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers in dollars, not millions of dollars (e.g., 1,234,567). Round your answers to 2decimal places (e.g., 32.16).)
Requirement 2: What is the NPV of the project? (Enter rounded answer as directed, but do not use rounded numbers in intermediate calculations. Enter your answer in dollars, not millions of dollars (e.g., 1,234,567). Round your answer to 2 decimal places (e.g., 32.16).)
Need to know how I would go about setting this up in excel.
|
Calculate the outstanding loan balance immediately
: A loan is amortized over five years with monthly payments (i.e. end of month) at an annual nominal interest rate of 5% compounded monthly. The first payment is 500 and is to be paid one month from the date of the loan. Each succeeding monthly payment..
|
|
What is the bonds yield to maturity
: Yield to maturity a bonds market price is $800. it has a !1,000 par value, will mature in 8 yrs, and has a coupon interest rate of 11 % annual interest, but makes its interest payments semi-annually. What is the bonds yield to maturity?
|
|
Explain how accounts payable affects external funds required
: There is an expression that it is best to operate a business using “other people’s money.” Given that other people’s money is reflected in accounts payable, explain how accounts payable affects the external funds required (EFR).
|
|
What is present value of perpetuity
: After grad you worked on Wall Street made. Fortune & now wish to endow a professorship here at Morgan. You'd like endowment to pay 10000 forever. If appropriate interest rate is 6.7% what is the present value of perpetuity?
|
|
What is the net cash flow of the project
: Cochrane, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2,430,000. The fixed asset falls into the three-year MACRS class (MACRS Table). The project is estimated to generate $2,260,000 in a..
|
|
Entire balance in her account to invest in investment
: Beverly Hills started a paper route on January 1, 2009. Every three months, she deposits $550 in her bank account, which earns 8 percent annually but is compounded quarterly. How much will she have on December 31, 2015? Use Appendix A and Appendix C ..
|
|
What were the other administrative expenses
: The New Fund had average daily assets of $2.6 billion in the past year. New Fund’s expense ratio was 1.5% and the management fee was 1.0%. What were the total fees paid to the fund’s investment managers during the year? What were the other administra..
|
|
Common stock valuation problem
: COMMON STOCK VALUATION PROBLEM The Fast-Growth Company recently paid a dividend of $3.20 per share. Analysts expect the dividend to grow at the rate of 28% per year for 3 years, then by 16% for 3 more years, before converging to the industry median g..
|
|
Calculate the firms the operating profit margin
: Canadian Bacon Inc. financial statements are presented in the table below. Based on the information in the table, calculate the firm’s the operating profit margin. Round the answers to two decimal places in percentage form. (Write the percentage sign..
|