Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Learning 5 Online Student Work X + * E xhtml?deploymentid=5932632355234278943577737914&SBN 97813379096 994538693&anapshotid=2006330R M Connect login Log in to Canvas Scenty Dashboard uncp emal North America
Learning 5 Online Student Work X + * E xhtml?deploymentid=5932632355234278943577737914&SBN 97813379096 994538693&anapshotid=2006330R M Connect login Log in to Canvas Scenty Dashboard uncp emal North America Micr What's inside a mic. NDTAP Q Search this y: Corporate valuation 0 Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFS) during the next 3 years, after which FCF is expected to grow at a constant 5% rate. Dantzler's WACC is 11%. Year FCF (S millions) $25 $24 $45 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required arblysis to answer the questions below Open spreadsheet a. What is Dantzler's horizon, or continuing value? (Hint Find the value of free cash flows beyond Year 3 discounted back to Year 1.) Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55 5 million G - c 1111 DELL P. Priser Poup Insert Delete F11 F12 F6 F7 F9 F10 F8 e Nu Learning S cel One Student Work mildeploymentid5932632365234278943577737914SBN 9781337909686994530693&srpshold 20863308 M Connect login Log in to Canvas Scent Dashboard uncpemad North America Mic What's inside a mic DTAP Search this course Corporate valuation X Open spreadsheet 2. What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13:55 5 million b. What is the firm's value today? Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55. Do not round your intermediate calculations, million 6. Suppose Dantzler has 891 million of debt and 20 million shares of stock outstanding. What is your estimate of the current price per share Round your answer to two decimal places. Write out your answer completely. For example, 0.00025 million should be entered $ as 250. $ Check My Work Reset Prom ED A 38 PM TVM O DELL beror Activity Corporate Mind Top Gengarang Excel Online Student Work O aboutbank Apps M Gmail Youtube Maps > New Tab M Connect login Log in to Carvas Scenty Dashboard uncp email Xi Excel template Saved Home Insert Formulas Data Review View Help Tell me what you want to do 23 Currency M Paste Arial - 10 B 1 U B 0.0.A. A fort Insel A Conditional Fom Cell Formatting - table Styles S. % 923 Alignment Number Unda 513 B D 1 Corporate valuation 2 3 Dolars shares in millions 4 FCF 5 FCF 6 FCF 7 Constant growth rate. WACC 9 Market value of debt 10 Common shares outstanding 52500 524.00 54500 6.00% 1100% 591 00 20 0 $25.00 2 52400 3 $45.00 12 13 FCFS 14 Hortzon value 15 Total FCF 16 TPV of FCFs to investors Sheeti + Calin Modem Wence Same Type here to search o 1 G DELL FT F2 F3 F4 FS F7 F8 F9 F6 P F10 F11 Excel Online Activity polex Mindo.Cengage Excel Online Student Work > C O about di Apps MG YouTube Maps New Tab M Connect login Log in to Canvas Scent Dashboard uncp mad Xi Excel template Saved File Home Insert Formulas Data Review View Help Tell me what you want to do X - 10 29 Currency Arial B 1 u ..A. Paste ca Insert + Conditional Format Formatting Table Styles A - $ % 93% Occord Font Number Tables no 3 B 7 PV of FCFs to investors 9 Firm value today 0 1. Market value of equily MVA Price per share. Po 3 4 Formulas 0 $25.00 2 $2400 SNA FCFS 7- Horizon value Total FCFS $15.00 UNIA UNA SNA 9 PV of FCFs to investors NA SNA Firm value today SNA Sheet+ MoottomW Type here to search o DELL X Excel Online Student Work Mind Lap - Cengage learning Ex Online Activity: Corporatex e O about blank Apps M Gmail YouTube Maps New Tab M Connect login Log in to Canvas templa X Excel View Tell me what you Data Review Help Formulas File Home Insert Arial 10 29 Currency X [G Il lol 1 B U ilil ab Paste $. % 848 . A A IM Number Clipboard Font Undo Alignment G13 fo D E A N/A #N/A #NA 32 Firm value today 33 34 Market value of equity, MV Egy 35 Price per share. Po 36 37 38 39 40 44 46 47 Sheet1 + Ceci e 25 Type here to search Learning 5 Online Student Work X + * E xhtml?deploymentid=5932632355234278943577737914&SBN 97813379096 994538693&anapshotid=2006330R M Connect login Log in to Canvas Scenty Dashboard uncp emal North America Micr What's inside a mic. NDTAP Q Search this y: Corporate valuation 0 Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFS) during the next 3 years, after which FCF is expected to grow at a constant 5% rate. Dantzler's WACC is 11%. Year FCF (S millions) $25 $24 $45 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required arblysis to answer the questions below Open spreadsheet a. What is Dantzler's horizon, or continuing value? (Hint Find the value of free cash flows beyond Year 3 discounted back to Year 1.) Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55 5 million G - c 1111 DELL P. Priser Poup Insert Delete F11 F12 F6 F7 F9 F10 F8 e Nu Learning S cel One Student Work mildeploymentid5932632365234278943577737914SBN 9781337909686994530693&srpshold 20863308 M Connect login Log in to Canvas Scent Dashboard uncpemad North America Mic What's inside a mic DTAP Search this course Corporate valuation X Open spreadsheet 2. What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13:55 5 million b. What is the firm's value today? Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55. Do not round your intermediate calculations, million 6. Suppose Dantzler has 891 million of debt and 20 million shares of stock outstanding. What is your estimate of the current price per share Round your answer to two decimal places. Write out your answer completely. For example, 0.00025 million should be entered $ as 250. $ Check My Work Reset Prom ED A 38 PM TVM O DELL beror Activity Corporate Mind Top Gengarang Excel Online Student Work O aboutbank Apps M Gmail Youtube Maps > New Tab M Connect login Log in to Carvas Scenty Dashboard uncp email Xi Excel template Saved Home Insert Formulas Data Review View Help Tell me what you want to do 23 Currency M Paste Arial - 10 B 1 U B 0.0.A. A fort Insel A Conditional Fom Cell Formatting - table Styles S. % 923 Alignment Number Unda 513 B D 1 Corporate valuation 2 3 Dolars shares in millions 4 FCF 5 FCF 6 FCF 7 Constant growth rate. WACC 9 Market value of debt 10 Common shares outstanding 52500 524.00 54500 6.00% 1100% 591 00 20 0 $25.00 2 52400 3 $45.00 12 13 FCFS 14 Hortzon value 15 Total FCF 16 TPV of FCFs to investors Sheeti + Calin Modem Wence Same Type here to search o 1 G DELL FT F2 F3 F4 FS F7 F8 F9 F6 P F10 F11 Excel Online Activity polex Mindo.Cengage Excel Online Student Work > C O about di Apps MG YouTube Maps New Tab M Connect login Log in to Canvas Scent Dashboard uncp mad Xi Excel template Saved File Home Insert Formulas Data Review View Help Tell me what you want to do X - 10 29 Currency Arial B 1 u ..A. Paste ca Insert + Conditional Format Formatting Table Styles A - $ % 93% Occord Font Number Tables no 3 B 7 PV of FCFs to investors 9 Firm value today 0 1. Market value of equily MVA Price per share. Po 3 4 Formulas 0 $25.00 2 $2400 SNA FCFS 7- Horizon value Total FCFS $15.00 UNIA UNA SNA 9 PV of FCFs to investors NA SNA Firm value today SNA Sheet+ MoottomW Type here to search o DELL X Excel Online Student Work Mind Lap - Cengage learning Ex Online Activity: Corporatex e O about blank Apps M Gmail YouTube Maps New Tab M Connect login Log in to Canvas templa X Excel View Tell me what you Data Review Help Formulas File Home Insert Arial 10 29 Currency X [G Il lol 1 B U ilil ab Paste $. % 848 . A A IM Number Clipboard Font Undo Alignment G13 fo D E A N/A #N/A #NA 32 Firm value today 33 34 Market value of equity, MV Egy 35 Price per share. Po 36 37 38 39 40 44 46 47 Sheet1 + Ceci e 25 Type here to search
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669289ace3894_532669289ac7a419.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669289ad7bf58_533669289ad18a4e.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669289ae1994d_533669289adb403c.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669289aeb88a4_534669289ae4fb57.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669289af4e541_534669289aee6f71.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started