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

(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

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!