Financial Accounting

Student ID: 21993408

Exam: 061580RR – Accounting for Merchandising

When you have completed your exam and reviewed your answers, click Submit Exam. Answers will not be recorded until you hit Submit Exam. If you need to exit before completing the exam, click Cancel Exam.

Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page break, so be sure that you have seen the entire question and all the answers before choosing an answer.

 

1. If ending inventory in Period 1 is overstated, gross profit in Period 2 is A. not affected.

B. overstated.

C. understated.

D. the same as in Period 1.

 

2. The major difference in the statement of retained earnings between a service business and a merchandising business is A. that the retained earnings statement of a merchandising business includes Dividends.

B. nothing. There are no differences between the two.

C. that the retained earnings statement of a service business includes Dividends.

D. that the retained earnings statement of a merchandising business shows the Cost of Goods Sold.

 

3. The cost of goods sold equals A. beginning inventory minus net purchases plus ending inventory.

B. beginning inventory plus net purchases minus ending inventory.

C. ending inventory plus net purchases minus beginning inventory.

D. beginning inventory plus net sales minus ending inventory.

 

4. If an employee overbills a company for travel, this would be considered a/an A. check tampering scheme.

B. cash register scheme.

C. disbursement scheme.

D. expense scheme.

 

5. A/An _______ is used to determine the amount of inventory actually on hand at the end of the accounting period. A. inventory layer

B. footnote

C. physical inventory count

D. inventory shrinkage

 

 

 

6. A method of valuing inventory based on the average of units is called the A. FIFO method.

B. LIFO method.

C. specific cost method.

D. average cost method.

 

7. Beginning inventory plus net purchases equals A. gross profit.

B. cost of goods sold.

C. ending inventory.

D. cost of goods available for sale.

 

8. If there is a difference between the physical count and the perpetual record, the account in which the difference is recorded is the A. Sales.

B. Revenue.

C. Cost of Goods Sold.

D. Inventory Expense.

 

9. Under the average cost method, the flow of costs through the accounting records will _______ to the physical flow of goods through the business. A. exactly match

B. match closely

C. be nearly opposite

D. have no relationship

 

10. Olympic Enterprises has the following inventory data:

Assuming FIFO, what is the cost of goods sold for June 14?

Date Quantity Unit Cost

June 1 Beginning inventory 5 $52

June 4 Purchase 10 $55

June 7 Sale 12

June 11 Purchase 9 $58

June 14 Sale 8

A. $456

B. $455

C. $464

D. $440

 

11. If net sales decrease and cost of goods sold increases, the gross profit percentage A. increases.

 

 

B. decreases.

C. will change based upon the change in total assets.

D. remains the same.

 

12. In a FOB destination agreement, when will ownership transfer to the buyer? A. When the goods arrive at the delivery location

B. When the buyer physically touches the goods

C. When the goods leave the seller’s location

D. When the buyer has paid for the goods in full

 

13. An audit opinion in which the auditors are taking exception to a specific treatment of accounting information is the A. qualified opinion.

B. adverse opinion.

C. disclaimer of opinion.

D. unqualified opinion.

 

14. A new car lot would probably cost its inventory using the _______ method of inventory costing. A. moving average

B. specific-identification

C. LIFO

D. FIFO

 

15. Which of the following is not part of the fraud triangle? A. Realization

B. Rationalization

C. Perceived opportunity

D. Perceived pressure

 

16. Gordon the CPA says, “I am unable to give an opinion about the validity of this accounting information.” What kind of opinion is this? A. Adverse

B. Disclaimer

C. Unqualified

D. Qualified

 

17. What does GAAS stand for? A. Goals, assessment activities, and statuses

B. Generally accepted auditing standards

C. Goals, accruals, audits, and standards

D. General accounts and statuses

 

18. Which of the following would probably not need to be disclosed in a footnote?

 

 

End of exam

A. Change of inventory methods

B. A material change in estimated shrinkage

C. A change in depreciation method

D. A 10% increase in sales

 

19. Goods available for sale are $350,000; beginning inventory is $24,000; ending inventory is $32,000; and cost of goods sold is $275,000. What is the inventory turnover? A. 8.59

B. 9.82

C. 12.50

D. 11.46

 

20. _______ occurs if a disgruntled employee convinces another to steal from the company. A. Monitoring

B. The control environment

C. A control activity

D. Collusion

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Value Line Publishing

