1. Vilas Company is considering a capital investment of $191,400 in additional p
ID: 2424167 • Letter: 1
Question
1. Vilas Company is considering a capital investment of $191,400 in additional productive facilities. The new machinery is expected to have a useful life of 5 years with no salvage value. Depreciation is by the straight-line method. During the life of the investment, annual net income and net annual cash flows are expected to be $16,740 and $49,810, respectively. Vilas has a 12% cost of capital rate, which is the required rate of return on the investment.
Compute the cash payback period.
Compute the annual rate of return on the proposed capital expenditure.
Using the discounted cash flow technique, compute the net present value.
2. Pierre’s Hair Salon is considering opening a new location in French Lick, California. The cost of building a new salon is $287,100. A new salon will normally generate annual revenues of $61,185, with annual expenses (including depreciation) of $41,000. At the end of 15 years the salon will have a salvage value of $79,900.
Calculate the annual rate of return on the project
3. Eisler Corporation is involved in the business of injection molding of plastics. It is considering the purchase of a new computer-aided design and manufacturing machine for $448,200. The company believes that with this new machine it will improve productivity and increase quality, resulting in an increase in net annual cash flows of $118,431 for the next 6 years. Management requires a 10% rate of return on all new investments
Calculate the internal rate of return on this new machine. (Round answer to 0 decimal places, e.g. 10.)
4. BAK Corp. is considering purchasing one of two new diagnostic machines. Either machine would make it possible for the company to bid on jobs that it currently isn’t equipped to do. Estimates regarding each machine are provided below.
Calculate the net present value and profitability index of each machine. Assume a 9% discount rate
5. Doug’s Custom Construction Company is considering three new projects, each requiring an equipment investment of $23,180. Each project will last for 3 years and produce the following net annual cash flows.
The equipment’s salvage value is zero, and Doug uses straight-line depreciation. Doug will not accept any project with a cash payback period over 2 years. Doug’s required rate of return is 12%.
Compute the net present value of each project
Explanation / Answer
1) Year Particulars PV Factor @ 12% Cash Flow PV of cash flow Pay Back Period Cash Payback Period 0 Initial Investment 1.00000 -191400 -1,91,400 1 Yearly Net cash Flow 0.89286 49810 44,473 2 Yearly Net cash Flow 0.79719 49810 39,708 3 Yearly Net cash Flow 0.71178 49810 35,454 4 Yearly Net cash Flow 0.63552 49810 31,655 3 years 57 Days 5 Yearly Net cash Flow 0.56743 49810 28,264 NPV -11,846 NA 2) Year Particulars PV Factor @ 8% PV Factor @ 9% Cash Flow PV of cash flow @ 8% PV of cash flow @ 9% 0 Initial Investment 1.00000 1.00000 -287100 -2,87,100 -2,87,100 1 Yearly Net cash Flow 0.92593 0.91743 33998 31,480 31,191 2 Yearly Net cash Flow 0.85734 0.84168 33998 29,148 28,615 3 Yearly Net cash Flow 0.79383 0.77218 33998 26,989 26,253 4 Yearly Net cash Flow 0.73503 0.70843 33998 24,990 24,085 5 Yearly Net cash Flow 0.68058 0.64993 33998 23,138 22,096 6 Yearly Net cash Flow 0.63017 0.59627 33998 21,425 20,272 7 Yearly Net cash Flow 0.58349 0.54703 33998 19,838 18,598 8 Yearly Net cash Flow 0.54027 0.50187 33998 18,368 17,062 9 Yearly Net cash Flow 0.50025 0.46043 33998 17,007 15,654 10 Yearly Net cash Flow 0.46319 0.42241 33998 15,748 14,361 11 Yearly Net cash Flow 0.42888 0.38753 33998 14,581 13,175 12 Yearly Net cash Flow 0.39711 0.35553 33998 13,501 12,087 13 Yearly Net cash Flow 0.36770 0.32618 33998 12,501 11,089 14 Yearly Net cash Flow 0.34046 0.29925 33998 11,575 10,174 15 Yearly Net cash Flow 0.31524 0.27454 33998 10,718 9,334 0.29189 0.25187 33998 9,924 8,563 NPV 13,829 -4,490 For 1% change in Discounting rate will lead to $ 18,318 ( 13829+4490) So for $13829 the Rate will Change by 13829/18318*100 = 0.75% There for IRR = 8.75% 3) Year Particulars PV Factor @ 10% Cash Flow PV of cash flow @ 10% PV Factor @ 15% Cash Flow PV of cash flow @ 15% 0 Initial Investment 1.00000 -448200 -4,48,200 1.00000 -448200 -4,48,200 1 Yearly Net cash Flow 0.90909 118431 1,07,665 0.86957 118431 1,02,983 2 Yearly Net cash Flow 0.82645 118431 97,877 0.75614 118431 89,551 3 Yearly Net cash Flow 0.75131 118431 88,979 0.65752 118431 77,870 4 Yearly Net cash Flow 0.68301 118431 80,890 0.57175 118431 67,713 5 Yearly Net cash Flow 0.62092 118431 73,536 0.49718 118431 58,881 6 Yearly Net cash Flow 0.56447 118431 66,851 0.43233 118431 51,201 NPV 67,598 NPV 0 IRR = 15% 4) Year Particulars PV Factor @ 9% Cash Flow _A PV of cash flow_A @ 10% PV Factor @ 9% Cash Flow_ B PV of cash flow_B @ 9% 0 Initial Investment 1.00000 -78120 -78,120 1.00000 -185800 -1,85,800 1 Yearly Net cash Flow 0.91743 15180 13,927 0.91743 30160 27,670 2 Yearly Net cash Flow 0.84168 15180 12,777 0.84168 30160 25,385 3 Yearly Net cash Flow 0.77218 15180 11,722 0.77218 30160 23,289 4 Yearly Net cash Flow 0.70843 15180 10,754 0.70843 30160 21,366 5 Yearly Net cash Flow 0.64993 15180 9,866 0.64993 30160 19,602 6 Yearly Net cash Flow 0.59627 15180 9,051 0.59627 30160 17,983 7 Yearly Net cash Flow 0.54703 15180 8,304 0.54703 30160 16,499 8 Yearly Net cash Flow 0.50187 15180 7,618 0.50187 30160 15,136 NPV 5,899 NPV -18,870 PI = NPV/initial Investment PI for A = 5899/78120= 0.075 PI for B = =-18870/185800= 0.102 5) Year PV Factor @ 12% Cash Flow _A PV of cash flow_A @ 12% PV Factor @ 12% Cash Flow _A PV of cash flow_A @ 12% Cash Pay Back Period_ A Cash Pay Back Period_ B 0 1.00000 -23180 -23,180 1.00000 -23180 -23,180 1 0.89286 9882 8,823 0.89286 15982 14,270 2 0.79719 12688 10,115 0.79719 12322 9,823 1 year 100 days 3 0.71178 18422 13,112 0.71178 13542 9,639 2 years 13 days NPV 8,870 10,552 Hence Project B should be selected as payback period is less than 2 years & positive NPV
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.