Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I only need help with C. This is what I have so far which is correct. Use Excel to do problem C a. Calculate 2020

image text in transcribedimage text in transcribedimage text in transcribed

I only need help with C. This is what I have so far which is correct.

image text in transcribed

Use Excel to do problem C

a. Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). a. Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). Assume the firm has no excesss cash. fill in the following $149,872 Net Operating Working Capital (must be financed by external sources) \begin{tabular}{l|l|lll|} NOWC21= & Operating current assets & - & Operating current liabilities \\ NOWC21= & (Current assets - Excess cash) & - & (Current liabilities - Notes payable) \\ \hline NOWCC21= & $244,659 & & $44,521 \\ \hline NOWC21= & $200,138 & & & \\ \hline \end{tabular} Free Cash Flow \begin{tabular}{lc|} FCF21= & EBIT(1T) \\ \( {_{21}}=} \) & $42,137 \\ FCF21= & $149,872 \\ \hline \end{tabular} b. Assume that the firm's after-tax cost of capital is 10.5%. What is the firm's 2021 EVA? \begin{tabular}{|l|r|} \hline Tax rate & \\ \hline After-tax cost of capital & 25.0% \\ \hline \end{tabular} Calculate the firm's total invested capital first: \begin{tabular}{|c|} \hline Notes payable \\ \hline$16,717 \\ \hline$250,586 \\ \hline \end{tabular} c. Assume that the firm's stock price is $22 per share and that at year-end 2021 the firm has 10 million shares outstanding. What is the firm's MVA at year-end 2021 ? Stock price, P0 522.00 Shares outstanding a. Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). a. Calculate 2020 and 2021 net operating working capital (NOWC) and 2021 free cash flow (FCF). Assume the firm has no excesss cash. fill in the following $149,872 Net Operating Working Capital (must be financed by external sources) \begin{tabular}{l|l|lll|} NOWC21= & Operating current assets & - & Operating current liabilities \\ NOWC21= & (Current assets - Excess cash) & - & (Current liabilities - Notes payable) \\ \hline NOWCC21= & $244,659 & & $44,521 \\ \hline NOWC21= & $200,138 & & & \\ \hline \end{tabular} Free Cash Flow \begin{tabular}{lc|} FCF21= & EBIT(1T) \\ \( {_{21}}=} \) & $42,137 \\ FCF21= & $149,872 \\ \hline \end{tabular} b. Assume that the firm's after-tax cost of capital is 10.5%. What is the firm's 2021 EVA? \begin{tabular}{|l|r|} \hline Tax rate & \\ \hline After-tax cost of capital & 25.0% \\ \hline \end{tabular} Calculate the firm's total invested capital first: \begin{tabular}{|c|} \hline Notes payable \\ \hline$16,717 \\ \hline$250,586 \\ \hline \end{tabular} c. Assume that the firm's stock price is $22 per share and that at year-end 2021 the firm has 10 million shares outstanding. What is the firm's MVA at year-end 2021 ? Stock price, P0 522.00 Shares outstanding

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Market Liberalization In Chile 1973-1982

Authors: Alejandra Salces

1st Edition

1138565202, 978-1138565203

More Books

Students also viewed these Finance questions