Question

1 Approved Answer

Posted on Oct 02, 2024

this is the only table given 1. (30% Marks) For Project B data given in table 12.2 determine the following values and compare them with

this is the only table given image text in transcribed

1. (30% Marks) For Project B data given in table 12.2 determine the following values and compare them with Project A: a. Determine the Payback Period in years. b. Determine the Discounted Payback Period in years. c. Determine the Present Worth of the net profits. d. Determine the Future Worth of the net profits. e. Determine the Average Annual Worth of the net profits. f. Determine the Returns on Investment - ROI and ROI-D, and AW (ROI) Table 12.1: Cash flows of additive manufacturing project (Project A) Depreciation Total Taxable Net Flow Expanse Amen Flow Discounted Cumulative Discounted Net Cash Net CFAT Profits Flow Profits Foun-TECTATIO INP. 0 20,000 30,000 690293420,066 -1,643 10,17 9,929 DRIO DO EU 50.000 CFBTO LCF(0) - 50.000 20,000 20.000 -8.00 -800 20,000 -8.042 Cash Total After Profits Profits Taxes 0 -30,000 -30,000 0 534 11.24 -18,576 -1,448 13,406 -5,170 2.172 -1,371 4746 7212 2,042 2.113 5.747 6,518 13,482 15,524 9 .777 3.000 12.000 27.924 92.000 18,349 27,524 27.524 CEALAD - 20000 11.958 11,28 11,958 2.000 1,395 33.33 44.45 16,665 22,225 1,335 -3.621 3.705 16,295 2 5,590 5.966 7.708 .466 ,521 4 8 9.334 15290 30.000 200.000 20.000 0 00 20,000 45,873 4,127 4,127 100 100 50,000 45,873 Table 12.2: Cash flows of computer security project (Project B) Depreciation Cash Flow Reverse Exp Flow Flow Taxable Income Taxes Paid Total Cash Flow Total Net Profits Net Cash Amount Rate Amount CFAT Profits ROE 0 30.000 0 Cumulative Discounted Discounted VT Net Profits Flow Profis FlowAT ICFATU) INPU). 33.000 25,000 20 6 .881 -18 119 18 7 415 -10,484 4.800 3,953 6.515 9,146 17.18 2.500 CIUTO LCRO CHALO ODRODOTHO TROCFATIO ECFATIONPO EBOU .000 - 50.000 25.000 25.000 0 25.000 -25,000 12.000 20.00 10.000 5,500 2.2009 3.000 1.91 32.00 16,000 39 15 10,098 -6,789 3.323 12.000 18.000 3.547 30.113 1.369 19.20 2001 2.812 42197.50 2,000 ,000 1 9 ,113 717 11:52 11,5234 .00 5.504 5,816 13.00 15.000 9 18.000 11.52 5.76012200 27.44 21,800 12.000 18.000 18.000 15,120 30.872 100.00 50.000 30,872 30.000 30,000 30.000 TIL UDCNTE 20.581 Depreciation Total Total Taxable Paid Profits Cash Rate Profits CFAT Profit ( O 1 RO EO CFBTO LCFO CFALCO LODRODOTIO 0 507300 -50,000 25000 25.000 .000 12.000 15.000 -7.7 10,113 2,500 20100 10000 5.500 3 0,000 12.000 18.000 -7,887 10,113 1.961 32.00 16.000 30.000 1.000 1.000 -7710,113 1.69 19.20 9.600 7,031 3 0.000 12.000 18,000 -7.887 10,113 717 11.525.760 11,323 0 18.000 11.52 5,760 12,240 30,000 12.000 18.000 0 18.000 150.000122.000 58.000 6,547 51,453 6,547 51.453 2 Cumulative Discounted Discounted Net Net Profis Flow CAP Profits Fons AT ICFATO ENPYOL 0 25.000 25,000 2.870 .881 -18,119 2 .870 7,635 -10,484 2.887 2.774 4.800 -508 -2,536 4,915 $116 17.157 TPO CFATO ECFATO NP/t) EBOX 0 -25000 25.000 0 0 2.200 7,913 -170 3. KOO 00 6,999233,323 2012 7,101 312 42197502 6,91414,456 21.800 6.048 11,952 30372 9,002 20.581 30,872 30.872 4 1993 80 15.1.20 Fit to widt Eable 12.1: Cash flows of additive manufacturing project (Proje Depreciation End of Year Revenue Expanse Flow Flow Cash Flow Before Taxes Loan Cash Flow Cash Flow After Loan Loan Interest Amount Taxable Income Rate Amount RO) (0) O 1 0 2 ED) CFBTC LCF) CFALOLIO 50,000 -50,000 20,000 -30,000 0 30,000 20,000 -8,042 11,958 2,000 30,000 20,000 -8,042 11,958 1,396 30,000 20,000 -8,042 11,958 737 30,000 20,000 0 20,000 0 30,000 20,000 0 20,000 200,000 50,000 -4,127 45,873 4,127 50,000 5 0,000 50,000 5 0,000 50,000 250,000 3 DRODOTTICI 0 0 33.33 16,665 1,335 44.45 22,225 -3,621 14.81 7,405 11,864 7 .41 3,705 16,295 0.00 0 20,000 100 50,000 45,873 4 5 Totals Table 12.2: Cash flows of computer security project (Project B) End of Year Depreciation Revenue Expanse Flow Flow Cash Flow Before Cash Flow Loan Cash Loan Interest Amount Flow After Loan Taxable Income Taxes Rate Amount LI(C) DR(t) D(t) TI(C) 2,500 it to width 5,500 1,961 R(t) 0 30,000 30,000 30,000 30,000 30,000 30,000 180,000 Et) 50,000 12,000 12.000 12.000 12,000 12,000 12,000 122,000 CFBT(0) -50,000 18,000 18,000 18,000 18,000 18,000 18.000 58,000 LCF(t) 25,000 -7,887 -7,887 -7.887 -7,887 0 0 -6,547 CFAL(t) -25,000 10,113 10,113 10,113 10,113 18,000 18,000 51,453 1.369 5 717 20.00 32.00 19.20 11.52 11.52 5.76 100.00 10,000 16,000 9,600 5,760 5,760 2,880 50.000 7,031 11,523 12.240 15,120 51,453 Page View Totals 6,547 All Read Taxable Total Taxes Total Cash Flow Income Net Paid Net Profits Profits R! Tit) EBO(C) Cash Flow After Taxes CFAT(t) -30,000 11,424 13,406 7,212 13,482 12,000 27,524 0 TP(t) 0 534 -1,448 4,746 6,518 8,000 18,349 1,335 -3,621 11,864 16,295 20,000 45,873 CEAT(0) -30,000 -18,576 -5,170 2,042 15,524 27,524 Cumulative Discounted Discounted Net Cash CFAT Net Profits Flow Profits Profits Flows-AT ECFAT() ENPC). 0 -30,000 -30,000 697 9,934 -20,066 697 -1,643 10,137 -9,929 -946 4,742 -5,187 3,734 5,590 7,708 2,521 9,324 5,966 5,966 8,487 15,290 15,290 8,487 NPC) 0 801 -2,172 7,118 9,777 12,000 27,524 801 -1,371 5,747 15,524 27,524 4,680 ject B) Cash Flow Net Taxable Income Taxes Paid Total Cash Flow Total Net Profits After Profits Taxes NPO 0 3,300 5,500 39 7,031 11,523 12,240 0 2,200 - 15 2,812 4,609 4,896 CFAT() CFATO -25,000 -25,000 7,913 -17,087 10,098 -6,989 7,301 312 5,504 5,816 13,104 18,920 11,952 30,872 30,872 (0) 0 3,300 3,323 7,542 14,456 21,800 30,872 Cumulative Discounted Discounted Net Cash CFAT Net Profits Flow Profits Profits Flow- CFAT() . 0 -25,000 -25,000 2,870 6 ,881 -18,119 2,870 18 7,635 -10,484 2,887 2,774 4,800 -5,683 5,661 3,953 3,147 -2,536 9,614 3,651 6,515 3,979 13,265 3,922 5,167 9,146 17,187 17,187 9,146 4,219 6,914 7,344 9,072 30,872 51,453 20,581