In addition to the written memo, please provide your calculated historical 1997-2001 financial ratios for Lowe’s as well as a forecast for Lowe’s for 2002-2006. 

 

 

 

Within the written memo, be sure to well address the following questions:

 

 

 

  1. What do the financial ratios in case Exhibit 7 tell you about the operating performance of Home Depot? What additional information do the different ratios provide?  Complete and compare a similar analysis for Lowe’s using the Excel Template provided – Lowe’s Financial Ratios.
  2. Who deserves the “management of the year” award in the retail-building-supply industry?  Provide a detailed explanation including support for your position.

 

 

 

  1. Assumptions drive the financial forecasting models like that of Home Depot in Exhibit 8.  By putting the assumptions all at the top of the model, the analyst can also easily alter the assumptions and measure the impact.  What do you think of Galeotafiore’s forecast for Home Depot? Are there any “red flags” in Galeotafiore’s work?

 

4.  Prepare a forecast for Lowe’s using the Excel Template provided – Lowe’s Forecast. Articulate and explain your choice of key assumptions within the memo. Draw upon the case dialogue about future growth opportunities and financial forecast for Lowes, as well as overall economic, demographic or sector/industry trends evidenced in the exhibits.

Lowe’s Ratio Analysis

Ratio Analysis for Lowes
Fiscal Year
1997 1998 1999 2000 2001
Working capital (CA – NIBCL*)
Fixed assets
Total capital
Tax rate
NOPAT (EBIT x (1-tax rate))
PROFITABILITY
Return on capital (NOPAT/total capital)
Return on equity (net earnings/equity)
MARGINS
Gross margin (gross profit/sales)
Cash operating expenses/sales
Depreciation/sales
Depreciation/P&E
Operating margin (EBIT/sales)
NOPAT margin (NOPAT/sales)
TURNOVER
Total capital turnover (sales/total capital)
P&E turnover (sales/P&E)
Working capital turnover (sales/WC)
Receivable turnover (sales/AR)
Inventory turnover (COGS/inventory)
Sales per store ($ millions)
Sales per sq. foot ($)
Sales per transaction ($)
GROWTH
Total sales growth
Sales growth for existing stores
Growth in new stores
Growth in sq. footage per store
LEVERAGE
Total capital/equity
* The author has altered the Working capital (Net Working Capital as its identified in the text) equation from CA – CL to that of Current Assets – Non-interest Bearing Current Liabilities. This is not uncommon.

Lowe’s Forecast

Financial Forecast for Lowes
Fiscal Year
2001 2002E 2003E 2004E 2005E 2006E
ASSUMPTIONS
Growth in new stores
Sales growth for existing stores
Total sales growth
Gross margin
Cash operating expenses/sales
Depreciation/sales
Income-tax rate
Cash & ST Inv. / sales
Receivable turnover
Inventory turnover
P&E turnover
Payables/COGS
Other curr. Liab./sales
FORECAST
Number of stores
Net sales
Cost of sales
Gross profit
Cash opertating expenses
Depreciation & amortization
EBIT
NOPAT
Cash and ST investments
Accounts receivable
Merchandise inventory
Other current assets
Total current assets
Accounts payable
Accrued salaries & wages
Other current liabilities
Non-int.-bearing current liab.
Working capital
Net property and equipment
Other assets
Total capital
Return on capital
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Financial Market Institutions

Name _________________________

Problem Set 3

Interest Rates and Security Prices

1. Western Enterprises’ bonds have 10 years remaining to maturity. Interest is paid annually, the bonds have a $1,000 par value, and the coupon rate is 9 percent. The bonds have a yield to maturity of 7 percent. What is the current market price of these bonds?

2. Calculate the fair present value of the following bonds, all of which have a 10 percent coupon rate (paid semiannually), face value of $1,000, and a required rate of return of 8 percent.

a. The bond has 10 years remaining to maturity.

b. The bond has 15 years remaining to maturity.

c. The bond has 20 years remaining to maturity.

d. What do your answers to parts (a) through (c) say about the relation between time to maturity and present values?

3. Compute the stock valuation in the following cases.

a. Financial analysts forecast Safeco Corp. (SAF) growth for the future to be 10 percent. Safeco’s recent dividend was $1.20. What is the fair present value of Safeco stock if the required rate of return is 12 percent?

b. A stock you are evaluating just paid an annual dividend of $2.50. Dividends have grown at a constant rate of 1.5 percent over the last 15 years and you expect this to continue.

