AutoSave ( OFF A 9 9 9 . C ... FIN 210_EXAM2_Excel Home Insert Draw Page Layout Formulas Data Review View ? Tell me Calibri (Body) 11 A A ab Wrap Text " Accounting Conditional Format Cell Insert Delete Format DV Paste IUV Merge & Center v $ ~ % Formatting as Table Styles Styles Font Number Cells Clipboard Alignment 619 + XVfx G H K M 1 With an Initial Investment of a Semi Truck for $160,000 and Cash Flows for 7 Years and an expected residual value of the Semi Truck of $25,000 after the 7 years, 2 What is the NPV for this Semi Truck assuming a 7% discount rate? What would be the IRR? (HINT: 7th year cash flows will be cash + residual value) 6 Initial Investment 160,000.00 Discount Rate 7% 1.00 2.00 3.00 4.00 5.00 6.00 7.00 Residual Value Cash Flows 27,000.00 32,000.00 31,000.00 35,000.00 38,000.00 43,000.00 48,000.00 25,000.00 56 00 10 11 12 NPV 13 14 IRR 15 27 28 29 NPV DCF EV Relative Valuation Ready 68 9 - MacBook Air OSC 88 5 9