Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Complete the Balance Sheet and income statement values below (all yellow cells). begin{tabular}{|l|r|} hline Initial Debt & 234.00 hline Cost of Capital &
1. Complete the Balance Sheet and income statement values below (all yellow cells). \begin{tabular}{|l|r|} \hline Initial Debt & 234.00 \\ \hline Cost of Capital & 14.00% \\ \hline Tax Rate & 28.00% \\ \hline Number of Shares & 4.5Mil \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|c|} \hline Year & 0 & 1 & 2 & 3 & 4 \\ \hline NOWC (15\% of Revenues) & & & & & \\ \hline Net PPE (30\% of Revenues) & & & & & \\ \hline Total Assets & & & & & \\ \hline & & & & & \\ \hline Year & 0 & 1 & 2 & 3 & 4 \\ \hline Sales (12\% annual growth, years 1- & 275.000 & & & & \\ \hline Cost of sales (75\% of sales) & & & & & \\ \hline EBITDA & & & & & \\ \hline Depreciation (10\% of Beginning NFA) & & & & \\ \hline EBIT & & & & \\ \hline \end{tabular} 2. Complete the following values for FCF and EP valuation (all yellow cells), in the same way we did in-class. 1. Complete the Balance Sheet and income statement values below (all yellow cells). \begin{tabular}{|l|r|} \hline Initial Debt & 234.00 \\ \hline Cost of Capital & 14.00% \\ \hline Tax Rate & 28.00% \\ \hline Number of Shares & 4.5Mil \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|c|} \hline Year & 0 & 1 & 2 & 3 & 4 \\ \hline NOWC (15\% of Revenues) & & & & & \\ \hline Net PPE (30\% of Revenues) & & & & & \\ \hline Total Assets & & & & & \\ \hline & & & & & \\ \hline Year & 0 & 1 & 2 & 3 & 4 \\ \hline Sales (12\% annual growth, years 1- & 275.000 & & & & \\ \hline Cost of sales (75\% of sales) & & & & & \\ \hline EBITDA & & & & & \\ \hline Depreciation (10\% of Beginning NFA) & & & & \\ \hline EBIT & & & & \\ \hline \end{tabular} 2. Complete the following values for FCF and EP valuation (all yellow cells), in the same way we did in-class
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started