Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me identify c19 other values for c14-c17, C20-C21 Diltz Farms is considering investing in an automated egg-sorting system to increase production for international
Please help me identify c19 other values for c14-c17, C20-C21
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 cost \$2554 inchding installation. It will be fully depreciated in 5 yrs (straight-line) to zero and generate $255 after-tax gain at the end of the projected period (year 6 ). The initial working captital will be $255 and will be $512 in year one and increase each year thereatter by 5 percent.Assume that at year 0 , there is no change in working capital. Revenues generated from the egg-sorter are expected to be $908 in year one, and increase by five percent each year. Expenses are ten percent of revenues. Diltz Farms' cost of capital is 7.7%. Using 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 depreciationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started