Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What did I do wrong in the problem and please show all steps it is saying my total cash flows are all wrong. Diltz Farms

What did I do wrong in the problem and please show all steps it is saying my total cash flows are all wrong.image text in transcribed

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 $3839 including installation. It will be fully depreciated in 5 yrs.(straight-line) to zero and generate $236 after-tax gain at the end of the projected period (year 6 ). The initial working 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% \begin{tabular}{l|r|} \hline Cost of the Asset & 3839 \\ Life of the Asset in Years & 5 \\ \hline \end{tabular} Identify, the values from the questions for cells C14,C15,C16,C17,C19,C20 and C21. at the end of its life of an asset at the end of its to find depreciation. In cell C23 enter: =C14 In cell I 24 enter: =C19 In cell C25 enter the initial working capital from the problem In cell D25 enter the working capital for year 1 from the problem In cell E25 enter : =1.05D25 and then drag it till H25 In cell C26 enter 0 In cell D26 enter: = D25-C25 and then drag it till I26 In cell D27 enter the revenue for year 1 from the problem In cell E27 enter: = D27*1.05 and then drag it till H27 In cell D28 enter: = D 270.1 In cell E28 enter: = D28*1.05 and then drag it till H28 In cell D29 enter: =$C$18 and then drag it till H29 In cell D30 enter: = D27-D28-D29 and then drag it till H30 In cell D31 enter: =$C$21D30 and then drag it till H31 In cell D32 enter: = D30-D31 and then drag it till H32 In cell C34 enter: =C23 In cell C35 enter: =C26 and drag it till H35

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Finance questions