Purchase Solution

Capital Budgeting

Not what you're looking for?

Ask Custom Question

Scenario:

The meeting with the analyst went well. However, you want to crunch the numbers yourself to ensure accuracy. Furthermore, you need to consider the project in the broader context of how the new production facility can help the company increase output and, more importantly, profits. You know that the CFO will ask you to analyze the project at different hurdle rates, determine the implication on earnings and cash flow, and articulate why this project was chosen over the multitude of options that exists.

Task:

Create an Excel spreadsheet for a production plant that the company will lease for 5 years at US$1,500,000 per year; it will cost the firm US$4,000,000 in capital (straight-line depreciation, 5 year life) in year 0; it will cost the firm an additional US$150,000 per year after the new production plant is brought online for other expenses; and it will generate an incremental revenue of US$3,500,000 per year. Use a 40% tax rate, a 10% cost of capital, and a 12% re-investment rate. Assume the company will use cash flow to finance the project.

Discuss how the project would fair under hurdle rate scenarios of 10%, 15%, and 20% (based on MIRR). Based on results do we accept or reject at each hurdle rate? 10-15-20

Calculate NPV, MIRR

Attachments
Purchase this Solution

Solution Summary

The solution explains the calculation of NPV and MIRR and making the accept/reject decision

Purchase this Solution


Free BrainMass Quizzes
Learning Lean

This quiz will help you understand the basic concepts of Lean.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.