i. If the required rate of return on the stock is 12 percent, what is its fair present value?

ii. If the required rate of return on the stock is 15 percent, what should the fair value be four years from today?

c. A stock you are evaluating is expected to experience supernormal growth in dividends of 8 percent over the next six years. Following this period, dividends are expected to grow at a constant rate of 3 percent. The stock paid a dividend of $5.50 last year and the required rate of return on the stock is 10 percent. Calculate the stock’s fair present value.

4. A bond has a par value of $1000 and a coupon rate of 8%, which is paid annually. The maturity of the bond is four years and the coupon payments are reinvested at the current rates listed below. The required rate of return is 6 percent. What is the bonds duration?

Year Rate
1 4%
2 3%
3 5%
4 6%

5. What is the duration of a five-year, $1,000 Treasury bond with a 10 percent semiannual coupon selling at par? Selling with a yield to maturity of 12 percent? 14 percent? What can you conclude about the relationship between duration and yield to maturity? Plot the relationship. Why does this relationship exist?

6. MLK Bank has an asset portfolio that consists of $100 million of 30-year, 8 percent coupon, $1,000 bonds that sell at par.

a. What will be the bonds’ new prices if market yields change immediately by ± 0.10 percent? What will be the new prices if market yields change immediately by ± 2.00 percent?

b. The duration of these bonds is 12.1608 years. What are the predicted bond prices in each of the four cases using the duration rule? What is the amount of error between the duration prediction and the actual market values?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Project Management

Rachel, the project manager of a large information systems project, arrives at her office early to get caught up with work before her co-workers and project team arrive. However, as she enters the office she meets Neil, one of her fellow project managers, who also wants to get an early start on the day. Neil has just completed a project overseas. They spend 10 minutes socializing and catching up on personal news.

 

It takes Rachel 10 minutes to get to her office and settle in. She then checks her voice mail and turns on her computer. She was at her client’s site the day before until 7:30 p.m. and has not checked her e-mail or voice mail since 3:30 p.m. the previous day. There are 7 phone messages, 16 e-mails, and 4 notes left on her desk. She spends 15 minutes reviewing her schedule and “to do” lists for the day before responding to messages that require immediate attention.

 

Rachel spends the next 25 minutes going over project reports and preparing for the weekly status meeting. Her boss, who just arrived at the office, interrupts her. They spend 20 minutes discussing the project. He shares a rumor that a team member is using stimulants on the job. She tells him that she has not seen anything suspicious but will keep an eye on the team member.

 

The 9:00 a.m. project status meeting starts 15 minutes late because two of the team members have to finish a job for a client. Several people go to the cafeteria to get coffee and doughnuts while others discuss last night’s baseball game. The team members arrive, and the remaining 45 minutes of the progress review meeting surface project issues that have to be addressed and assigned for action.

 

After the meeting Rachel goes down the hallway to meet with Victoria, another IS project manager. They spend 30 minutes reviewing project assignments since the two of them share personnel. Victoria’s project is behind schedule and in need of help. They broker a deal that should get Victoria’s project back on track.

 

She returns to her office and makes several phone calls and returns several e-mails before walking downstairs to visit with members of her project team. Her intent is to follow up on an issue that had surfaced in the status report meeting. However, her simple, “Hi guys, how are things going?” elicits a stream of disgruntled responses from the “troops.” After listening patiently for over 20 minutes, she realizes that among other things several of the client’s managers are beginning to request features that were not in the original project scope statement. She tells her people that she will get on this right away.

 

Returning to her office she tries to call her counterpart John at the client firm but is told that he is not expected back from lunch for another hour. At this time, Eddie drops by and says, “How about lunch?” Eddie works in the finance office and they spend the next half hour in the company cafeteria gossiping about internal politics. She is surprised to hear that Jonah Johnson, the director of systems projects, may join another firm. Jonah has always been a powerful ally.

 

She returns to her office, answers a few more e-mails, and finally gets through to John. They spend 30 minutes going over the problem. The conversation ends with John promising to do some investigating and to get back to her as soon as possible.

 

Rachel puts a “Do not disturb” sign on her door, and lies down in her office. She listens to the third and fourth movement of Ravel’s string quartet in F on headphones.

 

Rachel then takes the elevator down to the third floor and talks to the purchasing agent assigned to her project. They spend the next 30 minutes exploring ways of getting necessary equipment to the project site earlier than planned. She finally authorizes express delivery.

 

