Doll case analysis CFM.xlsx - 7.70 Amt in 000's Revenue Revenue Growth Production Costs Fixed Production Expense(excl depriciation Variable Production

Doll case analysis CFM.xlsx - 7.70 Amt in 000's Revenue...

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

7.70% 1 2 3 4 5 6 7 8 9 Amt in 000's 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Revenue $4,500 $6,860 $8,409 $9,082 $9,808 $10,593 $11,440 $12,355 $13,344 Revenue Growth 52.4% 22.6% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% Production Costs Fixed Production Expense (excl depriciation) $575 $575 $587 $598 $610 $622 $635 $648 $660 Variable Production Costs $2,035 $3,404 $4,291 $4,669 $5,078 $5,521 $6,000 $6,519 $7,079 Depriciation $152 $152 $152 $152 $164 $178 $192 $207 $224 Total Production Costs $0 $2,762 $4,131 $5,030 $5,419 $5,852 $6,321 $6,827 $7,374 $7,963 S,G & A Expenses $1,250 $1,155 $1,735 $2,102 $2,270 $2,452 $2,648 $2,860 $3,089 $3,336 Total Operating Expenses $1,250 $3,917 $5,866 $7,132 $7,689 $8,304 $8,969 $9,687 $10,463 $11,299 Operating Profit -$1,250 $583 $994 $1,277 $1,393 $1,504 $1,624 $1,753 $1,892 $2,045 PAT (Tax @ 40%) -$750 $350 $596 $766 $836 $902 $974 $1,052 $1,135 $1,227 Working Capital Assumptions Minimum Cash Balance as 3% of Sales $135 $206 $252 $272 $294 $318 $343 $371 $400 Days Sales Outstanding 59.2 59.2 59.2 59.2 59.2 59.2 59.2 59.2 59.2 Inventory Turnover (prod cost/ending inv) 7.7 8.3 12.7 12.7 12.7 12.7 12.7 12.7 12.7 Days Payable Outstanding 30.8 30.9 31.0 31.0 31.0 31.0 31.0 31.0 31.0 Capital Expenditured $1,470 $952 $152 $152 $334 $361 $389 $421 $454 $491 Net Working Capital Cash $135 $206 $252 $272 $294 $318 $343 $371 $400 Accounts recivable $730 $1,113 $1,364 $1,473 $1,591 $1,718 $1,855 $2,004 $2,164 Inventory $359 $498 $396 $427 $461 $498 $538 $581 $627 Accounts Payable $318 $484 $593 $640 $691 $747 $806 $871 $941 Working Capital $800 $906 $1,332 $1,419 $1,532 $1,654 $1,787 $1,930 $2,084 $2,251 Change in NWC $106 $427 $87 $113 $122 $133 $143 $154 $167 Free Cash Flow -$3,020 -$556 $170 $679 $541 $583 $631 $680 $734 $793 NPV @ 7.7% -$3,020 -$516 $146 $544 $402 $402 $404 $405 $405 $407
Image of page 1
10 2020 $14,411 8.0% $674 $7,685
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 4 pages?

  • Spring '18
  • Tarun
  • Working Capital, cash conversion cycle, Operating expense

  • 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