Download the Applying Excel form and ente formules in a that contain question marks Foreca incelenter the form NoteThe presentados de comedong the button Excel fonction PV, but wt lecun en ting the format in opende Verty that your worshest matches the example the text Check your worksheet by change the discount rate to to. The best should now be between 556.400 and $56505ping on the precision of the comme range. And the son on your worksheet and correct them you ad not use formules to calculate the scout Factor be sure that the values are updated appropriately on the end als at the bonam of the sheet nad of using the Discount factors Click here to view and Exh2 to the proprie discourse tables Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse Next, cick Save. You will use this worksheet to answer the questions in Part 2 Data Om OCH wy 1500 3 RE 11 C CE VIE oso W 13 14 10.14 11 VE 2 1 heep 30w 31 Ac perating con 24 Opment 26 Ward T TO Find Penca CSS Presente wenyewe Download the Applying Excel form and enter formules in all cate that contain question marte Forence Center the formule Note: The present factors could be come in the base function but congres Verity that your worst matches the camp in the text Check your worksheet by change the contrato 10%The net present should now be and Spongono tange. And the error in your worksheet and cond then you did not sem contacto estado ng to de bottom of the sheet med at sige Decounter Click here to view and MD2 to determine the appropriate contact Save your completed Applying bacel form to your computer and then upload it here by clicking Browse" est, click Save You use this worksheets Part Enable Editing G PROTECTED VIEW Belstrom the Internet can contain viet Unless you need to edit safe to stay in Protected A17 B c D E 4 Example E 5 Cost of equipment needed 560.000 6 Working capital needed $100,000 7 Overhaul of equipment in four years $5.000 8 Salvage value of the equipment in five years $10.000 9 Annual revenues and costs 10 Sales revenues $200,000 1 Cost of goods sold $125.000 2 Out-of-pocket operating costs $35.000 3 Discount rate 14% 4 5 Enter a formula into each of the cells marked with a ? below 6 Exhibit 14-8 7 Years Now 1 2 3 Purchase of equipment 2 Investment in working capital 2 Sales 2 2 Cost of goods sold 2 2 2 Out-of-pockel operating costs ? 2 2 Overhaul of equipment Salvage value of the equipment Working capital released 2 Total cash flows (a) 2 2 2 Discount factor (14%) (b) 2 2 Present value of cash flows (a) (b) 2 2 Net present value ? 4 5 2 2 2 ? 2 2 . 2 2 2 ? 2 Use the formulas from Appendix 138 Pracant van 111 rin