Question

Factor Company is planning to add a new product to its line. To manufacture this product, the company needs to buy a new machine at a $880,000 cost with an expected four-year life and a $60,000 salvage value. All sales are for cash, and all costs are out-of-pocket, except for depreciation on the new machine. Additional information includes the following. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided. Round PV factor value to 4 decimal places.) Expected annual sales of new product Expected annual costs of new product $2,840,000 520,000 712,000 736,000 200,000 Direct materials Direct labor Overhead (excluding straight-line depreciation on new machine) Selling and administrative expenses Income taxes 30% Required: 1. Compute straight-line depreciation for each year of this new machine's life. 2. Determine expected net income and net cash flow for each year of this machine's life. 3. Compute this machine's payback period, assuming that cash flows occur evenly throughout each year. 4. Compute this machine's accounting rate of return, assuming that income is earned evenly throughout each year. 5. Compute the net present value for this machine using a discount rate of 3% and assuming that cash flows occur at each year-end. Hint:Salvage value is a cash inflow at the end of the asset's life.) Required1Required 2Required 3 Required 4Required 5 Compute straight-line depreciation for each year of this new machine's life. Straight-line depreciation Required 1 Required 2Required 3 Required 4Required 5 Determine expected net income and net cash flow for each year of this machine's life Expected Net Income Revenues Expenses Expected Net Cash Flow Required 1 Required 2 Required 3 Required 4Required 5 Compute this machine's payback period, assuming that cash flows occur evenly throughout each year. Payback Period Choose Numerator: Choose Denominator:Payback Period - Payback period Required 1 Required 2 Required 3 Required 4Required 5 Compute the net present value for this machine using a discount rate of 3% and assuming that cash flows occur at each year- end. (Hint: Salvage value is a cash inflow at the end of the asset's life.) (Do not round intermediate calculations. Amounts to be deducted should be indicated by a minus sign.) Chart Values are Based on: Select Chart Cash Flow Annual cash flow Residual value x PV FactorPresent Value Amount Net present value

Answer 1

Solution 1:

Straight line depreciation = ($880000 - $60000) / 4 = $205,000

Solution 2:

Expescted Net Income
Revenues:
Sales		$28,40,000
Expenses:
Direct Materials	$5,20,000
Direct Labor	$7,12,000
Overhead excluding depreciation	$7,36,000
Selling and administrative expenses	$2,00,000
Straight line depreciation	$2,05,000
Total Expenses		$23,73,000
Income before taxes		$4,67,000
Income tax expense (30%)		$1,40,100
Net Income		$3,26,900
Expected net Cash Flow
Net Income		$3,26,900
Add: Straight line Depreciation		$2,05,000
Net Cash Flow		$5,31,900

Solution 3:

Payback Period
Choose Numerator	/	Choose Denominator	=	Payback Period
Cost of investment	/	Annual net Cash flow	=	Payback Period
$8,80,000	/	$5,31,900	=	1.65
				Years

Solution 4:

Accounting rate of Return
Choose Numerator	/	Choose Denominator	=	Accounting Rate of Return
Annual Net Income after tax	/	Average Investment	=	Accounting Rate of Return
$3,26,900	/	$4,70,000	=	69.55%

Solution 5:

	Chart Values are based on
	n=	4
	i=	3%
Cash Flow	Select Chart	Amount	*	PV Factor	=	Present Value
Annual cash Flow	Present Value of an annuity of 1	$5,31,900	*	3.7171	=	$19,77,125
Residual Value	present value of 1	$60,000	*	0.8885	=	$53,310
	Present value of cash inflows					$20,30,435
	Present value of cash outflows					-$8,80,000
	Net Present Value					$11,50,435