0 0

Capital Budgeting Analysis with Excel Model

ABOUT THIS DOCUMENT

This Capital Budgeting Analysis is a spreadsheet that should be used by business managers to evaluate whether new capital assets are worth investing in. Capital budgeting is the process of determining the impact of a project's cash inflows and outflows on a firm's value. Different approaches are applied in selecting the projects; they include pay-back period, profitability index, internal rate of return, and net present value. This spreadsheet should be used by company managers to determine which projects and capital expenditures will yield the highest levels of return over a given period of time.

Reads: 11634 times
Used: 38 times
Pages: 1
Size: 28 kb
Format: Excel Spreadsheet

Text Version

CAPITAL BUDGETING/PROJECT ANALYSIS

MARCS Depreciation

Rates

Cost of New Equipment(Initial Outlay ) $ 100,000.00

Disposal Amount at the End 14,285.00 Year

1 15.00%

2 15.00%

3 15.00%

4 15.00%

5 15.00%

6 15.00%

7 0.00%



PROJECT FAVOURABLE





Tax Rate 45.00%

Required Rate of Return Discount rate) 6.50%

NET PRESENT VALUE $3,975.60





YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 YEAR 6 YEAR 7

Volume To be Sold ( Quantity) 20000 20000 20000 20000 20000 20000 20000

Selling price per Unit $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00

Additional Cash Generated $ 200,000.00 $ 200,000.00 $ 200,000.00 $ 200,000.00 $ 200,000.00 $ 200,000.00 $ 200,000.00

Variable Cost $ (300,000.00) $ (300,000.00) $ (300,000.00) $ (300,000.00) $ (300,000.00) $ (300,000.00) $ (300,000.00)

Variable Cost Tax Savings $ 135,000.00 $ 135,000.00 $ 135,000.00 $ 135,000.00 $ 135,000.00 $ 135,000.00 $ 135,000.00

Fixed Cost $ (40,000.00) $ (40,000.00) $ (40,000.00) $ (40,000.00) $ (40,000.00) $ (40,000.00) $ (40,000.00)

Fixed Cost Tax Savings $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00

Depreciation $ 6,750.00 $ 6,750.00 $ 6,750.00 $ 6,750.00 $ 6,750.00 $ 6,750.00 $ -

Cash Inflow From The Operations $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 13,000.00



Equipment Disposal $ 7,856.75

Cash Inflow From The Project $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 13,000.00

Year

1 15.00%

2 15.00%

3 15.00%

4 15.00%

5 15.00%

6 15.00%

7 0.00%



PROJECT FAVOURABLE





Tax Rate 45.00%

Required Rate of Return Discount rate) 6.50%

NET PRESENT VALUE $3,975.60





YEAR 1 YEAR 2

Volume To be Sold ( Quantity) 20000 20000

Selling price per Unit $ 10.00 $ 10.00

Additional Cash Generated $ 200,000.00 $ 200,000.00

Variable Cost $ (300,000.00) $ (300,000.00)

Variable Cost Tax Savings $ 135,000.00 $ 135,000.00

Fixed Cost $ (40,000.00) $ (40,000.00)

Fixed Cost Tax Savings $ 18,000.00 $ 18,000.00

Depreciation $ 6,750.00 $ 6,750.00

Cash Inflow From The Operations $ 19,750.00 $ 19,750.00



Equipment Disposal $ 7,856.75

Cash Inflow From The Project $ 19,750.00 $ 19,750.00

CAPITAL BUDGETING/PROJECT ANALYSIS









YEAR 3 YEAR 4 YEAR 5 YEAR 6 YEAR 7

20000 20000 20000 20000 20000

$ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00

$ 200,000.00 $ 200,000.00 $ 200,000.00 $ 200,000.00 $ 200,000.00

$ (300,000.00) $ (300,000.00) $ (300,000.00) $ (300,000.00) $ (300,000.00)

$ 135,000.00 $ 135,000.00 $ 135,000.00 $ 135,000.00 $ 135,000.00

$ (40,000.00) $ (40,000.00) $ (40,000.00) $ (40,000.00) $ (40,000.00)

$ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00

$ 6,750.00 $ 6,750.00 $ 6,750.00 $ 6,750.00 $ -

$ 19,750.00 $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 13,000.00





$ 19,750.00 $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 13,000.00

13,000.00





$ 19,750.00 $ 19,750.00 $ 19,750.00 $ 19,750.00 $ 13,000.00

Sign-up for Docstoc Premium
Registration enables you to experience on site recommendations of documents, articles, packages and courses as well as recommendation emails for the content we think you'll love the most
Already a member?
Don't have a Facebook account?
Register with E-mail

Enter a valid email address (xxx@xxx.com)
Preloader
By registering with docstoc.com you agree to
our privacy policy and terms of service
Sign-in
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Forgot Password?
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Don't have a Facebook account?
Login with your Docstoc account.


Email or Username

Preloader

1. Please rate your experience on the following scale:


2. Would you recommend Docstoc to a friend?


Submit

Would you be interested in taking a longer survey for a chance to win a 1-month free subscription to Docstoc Premium?