Question

You are contemplating the purchase of a new $1,840,000 computer-based dairy cow feeding system. The system will be depreciated straight-line over its ten-year life and have no value at the end of its life. You will earn $250,000 before taxes in the first year from additional milk production and expect an annual growth rate of 4%. Your tax rate is 25%, equity cost 10%, and debt cost 7%. Currently, your farm’s debt to asset ratio is 0.25 and you would like to keep the same financial ratio.

a. Compute the following for this project using after-tax cash flows: (1) payback period, (2) NPV, and (3) internal rate of return. Please also list cash flows for each year.

Answer 1

We compute the cash flows of each year. Following components needs to be considered Initial Capital Outlay, Tax Savings on Depreciation, Increase in Revenue.

Particulars	0	1	2	3	4	5
Capital Outlay (a)	-18,40,000
Tax Savings on Depreciation
Depreciation		1,84,000	1,84,000	1,84,000	1,84,000	1,84,000
Tax Savings (b)		46,000	46,000	46,000	46,000	46,000
Increase in Revenue/ Savings in Cost
Savings		2,50,000	2,60,000	2,70,400	2,81,216	2,92,465
Less Tax		50,000	52,000	54,080	56,243	58,493
Net Savings ©		2,00,000	2,08,000	2,16,320	2,24,973	2,33,972
Operating Cash Flow (b+c)	-	2,46,000	2,54,000	2,62,320	2,70,973	2,79,972
Net Cash Flow (a+b+c)	-18,40,000	2,46,000	2,54,000	2,62,320	2,70,973	2,79,972

6	7	8	9	10
1,84,000	1,84,000	1,84,000	1,84,000	1,84,000
46,000	46,000	46,000	46,000	46,000
3,04,163	3,16,330	3,28,983	3,42,142	3,55,828
60,833	63,266	65,797	68,428	71,166
2,43,331	2,53,064	2,63,186	2,73,714	2,84,662
2,89,331	2,99,064	3,09,186	3,19,714	3,30,662
2,89,331	2,99,064	3,09,186	3,19,714	3,30,662

a) Payback period is the period in which original investment shall come back as cash flows. We observe that cumulative cashflows upto 6th Year is 16,02,595 and upto 7th year it is 19,01,659. Hence Payback period is between 6th and 7th year.  Cash flow after 6th year required to cross original investment is Rs. 237,405 (1840,000 - 1602595) .

Hence, Final Payback period = 6years + 237405/ 299064 = 6.79 years

B) Now, we find the cost of capital.

Cost of debt = Int (1- Tax ) = 7 (1-0.25) = 5.25%

Cost of Equity = 10%

Weight of Debt = 0.25 AND of equity = 0.75

WACC

	Cost	Weight	WACC
Debt	5.25	0.25	1.31
Equity	10.00	0.75	7.50
	Total		8.81

Now we discount the cash flows calculated above @ WACC of 8.81% to find the present value.

Discount Factor for each year = 1/ (1+R)^N i.e for year 1 = 1/ ((1+8.81%)^1) = 0.9190

Particulars	0	1	2	3	4	5
Net Cash Flow (a+b+c)	-18,40,000	2,46,000	2,54,000	2,62,320	2,70,973	2,79,972
Discount Factor @10%	1.0000	0.9190	0.8446	0.7762	0.7134	0.6556
Present Value	-18,40,000	2,26,082	2,14,534	2,03,622	1,93,308	1,83,557

6	7	8	9	10
2,89,331	2,99,064	3,09,186	3,19,714	3,30,662
0.6025	0.5538	0.5089	0.4677	0.4298
1,74,334	1,65,608	1,57,351	1,49,535	1,42,134

Sum of Present Value is -29,935.

c) As we observe, NPV is negative. Hence Discount rate should be reduced such that NPV is zero which will be the IRR.

By various permutation of discount rate we find that @ 8.45987, NPV is nil and that rate is the IRR.

