Lecture Qs + Mini Assign. 2

xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

380

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

42

Uploaded by furymills

Report
Dividend $0.44 Price Today $30.82 Stock Price (P1) $33 return 8.50% Dividend Yield 1.43% Capital Gain Rate 7.07% CF1 CF2 CF3 CF4 CF5 2.36 2.3954 2.431331 2.467800965 2.504817979475 Price Today $39.33 Company XYZ CF0 CF1 CF2 CF3 CF4 4 4.24 4.4944 4.764064 5.04990784 Price Today 42.4 Changing Growth Rates Year 0 Year 1 Year 2 Year 3 Required return Growth 20% 15% 5% 14% 1 0 1 æ + = ç + è E D i v P P r 1 1 1 0 0 D i v i d e n d Y i e l d 1 + = - = + E D i v P D i v r P P
$1.00 $3.00 $6.00 $12.00 $66.67 after year 2 levels off so use D2, use level off rate, and requi $69.67 P1+D1 $61.11 P0 Year 0 Year 1 Year 2 Year 3 Year 4 Earnings $2 $2.40 $2.88 $3.46 $4.15 Dividends 0 0 0 0 $2.49 Price $62.21 FCF $0.00 0 0 $62.21 $49.38 Discount 3 periods using DDM 133.3333333 90.00
CF6 Rate g 2.54239025 7.50% 1.50% price CF5 g Rate 5.35290231 6% 16% 20% 15% 1 1.2 1.38 1 1 0 1 æ ö + = ç ÷ + è ø E D i v P r 1 0 1 0 0 D i v i d e n d Y i e l d C a p i t a l G a i n R a t e 1 - - = + P P D i v P P 1 0 E = - D i v P r g 1 0 E = - D i v P r g
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
9.2 10.4 red return. This will give us P1 $8.67 $2 g cost capital 20% 8% 4%
13.3333333 constant dividend growth model 5% 20% 1.449
20% 4% 8%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Total Payments Earnings g cost capital 50% 860 7.50% 10% CF1 Earnings 860,000,000 Total PMTS 430000000 Market Cap $17,200,000,000.00 Share Price $79.26 2005 2006 2007 2008 Sales 518,000,000 564620000 609789600 652474872 Change in Sales 9% 8% 7% EBIT (9% sales) 50815800 54881064 58722738.5 Taxes (37%) 18801846 20305993.7 21727413.2 NWC (10% increase in sales) 4662000 4516960 4268527.2
Net Investment (8% of sale inc) 3729600 3613568 3414821.76 FCF 23622354 26444542.3 29311976.3 Terminal Value Final FCF 23622354 26444542.3 29311976.3 PV FCF $424,827,741.87 Cash 100,000,000 Debt 3,000,000 Shares outstanding 21,000,000 Stock price $24.85 EPS 1.38 P/E (valuation multiple) 21.3 Value Herman Miller $29.39
CF1 CF2 CF3 CF4 $5 Price Today 76.92 3.50% 55.5
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
217 860 50% 430 17200 79.2626728 Shares outstanding 217,000,000 2009 2010 2011 2012 Cost capital 691623364 726204533 755252713.837 785462822 11% 6% 5% 4% 4% 62246102.8 65358407.93 67972744.2454 70691654 23031058 24182610.93 25149915.3708 26155912 3914849.23 3458116.822 2904818.13014 U n l e v e r e d N e t I n c o m e F r e e C a s h F l o w ( 1 ) C a p i t a l E x p e n d i t u r e s = ´ - t + -    c E B I T 0 0 0 C a s h S h a r e s O u t s t + = V P 0 ( F u t u r e T o t a l D i v i d S h a r e s O u = P V P V
3131879.39 2766493.457 2323854.50412 32168316.1 34951186.72 37594156.2403 39097922.5 558541749.856 32168316.1 34951186.72 596135906.097 find the growth rate
CF5 Rate 10%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
7.50% 10% n l e v e r e d N e t I n c o m e ( 1 ) D e p r e c i a t i o n i t a l E x p e n d i t u r e s I n c r e a s e s i n N e t W o r k i n g C a p i t a l ´ - t + -    c I T 0 0 0 0 C a s h D e b t S h a r e s O u t s t a n d i n g + - V 0 r e T o t a l D i v i d e n d s a n d R e p u r c h a s e s ) S h a r e s O u t s t a n d i n g
Midterm 2 exam Question 1 42.87 25.63 16.99 13.72 23.96 26.28 11.74 3.75 23.027142857 86.4 Qestion 2 B 0.9000 1.2 C/D 1.119375 1.15 C/E 1.063125 1.08 E/D 0.88875 1.11 1 2 3 4 14% 3 6 12 5% 133.333333 142.333333 96.0709458 5.1 72.857142857 55.56 -55000 10,000 20,000 35,000 30,000 15,000 8%
$31,449.81 26% 400,000 85,000 PV NPV 2.50% 1545454.55 1,145,455 PV NPV 475,000 75,000 1500000 1,025,000 3% 8% PV NPV 300,000 63,000 3% 1260000 960,000 400,000 80,000 3% 1600000 1,200,000 8% -55,000 ($0.57) 10,000 $3.14 20,000 1.15 35,000 -0.57181468 30,000 15,000 8% 31,450 ($0.57) 26% 0.846153846 5% 14% 3 6 12 33.3333333 36.75
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
12.50% 0.0
Chapter 9 practice problems question 1 55.50 question 2 20 1 0.05 div yield 0.1 Cap gain rate 0.15 COC question 3 22 0.88 0.04 div yield 0.07 Cap gain rate 0.11 COC Question 4 2 15% P 13.3333333333 Question 5 1.5 6% 11% P 30 Question 6 $3 $6 $12 5% a 0.2 b -50 c 0.03 36.363636364 price exceeds cost of capital Question 7 12% 1 2 3 4 0.65 0.73 0.82 0.91 -16.25 3.24057722654 15.07 Question 8 0 1 2 3 0.96 1.0656 1.182816 1.31292576 -42.624 first 5 dividends 5.14216848256 39.4378341 Question 9 coc 8% 2 growth 6% 450 payout next year 2.12 EV 106 Share price 0.23555555556 Question 10 1 2 3 4
FCF 53 68 78 75 46.4912280702 52.323791936 52.647778264 529.911848 820 Question 11 PEP 72.62 KO 36.1188947 3.8 1.89 19.110526316 Question 12 Cole 12.05 1.65 0.5 2% 15% 0.51 3.92 $5 $33.33 $19.06
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0 1 2 3 20% 1 5% 8% 10% 1.05 1.13 1.25 12.47 13.61 $10.33 2.96 50% 9.2% 12% 1.48 52.86 75.73 8 1.5 22.5 33.75 Chapter 7 practice questions question 1 -10,000 12,000 10% Question 2 9 20% 200,000 1,000,000 NPV -6193.3005322 IRR 1953124 Question 3 0 1 2 3 10% 10 -8 -8 -8 NPV 1 2 3 4 5 -200,000 -200,000 -200,000 -200,000 -200,000 10% $169,482.24 12.66% Question 4 -100,000 120,000 20% indifferent because it’s the same N P V 2 = -
Question 5 1,000 25% 100,000 40 IRR 12.20% NPV -986.71 Question 6 5,000 500 10 months Question 7 0 1 2 3 -10 0 5 2 NPV PV 10 2 7% 10 1.5 2% 11 1.7 0.032 0.18655 $15 price $0.05 $2 0.75 0.032 $1.78 $15.50 $0.08 $2 $25.27 $19.72 $1.92 5% 11% $2.25 ($0.06) $37.50 11.00% 500 40% total payout 200 PV 1818.1818182 Po 18.181818182
COC 14% 5 6 COC 1.02 1.04324 8% 17.39 2% 11.83 4 5 6 1.4573475936 1.61765583 1.70177393 11% growth PV of remaini 51.568907 5.20% expected Po 34.2956656 8.50% coc price of colgate discounted free cash flow m 5 growth 4% 0 0 0 0 0 C a s h D e b t S h a r e s O u t s t a n d i n g + - = V P
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
82 COC 14% 681.374646516233 9.53436616290582 Dividend grwoth model d(1)/r-g N 4 rate 15% PV ($19.06) 15% PMT 0 FV 33.33 0 0 0 0 0 C a s h D e b t S h a r e s O u t s t a n d i n g + - = V P
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0.698 6 7 8 9 10 11 -200,000 300,000 300,000 300,000 300,000 300,000 3 5 N P V 2 5 0 = - + r 0 0 ( F u t u r e T o t a l D i v i d e n d s a n d R e p S h a r e s O u t s t a n d i n g = P V P V
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
4 5 6 10% 2 2 2 NPV IRR 18.5714 20% 20.000 0.17 $50 12.50% $2.50 $41.48 $43.259 2 4% $29.25 12% 4% 29.25 $1.85 $1.78 $1.71 12% 25.0000 4% 15% 100
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
model 0 0 0 C a s h D e b t s O u t s t a n d i n g -
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
-81.6 28 28 28 28 10% ($75.09) 0 0 0 C a s h D e b t s O u t s t a n d i n g -
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
12 13 14 15 16 300,000 300,000 300,000 300,000 300,000 0 D i v i d e n d s a n d R e p u r c h a s e s ) s O u t s t a n d i n g
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
A B C Cost / CF0 55 120 150 FCF 28 30 35 Payback Period 1.96428571 4 4.28571429 in years CF0 CF1 g rate 300,000 63,000 3% 8% 400,000 80,000 3% 8% 400,000 104,000 0% 8% 400,000 100,000 3% 11% Project NPV Investment PI A 230,000 200,000 1.15 B 141,250 125,000 1.13 C 194,250 175,000 1.11 D 162,000 150,000 1.08
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
we have 300,000 to invest. Which do we select? A 0.76666667 B & C 1.11833333 B & D 1.01083333 400 B 0.9000 1.2 C/D 1.119375 1.15 C/E 1.063125 1.08 E/D 0.88875 1.11
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
PV NPV 1260000 960,000 1600000 1,200,000 coffee shop 1300000 900,000 1250000 850,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Revenue 200000 Year 1 COGS 125000 Depreciation 30000 Depreciation 30000 Lease - Fixed 17430 NWC year 0 20000 Sales 200000 EBIT 27570 Variable Costs 125000 Depreciation 30000 Depreciation 30000 Taxs 5789.7 Fixed Costs 17430 Operating CF 51780.3 EBIT 27570 Taxes (21%) 5789.7 Incremental Earnings 21780.3 CF0 CF1 -90000 51780.3 Equipment 90000 -20,000 You currently have a bakery and plan on in muffin line for the next three years. You est muffins a year at $4 a muffin. It will cost yo muffin. You will have buy a new oven that will cost line, and it will be worth nothing at the end straight-line depreciation for the oven. You additional lease space which cost $17,430 You will need to keep some muffins in stoc and you estimate that you will need to set a and will recoup it all at the end.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
NWC 20,000 FCF -110000 51780.3 rate 20% NPV $10,648.32 Straight Line 13285.7143 MACRS Initial Cost Equipment 110,000 0.1429 110,000 useful life 7 0.2449 resiudal value 17,000 0.1749 0.1249 Tax rate 21% 0.0893 0.0892 0.0893 0.0446 Sell at year 4 45,000 BV Year 4 34,364 Book Value Year 4 56857.1429 After Tax Salvage 42766.44 After tax salvage 47490 You purchase equipment for $100,000, and it costs $ have it delivered and installed. Based on past informa believe that you can sell the equipment for $17,000 a life of 7 years. The company’s marginal tax rate is 21% the depreciation expense each year under the followi situations. Straight-line Depreciation (assuming it has a useful life of 7 MACRS 7yr schedule. What is the after salvage value if you end up selling the eq year 4 for 45,000?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year 2 Year 3 12570 30000 CF2 CF3 51780.3 51780.3 20000 ntroducing a new gluten free timate you can sell 50,000 ou roughly $2.50 to make each t $90,000 for the new muffin of the third year. You will use will also need some 0 a year. ck in order to meet demands, aside $20,000 in NWC year 0,
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
51780.3 71780.3 Depreciation 15719 Depreciation at year 4 26939 75,636 19239 13739 9823 9812 9823 4906 $10,000 to ation, you after its useful %. What is ing 7 years) quipment in
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2024 2025 2026 Sales 40 42 44.1 % growth 5% 5% EBIT (14% sales) 12 12.6 13.23 NWC (5% increase in sales) 0.3 0.315 Taxes (21%) 2.52 2.646 2.7783 CapEX -0.04 0.042 FCF 9.48 9.694 10.0947 Final FCF 9.48 9.694 10.0947 NPV 2023 $104.32 Cash 2 Debt 9 Shares Outstanding 5 FCF + Cash - Debt $97.32 Stock Price $19.46 Year 1 Year 2 $5.00 $5.25 Price $131.25 Year 0 Year 1 Year 2 Year 3 Dividend 0 0 0 0 Price
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
FCF 0 0 0 0 Price today $36.11 Year 0 Year 1 Year 2 Year 3 Dividend $1 $1.05 $1.13 $1.25 Growth 5% 8% 10% Price $12.47 Final FCF $1.05 $13.61 NPV $10.33 Year 1 Year 2 Year 3 Year 4 Earnings 2.96 3.23232 3.52969344 3.85442524 g 9.20% 9.20% 9.20% 9.20% Total payouts 1.48 1.61616 1.76484672 1.92721262 Price 52.8571428571429 Shares outstanding 0.698 Share Price $75.73 EPS 1.5 P/E Valuation multiple 22.5 Share Value $33.75
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2027 2028 2029 2030 46.305 48.62025 49.592655 52.0722878 5% 5% 2% 5% 13.8915 14.586075 14.8777965 15.6216863 0.33075 0.3472875 0.14586075 0.37194491 2.917215 3.06307575 3.124337265 3.28055413 0.0441 0.046305 0.0194481 0.04959266 10.599435 11.1294068 11.588150385 11.9195946 12.5155744 Rate Terminal Value 119.195946 12% 10.599435 11.1294068 11.588150385 131.12 g Rate 5% 9% Year 4 Year 5 year 6 rate 0 0 $5 9% $55.56
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$55.56 1 2 3 20% Rate 1 5% 8% 10% 20% 1.05 1.134 1.2474 12.474 $10.33 13.608 Year 5 Rate 4.20903236 12% 9.20% 2.10451618
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
5.1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
72.8571429
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help