# Capital Budget

Satisfactory Essays
297 Words
Grammar
Plagiarism
Writing
Score
Capital Budget
FIN 641- Fall 2012 – Excel Assignment

This assignment is due 10 am on Thursday, December 6. Your assignment will be graded on a scale of 0 to 16. Each question is equally worth. You need to use the posted Excel Template. You should work on these individually. The assignment should be submitted on Blackboard. No late assignment will be accepted. Enjoy the problems!

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.

1. Calculate the initial outlay, annual after-tax cash flows and terminal cash flows.

2. Complete the table with the timeline and calculate the NPV and IRR of the project. Is the project acceptable?

3. Data Table that shows changes in NPV, when required rate changes (11%, 12%, 13%, 14%, 15%)
4. Create a scenario summary table (using the scenario manager tool) to show what happens to the NPV and IRR for the following three scenarios for sales and tax rate.
Three Scenarios for quantity sold and unit price : Quantity Sold Unit Price
Worst 200,000 1.4
Expected 400,000 1.3
Best 600,000 1.1

## You May Also Find These Documents Helpful

• Good Essays

IRR: It is that rate of interest that makes the sum of all cash flows…

• 2679 Words
• 11 Pages
Good Essays
• Better Essays

The focus of EEC’s investment of the purchasing of the supplier is to cut down on the cost expenditures of the company. The primary board members and investors anticipate in the timeframe the fifth of to save financially in revenue \$600,000 per annum this will accumulate \$9 million in net in the timeframe of that 15 years. 14% of that investment and consumption cost will be attributed out of \$9 million net, which adds up to sum of \$3 million. The president of the company asked me to give an analysis in the possibilities foreseen in the investment what would be the Net Present Value, along with the Internal Rate of Return, and the payback of the investment.…

• 1228 Words
• 4 Pages
Better Essays
• Satisfactory Essays

1. Is this project financially feasible given the base scenario? Why or why not. Be sure to include a discussion of NPV and IRR. How does the lifetime income compare to the initial investment? 5 points…

• 644 Words
• 3 Pages
Satisfactory Essays
• Powerful Essays

The NPV and IRR were calculated both with and without NOBPT. Furthermore the replicated NPV was incorrect and as such was corrected using a revised NPV function. The Excel NPV function does not correspond to the finance use of the term NPV. To correct this NPV should be calculated as the present value of future cash flows minus the initial payment, the initial payment is later added outside the parenthesis of the function.…

• 928 Words
• 4 Pages
Powerful Essays
• Satisfactory Essays

A project has initial costs of \$3,000 and subsequent cash inflows in years 1 – 4 of \$1350, 275, 875, and 1525. The company 's cost of capital is 10%. Calculate NPV for this project.…

• 836 Words
• 4 Pages
Satisfactory Essays
• Satisfactory Essays

A project has initial costs of \$3,000 and subsequent cash inflows in years 1 ? 4 of \$1350, 275, 875, and 1525. The company's cost of capital is 10%. Calculate NPV for this project.…

• 1062 Words
• 5 Pages
Satisfactory Essays
• Satisfactory Essays

B. What is the NPV of the project at 10% higher than forecast, and what if the NPV was 10% lower?…

• 253 Words
• 2 Pages
Satisfactory Essays
• Better Essays

The financial assistant received the important assignment by memorandum from the CEO. The memorandum stated that the company is considering the introduction of a new product (Keown, Martin, Perry, & Scott, 2005). Caradonia is currently at a 34% marginal tax bracket with a 15% required rate of return or cost of capital (Keown, Martin, Perry, & Scott, 2005). The new project is estimated to last five years and then be terminated because of being a fad project (Keown, Martin, Perry, & Scott, 2005). The financial assistant must analyze two mutually exclusive projects. Each project has an 11% rate of return and a life span of five years (Keown, Martin, Perry, & Scott, 2005). The following table (table one) shows the expected cash flows for each project.…

• 1388 Words
• 6 Pages
Better Essays
• Good Essays

On the current proposal for building the new factory below will explain the analysis needed for the projection of the incremental cash flows that will be used for the NPV analysis. Building of a new factory will increase the capacity by 30% which is 3 million a year. With the estimate of profit margin at 5% this is equivalent to \$150,000.00 in gross margin. At the end if the analysis the factory worth is 14 million.…

• 854 Words
• 4 Pages
Good Essays
• Satisfactory Essays

Considering the information for the Proposal concerning the building of the new factory, the incremental cash flows are needed for the NPV analysis. The incremental cash flows are sales of \$3 million a year which equals an increase in gross margin by \$150,000 given a 5% gross margin and initial on investment of \$10 million which is the cost of building the new factory. The savage value at the end of the project life will be \$14 million.…

• 588 Words
• 6 Pages
Satisfactory Essays
• Good Essays

A. Data Table: Insert your Data Table here with your sample calculations. You must show at least one sample calculation per procedure step. (16 points)…

• 1069 Words
• 7 Pages
Good Essays
• Good Essays

Testco Corp. is considering adding a new product line. The cost of the factory and equipment to produce this product is \$1,780,000, and the company expects increased cash flows from the sale of this product to be \$450,000 for each of the next eight years. If the company uses a discount rate of 12 percent, what is the net present value of this project? What is the internal rate of return of this project?…

• 1228 Words
• 5 Pages
Good Essays
• Good Essays

NPV (Net Present Value) measures the expected change in wealth from undertaking the project. The NPV of purchasing is \$60.34 million and \$93.23 million for developing the technologies. NPV is the most effective measurement since both IRR and MIRR have the project scale issues. In this case, developing the technologies gives a greater NPV and is the best choice.…

• 655 Words
• 3 Pages
Good Essays
• Powerful Essays

was based on a Net Present Value (NPV) analysis on six different scenarios. Each scenario and…

• 2248 Words
• 58 Pages
Powerful Essays
• Satisfactory Essays

Delivery Charges Production Cost Annual Holding Cost per Unit S C h \$ \$ Weekly Usage (gallons) Annual Demand Order Quantity D \$ \$ Annual Holding Cost per Unit per year Number of Orders Per Year Average Inventory Annual Ordering Cost Annual Holding Cost EOQ Q H = h*C D/Q Q/2…

• 346 Words
• 9 Pages
Satisfactory Essays