ACCT505 Capital Budgeting problem Clark Paints
Cost of new equipment $200,000
Expected life of equipment in years 5
Disposal value in 5 years $40,000
Initial working capital $0
Life production - number of cans 5,500,000
Annual production or purchase needs 1,100,000
Initial training costs 0
Number of workers needed 3
Annual hours to be worked per employee 2,000
Earnings per hour for employees $12.00
Annual health benefits per employee $2,500
Other annual benefits per employee-% of wages 18%
Cost of raw materials per can $0.25
Other variable production costs per can $0.05
Costs to
…show more content…
al, 2014, p. 624) instead of PV tables. n number of year 0 1 2 3 4 5 F (net cah flows) $(200,000) $58,351 $58,351 $58,351 $58,351 $98,351 r (trial internal rate of return 1 0.847520114 0.718290343 0.608765513 0.515941017 0.43727039
P (Discounted cash flows) $(200,000) $49,453.65 $41,912.96 $35,522.08 $30,105.67 $43,005.98 NPV Pv cash inflows-PV cash outflow= 0
IRR = 17.9913% 17.99% step 2.
PV of cash inflows $233,039.37 net out year 0 cash outflows $(200,000)
NPV $33,039.37 0 1 2 3 4 5
EXCEL method for NPV and IRR (yearwise cash flows required)
Cost of asset -200,000 $- $- $- $- $-
Annual cash savings , after tax 47,151
Estimate the project’s operating cash flows for each year of the project’s economic life. (Hint: Use Table 2 as a guide)
Fred was an engineer hired by the company to design a new plant to manufacture a paint remover. The budgets of the design that Fred has been
(TCO G) – (Ignore income taxes in this problem.) Tennessee Co. is considering the production of an exterior paint that will require the purchase of new mixing machinery. The machinery will cost $700,000, is expected to have a useful life of 12 years, and is expected to have a salvage value of $100,000 at the end of 12 years. The machinery will also need a $40,000 overhaul at the
Nick, I was able to figure most of the math except that there is a $40,715.99 delta which I think is because we rounded the budget for Steve as $278.2 M when it was $278,240,715.99. Also, I updated the Construction Contingency line to reflect both Ph1A and Ph2. There are few other changes I incorporated to reflect the line transfers, let me know if you are available today/tomorrow to talk-thru this before sending it to Jessica.
See Table 1: Expected non-operating cash flow when the project is terminated at year 4 = 165,880$
7. You are evaluating a project for The Ultimate recreational tennis racket. You estimate the sales price of The Ultimate to be $400 and sales volume to be 1,000 units in year 1, 1,250 units in year 2, and 1,325 units in year 3. The project has a 3-year life. Variable costs amount to $225 per unit and fixed costs are $100,000 per year. The project requires an initial investment of $165,000, which is depreciated
The first capital project request that will be analyzed is Gopher Place. This store would come at a cost of $23 million which is $5.4 million more expensive than the prototype. The NPV and IRR for Gopher place is $16.8 million and 12.3% respectively. Sales at this location could decrease by 5.3% and still achieve the prototypes NPV. However sales would have to rise by 2.2% to achieve the prototype IRR. With a sales decline of 10 percent the store NPV would decline by $4.7 million and the IRR would decline by 1.3 percentage points. Target already operated five stores in this market and this store would be expected to derive 19% of its sales from these
The next table shows the present value of each cash flow. Cash flow was multiplied with the PV column. The net present value is $1,078,460 also negative, which results in being higher than the NPV at %10. The weighted cost of capital is %6.
Superior Manufacturing is thinking of launching a new product. The company expects to sell $950,000 of the new product in the first year and $1,500,000 each year thereafter. Direct costs including labor and materials will be 55% of sales. Indirect incremental costs are estimated at $80,000 a year. The project requires a new plant that will cost a total of $1,000,000, which will be depreciated straight line over the next five years. The new line will also require an additional net investment in inventory and receivables in the amount of $200,000. Assume there is no need for additional investment in building and land for the project. The firm's marginal tax rate is 35%, and its cost of capital is 10%. 1. Prepare a statement showing the
You can use the same approach to find the threshold value of units sold (777) for net cash flow of $4,300, as shown in Figure 2.8.
The cost-volume-profit analysis is a form of cost accounting and an important part of this analyses is the break-even point.
The questions have been attempted as follows and the same analogy has been taken to excel for rest of the part of the question:
Task 3: A five-year project has a projected net cash flow of AED 15,000, AED 25,000, AED
For Depreciation in ACP, you are using Depreciation for Paducah (Old), not the Capitalized Plant Bldg costs. Further, your analysis does not seem to include the $1.7b cost anywhere, other than in the text of this document where you apparently take a t=0 PVCF and