Use the file titled “FSAP 9e” . This is a financial statement analysis spreadsheet template file ...
Use the file titled “FSAP 9e” . This is a financial statement analysis spreadsheet template file accompanying the Financial Reporting, Financial Statement Analysis and Valuation textbook. Open the spreadsheet tab titled “Data.” This spreadsheet is set up so that you enter Your Company’s data in the green shaded cells with a blue font. You must manually type the data in those cells FOR ALL SIX YEARS. The data tab is the only tab which needs filling in, all the other tabs should complete with the template. A. Ensure that you have SIX years of Annual Reports downloaded for your company as data for input into the FASP 9e spreadsheet. (You will use the six years of data downloaded from Mergent Online (as reported), and SEC EDGAR 10-K reports for Your Company for supplemental data as needed.) I have attached this data. B. Manually type in the Balance Sheet, Income Statement, Statement of Cash Flows, and Supplementary Data amounts/numbers into the appropriate cells in the “Data” tab of the “FSAP 9e” spreadsheet file FOR ALL SIX YEARS. See the textbook authors’ instructions on entering data included in in the FSAP 9e spreadsheet. All of the rules are to the side on the excel sheet. C.As you input your data, be sure to notice that the most recent year is the year furthest to the right. The years in the FSAP 9e spreadsheet are in the opposite order of the data downloaded in the Annual Reports from Your Company's website, and from Mergent Online and SEC Edgar. D. Ensure that your data entry is correct and that all the cells in lines 154 thru 156 (FINANCIAL DATA CHECKS) on the "Data" tab, and lines 14 thru 17 (DATA CHECKS) on the “Analysis” tab of the “FSAP 9e” spreadsheet file show "0" as the calculated amounts. This is very important that ALL THE CELLS IN THE FINANCIAL DATA CHECKS ARE 0. E. Use amounts in the “Data Check” cells on both tabs in the spreadsheet to help you identify input errors. The company which we are looking at is Urban Outfitters and I have attached all of the financials needed for them. THE DATA IN THE DATA TAB MUST EXACTLY MATCH WITH THE FINANCIALS IN THEIR BALANCE SHEETS AND INCOME STATEMENTS. For the statement of cash flows section, use the data in the company's 10K reports. This is the link to the 10Ks- ,https://investor.urbn.com/financial-information/annual-review https://investor.urbn.com/financial-information/annual-revie After this is completed- 1. Use the same FSAP 9e spreadsheet you created for the “Your Company (YC) #1 assignment. This is a financial statement analysis spreadsheet template file accompanying the Financial Reporting, Financial Statement Analysis and Valuation textbook. 2. Add a new spreadsheet tab to the file. Name the tab “Income Statement Trends”. A. Use the data from the common-size balance sheet in the "Analysis" tab, lines 128 thru 152 (INCOME STATEMENT ITEMS AS A PERCENT OF REVENUES), to evaluate revenue and expense trends over the five-year period. 1. In the "Income Statement Trends" spreadsheet tab, discuss the positive or negative income statement trends that are evident over the five-year period for ALL of the revenue and expense accounts. 2. In your comments, provide a reason or reasons why these trends may have occurred. 3. Add Another new spreadsheet tab to the file. Name the tab “Balance Sheet Trends”. A. Use the data from the common-size balance sheet in the "Analysis" tab, lines 195 thru 243 (COMMON SIZE BALANCE SHEET – AS A PERCENT OF TOTAL ASSETS), to evaluate balance sheet trends over the five-year period. 1. In the "Balance Sheet Trends" spreadsheet tab, discuss the positive or negative balance sheet trends that are evident over the five-year period for ALL of the balance sheet accounts. 2. In your comments, provide a reason or reasons why these trends may have occurred. 4. Create another new spreadsheet tab titled “Statement of Cash Flows Trends”. A. Copy and paste the data (values) from the STATEMENT OF CASH FLOWS: SUMMARY, lines 363 thru 388 in the "Analysis" tab and prepare a common-size Statement of Cash Flows like the statements presented in Exhibit 3.25 on page 178 of the Whalen textbook. Format your columns and numbers so they look like those in Exhibit 3.25 and are professionally presented. I attached a screenshot of the exhibit. Use your common-size Statement of Cash Flows to evaluate cash flow trends over the five-year period. 1. On the "Statement of Cash Flows Trends" spreadsheet, discuss positive or negative cash flow trends that are evident of the five-year period for ALL operating, investing, and financing activities cash flows on the statements. 2. In your comments, provide a reason or reasons why these trends may have occurred.
