Calculate the project IRR and using the Excel NPV function

Assignment Help Financial Management

Reference no: EM131974202

You will complete a capital budgeting Excel spreadsheet solution based on:

Cost of new equipment $14,800,000

Shipping and installation 200,000

Unit sales

Year 1 70,000

Year 2 120,000

Year 3 120,000

Year 4 80,000

Year 5 70,000

Sales price = $300 / unit in years 1-4 and $250/unit in year 5

Variable cost = $140 / unit

Fixed cost = $700,000 per year for all 5 years

Working capital : $200,000 at start of project, recovered at end

Depreciation = straight line over 5 years

Tax rate = 34%

Cost of capital = 15%

You must complete this project using an Excel spreadsheet. Your assignment specifically:

Lay out the cash flows for years 1-5

Calculate the project NPV, using the Excel NPV function

Calculate the project IRR, using the Excel NPV function

Reference no: EM131974202

Questions Cloud

Plan to purchase used motorcycle : You plan to purchase a used motorcycle for $6,500. You can only afford a monthly payment of $200 for a period of two years.

What monthly interest rate are you paying on the loan : What monthly interest rate are you paying on the loan?

What is the remaining margin in the account : What is the remaining margin in the account? How much will she have to put up to get back to 50% when her broker calls?

What is the dividend yield and what is the capital gain : What is the dividend yield? What is the capital gain?

Calculate the project IRR and using the Excel NPV function : Calculate the project NPV, using the Excel NPV function. Calculate the project IRR, using the Excel NPV function

Instead of investing her money equal in each stock : Instead of investing her money equal in each stock, your friend invests 70% of her money in stock A and 30% of her money in stock B.

What is weighted average cost of capital after transaction : What is the weighted average cost of capital with the current capital structure? What is the weighted average cost of capital after transaction?

What are the limitations of financial ratio analysis : What are the limitations of financial ratio analysis? Discuss the purpose and importance of financial ratios and financial analysis.

Calculate the cost of each capital component for apple : Calculate the cost of each capital component for Apple: after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method

User Account

All Pages