Populate the Life Cycle Cost model and answer the 4 questions at the bottom of the spreadsheet.

Chapter 9 Homework- Student- Excel FILE HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEW Foxit PDF Areeb Khan B2 10 Equipment Purchase st$825,000 Benefit $600,000 $600,000 $600,000$600,000 $600,000$600,000 $600,000$600,000 $600,000 ($63,000 $45,000 $63,000 $45,000 $30,000 $63,000) ($63,000 $63,000 Equipment Operation Maintenance Spare Parts, Tire Replacement Overhaul Income from salvage Sale $45,000 $30,000 $10 $10,000 ($,000)($10,000 $10 $125,000 $180,000 Total ($825,000 $452,000 $452,000 $452,000 $452,000 $327,000 $452,000 $452,000 $452,000 $452,000 $180,000 12 13 Discount Rate 1.000 1.080 Discounted Annual Value! $825,000) | $418,519 17 Cumulative Value($825,000) ($406,481 19 Net Present Value 20 21 Return on Investment 23 Internal Rate of Return 24 25 Payback Period 26 27 Sheet1 + 100% O Type here to search 2-12 PM 11/26/20182