To help you understand the importance of cash flows in the operation of a small business.
You just returned from a meeting with your bank loan officer and you were a little taken aback by his comments. You've been doing business with this bank for a number of years and he always seemed happy with your company's performance. This is why you can't understand the bank's hesita tion to continue extending credit to your company. At this meeting, you had supplied him with the current year's financial information and even ran some of the financial ratios that you know the bank asks about. You thought the numbers looked decent for the current year, maybe not the best, but decent. Sure, sales had fallen a little bit since the previous year, but they were still pretty good. So when the discussion turned to a comparison of the last couple of years' financial information with this year's, you had to question what that has to do with anything. "Why shouldn't each and every year stand by itself?" you asked the banker. His comments to you were, "A company's performance is best evaluated by examining more than one year's data. This is why most financial statements cover at least two periods. In fact, most financial analysis covers trends of up to five years." He also said that a company's performance is best evaluated by comparing it against its own past performance, the performance of competitors, and the industry averages for the industry the company is in.

Requirement
1. Following are some selected financial data from the last four years. Calculate the trend percentages using 2009 as the base year and the return on sales for these four years and see if you can figure out what the concern is that the banker has for the financial health of yourcompany.

Transcribed Image Text:

2012 2011 1 2010 2009 1010,000 1,050,000 1,080,000 1,000.000 Total Sales Total Expenses896,000 888,000 880,000 800.000 4,000 162,000 200,000 200,000 Net Income