# Capital Budget Mini-Case

Good Essays
2439 Words
Grammar
Plagiarism
Writing
Score
Capital Budget Mini-Case
Your company is thinking about acquiring another corporation. You have two choices; the cost of each choice is \$250,000. You cannot spend more than that, so acquiring both corporations is not an option. The following are your critical data: a. Corporation A:
1) Revenues = 100K in year one, increasing by 10% each year
2) Expenses = 20K in year one, increasing by 15% each year
3) Depreciation Expense = 5K each year
4) Tax Rate = 25%
5) Discount Rate = 10% b. Corporation B:
1) Revenues = 150K in year one, increasing by 8% each year
2) Expenses = 60K in year one, increasing by 10% each year
3) Depreciation Expense = 10K each year
4) Tax Rate = 25%
5) Discount Rate = 11% You must compute and analyze items (a) through (h) using a Microsoft Excel spreadsheet. Make sure that all calculations can be seen in the background of the applicable spreadsheet cells. In other words, leave an audit trail so that others can see how you arrived at your calculations and analysis. Items (i), (j), and (k) should be submitted in Microsoft Word. c. A 5-year projected income statement
d. A 5-year projected cash flow
e. Net Present Value
f. Internal Rate of Return
g. Payback Period
h. Profitability Index
i. Discounted Payback Period
j. Modified Internal Rate of Return
k. Based on items (a) through (h), which company would you recommend acquiring?
l. In a 1,050-1,500-word memo, define, analyze, and interpret the answers to items (c) through (h). Present the rationale behind each item and why it supports your decision stated in item (i). Also, attempt to describe the relationship between NPV and IRR. (Hint: The key factor here is the discount rate used.) In this memo, explain how you would analyze projects differently if they

## You May Also Find These Documents Helpful

• Good Essays

Chapter 4 and 5 Problems Please complete the following 7 exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculations within Excel cells is acceptable). Save the document, and submit it in the appropriate week using the Assignment Submission button.…

• 1284 Words
• 12 Pages
Good Essays
• Powerful Essays

Good luck! Iceman Inc. Your boss, Mr. Kuklinski, believes that Southern California will soon run short of water. One of the ramifications, other than widespread rioting, is that there will be high demand for fresh, potable water. He is considering starting an iceberg transport company named “Iceman Inc.” to address this need and has asked you to help him analyze the project.…

• 1264 Words
• 4 Pages
Powerful Essays
• Powerful Essays

Capital budgeting Making decisions having significant future benefits or costs for various entities and their stakeholders.…

• 5574 Words
• 23 Pages
Powerful Essays
• Satisfactory Essays

| | | | a. Calculate each projects payback period, Discounted payback period, net present value (NPV), internal rate of return(IRR) and Profitability Index…

• 1029 Words
• 5 Pages
Satisfactory Essays
• Satisfactory Essays

Capital Budgeting The C & S Company manufactures ice-cream bars. They are considering the purchase of a new machine that will top the bar with high quality chocolate. The cost of the machine is \$900,000; it has a life of 10 years and the company will have to increase its net working capital by \$20,000 to use it. The machine can produce up to 1,000,000 ice-cream bars annually. The marketing director believes that if the company will spend \$20,000 in advertising every year, the company will be able to sell 400,000 bars for \$1.30 each. The cost of producing each bar is \$0.40; and other costs related to the new product are \$4,000 annually. The company’s cost of capital is 14% and the corporate tax rate is 30%. The company will depreciate 10% (or \$90,000) of the machine’s value every year and the book value at the end of year 10 would be zero. The company expects the equipment to be actually sold for \$200,000 after 10 years.…

• 297 Words
• 2 Pages
Satisfactory Essays
• Good Essays

The Capital Budget Instructor: Dr. Joseph McCue Public Budgeting and Finance - PAD 505 August 11, 2013…

• 1386 Words
• 6 Pages
Good Essays
• Satisfactory Essays

Instructions: 1. Test consists of 07 questions. Read each question carefully. 2. Construct an appropriate excel sheet (With all related Columns Specified) for First 2 Questions.…

• 289 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

rate is 20%. a. b. c. 2. What is the firm’s cost of equity capital?…

• 1224 Words
• 5 Pages
Powerful Essays
• Powerful Essays

frequency with which various evaluation methods, such as payback, internal rate of return (IRR), net present value (NPV), discounted payback, profitability index (PI), or average…

• 9954 Words
• 55 Pages
Powerful Essays
• Powerful Essays

5 CAPITAL BUDGETING PROCESS 7 ORGANIZING CAPITAL BUDGETING PROCESS IN LARGE FIRMS 8 CAPITAL BUDGETING DECISION RULES…

• 2504 Words
• 11 Pages
Powerful Essays
• Good Essays

A wrong decision will result in a drop in firm value as well as shareholders’ wealth.…

• 788 Words
• 4 Pages
Good Essays
• Powerful Essays

CAPITAL BUDGETING MEANING OF CAPITAL BUDGETING Capital budgeting is the making of long term planning decision for investment fixed assets and their financing. Capital budgeting decision is concerned with current investment that will pay for itself and yield an acceptable rate of return over its life span. Hampton (1992) defines capital budgeting as the decision making process by which firms evaluate the purchase of major fixed assets, including buildings, equipment. It also covers decisions to acquire other firms, either through purchase of their common stock or groups of assets that can be used to conduct an on-going business. It is a process used to evaluate capital expenditures. The primary objective in capital budgeting decision is to add to the value of a business by selecting investments that meet the goals of the organization and provide the highest possible rates of return.…

• 5557 Words
• 23 Pages
Powerful Essays
• Powerful Essays

C. (1) Define the term net present value (NPV). What is each project’s NPV? C.…

• 751 Words
• 4 Pages
Powerful Essays
• Better Essays

Question a What is capital budgeting? Are there any similarities between a firm’s capital budgeting decisions and an individual’s investment decisions?…

• 1749 Words
• 7 Pages
Better Essays
• Satisfactory Essays

4) Tax Rate = 25% 5) Discount Rate = 10% b. Corporation B: 1) Revenues = 150K in year one, increasing by 8% each year.…

• 348 Words
• 2 Pages
Satisfactory Essays