Diltz Farms is considering investing in an automated egg-sorting system to increase production for international (web-based) sales of Diltz Farms' products. The new system will c $3531 including installation. It will be fully depreciated in 5 yrs.(straight-line) to zero and generate $193 after-tax gain at the end of the projected period (year 6 ). The initial work captital will be $247 and will be $585 in year one and increase each year thereafter by 5 percent.Assume that at year 0 , there is no change in working capital. Revenues generate from the egg-sorter are expected to be $1086 in year one, and increase by five percent each year. Expenses are ten percent of revenues. Diltz Farms' cost of capital it the discounted cash-flow analysis, should Diltz Farms invest in the machinery? What is the NPV of the egg-sorter project? Asume Tax rate as 35% Identify, the values from the questions for cells C14,C15,C16,C17,C19,C20 and C21. Depreciable Basis = Cost of the Asset - Book Value at the end of its life Sometimes, if we do not have information about Book Value of an asset at the end of its useful life, we might use Salvage Value in those cases to find depreciation. Net present value using Discount factor If you directly use NPV formula, you will not get points. IRR using formula If you use GoalSeek for IRR, you will not get points. Diltz Farms is considering investing in an automated egg-sorting system to increase production for international (web-based) sales of Diltz Farms' products. The new system will c $3531 including installation. It will be fully depreciated in 5 yrs.(straight-line) to zero and generate $193 after-tax gain at the end of the projected period (year 6 ). The initial work captital will be $247 and will be $585 in year one and increase each year thereafter by 5 percent.Assume that at year 0 , there is no change in working capital. Revenues generate from the egg-sorter are expected to be $1086 in year one, and increase by five percent each year. Expenses are ten percent of revenues. Diltz Farms' cost of capital it the discounted cash-flow analysis, should Diltz Farms invest in the machinery? What is the NPV of the egg-sorter project? Asume Tax rate as 35% Identify, the values from the questions for cells C14,C15,C16,C17,C19,C20 and C21. Depreciable Basis = Cost of the Asset - Book Value at the end of its life Sometimes, if we do not have information about Book Value of an asset at the end of its useful life, we might use Salvage Value in those cases to find depreciation. Net present value using Discount factor If you directly use NPV formula, you will not get points. IRR using formula If you use GoalSeek for IRR, you will not get points
