Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer the following questions. Please write all your work and equations used Guadalajara & Blings is a firm that makes Mexican food and princess

Please answer the following questions. Please write all your work and equations used

Guadalajara & Blings is a firm that makes Mexican food and princess tiaras. It is a competitor of the firm in the previous problem, so it will have the same cost of capital and the same long-term growth rate (in fact, your keen analysis should notice something fishy its balance sheet looks very similar to its competitor). For the sake of simplicity, we will also assume that it has the same cost of equity (although in reality, this will not be the case if it has a different debt ratio). This firm has 500,000 shares of stock outstanding. The accounting statement is in thousands of dollars on the following pages. Assuming that the projections are correct and that there are no asset sales other than those at book value, compute the stock price per share using:

a) the WACC/FCF method

b) the Flow-to-Equity method

You are already given a pro-forma statement for this problem, but you still need to show how you arrived at your pro-forma cash flows.

image text in transcribed Guadalajara \& Blings Financial Statement Projections: \begin{tabular}{lrrrrrrrr} Income Statement & Year 0 & \multicolumn{1}{c}{1} & \multicolumn{1}{c}{2} & \multicolumn{1}{c}{3} & \multicolumn{1}{c}{4} & \multicolumn{1}{c}{5} & \multicolumn{1}{c}{6} & \multicolumn{1}{c}{7} \\ \cline { 2 - 8 } Total Revenue & 17,300 & 19,030 & 19,982 & 21,980 & 23,738 & 26,112 & 26,112 & 28,723 \\ Cost of Goods Sold & 7,000 & 7,700 & 8,085 & 8,894 & 9,783 & 10,761 & 11,837 & 13,021 \\ SG \& A & 3,600 & 3,960 & 3,960 & 4,356 & 4,574 & 5,031 & 5,534 & 6,088 \\ Depreciation & 3,250 & 3,575 & 3,933 & 4,326 & 4,758 & 5,234 & 5,758 & 6,333 \\ Earnings Before Interest and & 3,450 & 3,795 & 4,004 & 4,404 & 4,623 & 5,085 & 2,983 & 3,281 \\ Taxes (EBIT) & 680 & 690 & 700 & 710 & 720 & 730 & 740 & 750 \\ Interest Expense & 2,770 & 3,105 & 3,304 & 3,694 & 3,903 & 4,355 & 2,243 & 2,531 \\ Taxable Income & 969.5 & 1087 & 1156 & 1293 & 1366 & 1524 & 785 & 886 \\ Tax Expense & 1,801 & 2,018 & 2,148 & 2,401 & 2,537 & 2,831 & 1,458 & 1,645 \\ Net Income (Loss) & 450 & 490 & 530 & 610 & 790 & 870 & 950 & 1030 \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Balance Sheet & \begin{tabular}{l} End of \\ Year 1 \end{tabular} & & & & & & & \\ \hline \multicolumn{9}{|l|}{ Assets } \\ \hline \multicolumn{9}{|l|}{ Current assets: } \\ \hline Cash and cash equivalents & 1,350 & 1,350 & 1,350 & 1,350 & 1,350 & 1,350 & 1,350 & 1,350 \\ \hline Accounts receivable & 940 & 1034 & 1085.7 & 1194 & 1290 & 1419 & 1419 & 1561 \\ \hline Inventory & 2,360 & 2596 & 2725.8 & 2998 & 3298 & 3628 & 3991 & 4390 \\ \hline Total current assets & 4,650 & 4,980 & 5,162 & 5,543 & 5,938 & 6,397 & 6,760 & 7,301 \\ \hline Net Fixed Assets & 9,850 & 10,850 & 12,850 & 13,350 & 14,350 & 15,350 & 16,350 & 16,850 \\ \hline Total assets & 14,500 & 15,830 & 18,012 & 18,893 & 20,288 & 21,747 & 23,110 & 24,151 \\ \hline \multicolumn{9}{|l|}{\begin{tabular}{l} Liabilities and stockholders' \\ equity \end{tabular}} \\ \hline \multicolumn{9}{|l|}{ Current liabilities: } \\ \hline Accounts payable & 1,920 & 2112 & 2218 & 2439 & 2683 & 2952 & 3247 & 3571 \\ \hline Short/Current L.T. Debt & 1,500 & 1,500 & 1,500 & 368 & 368 & 368 & 368 & 368 \\ \hline Total current liabilities & 3,420 & 3,612 & 3,718 & 2,807 & 3,051 & 3,320 & 3,615 & 3,939 \\ \hline Long Term Debt & 2,800 & 2,410 & 2,868 & 2,868 & 2,273 & 1,502 & 2,062 & 2,163 \\ \hline Capital Leases & 700 & 700 & 700 & 700 & 700 & 700 & 700 & 700 \\ \hline Deferred Taxes & 1,500 & 1,500 & 1,500 & 1,500 & 1,500 & 1,500 & 1,500 & 1,500 \\ \hline Total liabilities & 8,420 & 8,222 & 8,786 & 7,875 & 7,524 & 7,022 & 7,877 & 8,302 \\ \hline \multicolumn{9}{|l|}{ Stockholders' equity: } \\ \hline Common stock & 3,500 & 3,500 & 3,500 & 3,500 & 3,500 & 3,500 & 3,500 & 3,500 \\ \hline Retained Earnings & 2,580 & 4,108 & 5,726 & 7,517 & 9,264 & 11,225 & 11,733 & 12,348 \\ \hline Total stockholders' equity & 6,080 & 7,608 & 9,226 & 11,017 & 12,764 & 14,725 & 15,233 & 15,848 \\ \hline \begin{tabular}{l} Total liabilities and \\ equity \end{tabular} & 14,500 & 15,830 & 18,011 & 18,893 & 20,288 & 21,747 & 23,110 & 24,151 \\ \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_2

Step: 3

blur-text-image_3

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

Real Life Money An Honest Guide To Taking Control Of Your Finances

Authors: Clare Seal

1st Edition

1472272293, 978-1472272294

More Books

Students also viewed these Finance questions

Question

=+3. How do you want to affect this reputation?

Answered: 1 week ago

Question

3. What should a contract of employment contain?

Answered: 1 week ago

Question

1. What does the term employment relationship mean?

Answered: 1 week ago