Chapter_13_Applying_Excel_Student Form Q- Search Sheet Formulas Data Review View .10 x Auto Sum Home Insert Xcut Copy Paste Format H1 x v Page Layout Arial BIV fx| . A- A A y = E to Wrap Text Merge & Center Ceneral $ % : . 3*. # 3 3 3 ) Conditional Format Formatting as Table Call Styles i nsart Delete Format Sort & Clear Filter 1 Chapter 13: Applying Excel Data 4 Example E Coat of equlomert needed 6 Worldng capital needed 7 Overhaul of equipment in four years 8 Salvage value of the equipment in five years 9 Annual revenues and costs 10 Sales Manues 11 Cast of goas sold 12 Quot parket operating costs 13 Dscourt rada $350,000 S33,030 $31.030 $35.0: $43.01:10 . $35.000 16% 15 Enter a formula ito cach a the calls marked with a bolow 16 Exhibit 13-9 Years Now 19 Purchase of equipment 20 Investment in working capital 21 Sales 22 Cast of poacs sold 23 Out-of-packel operating US.S 24 Overhaul of equipment 25 Salvage value of the equipment 26 Working capital relegged 27 Total cash none (8) 28 Decourt factor (44%) (b) 29 Preeent value of cash fOAS (a) x (6) 39 Net present value 32 "Use the formules from Appendix 13B: 33 Present value of $1 = 1.11+ri'n 34 Prosent value of an annuity of $ = (ir)"1141/(1-1 ) 35 waren in the number of years and is the discourt rate 37 PLEASE ANSWER QUESTIONS BELOW (A,B,C,D 38 The Company is considering project involving the purchase of new scuipment Change the data area of your worksheet 40 A What is the represent a nd the project Round rasend value factoria 3 decimals and round all other intermediate calcuniars a whole dollar 41 Nat Pmant Vaunu 42 C. The internal rate of return is between what the whole discount ratesc.g., atunen 10% and 11%, between 11% and 12%, may? 43 The internal rate of return is betwee and 44 D. Reset the discount rate to 18%. Suppose the salvage is uncertain. How large would the salvage have to be to result in a sositive net present value? 45 Minimum salvape value required to generale a pastive present value Chapter 13 Form + Ready EG - + 111%