Excel Spreadsheets + 1-page letter
To better understand the past two years, the vice president asks you to create a financial income statement and balance sheet for UFI for the combined years of 2004 and 2005. Use this information to calculate the following ratios:
? net margin
? return on investment
? return on equity
Write a letter to the vice president analyzing and comparing these ratios year to year.
Please see the attached file.
REPORT TO VICE PRESIDENT
Ratios are an important financial statement analysis technique. The following ratios have been computed for the year 2004 &2005:
NET MARGIN = NET PROFIT / SALES
Particulars 2004 2005
Excel sheets and Letter as required by the instructions