Particulars	0	1	2	3	4
			0 0 Add a comment Know the answer? Your Answer: Post as a guest Your Name: What's your source? Earn Coins Coins can be redeemed for fabulous gifts. Log In Sign Up Post as anonymous Post Your Answer Not the answer you're looking for? Ask your own homework help question Similar Questions Your firm is contemplating the purchase of a new $605,000 computer-based order entry system. The system... Your firm is contemplating the purchase of a new $605,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $89,000 at the end of that time. You will save $188,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $104,000 (this is a one-time reduction). If the tax rate is 21 percent, what is the IRR for this project? Your firm is contemplating the purchase of a new $500,000 computer-based order entry system. The system... Your firm is contemplating the purchase of a new $500,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $44,000 at the end of that time. You will be able to reduce working capital by $69,000 (this is a one-time reduction). The tax rate is 23 percent and the required return on the project is 11 percent. If the pretax cost savings are $150,000 per year, what is the... Your firm is contemplating the purchase of a new $1,999,200 computer-based order entry system. The system... Your firm is contemplating the purchase of a new $1,999,200 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $178,500 at the end of that time. You will save $785,400 before taxes per year in order processing costs and you will be able to reduce working capital by $139,442 (this is a one-time reduction).    Required : If the tax rate is 34 percent, what is the IRR for... Your firm is contemplating the purchase of a new $1,184,000 computer-based order entry system. The system... Your firm is contemplating the purchase of a new $1,184,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $115,200 at the end of that time. You will be able to reduce working capital by $160,000 (this is a one-time reduction). The tax rate is 33 percent and your required return on the project is 21 percent and your pretax cost savings are $379,800 per year. Requirement 1: What... Your firm is contemplating the purchase of a new $888,000 computer-based order entry system. The system... Your firm is contemplating the purchase of a new $888,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $86,400 at the end of that time. You will be able to reduce working capital by $120,000 (this is a one-time reduction). The tax rate is 34 percent and your required return on the project is 18 percent and your pretax cost savings are $264,550 per year. Requirement 1: What... 18. Your firm is contemplating the purchase of a new $540,000 computer-based order entry system. The... 18. Your firm is contemplating the purchase of a new $540,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $68,000 at the end of that time. You will be able to reduce working capital by $93,000 (this is a one-time reduction). The tax rate is 21 percent and the required return on the project is 9 percent. If the pretax cost savings are $150,000 per year, what is... Your firm is contemplating the purchase of a new $555,000 computer-based order entry system. The system... Your firm is contemplating the purchase of a new $555,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $77,000 at the end of that time. You will save $169,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $102,000 (this is a one-time reduction). If the tax rate is 24 percent, what is the IRR for this project? (Do... Your firm is contemplating the purchase of a new $570,000 computer-based order entry system. The system... Your firm is contemplating the purchase of a new $570,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $86,000 at the end of that time. You will save $175,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $111,000 (this is a one-time reduction). If the tax rate is 22 percent, what is the IRR for this project? (Do... Your firm is contemplating the purchase of a new $794,500 computer-based order entry system. The system... Your firm is contemplating the purchase of a new $794,500 computer-based order entry system. The system will be depreciated straight-line to zero over its seven-year life. It will be worth $59,000 at the end of that time. You will be able to reduce working capital by $54,000 at the beginning of the project. Working capital will revert back to normal at the end of the project. Assume the tax rate is 30 percent. Suppose your required return on the project... Your firm is contemplating the purchase of a new $2,146,000 computer-based order entry system. The system... Your firm is contemplating the purchase of a new $2,146,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $208,800 at the end of that time. You will be able to reduce working capital by $290,000 (this is a one-time reduction). The tax rate is 33 percent and your required return on the project is 20 percent and your pretax cost savings are $670,500 per year.    Requirement 1:... ADVERTISEMENT Need Online Homework Help? Get Answers For Free Most questions answered within 1 hours. Ask a Question ADVERTISEMENT Active Questions Which document is necessary in establishing outsourcing relationships with an application service provider (ASP)? Service Level... asked 4 minutes ago In order to conduct a hypothesis test for the population proportion, you sample 450 observations that... asked 10 minutes ago Doctor’s Order: Vancomycin 500mg tab i po q12h X 7 days Available: Vancomycin 500mg tablets What... asked 23 minutes ago Calculate the ΔG∘rxn for the reaction using the following information. 4HNO3(g)+5N2H4(l)→7N2(g)+12H2O(l) ΔG∘f(HNO3(g)) = -73.5 kJ/mol; ΔG∘f(N2H4(l))... asked 24 minutes ago Question 03: Saturn Shoes (Pvt.) Ltd manufacture multi-style fashion boots for the residents of Missouri. Leather... asked 26 minutes ago A highway with a design speed of 100 km/hr is designed with a sag curve connecting... asked 38 minutes ago Shift Registers can be used for serial/parallel interface applications. True or false? asked 1 hour ago Scenario 1: To describe the instructors’ experience, the researcher records the year in which each instructor... asked 1 hour ago develop a flowchart or pseudocode to check the prime numbers 1- below 100 what to do... asked 1 hour ago Which of the following statements are true? I. The sampling distribution of ¯xx¯ has standard deviation... asked 1 hour ago Which of the following methods of reporting cash flows provided by operating activities does the Financial... asked 1 hour ago SITUATION 2: EFFECTIVE STRESS An engineer investigates a granular soil deposit, 4 meters thick, overlaying a... asked 1 hour ago About Contact Terms of Use Privacy Policy Academic Honesty Policy Homework Answer Scanner App Report DMCA © 2022 JustAAA   user contributions licensed under cc by-sa 4.0