Question: For the following problems, use Exhibit B. Exhibit B has the balance sheet and Income Statement projections for a specific company. The company is evaluating

 For the following problems, use Exhibit B. Exhibit B has thebalance sheet and Income Statement projections for a specific company. The company

For the following problems, use Exhibit B. Exhibit B has the balance sheet and Income Statement projections for a specific company. The company is evaluating if it is worth it to have the capital investment as showed in the Capital Investment Table. The EBITDA multiplier of similar companies [(D+3.2)]. The debt used has a coupon of [(C+4)]%. The WACC is [6+C+D]%.

a. What is the increase in Net Working Capital for 2020? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

b. What is the increase in Net Working Capital for 2021? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

c. What would be the Free Cash Flow for 2020? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

d. What would be the Free Cash Flow for 2021? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

e. What is the present value of the Free cash flows? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

f. What is the present value of the continuation value for the firm? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

g. What is the present value of the Interest Tax Shield? NOTE: Provide your answers in dollars. E.G. for 100M you must enter 100000000.0000, for 20M you must enter 20000000.000, etc.

is evaluating if it is worth it to have the capital investmentas showed in the Capital Investment Table. The EBITDA multiplier of similar

Bb Upload Assignr X 5 Exam 3 Online | X Bb ANSWERS, EXA X SV CUNY Login C @ File /home/chronos/u-ba2629988095f5abc4c5ba7360e1b460133bccef/MyFiles/Downloads/Exam%203%20Online%20Fall%202020%20(1).pdf Integrated Financial Statement Template Exhibit B: Free Cash Flow and Valuation 2019 2020 2021 Income Statement Sales Revenue 104,580.00 123,672.39 144,948.70 less: Cost of Goods Sold 85,755.60 $ 18,857.94 EBITDA 18,824.40 101,411.36 15,687.00 $ 22,261.03 26,090.77 less: Depreciation Expense 18.550.86 21,742.31 EBIT 3,137.40 3,710.17 4,348.46 less: Interest and Other Expenses 405.00 405.00 4,230.00 PRE-TAX INCOME 2,732.40 3,305.17 $ 118.46 less: Income Tax 1,092.96 1,322.07 $ 47.38 NET INCOME 1,639.44 S 1,983.10 $ 71.08 Balance Sheet ASSETS Cash and Equivalents 31,374.00 24,053.40 37,101.72 43,484.61 Accounts Receivable 24.053.40 28,444.65 28,444.65 33,338.20 Inventory 33,338.20 CURRENT ASSETS 79,480.80 93,991.01 10,161.01 Property, Plant and Equipment 75,297.60 89,044.12 104,363.07 TOTAL ASSETS 154,778.40 $ 183,035.13 $ 214,524.08 8 LIABILITIES AND EQUITY 9 Accounts Payable 10 CURRENT LIABILITIES 16,732.80 16,732.80 19,787.58 19,787.58 23,191.79 23, 191.79 11 Long-Term Debt 4.500.00 47,000.00 47,000.00 12 TOTAL LIABILITIES 21,232.80 66,787.58 70,191.79 13 STOCKSHOLDER'S EQUITY 133,545.60 74,134.00 74,134.00 14 Retained Earnings 892.40 31.98 15 TOTAL EQUITY 133,545.60 75,026.40 16 TOTAL LIABILITIES AND EQUITY 154,778.40 $ 141,813.98 $ 74,165.98 144,357.78 Net Working Capital Requirements 1 Current Assets N Current Liabilities Net Working Capital Increase in Net Working Capital Capital Investment Capital Investment $ 2.500.00 $ 45.000.00 $ 7.500.00Bb Upload Assignr X 5 Exam 3 Online | X Bb ANSWERS, EXA X SV CUNY Login C @ File /home/chronos/u-ba2629988095f5abc4c5ba7360e1b460133bccef/MyFiles/Downloads/Exam%203%20Online%20Fall%202020%20(1).pdf Integrated Financial Statement Template Exhibit B: Free Cash Flow and Valuation 2019 2020 2021 Free Cash Flow (000s) 1 Net Income NO Plus: After-Tax Interes Expense Unlevered Net Income A Plus: Depreciation Less: Increases in NWC Less: Capital Expenditures 7 Free Cash Flow of Firm Valuation of the Growth Free Cash Flow of the Firm 2 PV of the Cash Flow Screenshot . now 3 Continuation Value Screenshot taken PV of Continuation Value Show in folder 5 net Interest Expense 6 Interest Tax Shield 7 PV Interest Tax Shield 8 Firm Value COPY TO CLIPBOARD

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!