#### Details of this Paper

##### DEVRY ACCT505 course project B

Description

solution

Question

Question;Capital BudgetiCapital Budgeting Decision;These instructions can also be;downloaded from DocSharing!!;Due by Tuesday of week 8, midnight, Mountain;Time;Here is;Part B;Clark Paints: The production department has been;investigating possible ways to trim total production costs. One possibility;currently being examined is to make the paint cans instead of purchasing them.;The equipment needed would cost \$200,000 with a disposal value of \$40,000 and;would be able to produce 5,500,000 cans over the life of the machinery. The;production department estimates that approximately 1,100,000 cans would be;needed for each of the next five years.;The company would hire;three new employees. These three individuals would be full-time employees;working 2,000 hours per year and earning \$12.00 per hour. They would also;receive the same benefits as other production employees, 18% of wages in;addition to \$2,500 of health benefits.;It is estimated that the;raw materials will cost 25? per can and that other variable costs would be 5?;per can. Since there is currently unused space in the factory, no additional;fixed costs would be incurred if this proposal is accepted.;It is expected that cans;would cost 45? per can if purchased from the current supplier. The company's;minimum rate of return (hurdle rate) has been determined to be 12% for all new;projects, and the current tax rate of 35% is anticipated to remain unchanged.;The pricing for a gallon of paint as well as number of units sold will not be;affected by this decision. The unit-of-production depreciation method would be;used if the new equipment is purchased.;Required;1. Based on the above;information and using Excel, calculate the following items for this;proposed equipment purchase;Annual cash flows over the;expected life of the equipment;Payback period;Annual rate of return;Net present value;Internal rate of return;2. Would you recommend the;acceptance of this proposal? Why or why not. Prepare a short double spaced Word;paper elaborating and supporting your answer.;ACCT505;Part B;Capital Budgeting problem;CLARK PAINTS;Data;Cost of new equipment;\$2,00,000;Expected life of equipment in years;5;Disposal value in 5 years;\$40,000;Life production - number of cans;55,00,000;Annual production or purchase needs;11,00,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 purchase cans - per can;\$0.45;Required rate of return;12%;Tax rate;35%;Make;Purchase;Cost to;produce;Annual cost of direct material;Need of 1,000,000 cans per year;Annual cost of direct labor for new;employees;Wages;Health benefits;Other benefits;Total wages and benefits;0;Other variable production costs;Total annual production costs;0;Annual cost to purchase cans;Part;1 Cash flows over the life of the project;Before Tax;Tax;After Tax;Item;Effect;Amount;Annual cash savings;0.65;\$0;Tax savings due to depreciation;0.35;\$0;Total annual cash flow;\$0;Part;2 Payback Period;years;Part;3 Annual rate of return;Accounting income as result of;decreased costs;Annual cash savings;Less Depreciation;Before tax income;0;Tax at 35% rate;After tax income;\$0;Part;4 Net Present Value;Before Tax;After tax;10% PV;Present;Item;Year;Amount;Tax %;Amount;Factor;Value;Cost of machine;0;\$0;\$0;Cost of training;0;0;\$0;Annual cash savings;1-5;0.65;-;\$0;Tax savings due to depreciation;1-5;0.35;-;\$0;Disposal value;5;0;\$0;Net Present Value;\$0;Part;5 Internal Rate of Return;Excel Function method to calculate IRR;This function REQUIRES that you have;only one cash flow per period (period 0 through period 5 for our example);This means that no annuity figures;can be used. The chart for our example can be revised as follows;After Tax;Item;Year;Amount;Cost of machine and training;0;Year 1 inflow;1;Year 2 inflow;2;Year 3 inflow;3;Year 4 inflow;4;Year 5 inflow;5;The IRR function will require the;range of cash flows beginning with the initial cash outflow for the;investment;and progressing through each year of;the project. You also have to include an initial "guess" for the;possible IRR. The formula is: =IRR(values,guess);IRR Function;IRR(f84..f89,.30);#NUM!;="msonormal">

Paper#40735 | Written in 18-Jul-2015

Price : \$32