Complete the minicase in the attached spreadsheet
The beginning numbers are typed into the attached spread sheet for your convenience.
The Instructions are as follows:
Jaedan Industires has the following account balances as of December 31, 2010 (provided in spreadsheet). The Firm’s dividend payout ratio is 25% and the tax rate is 34%. The firm’s stock price on December 31, 2009 was 42.89 and on Dec 31, 2010 was 56.82.
1 Construct an income statement and a balance sheet for Dec 31, 2010, and
determine the firm’s free cash flow.
3 Calculate the financial ratios.
4 Perform a DuPont analysis and compare the firm to the industry ratios.
5 Highlight several financial strengths and weaknesses.
