Question #1: WACC & Capital Budget Analysis – Based on the inputs below prepare a capital...

Question #1: WACC & 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 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 70% and Equity is 30% of this firm’s capital structure. Interest rate on the debt is 7.5%, firm’s tax rate is 22%. Firm’s beta is 1.50, Risk Free Rate is 1.0%, Market Return Rate is 7.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

Solutions

Expert Solution

The answer is explained below:

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for...

WACC & 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 spreadsheet calculations and your final determinations of “go” or “no go” on the project. Project Inputs: WACC – Debt is 70% and Equity is 30% of this firm’s capital structure. Interest rate on the debt is...

WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for...

WACC & 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 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 70% and Equity...

Based on the inputs below prepare a capital budget analysis for this Base Case using the...

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. PLEASE show formulas Project Inputs: WACC – Debt is 70% and Equity is 30%...

Based on the inputs below prepare a capital budget analysis for this Base Case using the...

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. Project Inputs: WACC – Debt is 70% and Equity is 30% of this firm’s capital structure. Interest rate on the debt is 7.5%, firm’s tax rate is...

Capital Budgeting Analysis - Use the information below to prepare for cash flow analysis in a...

Capital Budgeting Analysis - Use the information below to prepare for cash flow analysis in a table for both scenarios Please create your table from Colume L and keep this statement here as it is. You must show the analysis and results from both scenarios based on your cash flow analysis table and make your decision Decision without data support will be given 0 points. Micro-Technologies is a Bio Tech research firm that is conducting research on a cure for...

For this question, you need to prepare a flexible budget and offer a critical analysis of...

For this question, you need to prepare a flexible budget and offer a critical analysis of the performance of different items. The following are the budgeted and actual income statements for Baxter Ltd for the month of July: Output (production and sales) Budget 1000 units Actual 1050 units Sales Revenue 100,000 104,300 Raw materials (40 000) (40 000 meters) (41,200) (40,500 meters) Labour (20 000) (2,500 hours) (21,300) (2,600 hours) Fixed overheads (20 000) 19,400 Operating profit 20 000 22,400...

Suppose you are conducting a marginal WACC analysis to identify your firm’s optimal capital budget. Assume...

Suppose you are conducting a marginal WACC analysis to identify your firm’s optimal capital budget. Assume you have $1,500,000 of retained earnings available. The current market price of the common stock is $45.00. The expected dividend for this coming year is projected to be $2.80, increasing thereafter at a 7% annual growth rate. Sale of new common stock will be subject to a 2% discount from the current stock price, and investment banking fees will be $3.75 per share. Assume...

Based on the information provided below, estimate the income and expenditure and prepare a basic budget...

Based on the information provided below, estimate the income and expenditure and prepare a basic budget in the template provided. The Melbourne Football Club and the recreational centre has the following income and expenditure. Identify each item as income or expenditure and fill in the template provided to get total income and expenditure for the year. Assume one (1) season of the game per year. Sales: The number of opening hours per week: 14 The average sales per hour: $120...

Question: Prepare the cash disbursement for direct materials budget for the first quarter Budget information below...

Question: Prepare the cash disbursement for direct materials budget for the first quarter Budget information below Sweetums Cookies, Inc.: A Master Budget CaseIntroductionYou knew they were good, but you never thought Grandma’s old cookie recipe would bring you this far! It all started about three years ago when you began using your Grandma’s cookie recipe to bake cookies as a little side business. You bake them right in your home and sell them to friends and local stores. Response has...

1. Why does WACC increase and IRR decrease as the capital budget increases? Are there any...

1. Why does WACC increase and IRR decrease as the capital budget increases? Are there any steps management can take to reverse these trends? 2. How should a company prioritize all of its capital project opportunities? In responding invoke the various methodologies learned this week and how to use them for ranking projects.

Subjects