Overview: Corporate financial managers must have a business-wide perspective to successfully navigate the corporate environment. The skills you develop in this course will support you in your future business career as well as set the conceptual foundation for the future courses in your program. Your final project for FIN 330 will allow you to showcase your mastery of the varied skills a finance professional must obtain by requiring you to analyze a real-world corporation from a quantitative perspective while also investigating the challenges and decisions a manager must face. In this milestone, you will continue to work on elements of Final Project I, the corporation valuation report. Prompt: This milestone requires you to write a draft of the Capital Structure and Valuation sections (Sections III and IV) of Final Project I, the corporate valuation report. In this assignment, you will use the same corporation you focused on in Milestone One to expand upon the capital structure of the organization and the valuation of the corporation through forecasting. Specifically, the following critical elements must be addressed in this milestone: III. Capital Structure: In the third section of your report, discuss the capital structure of the corporation. A. Outline the most recent years debt, equity, and total capital using the provided Excel template to show the overall capital structure of the corporation. Please note: to complete this, you will use the same template you used in support of Milestone One, but this time you will be completing the Capital Structure tab. B. Articulate the corporations dividend policy and what impact it has on the investors. C. Analyze the relationship between capital structure, cost of capital, and risk, using examples from your chosen organization. D. Explain how the relationship between capital structure, cost of capital, and risk can help inform decision making and maximize corporate value. IV. Valuation: The final section of your report will focus on calculating current value, outlining assumptions, and estimating the future value of the corporation through forecasting the cash flows. Specifically, respond to the following: A. Calculate the current market value of equity for your corporation, using the three-year history and provided Excel template, and explain what it means for the corporation. You will submit this template along with your report, and may embed pieces of the Excel template into your report to help support your work in this section. Please note: this is the same template you used in support of Milestone One, but this time you will be completing the Valuation tab. B. Outline any assumptions you have made in calculating the current value and estimating the future value of the corporation, explaining why you made them and why they are important. (Hint: Assumptions can include growth rates, margins, trends, etc.) C. Estimate the current value of your corporation by forecasting the cash flows over five years using the provided Excel template, and explain your findings. Calculate EVA, NPV, IRR and MIRR. Guidelines for Submission: Your submission should be 34 pages in length, not including the Excel template you use to address sections IV.A and IV.C, above. The written submission should use 12-point Times New Roman font, double spacing, one-inch margins, and APA formatting. Be sure to submit both your written response and the completed Excel template when submitting this assignment. Any citations should follow APA guidelines.
420332 CONSIGLO recente START HERE Comments to help you filin yelow data entry boxes are in blue or red font. Take one row at & time: read row comment and enter data in the yellow cels only CURRENCY: US-Tils the argumenn er fandora Carens. Es, (ndian Rupee), ERL Brazilian Real BRECHY (Chinese Yumoran is found an francia atalarna SCA Arp fra en torbritahu HCCHE STATEMENT KILIGITS J. Arourt USD 10 The car and be dead Farbara - Ar brgareta blyser med on Dec. 30, acting as thes. 2015 2013 2017 2058 2012 Raplas you're altres.your data wale ILMAN CW Shut LTTE HET 14 -120 7.1% 5 KUEE ME 22778 HAN 2.5% 3 5 2.02 24.114 2390.0 22728 OTHEL 30% -- Culmaktantari reaktywod 3 31. NEDELSEA TOT ACCUETANES 5 274,00E: 3,712 120.0 % - Colmiche was also runsillet you down 0. The claw Na Lantur, Oru 27,00 3,712 000 $ 4302 0.94 0.3% Dupouuawala NST NOVE CRUCES 5 . 5 5 17 2746,000 S 3,743 030.0 3 436.2 - trata calatori Italiana dor ourdarting a performance - Towy, ul. - Conchus was alle ore franceset you downloaded - Maalukathal Wy OUR OLUTED DARWIN DRILDSPEL SUR 122520 -1. 14.1% 5 2005 2.77 -27% Vay Costa TO 1395 3 - Meal Tante 22, buang ke - Mayen Sweats you will allow 123 Mert ha asse Schon for your interest PRILHA Search the 73729972 COMPANY'S FULL NAME CASHFLOW STATE VENT HIGHLIGHTS UdruhVEBAB fo 2013 2013 2015 37130$ 2017 42LE S Nescrita Dearestonard Arran persis Sur Cashew ng Purmaca ataropete cua. capital expediera Oy Cah Mew Fronting Acht 11.0% -0.2% 1.79 1443.390.00 5 1,300.00 5 1 DOT, 00.CC 5 (142.220.66 $21.902 33 325,000.00 5 247950.00 1,200.00 4 1743000C 5 (10.320.065 2.168.362221 13,300.00 5 2012 2013 229.200.00 S 123 5 1.200.000 11,3740335 199,400.00 11441 21 5 2.3515 23 Torah puas se we add basis of here 343.7% - Tracer working all the deadazeta 133 Dy anderingen har en bewys 1-2% - Thabarwy again - THE The larwy seguente: Dy arborete orthu awabave will assical calced - Barwiony a laccata saya 2.0X - bogst value ACID in. Ult Ckwu -177. I- ByRT I will CLSPLUW 5 OB 12207 Culike tid. 11 3 SEWA AIWAN The Free 310 13 % COMPANY'S TULLE BALANCE SICHIGLIGHTS 9. Arourt USD X 1061 Purana water what we were rain. 103 TERK achew evakuachwa wax tante canto 2013 5 Gosa Priur You 2019 2010 2017 2018 CATARINA S 5 72015 34620 270.00 9737023031, LC SA000 S2016 Altera TH a v h. 12.9% Generbincasar. Recent har et betyder Fr. $ 5 1.799.300.00 1,629303133 13400.00 11.79.700.00 9.20.502.22 7905. OC.CC 5136578006160970210E 1.344000 B4% 17.8% 16. These are tanta accederetan - hasa ku prar Ft Hn an actorh ar aut Tcag. Marca: Property and we Oturaca Tea Heta TOTAL ASSETS Care state OtCureri abika Tra la 2015 FT. WWW 1112,700.00 5 1,175.2013 782,50 e 5 4572.230.00 4904502121 2435.200.00 SC18272.00 55722254229, 70 ce 10.9% 00% 52 21.9% 317 There are se arata receved but not yet paid Net Worth Opal paid to carta da Tere To Carbati Harcament Lake D. ILMA Tra le-amanla TOTAL LDLES 1.197.320.063 9,22020335 3532.800.00 $18.15432000 32.799.300.00 5 1921.22.661 T.2270 402.32 47,200.00 545008 5 3 Pace 2228 191 10.7% Erweis web Miche: Worts Captain To Care S 5 5-42DLDERS EUTY Com Aora da Baterad Barra Curi Traustad har TOTAL SARDIOL CAS DOUTY 12093 1, 0.00318833 41,000 097 330.00 1,403 .. 20.06 04.03.23 (148.700.CC 1, 1T2.9% 5457,900 S Cestini cha where or the first you desired Dy cantor, Share LE - Colcha Tobalasan Talat Total Last Charstadera Equit 14 325.000.CC Total LabTatal Shareholders' Equity 5 19 212.000005 24,193 4033 Wir hard777777777 TEOPANY'S HILLMARRI SFIRTHIAMI HARTS Amy Tuyer 2013 Greuth Prior You 2012 2017 HACAL RATOS Pro Cantiga 0.0 -133.3% De C! . 14.1 23 1037.2% Ta Dt./Eat turbully 2.3 13 1.2 15 2819 114 1975 ANEOs 1920 - Peperhana Carga pe Sharepka 43 Tata Labaola Ruta Trend trougly. Realmot hanchuriarcado - TaiLabai Toalhachika Bouty. Typiaca 20 - MISTUS 2. LUNCH FESTA, HAKARET -45 315 000 A. FINA CHF OTERUSET. BATICE Carrer Cune 5 3 1954 14.15 -3.7% 2708 13 - Metro Med Sw3313 Vay where alive Cumalacai Cumala Ty 15 COMO BIVORS 11 131 1 BATETIER CALCULATORS 10 Bad Freiend of the SACRACO 3 2018 Pet Change 1 B IND S Awwwwwwwww har han Anavar Pyutatkan rad affroad the atta sewa pertand BUT WHATIT UE VEN THIS AS A TIME VALUE OF NOREY QUESTION? leraatoria Tua Can Power 1 here 5 12.32 3 Bohelate al RY Oude AVE - fara invest whebeya arxite coledadvice the card or year. The local comentar pod SEWA WA MW A 1 Del 11 hstab is used to calculate Wieghed Mixerage cost of Capital (WINCC Enter data in the clowce only. Comments to help you arc indiased or assumpt on COMPANYS FULL NAME CAPITAL STRUCTURE IN rubor 2019 5 TOUHO 450 Cout a 10 11 12 200 Goa 25, c Ce vere Tex I-CT Como A. bricol Para Texel xe. ED Mpix CM w VER DON 2004 25 OUC LE 1-1 19 OC IC Ort: Order 17 LEIKA 18 15 GAN Como adesh Cosital 2 12010 WE OON 30 TOTO 000 2002 1 WHEN THIS CATAI WI- 1 200 909 INIS LAAT ed TOPAL CAPITAL ANT . 5622 TEN 2 WHILS re 37 B Sad Catras tancah cerdas da Raina Berger des formance 36 Kway.ATAN 10 PORTO ESTIMATED FATEORETI PORCONCE STOCK 11 DUOAT SKINCS DE CERES 1,333 500 13 4-1 the used There are con la colorach. Je a praca : Paris scale 15 45 pm 116 17 In order to recess wat so 2592 Ready Thish used to the corporate valuation report Final Project Enter data forecasts based on action you will explain with report in clowcar. Past perform 14. Coach custolors Carbh The microbial Wax 030 KOMPASAL COPY LITIO VERDIE 2009 2023 22: 20 ak i NYE TORAL FEARS 9543 22.03 LU WED sha Opera TON 10 Opening Drenger 2222 > 1 9543 we 414.30 15 SI SIIRIMIA Herbart HOVEDRILDS .. 12 25 2LTCA 221HGCRLI PER 5 2004 Horar Por Sh" 2 141X ,, Show or Dar AB SO SA SA - Prov 114, rose Dawa 31.8T 03 .45 ! 8 2 5* * re st Socha Tundu ET CASILLOW Tort ***** 288 SAMEHE 26.03 VAI LITION CALCIATIONS PORTWP *1 TUT SEX TIT Torta RT PRESENT VALE OF FUTURE PE CARE FLOW NE WS 2014 TAMMIRAR DET EN DE 140.433.29 Mb Techcobrar arxa 1 #1 11:45 Emere k | : Teriyalar 1837.49 year of LEX 49.90 39,202 Share toward a MTAZI 246002 IH make or Petar 21 122 Ver por caahtolescu Sarat cake ca 30 mm VOOF TE LATEST dr NA CONSUEVARATA CALLES SCOLPIT HCPTEDORA 4.677 220,20 .... 18.20 FreHOTI 22 22 23 204 2014 CIX VACE Ats sh sha They heldur erdhi Waar hy begive years that are care travel tocar 10yae. AV HESUGESTONE Duca and tak Herpecadascherat , Se 2 porta. Compare wadhavacanta 420332 CONSIGLO recente START HERE Comments to help you filin yelow data entry boxes are in blue or red font. Take one row at & time: read row comment and enter data in the yellow cels only CURRENCY: US-Tils the argumenn er fandora Carens. Es, (ndian Rupee), ERL Brazilian Real BRECHY (Chinese Yumoran is found an francia atalarna SCA Arp fra en torbritahu HCCHE STATEMENT KILIGITS J. Arourt USD 10 The car and be dead Farbara - Ar brgareta blyser med on Dec. 30, acting as thes. 2015 2013 2017 2058 2012 Raplas you're altres.your data wale ILMAN CW Shut LTTE HET 14 -120 7.1% 5 KUEE ME 22778 HAN 2.5% 3 5 2.02 24.114 2390.0 22728 OTHEL 30% -- Culmaktantari reaktywod 3 31. NEDELSEA TOT ACCUETANES 5 274,00E: 3,712 120.0 % - Colmiche was also runsillet you down 0. The claw Na Lantur, Oru 27,00 3,712 000 $ 4302 0.94 0.3% Dupouuawala NST NOVE CRUCES 5 . 5 5 17 2746,000 S 3,743 030.0 3 436.2 - trata calatori Italiana dor ourdarting a performance - Towy, ul. - Conchus was alle ore franceset you downloaded - Maalukathal Wy OUR OLUTED DARWIN DRILDSPEL SUR 122520 -1. 14.1% 5 2005 2.77 -27% Vay Costa TO 1395 3 - Meal Tante 22, buang ke - Mayen Sweats you will allow 123 Mert ha asse Schon for your interest PRILHA Search the 73729972 COMPANY'S FULL NAME CASHFLOW STATE VENT HIGHLIGHTS UdruhVEBAB fo 2013 2013 2015 37130$ 2017 42LE S Nescrita Dearestonard Arran persis Sur Cashew ng Purmaca ataropete cua. capital expediera Oy Cah Mew Fronting Acht 11.0% -0.2% 1.79 1443.390.00 5 1,300.00 5 1 DOT, 00.CC 5 (142.220.66 $21.902 33 325,000.00 5 247950.00 1,200.00 4 1743000C 5 (10.320.065 2.168.362221 13,300.00 5 2012 2013 229.200.00 S 123 5 1.200.000 11,3740335 199,400.00 11441 21 5 2.3515 23 Torah puas se we add basis of here 343.7% - Tracer working all the deadazeta 133 Dy anderingen har en bewys 1-2% - Thabarwy again - THE The larwy seguente: Dy arborete orthu awabave will assical calced - Barwiony a laccata saya 2.0X - bogst value ACID in. Ult Ckwu -177. I- ByRT I will CLSPLUW 5 OB 12207 Culike tid. 11 3 SEWA AIWAN The Free 310 13 % COMPANY'S TULLE BALANCE SICHIGLIGHTS 9. Arourt USD X 1061 Purana water what we were rain. 103 TERK achew evakuachwa wax tante canto 2013 5 Gosa Priur You 2019 2010 2017 2018 CATARINA S 5 72015 34620 270.00 9737023031, LC SA000 S2016 Altera TH a v h. 12.9% Generbincasar. Recent har et betyder Fr. $ 5 1.799.300.00 1,629303133 13400.00 11.79.700.00 9.20.502.22 7905. OC.CC 5136578006160970210E 1.344000 B4% 17.8% 16. These are tanta accederetan - hasa ku prar Ft Hn an actorh ar aut Tcag. Marca: Property and we Oturaca Tea Heta TOTAL ASSETS Care state OtCureri abika Tra la 2015 FT. WWW 1112,700.00 5 1,175.2013 782,50 e 5 4572.230.00 4904502121 2435.200.00 SC18272.00 55722254229, 70 ce 10.9% 00% 52 21.9% 317 There are se arata receved but not yet paid Net Worth Opal paid to carta da Tere To Carbati Harcament Lake D. ILMA Tra le-amanla TOTAL LDLES 1.197.320.063 9,22020335 3532.800.00 $18.15432000 32.799.300.00 5 1921.22.661 T.2270 402.32 47,200.00 545008 5 3 Pace 2228 191 10.7% Erweis web Miche: Worts Captain To Care S 5 5-42DLDERS EUTY Com Aora da Baterad Barra Curi Traustad har TOTAL SARDIOL CAS DOUTY 12093 1, 0.00318833 41,000 097 330.00 1,403 .. 20.06 04.03.23 (148.700.CC 1, 1T2.9% 5457,900 S Cestini cha where or the first you desired Dy cantor, Share LE - Colcha Tobalasan Talat Total Last Charstadera Equit 14 325.000.CC Total LabTatal Shareholders' Equity 5 19 212.000005 24,193 4033 Wir hard777777777 TEOPANY'S HILLMARRI SFIRTHIAMI HARTS Amy Tuyer 2013 Greuth Prior You 2012 2017 HACAL RATOS Pro Cantiga 0.0 -133.3% De C! . 14.1 23 1037.2% Ta Dt./Eat turbully 2.3 13 1.2 15 2819 114 1975 ANEOs 1920 - Peperhana Carga pe Sharepka 43 Tata Labaola Ruta Trend trougly. Realmot hanchuriarcado - TaiLabai Toalhachika Bouty. Typiaca 20 - MISTUS 2. LUNCH FESTA, HAKARET -45 315 000 A. FINA CHF OTERUSET. BATICE Carrer Cune 5 3 1954 14.15 -3.7% 2708 13 - Metro Med Sw3313 Vay where alive Cumalacai Cumala Ty 15 COMO BIVORS 11 131 1 BATETIER CALCULATORS 10 Bad Freiend of the SACRACO 3 2018 Pet Change 1 B IND S Awwwwwwwww har han Anavar Pyutatkan rad affroad the atta sewa pertand BUT WHATIT UE VEN THIS AS A TIME VALUE OF NOREY QUESTION? leraatoria Tua Can Power 1 here 5 12.32 3 Bohelate al RY Oude AVE - fara invest whebeya arxite coledadvice the card or year. The local comentar pod SEWA WA MW A 1 Del 11 hstab is used to calculate Wieghed Mixerage cost of Capital (WINCC Enter data in the clowce only. Comments to help you arc indiased or assumpt on COMPANYS FULL NAME CAPITAL STRUCTURE IN rubor 2019 5 TOUHO 450 Cout a 10 11 12 200 Goa 25, c Ce vere Tex I-CT Como A. bricol Para Texel xe. ED Mpix CM w VER DON 2004 25 OUC LE 1-1 19 OC IC Ort: Order 17 LEIKA 18 15 GAN Como adesh Cosital 2 12010 WE OON 30 TOTO 000 2002 1 WHEN THIS CATAI WI- 1 200 909 INIS LAAT ed TOPAL CAPITAL ANT . 5622 TEN 2 WHILS re 37 B Sad Catras tancah cerdas da Raina Berger des formance 36 Kway.ATAN 10 PORTO ESTIMATED FATEORETI PORCONCE STOCK 11 DUOAT SKINCS DE CERES 1,333 500 13 4-1 the used There are con la colorach. Je a praca : Paris scale 15 45 pm 116 17 In order to recess wat so 2592 Ready Thish used to the corporate valuation report Final Project Enter data forecasts based on action you will explain with report in clowcar. Past perform 14. Coach custolors Carbh The microbial Wax 030 KOMPASAL COPY LITIO VERDIE 2009 2023 22: 20 ak i NYE TORAL FEARS 9543 22.03 LU WED sha Opera TON 10 Opening Drenger 2222 > 1 9543 we 414.30 15 SI SIIRIMIA Herbart HOVEDRILDS .. 12 25 2LTCA 221HGCRLI PER 5 2004 Horar Por Sh" 2 141X ,, Show or Dar AB SO SA SA - Prov 114, rose Dawa 31.8T 03 .45 ! 8 2 5* * re st Socha Tundu ET CASILLOW Tort ***** 288 SAMEHE 26.03 VAI LITION CALCIATIONS PORTWP *1 TUT SEX TIT Torta RT PRESENT VALE OF FUTURE PE CARE FLOW NE WS 2014 TAMMIRAR DET EN DE 140.433.29 Mb Techcobrar arxa 1 #1 11:45 Emere k | : Teriyalar 1837.49 year of LEX 49.90 39,202 Share toward a MTAZI 246002 IH make or Petar 21 122 Ver por caahtolescu Sarat cake ca 30 mm VOOF TE LATEST dr NA CONSUEVARATA CALLES SCOLPIT HCPTEDORA 4.677 220,20 .... 18.20 FreHOTI 22 22 23 204 2014 CIX VACE Ats sh sha They heldur erdhi Waar hy begive years that are care travel tocar 10yae. AV HESUGESTONE Duca and tak Herpecadascherat , Se 2 porta. Compare wadhavacanta