When she returns to her office, her calendar reminds her that she is scheduled to participate in a conference call at 2:30. It takes 15 minutes for everyone to get online. During this time, Rachel catches up on some e-mail. The next hour is spent exchanging information about the technical requirements associated with a new version of a software package they are using on systems projects like hers.

Rachel decides to stretch her legs and goes on a walk down the hallway where she engages in brief conversations with various co-workers. She goes out of her way to thank Chandra for his thoughtful analysis at the status report meeting. She returns to find that John has left a message for her to call him back ASAP. She contacts John, who informs her that, according to his people, her firm’s marketing rep had made certain promises about specific features her system would provide. He doesn’t know how this communication breakdown occurred, but his people are pretty upset over the situation. Rachel thanks John for the information and immediately takes the stairs to where the marketing group resides.

She asks to see Mary, a senior marketing manager. She waits 10 minutes before being invited into her office. After a heated discussion, she leaves 40 minutes later with Mary agreeing to talk to her people about what was promised and what was not promised.

She goes downstairs to her people to give them an update on what is happening. They spend 30 minutes reviewing the impact the client’s requests could have on the project schedule. She also shares with them the schedule changes she and Victoria had agreed to. After she says good night to her team, she heads upstairs to her boss’s office and spends 20 minutes updating him on key events of the day. She returns to her office and spends 30 minutes reviewing e-mails and project documents. She logs on to the MS project schedule of her project and spends the next 30 minutes working with “what-if” scenarios. She reviews tomorrow’s schedule and writes some personal reminders before starting off on her 30-minute commute home.

· 1. How effectively do you think Rachel spent her day?

· 2. What does the case tell you about what it is like to be a project manager?

 

 

Bruce Palmer had worked for Moss and McAdams (M&M) for six years and was just promoted to account manager. His first assignment was to lead an audit of Johnsonville Trucks. He was quite pleased with the five accountants who had been assigned to his team, especially Zeke Olds. Olds was an Army vet who returned to school to get a double major in accounting and computer sciences. He was on top of the latest developments in financial information systems and had a reputation for coming up with innovative solutions to problems.

M&M was a well-established regional accounting firm with 160 employees located across six offices in Minnesota and Wisconsin. The main office, where Palmer worked, was in Green Bay, Wisconsin. In fact, one of the founding members, Seth Moss, played briefly for the hometown NFL Packers during the late 1950s. M&M’s primary services were corporate audits and tax preparation. Over the last two years the partners decided to move more aggressively into the consulting business. M&M projected that consulting would represent 40 percent of their growth over the next five years.

M&M operated within a matrix structure. As new clients were recruited, a manager was assigned to the account. A manager might be assigned to several accounts, depending on the size and scope of the work. This was especially true in the case of tax preparation projects, where it was not uncommon for a manager to be assigned to 8 to 12 clients. Likewise, senior and staff accountants were assigned to multiple account teams. Ruby Sands was the office manager responsible for assigning personnel to different accounts at the Green Bay office. She did her best to assign staff to multiple projects under the same manager. This wasn’t always possible, and sometimes accountants had to work on projects led by different managers.

M&M, like most accounting firms, had a tiered promotion system. New CPAs entered as junior or staff accountants. Within two years, their performance was reviewed and they were either asked to leave or promoted to senior accountant. Sometime during their fifth or sixth year, a decision was made to promote them to account manager. Finally, after 10 to 12 years with the firm, the manager was considered for promotion to partner. This was a very competitive position. During the last five years, only 20 percent of account managers at M&M had been promoted to partner. However, once a partner, they were virtually guaranteed the position for life and enjoyed significant increases in salary, benefits, and prestige. M&M had a reputation for being a results-driven organization; partner promotions were based on meeting deadlines, retaining clients, and generating revenue. The promotion team based its decision on the relative performance of the account manager in comparison to his or her cohorts.

One week into the Johnsonville audit, Palmer received a call from Sands to visit her office. There he was introduced to Ken Crosby, who recently joined M&M after working nine years for a Big 5 accounting firm. Crosby was recruited to manage special consulting projects. Sands reported that Crosby had just secured a major consulting project with Springfield Metals. This was a major coup for the firm: M&M had competed against two Big 5 accounting firms for the project. Sands went on to explain that she was working with Crosby to put together his team. Crosby insisted that Zeke Olds be assigned to his team. Sands told him that this would be impossible because Olds was already assigned to work on the Johnsonville audit. Crosby persisted, arguing that Olds’s expertise was essential to the Springfield project. Sands decided to work out a compromise and have Olds split time across both projects.

