Solution to FM12 Ch 15 P11 Build a Model
3 Pages

Solution to FM12 Ch 15 P11 Build a Model

Course Number: FI FI504, Summer 2009

College/University: DeVry Chicago

Word Count: 577

Rating:

Document Preview

1/10/2007 Chapter 15. Solution for Ch 15-11 Build a Model This model provides answers to the end-of-the-chapter spreadsheet problem. Inputs Sales Growth Rate Costs / Sales Depreciation / Net PPE Cash / Sales Acct. Rec. / Sales Inventories / Sales Net PPE / Sales Acct. Pay. / Sales Accruals / Sales Tax rate Weighted average cost of capital (WACC) Actual 2007 72% 10% 1% 10% 20% 75% 2% 5% 40% 10.5% Projected 2008...

Unformatted Document Excerpt
Coursehero >> Illinois >> DeVry Chicago >> FI FI504

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

15. 1/10/2007 Chapter Solution for Ch 15-11 Build a Model This model provides answers to the end-of-the-chapter spreadsheet problem. Inputs Sales Growth Rate Costs / Sales Depreciation / Net PPE Cash / Sales Acct. Rec. / Sales Inventories / Sales Net PPE / Sales Acct. Pay. / Sales Accruals / Sales Tax rate Weighted average cost of capital (WACC) Actual 2007 72% 10% 1% 10% 20% 75% 2% 5% 40% 10.5% Projected 2008 15% 72% 10% 1% 10% 20% 75% 2% 5% 40% 10.5% Projected 2009 10% 72% 10% 1% 10% 20% 75% 2% 5% 40% 10.5% Projected 2010 6% 72% 10% 1% 10% 20% 75% 2% 5% 40% 10.5% Projected 2011 6% 72% 10% 1% 10% 20% 75% 2% 5% 40% 10.5% Income Statement for the Year Ending December 31 (Millions of Dollars) 2007 Net Sales $800.0 Costs (except depreciation) $576.0 Depreciation $60.0 Total operating costs $636.0 Earning before int. & tax $164.0 Less interest $32.0 Earning before taxes $132.0 Taxes (40%) $52.8 Net income before pref. div. $79.2 Preferred div. $1.4 Net income avail. for com. div. $77.9 Common dividends $31.1 Addition to retained earnings $46.7 Number of shares (in millions) Dividends per share 10 $3.11 Balance Sheets for December 31 (Millions of Dollars) Assets 2007 Cash $8.0 Marketable Securities 20.0 Accounts receivable 80.0 Inventories 160.0 Total current assets $268.0 Net plant and equipment 600.0 Total Assets $868.0 Liabilities and Equity Accounts Payable Notes payable Accruals Total current liabilities Long-term bonds Preferred stock Common Stock (Par plus PIC) 2007 $16.0 40.0 40.0 $96.0 $300.0 $15.0 $257.0 200.0 $457.0 $868.0 Retained earnings Common equity Total liabilities and equity a. Forecast the parts of the income statement and balance sheets necessary to calculate free cash flow. Partial Income Statement for the Year Ending December 31 (Millions of Dollars) Actual 2007 Net Sales Costs (except depreciation) Depreciation Total operating costs Earning before int. & tax $800.0 $576.0 $60.0 $636.0 $164.0 Projected 2008 $920.0 $662.4 $69.0 $731.4 $188.6 Projected 2009 $1,012.0 $728.6 $75.9 $804.5 $207.5 Projected 2010 $1,072.7 $772.4 $80.5 $852.8 $219.9 Projected 2011 $1,137.1 $818.7 $85.3 $904.0 $233.1 Partial Balance Sheets for December 31 (Millions of Dollars) Actual Operating Assets 2007 Cash Accounts receivable Inventories Net plant and equipment Operating Liabilities Accounts Payable Accruals $8.0 $80.0 $160.0 $600.0 Projected 2008 $9.2 $92.0 $184.0 $690.0 Projected 2009 $10.1 $101.2 $202.4 $759.0 Projected 2010 $10.7 $107.3 $214.5 $804.5 Projected 2011 $11.4 $113.7 $227.4 $852.8 $16.0 $40.0 $18.4 $46.0 $20.2 $50.6 $21.5 $53.6 $22.7 $56.9 b. Calculate free cash flow for each projected year. Also calculate growth the rates of free cash flow each year to ensure that there is constant growth (i.e., the same as the constant growth rate in sales) by the end of the forecast period. Actual Projected Projected Projected Projected Calculation of FCF 2007 2008 2009 2010 2011 Operating current assets 248.0 285.2 313.7 332.5 352.5 Operating current liabilities 56.0 64.4 70.8 75.1 79.6 Net operating working capital 192.0 220.8 242.9 257.5 272.9 Net PPE 600.0 690.0 759.0 804.5 852.8 Net operating capital 792.0 910.8 1,001.9 1,062.0 1,125.7 NOPAT 98.4 113.2 124.5 131.9 139.9 Investment in operating capital na 118.8 91.1 60.1 63.7 Free cash flow na (5.6) 33.4 71.8 76.1 Growth in FCF na na -692.1% 115.1% 6.0% Growth in sales 15.0% 10.0% 6.0% 6.0% c. Calculate operating profitability (OP=NOPAT/Sales), capital requirements (CR=Operating capital/Sales), and return on invested capital (ROIC=NOPAT/Operating capital at beginning of year). Based on the spread between ROIC and WACC, do you think that the company will have a positive market value added (MVA= Market value of company - book value of company = Value of operations - Operating capital)? Actual 2007 Operating profitability (OP=NOPAT/Sales) 12.3% Projected 2008 12.3% Projected 2009 12.3% Projected 2010 12.3% Projected 2011 12.3% Capital requirement 99.0% 99.0% (CR=Operating capital/Sales) Return on invested capital (ROIC=NOPAT/Operating capital at start of year) na 14.3% Weighted average cost of capital (WACC) na 10.5% Spread between ROIC and WACC na 3.8% Because the spread is positive, the company should have a positive MVA. 99.0% 13.7% 10.5% 3.2% 99.0% 13.2% 10.5% 2.7% 99.0% 13.2% 10.5% 2.7% d. Calculate the value of operations and MVA. (Hint: first calculate the horizon value at the end of the forecast period, which is equal to the value of operations at the end of the forecast period. Assume that growth beyond the horizon is 6 percent.) Actual 2007 Free cash flow Long-term constant growth in FCF Weighted average cost of capital (WACC) Horizon value FCF + horizon value Value of operations (PV of FCF + HV) Operating capital Market value added (MVA=Market value of company - book value of company = Value of operations - Operating capital) Projected 2008 (5.6) 10.5% 10.5% (5.6) 1,329.6 792.0 537.6 Projected 2009 33.4 10.5% 33.4 Projected 2010 71.8 10.5% 71.8 Projected 2011 76.1 6.0% 10.5% 1,793.6 1,869.7 e. Calculate the price per share of common equity as of 12/31/2007. Actual 2007 Value of Operations Plus Value of Mkt. Sec. Total Value of Company Less Value of Debt Less Value of Pref. Value of Common Stock Number of shares Price per share 1,329.6 20.0 1,349.6 340.0 15.0 994.6 10 99.5

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

