CASE SOLUTION.xlsx - Sales Manufacturing Expenses Selling Administrative Expenses Research Development Expenses Profit Before Tax Tax Profit After Tax $

CASE SOLUTION.xlsx - Sales Manufacturing Expenses Selling...

This preview shows page 1 - 3 out of 6 pages.

2012 2013 2014 2015 Sales $ 142,528 $ 145,949 $ 149,451 $ 153,038 Manufacturing Expenses $ 79,246 $ 81,147 $ 83,095 $ 85,089 Selling & Administrative Expenses $ 30,358 $ 31,087 $ 31,833 $ 32,597 Research & Development Expenses $ 3,563 $ 3,649 $ 3,736 $ 3,826 Profit Before Tax $ 29,361 $ 30,065 $ 30,787 $ 31,526 Tax $ 10,276 $ 10,523 $ 10,775 $ 11,034 Profit After Tax $ 19,084 $ 19,543 $ 20,012 $ 20,492 Accounts Receivable $ 17,673.47 $ 18,097.64 $ 18,531.98 $ 18,976.75 Inventory $ 23,802.18 $ 24,373.43 $ 24,958.39 $ 25,557.39 Accounts Payable $ 11,687.30 $ 11,967.79 $ 12,255.02 $ 12,549.14 Working Capital Requirement $ 29,788.35 $ 30,503.27 $ 31,235.35 $ 31,985.00 0 1 2 3 2012 2013 2014 2015 Cash Flow Statement Cash Flow from Operating Activity Net Income $ 19,543 $ 20,012 $ 20,492 Depreciation $ 2,525 $ 2,600 $ 2,675 Net Change in Working Capital $ 715 $ 732 $ 750 Cash Flow from Investing Activity Investment $ -265,000 Capital Expenditure $ 1,738 $ 1,500 $ 1,500 Net Cash Flow $ -265,000 $ 19,615 $ 20,379 $ 20,917 Terminal Value Total Net Cash Flow $ -265,000 $ 19,615 $ 20,379 $ 20,917 WACC 7.08% Present Value of Net Cash Flow $ -265,000 $ 18,318 $ 17,774 $ 17,036 Net Present Value $ -5,036 IRR 6.77%
Image of page 1
2016 2017 2018 2019 2020 2021 $ 156,711 $ 160,472 $ 164,324 $ 168,267 $ 172,306 $ 176,441 $ 87,131 $ 89,223 $ 91,364 $ 93,557 $ 95,802 $ 98,101 $ 33,379 $ 34,181 $ 35,001 $ 35,841 $ 36,701 $ 37,582 $ 3,918 $ 4,012 $ 4,108 $ 4,207 $ 4,308 $ 4,411 $ 32,283 $ 33,057 $ 33,851 $ 34,663 $ 35,495 $ 36,347 $ 11,299 $ 11,570 $ 11,848 $ 12,132 $ 12,423 $ 12,721 $ 20,984 $ 21,487 $ 22,003 $ 22,531 $ 23,072 $ 23,625 $ 19,432.19 $ 19,898.56 $ 20,376.13 $ 20,865.15 $ 21,365.92 $ 21,878.70 $ 26,170.77 $ 26,798.87 $ 27,442.04 $ 28,100.65 $ 28,775.07 $ 29,465.67 $ 12,850.32 $ 13,158.73 $ 13,474.53 $ 13,797.92 $ 14,129.07 $ 14,468.17 $ 32,752.64 $ 33,538.70 $ 34,343.63 $ 35,167.88 $ 36,011.91 $ 36,876.19 4 5 6 7 8 9 2016 2017 2018 2019 2020 2021 $ 20,984 $ 21,487 $ 22,003 $ 22,531 $ 23,072 $ 23,625 $ 2,750 $ 2,825 $ 2,900 $ 2,975 $ 3,050 $ 3,125 $ 768 $ 786 $ 805 $ 824 $ 844 $ 864 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 21,466 $ 22,026 $ 22,598 $ 23,182 $ 23,778 $ 24,386 $ 219,476 $ 21,466 $ 22,026 $ 22,598 $ 23,182 $ 23,778 $ 243,862 $ 16,327 $ 15,646 $ 14,991 $
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 6 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes