Prepare a capital budget analysis

Reference no: EM13978613

Question #1: Weighted Average Cost of Capital (WACC) & Capital Budget Analysis

a. 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 year's methods, determining whether the project is feasible.

b. Please complete assignment in spreadsheet format and show calculations where possible (Capital Budget Analysis example has been attached)

c. After all calculations are completed and all cost determined, should the Base Case Project be considered or not?

Inputs:

Weighted Average Cost of Capital (WACC) = Debt is 75%

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

Question #2: (AFN) Additional Funds Needed - Forecasting

Forecast the firm's additional funds needed (AFN) for next year. The firm is operating at full capacity. Data to use for the forecast are shown below.

Based on the AFN equation, what is the AFN for the coming year? (show calculations)

Last year's sales = S₀	$200,000	Last year's accounts payable	$50,000
Sales growth rate = g	20%	Last year's notes payable	$15,000
Last year's total assets = A₀*	$135,000	Last year's accruals	$20,000
Last year's profit margin= PM	10.0%	Target payout ratio	50.0%

Spreadsheet is just showing example.

Attachment:- spreadsheet-examples.xlsx

Reference no: EM13978613

Questions Cloud

How much data is actually required for real-time reporting : A business has launched a new product line that has resulted in significant business and related data growth. A database/TPS application is facing issues with using too much disk storage. It is becoming critical and the organization may need to buy a..

Importance in terms of revenue collected among federal taxes : Which is the correct order of importance in terms of revenue collected among the following federal taxes? The marginal productivity principle says that a profit-maximizing firm should. An employer would never operate on the upward-sloping part of an ..

Investments ooportunities in e-sports : Task A: Report, 1250 words: Investments OOportunities in E-sports for "Norling PLC". Task B, Presentation reflection, 500 words. Task C, Critical essay, "Violence sells, but at what cost? Discuss whether violence in video games can be shown to have a..

Using the internet access the sec 10-k annual report : You can find the SEC 10-K annual report at the company's website in sections such as About Us and / or Investor Relations. Look for SEC and Annual Filings (you will often find drop down menus to click). You must research and secure the SEC 10-K Annua..

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 year's methods, determining whether the project is feasible.

Why do managers use prefer consolidated financial statements : Why Do Managers Use/Prefer Consolidated Financial Statements For Financial Decision-Making? (might be slightly changed)

Identity embodiment performance : A concept note is designed to demonstrate your knowledge of a particular concept, critical idea or approach that can be utilised in a particular field of study. You are asked to prepare a concept note that explores "Identity, Embodiment, Performance"

The demand for borrowed funds is : The demand for borrowed funds is, The income of Lebron James, for example, is determined by, The income to someone such as Lebron James is

Deep and surface approaches to learning for skilss to study : A power point about deep and surface approaches to learning for skilss to study class foundation uk. attached is the page from the book

User Account

All Pages