Question: (ALL WORK MUST BE DONE ON EXCEL AND SHOW YOUR FORMULAS, I MUST BE ABLE TO SEE YOUR CELL REFERENCES) Build a financial model on
(ALL WORK MUST BE DONE ON EXCEL AND SHOW YOUR FORMULAS, I MUST BE ABLE TO SEE YOUR CELL REFERENCES) Build a financial model on the following template. Assume that the WACC is 20%. Also assume the debt and equity remain the same. The FCF long-term growth rate is the same as the sales growth rate. (You may want to copy the table into Excel.) Sales growth urrent assets/sales Current ies/Sales Net fixed assets/sales TEIIIII cost of goods sold sales ation rate ate on debt on cash and marketable securities dividend out ratio Year income statement IO00IIIII cost of goods sold IS00 III interest payment on debt nterest eamed on cash and marketable securit depreciation fits before tax taxes IIIII ESIIIII profits after tax dividends retained earnings alance sheet cash and marketable securities IIIII fixed assets At cost DOTOIIIII depreciation IIIII Net fixed assets stock accumulated retained eamin total liabilitaes Equity a. Value the company's equity. (SHOW ALL WORK THROUGH EXCEL)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
