Based on the inputs below prepare a capital budget analysis

Assignment Help Business Management

Reference no: EM13801863

Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of "go" or "no go" on the project. Use your Investment Return Analysis as an example for this capital budget analysis.

Project Inputs: WACC - Debt is 75% and Equity is 25% of this firm's capital structure. Interest rate on the debt is 7.5%, firm's tax rate is 30%. Firm's beta is 1.25, Risk Free Rate is 2.0%, Market Return Rate is 11.0%. Project Investment Outlay, Year 0 - $1,000,000 Project Investment Life - 10 years Project Depreciation - $100,000 / year Project Salvage Value - $30,000 Working Capital Base of Annual Sales - 10% Expected inflation rate per year - 3.0% Project Tax Rate - 30% Units sold per year - 40,000 Selling Price per Unit, Year 1 - $40.00 Fixed operating costs per year excluding depreciation - $175,000 Manufacturing (Variable) costs per unit, Year 1 - $30.00

Reference no: EM13801863

Questions Cloud

The exponential smoothing model issues : When is the exponential smoothing model equivalent to the naïve forecasting model?

Assignment on agency introduction : Agency Introduction

What is a creative thinker : What is a creative thinker? What are some examples of how these creative thinkers have applied innovation, design, or creativity? What are the similarities among these creative thinkers? Explain your answer.

What is a mental model-mindset : What is a mental model/mindset? What forces influence a mental model/mindset, and what forces cause the evolution of that mental model/mindset? How has your mental model/mindset limited your decision-making?

Based on the inputs below prepare a capital budget analysis : Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your sprea..

Organize the three basic forms of government : Organize the three (3) basic forms of government from the point of view of a public administrator. Suggest two to three (2-3) common goals and interdependencies of the forms of government in question. Provide a rationale to support your response.

What will the exp days column contain : If expiration_date contains a value that's equivalent to November 2, 2008 and the SYSDATE function returns a value that's equivalent to December 17, 2008, what will the exp_days column contain when this code is executed

Analyze the main types of federalism : Analyze the main types of federalism. Debate two to three (2-3) advantages and two to three (2-3) disadvantages of federalism as it relates to intergovernmental relations. Provide a rationale to support your response. Only one page no specific wor..

Is anything still unclear that could be clarified : Review and reflect on the knowledge you have gained from this course. Based on your review and reflection - What approaches could have yielded additional valuable information?

User Account

All Pages