DeVry Chicago - FI - FI504
1/31/2007Chapter 16. Solution to Ch 16-13 Build a ModelElliott Athletics is trying to determine its optimal capital structure, which now consists of only debt and common equity. The firm does not currently use preferred stock in its capital struc
DeVry Chicago - FI - FI504
8/13/2006Chapter 17. Solution to Ch 17 P11 Build a ModelA. Fethe is a custom manufacturer of guitars, mandolins and other stringed instruments located near Knoxville, TN. Fethe's current value of operations, which is also its value of debt plus e
DeVry Chicago - FI - FI504
8/16/2006Chapter 18. Solution to Ch 18-12 Build a ModelBuena Terra Corporation is reviewing its capital budget for the upcoming year. It has paid a $3.00 dividend per share (DPS) for the past several years, and its shareholders expect the dividen
DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36BCDEChapter 19. Solution to Ch 19-06 Build a ModelNote: Fill in the shaded cells with the appropriate formulaMullet Technologies is consi
DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54BCDEFGHI 9/2/2006Chapter 20. Solution to Ch 20-06 Build a ModelAs part of its
DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26BCDEFGHChapter 21. Solution to Ch 21-08 Build a ModelNiendorf Incorporated needs to raise $25 million to construct production facilities for a new type of USB mem
DeVry Chicago - FI - FI504
9/4/2006Chapter 22. Solution to Ch 22 P18 Build a ModelInput Data Collections during month of sale Collections during month after sale Collections during second month after sale Lease payments Target cash balance General and administrative salari
DeVry Chicago - FI - FI504
25b02f085cf2eb6ded546adc8cad10c42101015a.xlsBuild a Model 9/6/2006Chapter 23. Solution to Ch 23-06 Build a ModelProblem 23-6. Use the information and data from Problem 23-5 Problem Inputs: Size of planned debt offering = Anticipated rate on debt
DeVry Chicago - FI - FI504
9/8/2006Chapter 24. Solution for Ch 24-5 Build a ModelAt the time it defaulted on its interest payments and filed for bankruptcy, the McDaniel Mining Company had the following balance sheet (in thousands of dollars). The court, after trying unsuc
DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59BCDEFGHIJ 9/14/2006Chapter 25. Solution to 25-07 Build a Mode
DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50BCDEFGHI 9/20/2006Chapter 26. Solution to Ch 26-15 Build a ModelYohe Telecommunications
DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41BCDEFGHChapter 27. Solution to Ch 27-12 Build a ModelMalone Feed and Supply Company buys on terms of 1/10, net 30, but
DeVry Chicago - FI - FI504
Chapter 28. Solution to Ch 28-3 Build a ModelThe following inventory data have been established for the Alder Corporation: (1) Orders must be placed in multiples of 100 units. (2) Annual sales are 338,000 units. (3) The purchase price per unit is $3
Stanford - ENGR - 30
Stanford - ENGR - 30
Stanford - ME - 70
PROBLEM SET 5 SOLUTIONSProf. Cappelli Winter 2008-09ME 70 Problems due Wednesday February 11, 2008 Linear Momentum Conservation (and sometimes Bernoulli's Equation) Problem 4.98 (Fox, McDonald, and Pritchard) Problem 4.105 (Fox, McDonald, and Prit
Stanford - ME - 70
Stanford - ME - 70
Stanford - ME - 70
Stanford - ME - 70
Stanford - ME - 70
Winter 08-09SOLUTIONSME 70 Problems due Wednesday January 28, 2009 Forces on Submerged Surfaces and Line of Action Solve: Problem 3.64 (Fox, McDonald, and Pritchard 7th Edition) Problem 3.72 (Fox, McDonald, and Pritchard 7th Edition) you will have
Stanford - ME - 70
ME 70 Final Exam June 9, 2008 This is an open textbook only test. Supplemental notes can augment the text, but they must be inserted and firmly attached to the textbook. Some useful numbers: air = 1.23 kg/m3 air = 1.8 x 10-5 Ns/m2 air = 1.5 x 10-5
Stanford - ME - 70
ME 70 Solutions Set 1 Winter 2008-09ME 70 Problem Set 1 SOLUTIONS Problem 1.ME 70 Solutions Set 1 Winter 2008-092.32 x 1024 m-32.32 x 1024 m-3 0.116 kg- m-30.116 17.2 km(2.32 x 1024)-1/3 7.55 x 10-9 m 7.55 x 10-9 m17,237 m1 0.1 0.01 Me
Stanford - ME - 70
SOLUTIONSME 70 Problems due Wednesday February 4, 2009 Momentum Flux Solve: Problem 4.55 (Fox and McDonald 7th Edition) Combined Mass, and Momentum Balances Solve: Problem 4.62 (Fox and McDonald 7th Edition) Problem 4.70 (Fox and McDonald 7th Editio
Stanford - ME - 70
Prof. Cappelli Winter 2008-09 ME 70 Problems due Wednesday February 18, 2009 Energy Balances Solve Problem 4.198 (7th Edition, Fox, McDonald, and Pritchard) Problem 4.203 (7th Edition, Fox, McDonald, and Pritchard) More Bernoulli, Euler "s", and Eule
Stanford - ME - 70
SOLUTIONSME 70 Problems due Wednesday January 21, 2009 Hydrostatics (Pressure-Depth Relation) Solve: Problem 3.17 (Fox, McDonald and Pritchard) Problem 3.24 (Fox, McDonald and Pritchard) Buoyancy Solve: Problem 3.88 (Fox, McDonald and Pritchard) Rig
Stanford - SPANLANG - 15
Los Simpson Quin no conoce a esta familia?Todo empez el da en que Homer J.Simpson se declar a Marge Bouvier, y por algn motivo que desconozco, ella acept la peticin de matrimonio. Los Simpson son, por un lado, una familia peculiar, pero por otro lad
Stanford - SPANLANG - 15
Espaol 1 Fecha:_ Composicin #3- PRIMER I. ContenidoNombre del autor/a: _ Nombre del editor/a: _BORRADOR- ANALISIS DEL CONTENIDO1. Se describe el bilingismo del compaero con suficientesdetalles? (sus experiencias, sus opiniones, etc.) Si / No M
Stanford - SPANLANG - 15
Months, Seasons, and Dates Here are the months in Spanish. Note that, like the days of the week, they are not capitalized. enero . January febrero . February marzo . March abril .. April mayo . May junio . June julio . July agosto . August septiembr
Stanford - SPANLANG - 15
-> http:/www.scola.org Login: Password: Stanford_VS001 1891Jordan
Stanford - SPANLANG - 15
Hablando de la salud. (Talking about health) desmayarse estornudar fracturarse romperse quebrarse Me fractur la pierna (la nariz). Me romp el brazo (la rodilla). Me quebr la mueca (el dedo) vomitar tener. una alergia a. catarro una cortada diarrea do
Stanford - SPANLANG - 15
IMPERFECTOBefore studying the grammar explanation, answer the question based on the dialogue: Do the sentences ,practicaba todos los das." and ,Yo tambin jugaba mucho" Refer to actions that occured only once on the past or to habitual actions in t
Stanford - SPANLANG - 15
PRESENTACIN DE MI COMPAER@ . TEMA:. Conocimiento previo: Quiero recordar de esta presentacin:Quiero preguntar: Mi opinin:PRESENTACIN MI MI COMPAER@ . PRESENTACIN DEDE COMPAER@ . TEMA:.. TEMA:.Conocimiento previo: Quiero recordar de esta presenta
Stanford - SPANLANG - 15
EL CUERPOel ojo la nariz el cuello el hombro el pecho el codo la mueca la mano la cadera la pierna el taln el piela cabeza la oreja la boca la barbilla el brazo la tripa el ombligo el dedo el muslo la rodilla la tibia / la pantorrilla el tobillo
Stanford - SPANLANG - 15
Cmo elegir un tema para el informe oral y prepararloPaso 1 - Seleccin de tema (semana 8)Lluvia de ideas: Think about the skills you've practiced throughout the quarter (e.g., description in the present and past) and the broader topics we've studied
Stanford - SPANLANG - 15
Espaol 1 Edicin de composicin #2Nombre del autor: _ Nombre del editor: _Paso 1. Read your partner's composition and check for the following:Formato: The composition has a title h It is double-spaced h It is typewritten hPaso 2.Contenido: 1. M
Stanford - SPANLANG - 15
Read the questions below, then read the attached descriptions of some academic programs at a university in Ecuador. Answer the questions in English. 1. Name the three academic disciplines outlined below, and give one general fact about the program in
Stanford - SPANLANG - 15
PRCTICA ORAL -Espaol 2 Answer each of these questions in a full sentence. Cmo te llamas? Cuntos aos tienes? En qu ao naciste? De dnde eres? En qu te especializas? Qu materias tomas? Dnde vives? Qu tiempo hace hoy?QuickTimeand a TIFF (Uncompressed)
Stanford - SPANLANG - 15
Situacin: Ay, mi compa de cuarto!Persona A: Your compaero/a de cuarto has done it again! S/He's wore your favorite shirt (without your permission!) for a "special date" and then spilled red wine all over it. Express your shock and anger to your room
Stanford - SPANLANG - 15
Stanford Spanish Language Program9/23/08 4:50 PMLA COMIDA: Cmo es.? Puedes describir e identificar los alimentos segn su: CATEGORA: carne, marisco, verdura, postre, bebida, legumbre, tubrculo. COLOR TAMAO: grande, pequeo, mediano, enorme, minscul
Stanford - SPANLANG - 15
Stanford - HUMBIO - 4a
Part 1 1) C The visual, gustatory and olfactory systems all use a combinatorial code to interpret an image, taste or smell in the brain. All of these systems react to stimuli via their 7-pass transmembrane proteins such as G-proteins or opsin. While
Stanford - HUMBIO - 4a
4A Problem Set 1 RationalesPart 1 1. C Modified Student Rationale: "A" is false because the number of open K+ leak channels stays constant during action potentials, while "B" is false because the activity of Na/K+ pumps does not change during action
Stanford - HUMBIO - 4a
Human Biology 4B Final Exam June 13, 2007 PART 1: MULTIPLE CHOICE QUESTIONS 1D 2C 3B 4E 5D 6C 7E 8B 9C 10 A 11 C 12 A 13 C 14 A 15 A 16 D 17 D 18 E 19 A 20 A 21 C 22 C 23 D 24 B 25 B 26 B 27 C 28 A 29 A 30 B 31 B 32 A 33 D 34
Stanford - HUMBIO - 4a
Human Biology 4B (Spring 2008) Study Questions for the Final Exam These questions will guide you in considering the material you have learned throughout the quarter. Please note that the study questions are not exhaustive, and exam questions will dra
Stanford - HUMBIO - 4a
Pset 5 Rationales PART 1 1) B Calcitonin (released by the thyroid gland) and PTH (released by the parathyroid gland) work in opposition to each other to maintain homeostatic blood Calcium levels. While Calcitonin stimulates bone growth by inhibiting
Stanford - HUMBIO - 4a
REVIEWSPREFRONTAL AND MEDIAL TEMPORAL LOBE INTERACTIONS IN LONG-TERM MEMORYJon S. Simons* and Hugo J. SpiersCognitive neuroscience has made considerable progress in understanding the involvement of the medial temporal and frontal lobes in long-te
Stanford - HUMBIO - 4a
4A Final Thought QuestionsNote: These thought questions are not necessarily representative of the exam. They are meant to be a guide to help your studying only. There may be things tested which are not referred to in the questions, and there are que
Stanford - HUMBIO - 4a
HUMAN BIOLOGY 4AReview/Thought Questions for the Midterm, 2008This guide is intended to help you think about, review and integrate the material from the class, problem sets, virtual lab and text books. While we believe this guide will be useful it
Stanford - HUMBIO - 4a
HumBio 4B Midterm 2008 Thought Questions These questions will guide you in integrating the diverse material you have learned throughout the quarter. Please note that the study questions are not exhaustive, and exam questions will draw on all of the r
DeVry Chicago - FI - FI504
6/26/2006 Chapter 5. Solution to Ch 05 P24 Build a ModelRework Problem 5-12 using a spreadsheet. After completing questions a through d, answer the new question. A 10-year 12 percent semiannual coupon bond, with a par value of $1,000, may be called
University of Colombo - MCCU - MCCU 1000
ARE WE STILL ON NEWSPAPERS? MAGAZINES.NO.WE'VE MOVED TOYEAH! 1955, TWO MEN ADMITTED TO THE LYNCHING I'M SORRY, THEY DIDN'T ADMIT TO IT IN EMMITT TILL, 14-YEAR- THESE TWO ADMIT TODAYOF EMMITT TILL.1955, THE LYNCHING HAPPENED THEN. OLD LITTLE
University of Texas - CH - 90262
fernandez (jf23742) H02: Chapter 17 McCord (90262) This print-out should have 29 questions. Multiple-choice questions may continue on the next column or page find all choices before answering. A reminder that EXAM 1 is on Monday, August 20th, fro
LSU - EE - 4720
mr-1Spring 2001 Midterm Exam Reviewmr-1When / WhereWednesday, 21 March, 13:40-14:30 CSTCEBA 1112 (Here)ConditionsClosed Book, Closed NotesBring one sheet of notes (both sides), 216 mm 280 mm.No communication devices unless a fair wa
LSU - EE - 4720
03-1Instruction Set (ISA) Design and Addressing Modes03-1 03-2ISA Design Decisions03-2Material from sections 2.1, 2.2, and 2.3. I. OrganizationA. Data types (supported by ISA). B. Memory and register organization. C. Addressing modes.Outl
LSU - EE - 4720
10-1Dynamic Scheduling10-1This Set Scheduling and Dynamic Execution Definitions From various parts of Chapter 4. Description of Two Dynamic Scheduling MethodsNot yet complete.(Material below may repeat material above.) Tomasulo's Algo
LSU - EE - 4720
02-1Components of CPU Performance and Performance Equation02-1Why is my computer fast (or slow)? ?Would it help to improveCPU performance equation is one way to start answering these questions.02-1EE 4720 Lecture Transparency. Formatted
LSU - EE - 4720
NameComputer Architecture EE 4720 Final Examination8 May 2000, 10:0012:00 CDTProblem 1 Problem 2 Problem 3 Problem 4 Problem 5 Alias Good Luck!(20 pts) (10 pts) (10 pts) (21 pts) (39 pts) (100 pts)Exam TotalProblem 1: An extended DLX ISA,
LSU - EE - 4720
10-1Dynamic Scheduling10-1 10-2Dynamic Scheduling10-2This Set Scheduling:Organizing instructions to improve execution efficiency. Scheduling and Dynamic Execution Definitions From various parts of Chapter 4. Static Scheduling:Organizing
LSU - EE - 4720
01-1EE 4720-Computer Architecture01-1URL: http:/www.ece.lsu.edu/ee4720/RSS: http:/www.ece.lsu.edu/ee4720/rss home.xmlOffered by:David M. Koppelman349 EE Building, 578-5482, koppel@ece.lsu.edu, http:/www.ece.lsu.edu/koppelOffice Hours:
LSU - EE - 4720
01-1EE 4720-Computer Architecture01-1Call Number 1825 (Fall 2002)URL: http:/www.ece.lsu.edu/ee4720Offered by:David M. Koppelman349 EE Building578-5482, koppel@ece.lsu.edu, http:/www.ece.lsu.edu/koppel/koppel.htmlTentative office hou