KADS, Inc. has spent $400,000 on research to develop a new computer game. The firm is planning to spend $200,000 on a machine to produce the new game. Shipping and installation costs of the machine will be capitalized and depreciated; they total $50,000. The machine has an expected life of three years, a $75,000 estimated resale value, and falls under the MACRS (Links to an external site.) 7-year class life. Revenue from the new game is expected to be $600,000 per year, with costs of $250,000 per year. The firm has a tax rate of 25 percent, KADS has an opportunity cost of capital of 15 percent, and it expects net working capital to increase by $100,000 at the beginning of the project.

Ch 12.6 Deliverable: Complete the Ch 12 Problem #6 Excel worksheet and answer the following questions

Q.1 What will the cash flows for this project be? Q.2 According to the Management Report, should KADS go forward with the project?

Chrome File Edit View History Bookmarks Profiles Tab Window Help 25 Q8 O Wed Dec 8 3:11 PM AutoSave @@@ -C$ Ch12 M_Finance_Prob_band9 (2) - Saved to my Mac SP Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 YA = = 30 2. Wrap Text s v General LV Paste B TU Uw A A. = = = + = Merge & Center . 98 Conditional Format Cell Formatting as Table Styles Insert Delete Format Sort & Filter Find & Select Analyze Data L31 fx H D F 6 H K 1.4 N P R T NPV - Investment Analysis Iniment Corto qual Cow of his to Decount Rent Rear MIRR ) TR Working Cap Conne Bulgulament Evil or Pro Miragement Summary NPV at 0% 50 IRRI PANUMI MRR PDWGI P.I. DIVI Payback 0.00 Disa Paybook 0.00 1C 11 12 13 13 10 17 18 19 1 Z First year change in we Reench year Fredywar chugain op Expres horses as we He-Yr Carnbution of other Rue Annual Caniballen Ihre DECE Incremental Income Beer wear 0 change in revenues carballution ch exam MACRS ah deproelation EBIT Taxes ch. Net Income Convert change in einee Imo change in cash low Net Income add back depreciation OCF of New Equipment SD $0 $0 80 80 911 SO $0 en $ Bon Value 21 22 SD 80 $0 24 SD So 50 SO $0 $11 $ 311 su 22 90 $0 $ SD 30 50 $0 $0 SO 31 33 M Corshow for sale of prett In Hal Investment mais Working Capital Commitmen $0 $2 $0 | | ATF = i + [ WO-TU Sell Equipment at End of Pro 37 30 Nat change in CF $ 311 $11 $0 SD SO 80 $0 SO 92 4- 42 Netatange in CF 22 Cumulative CF 4 Payback Discourried to Disc Cumulative CF 27 Diso Paybook 29 20_MACRS 3-year 9 $0 92 $0 $ $0 50 311 SO $11 $0 year 2 14.15% yaar1 51 E year 1 13 IX year 1 20.00% year 1 MAGAS 5-year year 3 14 1 % year 3 19.20% year 3 17.49% year 4 4 741 year 11.02 year 4 12.40% 22.00% MCRS 7-year years 5.76% year 8.02% 1.62% years 8.93 year 2 24.49% year 8984 your! 4.46% 54 ET Prob Ch 12.6 Prob Ch 12.9 + Ready 85%