Hello, I am trying to compute NPV, IRR, Payback Period, Discount Rate, Terminal Value. I already have computed some related information, but I need further assistance on how to do above mentioned.

Can I get assistance on how to do that? Here's the information I already have.

Thank you.

New Heritage Doll Company: Capital Budgeting Exhibit 1 Selected Operating Projections for Match My Doll Clothing Line Expansion 2010 2011 2012 2013 2014 2015 4,500.00 6,860.00 8,408.80 9,081.50 9,808.00 0.52 0.23 0.08 0.08 575.00 575.00 586.50 598.20 610.10 2,035.00 3,403.80 4,290.60 4,669.00 5,078.40 152.20 152.20 152.20 152.20 164.40 0.00 2,762.20 4,131.00 5,029.30 5,419.40 5,852.90 Selling, General & Administrative 1,250.00 1,155.00 1,735.00 2,102.20 2,270.30 2,452.00 Total Operating Expenses 1,250.00 3,917.20 5,866.00 7,131.50 7,689.70 8,304.90 (1,250.00) 582.80 994.00 1,277.30 1,391.80 1,503.10 Minimum Cash Balance as % of Sales 3.0% 3.0% 3.0% 3.0% 3.0% Days Sales Outstanding 59.2x 59.2x 59.2x 59.2x 59.2x 7.7x 8.3x 12.7x 12.7x 12.7x 30.8x 30.9x 31.0x 31.0x 31.0x 1,470.00 952.20 152.20 152.20 333.80 360.50 2010 2011 135.00 76.05 359.66 127.35 443.37 356.63 2012 205.80 115.94 500.12 189.84 632.02 (188.65) 2013 252.26 142.11 396.01 229.97 560.41 71.61 2014 272.45 153.48 426.72 247.97 604.68 (44.27) 2015 294.24 165.76 460.86 267.81 653.04 (48.37) (1,250.00) 0.00 (1,250.00) 582.80 233.12 349.68 152.20 501.88 994.00 397.60 596.40 152.20 748.60 1,277.30 510.92 766.38 152.20 918.58 1,391.80 556.72 835.08 152.20 987.28 1,503.10 601.24 901.86 164.40 1,066.26 (1,250.00) (800.00) (1,470.00) (3,520.00) 501.88 356.63 (952.20) (93.69) 748.60 (188.65) (152.20) 407.75 918.58 71.61 (152.20) 837.99 987.28 (44.27) (333.80) 609.21 1,066.26 (48.37) (360.50) 657.39 Revenue Revenue Growth Production Costs Fixed Production Expense (excl depreciation) Variable Production Costs Depreciation Total Production Costs Operating Profit Working Capital Assumptions: Inventory Turnover (prod. cost/ending inv.) Days Payable Outstanding (based on tot. op. exp.) Capital Expenditures Net Working Capital Accounts Minimum Cash Balance Accounts Receivable Inventory Accounts Payable Total Net Working Capital Change in Net Working Capital 800.00 (800.00) Operating Cash Flow (OCF): EBIT Tax 40% Earning After Tax Plus Depreciation Total OCF (1,250.00) Free Cash Flow (FCF): Operating Cash Flow Change in Net Working Capital Less Capital Expenditures Total FCF Net Present Value Internal Rate of Return Payback Period 2016 2017 2018 2019 2020 10,592.66 11,440.07 12,355.20 13,343.70 14,411.20 0.08 0.08 0.08 0.08 0.08 622.30 634.80 647.50 660.40 673.70 5,521.30 6,000.30 6,518.50 7,078.80 7,684.70 177.50 191.70 207.10 223.60 241.50 6,321.10 6,826.80 7,373.10 7,962.80 8,599.90 2,648.10 2,860.00 3,088.80 3,335.90 3,602.80 8,969.20 9,686.80 10,461.90 11,298.70 12,202.70 1,623.46 1,753.27 1,893.30 2,045.00 2,208.50 3.0% 3.0% 3.0% 3.0% 3.0% 59.2x 59.2x 59.2x 59.2x 59.2x 12.7x 12.7x 12.7x 12.7x 12.7x 31.0x 31.0x 31.0x 31.0x 31.0x 389.30 420.50 454.10 490.50 529.70 2016 317.78 179.02 497.72 289.24 705.29 (52.24) 2017 343.20 193.34 537.54 312.38 761.71 (56.42) 2018 370.66 208.81 580.56 337.37 822.65 (60.94) 2019 400.31 225.51 626.99 364.36 888.46 (65.81) 2020 432.34 243.56 677.16 393.51 959.54 (71.08) 1,623.46 649.38 974.08 177.50 1,151.58 1,753.27 701.31 1,051.96 191.70 1,243.66 1,893.30 757.32 1,135.98 207.10 1,343.08 2,045.00 818.00 1,227.00 223.60 1,450.60 2,208.50 883.40 1,325.10 241.50 1,566.60 1,151.58 (52.24) (389.30) 710.03 1,243.66 (56.42) (420.50) 766.74 1,343.08 (60.94) (454.10) 828.04 1,450.60 (65.81) (490.50) 894.29 1,566.60 (71.08) (529.70) 965.82 New Heritage Doll Company: Capital Budgeting Exhibit 2 Selected Operating Projections for Design Your Own Doll 2010 Revenue Revenue Growth Production Costs Fixed Production Expense (excl depreciation) Variable Production Costs Depreciation Total Production Costs Selling, General & Administrative Total Operating Expenses Operating Profit 2011 0 2012 6,000 2013 14,360 139.3% 2014 20,222 40.8% 2015 21,435 6.0% 1,201 1,201 0 0 0 0 0 0 1,650 2,250 310 4,210 1,240 5,450 1,683 7,651 310 9,644 2,922 12,566 1,717 11,427 310 13,454 4,044 17,498 1,751 12,182 436 14,369 4,287 18,656 (1,201) 0 550 1,794 2,724 2,779 3.0% 59.17x 12.18x 33.67x 3.0% 59.17x 12.27x 33.80x 3.0% 59.17x 12.63x 33.94x 3.0% 59.17x 12.72x 33.94x Working Capital Assumptions: Minimum Cash Balance as % of Sales Days Sales Outstanding Inventory Turnover (prod. cost/ending inv.) Days Payable Outstanding (based on tot. op. exp.) Capital Expenditures 4,610 0 310 310 2,192 826 Net Working Capital Accounts 2010 2011 0 2012 180 101 346 162 465 2013 431 243 786 372 1,088 2014 607 342 1,065 516 1,498 2015 643 362 1,130 550 1,585 (1,201.00) (1,201.00) 0.00 (1,201.00) 0.00 0.00 0.00 0.00 0.00 550.30 220.12 330.18 309.70 639.88 1,794.30 717.72 1,076.58 309.70 1,386.28 2,723.70 1,089.48 1,634.22 309.70 1,943.92 2,779.20 1,111.68 1,667.52 436.20 2,103.72 (1,201.00) 0.00 (4,610.00) (5,811.00) 0.00 0.00 0.00 0.00 639.88 0.00 (309.70) 330.18 1,386.28 0.00 (309.70) 1,076.58 1,943.92 0.00 (2,191.50) (247.58) 2,103.72 0.00 (825.70) 1,278.02 Cash Accounts Receivable Inventory Accounts Payable Total Net Working Capital Change in Net Working Capital Operating Cash Flow (OCF): EBIT Tax 40% Earning After Tax Plus Depreciation Total OCF Free Cash Flow (FCF): Operating Cash Flow Change in Net Working Capital Less Capital Expenditures Total FCF Net Present Value Internal Rate of Return Payback Period 2016 22,721 6.0% 2017 24,084 6.0% 2018 25,529 6.0% 2019 27,061 6.0% 2020 28,685 6.0% 1,786 12,983 462 15,231 4,544 19,775 1,822 13,833 490 16,145 4,817 20,962 1,858 14,736 520 17,113 5,106 22,219 1,895 15,694 551 18,140 5,412 23,553 1,933 16,712 584 19,229 5,737 24,966 2,946 3,123 3,310 3,509 3,719 3.0% 59.17x 12.72x 33.94x 3.0% 59.17x 12.72x 33.94x 3.0% 59.17x 12.72x 33.94x 3.0% 59.17x 12.72x 33.94x 3.0% 59.17x 12.72x 33.94x 875 928 983 1,043 1,105 2016 682 384 1,197 583 1,680 2017 723 407 1,269 618 1,781 2018 766 431 1,345 655 1,888 2019 812 457 1,426 694 2,001 2020 861 485 1,512 736 2,121 2,945.80 1,178.32 1,767.48 462.40 2,229.88 3,122.60 1,249.04 1,873.56 490.10 2,363.66 3,310.10 1,324.04 1,986.06 519.50 2,505.56 3,508.56 1,403.42 2,105.14 550.70 2,655.84 3,719.00 1,487.60 2,231.40 583.80 2,815.20 2,229.88 0.00 (875.30) 1,354.58 2,363.66 0.00 (927.80) 1,435.86 2,505.56 0.00 (983.40) 1,522.16 2,655.84 0.00 (1,042.50) 1,613.34 2,815.20 0.00 (1,105.00) 1,710.20