At this time Crosby turned to Palmer and said, “I believe in keeping things simple. Why don’t we agree that Olds works for me in the mornings and you in the afternoons. I’m sure we can work out any problems that come up. After all, we both work for the same firm.”

Top of Form

Bottom of Form

SIX WEEKS LATER

Palmer could scream whenever he remembered Crosby’s words, “After all, we both work for the same firm.” The first sign of trouble came during the first week of the new arrangement when Crosby called, begging to have Olds work all of Thursday on his project. They were conducting an extensive client visit, and Olds was critical to the assessment. After Palmer reluctantly agreed, Crosby said he owed him one. The next week when Palmer called Crosby to request that he return the favor, Crosby flatly refused and said any other time but not this week. Palmer tried again a week later and got the same response.

At first Olds showed up promptly at 1:00 p.m. at Palmer’s office to work on the audit. Soon it became a habit to show up 30 to 60 minutes late. There was always a good reason. He was in a meeting in Springfield and couldn’t just leave, or an urgent task took longer than planned. One time it was because Crosby took his entire team out to lunch at the new Thai restaurant—Olds was over an hour late because of slow service. In the beginning Olds would usually make up the time by working after hours, but Palmer could tell from conversations he overheard that this was creating tension at home.

What probably bothered Palmer the most were the e-mails and telephone calls Olds received from Crosby and his team members during the afternoons when he was supposed to be working for Palmer. A couple of times Palmer could have sworn that Olds was working on Crosby’s project in his (Palmer’s) office.

Palmer met with Crosby to talk about the problem and voice his complaints. Crosby acted surprised and even a little bit hurt. He promised things would change, but the pattern continued.

Palmer was becoming paranoid about Crosby. He knew that Crosby played golf with Olds on the weekends and could just imagine him badmouthing the Johnsonville project and pointing out how boring auditing work was. The sad fact was that there probably was some truth to what he was saying. The Johnsonville project was getting bogged down, and the team was slipping behind schedule. One of the contributing factors was Olds’s performance. His work was not up to its usual standards. Palmer approached Olds about this, and Olds became defensive. Olds later apologized and confided that he found it difficult switching his thinking from consulting to auditing and then back to consulting. He promised to do better, and there was a slight improvement in his performance.

The last straw came when Olds asked to leave work early on Friday so that he could take his wife and kids to a Milwaukee Brewers baseball game. It turned out Springfield Metals had given Crosby their corporate tickets, and he decided to treat his team with box seats right behind the Brewers dugout. Palmer hated to do it, but he had to refuse the request. He felt guilty when he overheard Olds explaining to his son on the telephone why they couldn’t go to the game.

Palmer finally decided to pick up the phone and request an urgent meeting with Sands to resolve the problem. He got up enough nerve and put in the call only to be told that Sands wouldn’t be back in the office until next week. As he put the receiver down, he thought maybe things would get better.

TWO WEEKS LATER

Sands showed up unexpectedly at Palmer’s office and said they needed to talk about Olds. Palmer was delighted, thinking that now he could tell her what had been going on. But before he had a chance to speak, Sands told him that Olds had come to see her yesterday. She told him that Olds confessed that he was having a hard time working on both Crosby’s and Palmer’s projects. He was having difficulty concentrating on the auditing work in the afternoon because he was thinking about some of the consulting issues that had emerged during the morning. He was putting in extra hours to try to meet both of the projects’ deadlines, and this was creating problems at home. The bottom line was that he was stressed out and couldn’t deal with the situation. He asked that he be assigned full-time to Crosby’s project. Sands went on to say that Olds didn’t blame Palmer, in fact he had a lot of nice things to say about him. He just enjoyed the consulting work more and found it more challenging. Sands concluded by saying, “We talked some more and ultimately I agreed with him. I hate to do this to you, Bruce, but Olds is a valuable employee, and I think this is the best decision for the firm.”

· 1. If you were Palmer at the end of the case, how would you respond?

· 2. What, if anything, could Palmer have done to avoid losing Olds?

· 3. What advantages and disadvantages of a matrix type organization are apparent from this case?

· 4. What could the management at M&M do to more effectively manage situations like this?

Top of Form

Bottom of Form

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"