Assignment:
Please read the following passage, and answer the following the passage. The passage will apply to Questions 1 and 2.
Well you made it and you have hung up your shingle that you are a CPA and are prepared to take on new clients. You sit down at your desk, turn on your shiny new Dell Laptop with wireless connection, take a sip of your steamy hot Starbucks Coffee and gaze at that beautiful shiny new wooden desk (that set you back $1000). Just then the door flies open and this big 6’4” man with a ten gallon hat steps into your office. He has big old cowboy boots caked in dirt and a shiny rhinestone jacket and new Levi Dungarees. He sits down leans back and puts his dirty boots on that shiny new desk (size 14 of course).He says, “My name is Tex A. Slong, my business is cattle, and you have to have to help me. They are running all over the place.” You look at Mr. Slongbewildered, “what is running all over the place, also could you please take your boots down I cannot see your face.” “Oh, sorry , little lady (or son), the cattle, the cattle are everywhere, my wife says if I don’t do something she’ll leave me.Got one in my bedroom.” So you ask, “what happened? “ Tex answers, ”I don’t know, and my business is going to pots, I never have any cash to pay my creditors, I really need your help.” You ask Tex is he brought anything for your too look at and he pulls this crumply piece of paper from his wallet. “Here, I put this together in the car coming over here.”
Question 1. Using the knowledge of ratios, look at the numbers above and see if you can identify Tex's problems. Assume all sales are credit Net 30 sales. What advice would you offer Tex in order to help out the situation. Should Tex liquidate some of his investments to pay his bills until something changes? How is he going to get the money to pay his creditors?
Question 2. Now that you have solved Tex's issues, what would you suggest he plan for the next fiscal year? Should Tex wait until December 31st every year to see his numbers? What would you advise Tex to do? Why? Would your ideas change if Tex sold oil, or cars, or ladies handbags? What types of budgets is your analysis going to focus on? What budget should you start with first?
|
|
BALANCE SHE ET AS OF DECEMBER 31
|
|
|
|
|
|
|
|
|
|
|
ASSETS
|
|
2008
|
|
2007
|
|
|
|
|
|
|
|
|
CASH
|
|
|
2,500
|
|
500,000
|
|
INVESTMENTS
|
|
1,000,000
|
|
100,000
|
|
ACCOUNTS REC.
|
|
500,000
|
|
200,000
|
|
|
TOTAL
|
|
150,500
|
|
1,700,000
|
|
|
|
|
|
|
|
|
INVENTORY
|
|
|
|
|
|
|
|
|
|
|
|
MACHINERY
|
|
2,000,000
|
|
2,000,000
|
|
|
|
|
|
|
|
LESS DEPRC
|
|
1,100,000
|
|
1,000,000
|
|
CATTLE
|
|
|
3,000,000
|
|
2,500,000
|
|
|
TOTAL
|
|
3,900,000
|
|
3,500,000
|
|
|
|
|
|
|
|
|
|
LIABILITIES
|
|
|
|
|
LONG TERM DE BT
|
|
500,000
|
|
500,000
|
|
SHORT TERM DE BT
|
|
100,000
|
|
100,000
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EQUITY
|
|
|
|
|
|
RETAINED
|
|
|
3,400,000
|
|
3,000,000
|
|
|
|
|
|
|
|
|
INCOME STATEMENT
|
2008
|
|
2007
|
|
GROSS SALE
|
2,000,000
|
|
2,500,000
|
|
COST OF GOODS SOLD
|
1,300,000
|
|
1,500,000
|
|
NET SALES
|
|
700,000
|
|
1,000,000
|
|
|
|
|
|
|
|
|
|
EXPENSES
|
|
550,000
|
|
500,000
|
|
|
|
|
|
|
|
|
|
NET INCOME
|
500,000
|
|
400,000
|