Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Think year 0 is correct nothing else Pt6 Pt5 Pt4 Pt3 Pt2 Pt.1 Find the answer for all the following highlighted regions. Pt 1 to
Think year 0 is correct nothing else
Pt6
Pt5
Pt4
Pt3
Pt2
Pt.1
Find the answer for all the following highlighted regions. Pt 1 to Pt 6
\begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|l|}{ Capital Structure } \\ \hline & Debt & Equity \\ \hline \$ amount & $30,000 & $22,350 \\ \hline \multicolumn{3}{|l|}{% of capital structure } \\ \hline Cost of capital (net of tax) & 4.35% & 15.00% \\ \hline \multicolumn{3}{|c|}{ Weighted Average Cost of Capital (WACC) } \\ \hline Perpetuity Growth Rate & 2.0% & \\ \hline \end{tabular} Forecast Cashflow Forecast Period Discounted Cash Flow Valuation Forecast Period Year0Year1Year2Year3Year4Year5Year6Year7 Net Income + D\&A and other noncash charges + Interest * (1 - tax rate) - Capital expenditures + Change in Working Capital Free Cash Flow to Firm Terminal value EBITDA 10 Total cash flows to discount Enterprise Value (NPV of cash flows to firm) + Cash - Debt \begin{tabular}{|c|c|} \hline & use NPV function \\ \hline$13,350 & \\ \hline($30,000) & \\ \hline \end{tabular} Equity Value Shares Outstanding 5,000 Fair value per share Forecast Income Statement \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & & \multicolumn{7}{|c|}{ Forecast Period } \\ \hline For the year ended & Year 0 & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 \\ \hline Total revenue & $104,832 & $110,074 & $115,577 & $121,356 & $127,424 & $131,247 & $133,872 & $136,549 \\ \hline Revenue growth & & 5% & 5% & 5% & 5% & 3% & 2% & 2% \\ \hline Operating expenses & $91,692 & $94,443 & $97,276 & $100,194 & $103,200 & $105,264 & $107,369 & $109,517 \\ \hline Operating expense growth & & 3% & 3% & 3% & 3% & 2% & 2% & 2% \\ \hline EBITDA & $13,140 & $15,631 & $18,301 & $21,162 & $24,224 & $25,983 & $26,502 & $27,032 \\ \hline EBITDA margin & 13% & 14% & 16% & 17% & 19% & 20% & 20% & 20% \\ \hline Depreciation \& Amortization & $2,500 & $2,201 & $2,312 & $2,427 & $2,548 & $2,625 & $2,677 & $2,731 \\ \hline D\&A \% of revenue & 2% & 2% & 2% & 2% & 2% & 2% & 2% & 2% \\ \hline EBIT & $10,640 & $13,430 & $15,990 & $18,735 & $21,676 & $23,358 & $23,825 & $24,301 \\ \hline EBIT margin & 10% & 12% & 14% & 15% & 17% & 18% & 18% & 18% \\ \hline Interest Expense & $1,500 & $1,500 & $1,500 & $1,500 & $1,500 & $1,500 & $1,500 & $1,500 \\ \hline Interest rate & 5% & 5% & 5% & 5% & 5% & 5% & 5% & 5% \\ \hline EBT & $9,140 & $11,930 & $14,490 & $17,235 & $20,176 & $21,858 & $22,325 & $22,801 \\ \hline Tax & $1,188 & $1,551 & $1,884 & $2,241 & $2,623 & $2,842 & $2,902 & $2,964 \\ \hline Tax rate & 13% & 13% & 13% & 13% & 13% & 13% & 13% & 13% \\ \hline Net income & $7,952 & $10,379 & $12,606 & $14,994 & $17,553 & $19,016 & $19,423 & $19,837 \\ \hline \end{tabular} LIABILITIES Current Liabilities Accounts Payable AP turnover (days sales) $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,50029.6$8,50029.6 \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Total Current Liabilities & $8,500 & $8,500 & $8,500 & $8,500 & $8,500 & $8,500 & $8,500 & $8,500 \\ \hline \multicolumn{9}{|l|}{ Long Term Liabilities } \\ \hline Long Term Debt & $30,000 & $30,000 & $30,000 & $30,000 & $30,000 & $30,000 & $30,000 & $30,000 \\ \hline Total Long Term Liabilities & $30,000 & $30,000 & $30,000 & $30,000 & $30,000 & $30,000 & $30,000 & $30,000 \\ \hline \end{tabular} EQUITY Owner's Funds Retained Earnings \begin{tabular}{|r|rrrrrrr|} \hline$20,000 & $20,000 & $20,000 & $20,000 & $20,000 & $20,000 & $20,000 & $20,000 \\ \hline$2,350 & $2,350 & $2,350 & $2,350 & $2,350 & $2,350 & $2,350 & $2,350 \\ \hline $22,350 & $22,350 & $22,350 & $22,350 & $22,350 & $22,350 & $22,350 & $22,350 \\ \hline \end{tabular} TOTAL LIABILITIES \& EQUITY error check (7,854)(17,889) (30,261) (45,133) (61,444) (78,184) (95,364) \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{9}{|l|}{ Balance Sheet } \\ \hline & & \multicolumn{7}{|c|}{ Forecast Period } \\ \hline end of & Year 0 & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 \\ \hline \multicolumn{9}{|l|}{ ASSETS } \\ \hline \multicolumn{9}{|l|}{ Current Assets } \\ \hline Cash at Bank & $13,350 & $21,204 & $31,239 & $43,611 & $58,483 & $74,794 & $91,534 & $108,714 \\ \hline Accounts Receivable & $12,500 & $12,500 & $12,500 & $12,500 & $12,500 & $12,500 & $12,500 & $12,500 \\ \hline AR turnover (days sales) & 43.5 & 43.5 & 43.5 & 43.5 & 43.5 & 43.5 & 43.5 & 43.5 \\ \hline Total Current Assets & $25,850 & $33,704 & $43,739 & $56,111 & $70,983 & $87,294 & $104,034 & $121,214 \\ \hline \multicolumn{9}{|l|}{ Fixed Assets } \\ \hline Gross PP\&E & $35,000 & $35,000 & $35,000 & $35,000 & $35,000 & $35,000 & $35,000 & $35,000 \\ \hline Less: Accumulated D\&A & $0 & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Net PP\&E (net of D\&A) & $35,000 & $35,000 & $35,000 & $35,000 & $35,000 & $35,000 & $35,000 & $35,000 \\ \hline TOTAL ASSETS & $60,850 & $68,704 & $78,739 & $91,111 & $105,983 & $122,294 & $139,034 & $156,214 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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