theluding installabion. It will be fully depreciated in 5ym (otraight-line) to zero and generate 3278 after-tx gain at the cnd of the projected period (year 6 . The initial working captital will be $297 and will be $650 in year one and increase each year theneafler by 5 persent A ssume that at year 0 , there is no change in working capital Reveauer generaled from the cgg-sorter are sbould bilte Farms invest ia the machinery? What is the NPV of the egR-10iter project? Asume Tax nite as 35% In cell CZ3 enter - Cl4 In cell 124 mier Clg In eell C25 cater the intial working capital from it In cell D2S eater the working capital for year I fin Is cell 825 enter : 105D25 and then drag it till In cell Cr6 enier 0 In cell D26 cater -D25. C25 and thon drag it till 12 In cell D27 enter de revenue for yeut I from the propers le eell 127 enter D27+1 o5 and ihen drag it till H. In cell D2k entar: D27.0.1 In cell E28 enter: -D2s* 1 . OS and then drag it till I In cell D29 criter: 50518 and then dres it till 129 In cell DS0 cuter: -D27.D28.D29 and then trag it t If cell D31 enter - 5C521D30 and then drag it 181 Is cell D32 euter: -D30-D31 end then drag it nill H3 In cell C34 enter =.C23 In cell C35 mier: C26 and drag it bill 135 Is cell t35 enter: =126+124 In cell D36 enter, D32+D29 and drag it till H36 Na prrant valis uving Diceum fattar IthR using farmula brow dinctly use NeV formula, jou wilf nat ger points In cell C97 enter - wum(C34, C35, C36) and drag it ul theluding installabion. It will be fully depreciated in 5ym (otraight-line) to zero and generate 3278 after-tx gain at the cnd of the projected period (year 6 . The initial working captital will be $297 and will be $650 in year one and increase each year theneafler by 5 persent A ssume that at year 0 , there is no change in working capital Reveauer generaled from the cgg-sorter are sbould bilte Farms invest ia the machinery? What is the NPV of the egR-10iter project? Asume Tax nite as 35% In cell CZ3 enter - Cl4 In cell 124 mier Clg In eell C25 cater the intial working capital from it In cell D2S eater the working capital for year I fin Is cell 825 enter : 105D25 and then drag it till In cell Cr6 enier 0 In cell D26 cater -D25. C25 and thon drag it till 12 In cell D27 enter de revenue for yeut I from the propers le eell 127 enter D27+1 o5 and ihen drag it till H. In cell D2k entar: D27.0.1 In cell E28 enter: -D2s* 1 . OS and then drag it till I In cell D29 criter: 50518 and then dres it till 129 In cell DS0 cuter: -D27.D28.D29 and then trag it t If cell D31 enter - 5C521D30 and then drag it 181 Is cell D32 euter: -D30-D31 end then drag it nill H3 In cell C34 enter =.C23 In cell C35 mier: C26 and drag it bill 135 Is cell t35 enter: =126+124 In cell D36 enter, D32+D29 and drag it till H36 Na prrant valis uving Diceum fattar IthR using farmula brow dinctly use NeV formula, jou wilf nat ger points In cell C97 enter - wum(C34, C35, C36) and drag it ul
