Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write out the years 2021 to 2025 projected annual FCFs given multistage growth. The short-term growth rate in FCFs is 3% for the next 4

image text in transcribed
  1. Write out the years 2021 to 2025 projected annual FCFs given multistage growth. The short-term growth rate in FCFs is 3% for the next 4 years and the long-run growth rate in FCFs is 1%.

2. Compute the intrinsic value using these 5 years of projected FCFs assuming the terminal value is a growth perpetuity. The WACC is 10% and the first cash flow in the terminal value is the year 5 future FCF.

3. What is the equity value per share assuming there is 9000 shares outstanding?

An answer to any of these would be greatly appreciated!!

IVodel Assumptions Short-term Interest Rate Long-term Interest Rate Tax Rate Divident Payout Ratio Short-term Growth Rate (4 years) Long-term Growth Rate WACC Income Statement Sales Cost of Goods Gross Profit S\&A Depreciation EBIT \begin{tabular}{|l|r|r|} \hline Interest & $5,450.00 & $3,667.01 \\ \hline EBT & $74,550.00 & $96,332.99 \\ \hline \end{tabular} \begin{tabular}{l} EBT \\ Taxes \\ \hline \end{tabular} Net Income Dividends Addition to Retained Earnings Balance Sheet Assets Cash and Cash Equivalents Acc Receivable Inventory Short Term Investments Current Assets Gross PPE Accumulated Depreciation Net PPE Total Assets Liabilities and Equity Accounts Payable Accruals Notes Payables Current Liabilities Long Term Debt Total Liabilities Retained Earnings Preferred Stock Common Stock Total Equity \begin{tabular}{|r|r|} \hline 5% & \\ \hline 40% & \\ \hline 30% & \\ \hline 3% & \\ \hline 10% & \\ \hline & \\ \hline 2019 & 2020 \\ \hline$150,000.00 & $175,000.00 \\ \hline$35,000.00 & $38,500.00 \\ \hline$115,000.00 & $136,500.00 \\ \hline$15,000.00 & $16,500.00 \\ \hline$20,000.00 & $20,000.00 \\ \hline$80,000.00 & $100,000.00 \\ \hline$5,450.00 & $3,667.01 \\ \hline$74,550.00 & $96,332.99 \\ \hline$29,820.00 & $38,533.20 \\ \hline$44,730.00 & $57,799.80 \\ \hline$13,419.00 & $17,339.94 \\ \hline$31,311.00 & $40,459.86 \\ \hline & \\ \hline \end{tabular} 2019 2020 $3,000.00$3,300.00 \begin{tabular}{|r|r|} $20,000.00 & $22,000.00 \\ \hline$10,000.00 & $11,000.00 \end{tabular} $0.00$6,500.00 \begin{tabular}{|r|r|} $33,000.00 & $42,800.00 \\ \hline$500,000.00 & $530,000.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $500,000.00 & $530,000.00 \\ \hline$100,000.00 & $120,000.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $400,000.00 & $410,000.00 \\ \hline$433,000.00 & $452,800.00 \end{tabular} \begin{tabular}{|l|l|r} \hline Total Liabilities and Equity & $433,000.00 & $452,800.00 \\ \hline \end{tabular} IVodel Assumptions Short-term Interest Rate Long-term Interest Rate Tax Rate Divident Payout Ratio Short-term Growth Rate (4 years) Long-term Growth Rate WACC Income Statement Sales Cost of Goods Gross Profit S\&A Depreciation EBIT \begin{tabular}{|l|r|r|} \hline Interest & $5,450.00 & $3,667.01 \\ \hline EBT & $74,550.00 & $96,332.99 \\ \hline \end{tabular} \begin{tabular}{l} EBT \\ Taxes \\ \hline \end{tabular} Net Income Dividends Addition to Retained Earnings Balance Sheet Assets Cash and Cash Equivalents Acc Receivable Inventory Short Term Investments Current Assets Gross PPE Accumulated Depreciation Net PPE Total Assets Liabilities and Equity Accounts Payable Accruals Notes Payables Current Liabilities Long Term Debt Total Liabilities Retained Earnings Preferred Stock Common Stock Total Equity \begin{tabular}{|r|r|} \hline 5% & \\ \hline 40% & \\ \hline 30% & \\ \hline 3% & \\ \hline 10% & \\ \hline & \\ \hline 2019 & 2020 \\ \hline$150,000.00 & $175,000.00 \\ \hline$35,000.00 & $38,500.00 \\ \hline$115,000.00 & $136,500.00 \\ \hline$15,000.00 & $16,500.00 \\ \hline$20,000.00 & $20,000.00 \\ \hline$80,000.00 & $100,000.00 \\ \hline$5,450.00 & $3,667.01 \\ \hline$74,550.00 & $96,332.99 \\ \hline$29,820.00 & $38,533.20 \\ \hline$44,730.00 & $57,799.80 \\ \hline$13,419.00 & $17,339.94 \\ \hline$31,311.00 & $40,459.86 \\ \hline & \\ \hline \end{tabular} 2019 2020 $3,000.00$3,300.00 \begin{tabular}{|r|r|} $20,000.00 & $22,000.00 \\ \hline$10,000.00 & $11,000.00 \end{tabular} $0.00$6,500.00 \begin{tabular}{|r|r|} $33,000.00 & $42,800.00 \\ \hline$500,000.00 & $530,000.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $500,000.00 & $530,000.00 \\ \hline$100,000.00 & $120,000.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $400,000.00 & $410,000.00 \\ \hline$433,000.00 & $452,800.00 \end{tabular} \begin{tabular}{|l|l|r} \hline Total Liabilities and Equity & $433,000.00 & $452,800.00 \\ \hline \end{tabular}

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

Infrastructure Planning And Finance

Authors: Vicki Elmer, Adam Leigland

1st Edition

0415693187, 978-0415693189

More Books

Students also viewed these Finance questions

Question

Influences on Nonverbal Communication?

Answered: 1 week ago