Answer the following questions:

Q.1) Is collecting cash from customers accounts receivable an expense or revenue or neither ?

Q.2) Are cash receipts recorded as revenues?

Q.3) Is paying for accounts payable an expense?

Not Easy Being Indie

Tough time to be in the retail music business. That wasn't always the case as chains such as Sam Goody's and Tower Records competed for side by side with thousands of independent record stores. Back in the day, one of the best independents was Millennium Music in Charleston, South Carolina—perennially winning awards for best CD store and best store staff. But things change. Millennium Music owner Kent Wagner had done everything possible to fight the changing tide brought on by the rise of digital music: At the apex of the business, Wagner owed seven stores, but for seven straight years, Millennium had suffered double-digit revenue declines.

"We always thought of ourselves as a community center, a meeting place," says Wagner. "We knew the industry was in decline, but we thought we were different."

It turned out Millennium wasn't different. And Wagner and his business partner, Clayton Woodson, soon faced a stark choice: fold up the business completely and walk away, or attempt to transform it into something entirely different. The once-hot business had but one glowing ember left: a small but growing online trading business that allowed customers to exchange used CDs, DVDs, and books for electronics—iPods and the like. Millennium was able to make money by reselling the used merchandise on Amazon, eBay, and other sites. Millennium was launched by Wagner in 1994 with the focus of creating a thinking person's music store. Their competitive advantage was based on an inventory of hard-to-find records with large classical and jazz sections and stellar customer service. Millennium would make music connoisseurship friendly and accessible.

In the early years, that philosophy worked well, and revenue grew some 20 percent annually. At its peak, Millennium generated sales of about $10 million annually. Live bands played regularly, Millennium hosted a live-jazz happy hour, and they held book readings. Wagner opened a restaurant and a bar and expanded to book sales and DVD rentals. But the seismic industry shifts that put Sam Goody's, Tower Records, and many others out of business started catching up to Millennium. As the years rolled by, the losses mounted. Wagner's empire was hemorrhaging, and he was soon ready to try anything. In 2006, he turned for help to his marketing director, Clayton Woodson, whose eclectic background included making furniture, teaching first grade at a charter school in New York, and teaching acrobatic yoga. "Clayton tends to see looking at the abyss as a growing experience," says Wagner. "I'm the opposite."

That glowing ember of Millennium's business—the used-CD section—gave Woodson an idea. Customers often came in hoping to exchange their old CDs for store credit. What if Millennium could formalize the process to entice additional customers by offering to trade iPods for used CDs? In the summer of 2005, he persuaded Wagner to give the idea a try. Woodson soon had another insight: Buying a used CD online was cheaper than buying an MP3 album through iTunes. If Millennium moved its iPod trading program online, it could collect discs from across the globe, profitably resell them online, and still undercut iTunes's prices. Millennium launched FeedYourPlayer.com in 2006. Traffic soared from a few hundred visitors per week to more than 6,000 items a week. By 2007, the online exchange brought in $400,000 of

Millennium's $1.7 million in revenue.

FeedYourPlayer's performance was heading in the exact opposite direction of Millennium's lone remaining store. In its last full year of operation, the store lost nearly $1 million. In September 2007, Wagner called a company meeting with his 50 or so remaining employees. He delivered the news that many had already foreseen. The retail business was dying. The future was online. The store would remain open, but resources would be put toward building FeedYourPlayer. Employees were still upset even if they had seen the changes coming. Millennium's music buyer quit when he realized the emphasis would be peddling used CDs rather than fresh releases.

Wagner understood his employees' anguish. He says, "staff members were accustomed to being tastemakers." Wagner felt the conflict himself. He clung to the hope that the huge changes might save the store. "When you spend so much of your energy fighting against the blindingly obvious," says Wagner, "you can lose your focus on the big picture."

Required

Question 1

1a. Using the strategic planning process, describe three core problems to be solved by Millennium?

1b. Explain four potential alternative solutions to the problem identified in 1a.

1c. Design a marketing plan for Millenniums FeedYourPlayer.

Question 2

Conduct an external environmental analysis to ascertain if a small business In Ghana can adapt to the business model of Millennium FeedYourPlayer.

I really would appreciate it if someone could provide me with the Excel formulas to calculate the last five (5) columns of the spreadsheet listed below.

Royal Gift Shop sells cards, supplies, and various holiday greeting cards.Sales to retail customers are subjected to an 8 percent sales tax. The firm sells its merchandise for cash; to customers using bank credit cards, such as Master Card and Visa; and to customers using American Express.The bank credit cards charge a 1 percent fee. American Express charged a 2 percent fee. Royal Gift Shop also grants trades discounts to certain wholesale customers who place large orders.These orders are not subjected to sale tax. During February 2019, Royal Gift engaged in the following transactions.

Date Transactions

Feb 1 Sold crystal good to Lovely Kitchen, whole sale customers. The list price is $ 4,300 with a 25 percent trade discount. This sale is not subjected to a sales tax. Issued invoice 5950 with terms of n/15

15 Recorded cash sales for the period from February 1 to February 15 of $8,000 plus sales tax of $ 704

15 Recorded sales for the period from February 1 to February 15 to customers using bank credit cards of $ 12,300 plus sales tax of $ 984. (Record the 1 percent credit card expenses at this time.)

16 Receive a check from Lovely Kitchen in payment of Invoice 5950 dated February 1

16 Sold merchandise to customers using American Express for $8,300 plus sales tax of $ 664

17 Sold a set of Roman statues to Beautiful Bedroom, a wholesale customers. The list price is $ 8,300, with a 30 percent traded discount. The sales is not subjected to sale tax. Issued Invoice 5951 with terms of n/15

20 Received payment from American Express for the amount billed on February 16 less a 2 percent credit card expense

27 Received a check for Beautiful Rooms in payment of Invoice 5951 dated February 17

28 Recorded cash sales for the period from February 16 to February 28 of $ 7,400 plus sales tax of $ 592

28 Recorded sales for the period from February 16 to February 28 to customers using bank credit cards of $ 10,000 plus sales tax of $ 800 (Record the 1 percent credit card expenses at this time)

28 Sold merchandise to customers using American Express for $ 9,500 plus sales tax of $ 760

Required

Record the transactions in a General Journal

Post the entries from the General Journal to the appropriate accounts in the general ledgers.

General Ledger Accounts

101 Cash $ 22, 530 Dr

121 Accounts Receivable

222 Sale Tax Payable

401 Sale

521 Credit Card Expense

Analize

What was the total credit card expenses incurred in February?

T or F: The stock market far exceeds the bond market in terms of size of new capital raised.

T or F: The NASDAQ Market is composed of large nationwide companies that are traded in the over-the-counter market.

When global capital markets collectively react to international events, like Russia's default on its sovereign debt, it is common to find
A.that there is no impact on the trade of foreign goods.
B.an impact on the ability to raise capital.
C.that Wall Street firms are so diversified that they are not affected by this event.
D.all of these options are true.

Which of the following is an internal source of funds?
A.Cash flow from depreciation (tax shield)
B.Net loss
C.Repurchase of debt securities
D.Bank loan

The Securities Exchange Act of 1934 is primarily concerned with
A.a central market system.
B.regulation of organized exchanges.
C.protecting customers of bankrupt securities firms.
D.original issues of securities.

Security markets are efficient EXCEPT for when which of the following exists?
A.Security prices follow the leading indicators such as the DJIA very closely.
B.The markets absorb large dollar amounts of stock without destabilizing the price.
C.Prices adjust rapidly to new information.
D.There is a continuous market where each successive trade is made at a price close to the previous trade.

Middle- to small-sized companies that are centered in one city or state would most likely be found on the
A.NASDAQ National Market.
B.NASDAQ Small Cap Market.
C.Supplemental list.
D.New York Stock Exchange.

______________ occurs when a company is broken up into smaller divisions and sold for a profit.
A.Liquidation
B.Internal reorganization
C.Chapter 11
D.Restructuring

Which of the following is an advantage to private bond placement over public offerings?
A.Higher interest costs
B.Greater flexibility in negotiating terms
C.Higher SEC registration fees
D.Lower interest costs

Raybac is about to go public. Its present stockholders own 500,000 shares. The new public issue will represent 700,000 shares. The shares will be priced at $25 to the public with a 5% spread. The out-of-pocket costs in addition to the spread will be $450,000. What are the net proceeds to Raybac?
A.$17,500,000
B.$17,050,000
C.$17,075,000
D.$16,175,000

Which of the following activities is not a service provided by investment bankers?
A.Underwriting initial public offerings
B.Raising capital via mutual fund offerings
C.Advising in mergers
D.Advising on restructurings

All of the following are advantages of going public EXCEPT
A.More funds are available to publicly traded firms.
B.The fact that a company is public helps in bank negotiations and marketing.
C.Publicly traded stocks afford the stockholders more liquidity.
D.The firm must disseminate more information to the public on corporate affairs.

T or F:The investment banking industry has shifted its emphasis from mergers and acquisitions to underwriting new securities.

T or F: Underpricing is when an investment banker sets the stock price above the market price to ensure that a profit is made.

T or F: Shelf registration requires the firm to file one comprehensive registration statement, which outlines the company's indefinite financial plan.

Disney Annual Historical Prices

Comparing the first six years (Period 1) with the last six years (Period 2) which of the

two periods was more volatile measured by standard deviation and coefficient of variation?

The following income statements illustrate different cost structures for two competing companies: Income Statements Company Name Munoz Jordan Number of customers (a) 85 85 Sales revenue (a × $230) $ 19,550 $ 19,550 Variable cost (a × $180) N/A (15,300 ) Variable cost (a × $0) 0 N/A Contribution margin 19,550 4,250 Fixed cost (15,300 ) 0 Net income $ 4,250 $ 4,250 Required Reconstruct Munoz’s income statement, assuming that it serves 170 customers when it lures 85 customers away from Jordan by lowering the sales price to $130 per customer. Reconstruct Jordan’s income statement, assuming that it serves 170 customers when it lures 85 customers away from Munoz by lowering the sales price to $130 per customer.

This project is assigned to give you the chance to apply the knowledge that you have acquired in statistics to our Global Society. The following data has been collected for you and you are going to look at the possible relationships and make some decisions that might impact your life based on the outcomes.

Use the following data in this project. The data represents the Total Number of Alternative-Fueled Vehicles in use in the United States (source:  US Department of Energy:  http://tonto.eia.doe.gov/aer/)

A.) Construct a scatter diagram of year (x) vs number of Alternative-fueled vehicles in US (y). Do these variables appear to have a relationship? Write 2 or 3 sentences describing the relationship or lack of a relationship. Explain your reasoning. (9 points for graph and 9 points for description of relationship or lack of relationship)

B.)

Description of the relationship of data:_____________________________________

C.) Find the correlation and regression lines for the data above.

r= _______________________ (5 points)

= _______________ x+ _______________ (5 points)

D.) Do the variables have significant correlation? For full credit, you must show each step of the hypothesis test. Use the 0.05 significance.  (18 points total)

E.) In 2008, the price of gas dropped drastically and hit a low average of $1.59 for the nation.  What effect do you think this will have on the alternative-fuel car sales, if any?  Do you think that this would affect the number of alternative-fueled vehicles used in the United States? Do you think that it would follow the same pattern as before 2008? Write 2 or 3 sentences explaining how you think the new vehicles will affect the number of alternative-fueled vehicles in the United States. (18 points)

F.) Use your regression equation to predict the number of alternative-fueled vehicles used in the United States in 2010. Assume that the pattern remains the same after the introduction of the electric-gas vehicles. Show your work. (18 points)

G.) Search online to find some evidence for or against your opinion in part e. Give the information that you found and state the URL to the data. Was your prediction correct or incorrect? Why do you think that happened? Write 2 or 3 sentences summarizing the information that you found and explain why you think that happened. Be sure to answer each question. (18 points)

This project is assigned to give you the chance to apply the knowledge that you have acquired in statistics to our Global Society. The following data has been collected for you and you are going to look at the possible relationships and make some decisions that might impact your life based on the outcomes.

Use the following data in this project. The data represents the Total Number of Alternative-Fueled Vehicles in use in the United States (source:  US Department of Energy:  http://tonto.eia.doe.gov/aer/)

A.) Construct a scatter diagram of year (x) vs number of Alternative-fueled vehicles in US (y). Do these variables appear to have a relationship? Write 2 or 3 sentences describing the relationship or lack of a relationship. Explain your reasoning. (9 points for graph and 9 points for description of relationship or lack of relationship)

B.)

Description of the relationship of data:_____________________________________

C.) Find the correlation and regression lines for the data above.

r= _______________________ (5 points)

= _______________ x+ _______________ (5 points)

D.) Do the variables have significant correlation? For full credit, you must show each step of the hypothesis test. Use the 0.05 significance.  (18 points total)

E.) In 2008, the price of gas dropped drastically and hit a low average of $1.59 for the nation.  What effect do you think this will have on the alternative-fuel car sales, if any?  Do you think that this would affect the number of alternative-fueled vehicles used in the United States? Do you think that it would follow the same pattern as before 2008? Write 2 or 3 sentences explaining how you think the new vehicles will affect the number of alternative-fueled vehicles in the United States. (18 points)

F.) Use your regression equation to predict the number of alternative-fueled vehicles used in the United States in 2010. Assume that the pattern remains the same after the introduction of the electric-gas vehicles. Show your work. (18 points)

G.) Search online to find some evidence for or against your opinion in part e. Give the information that you found and state the URL to the data. Was your prediction correct or incorrect? Why do you think that happened? Write 2 or 3 sentences summarizing the information that you found and explain why you think that happened. Be sure to answer each question. (18 points)

This question requires the use of the Excel file ‘Assignment 3 Data’ found on ACORN. In the file, you will find the annual returns for Enbridge Inc. (ENB) and the S&P/TSX Composite Index (which we will use for the market portfolio). All parts of this question are to be done in Excel with your results printed and submitted with the other questions in this assignment.

1. Use the data for each of ENB and the S&P/TSX Composite Index to find the historical 95% confidence interval of each. [10 points]

2. Plot the returns of the market against the returns of ENB. Add a trendline to the graph and determine the beta of the stock from your trendline. [5 points]

3. Determine the variance and average annual return of the market portfolio. [3 points]

4. Determine the correlation coefficient between the market portfolio and ENB. [3 points]

5. What is the calculated beta for ENB using the information derived from parts a, c, and d? How does this compare with your answer to part b? [2 points]

6. The current Government of Canada Benchmark 10 Year Bond Yield (which will be our risk-free rate) is 1.61%. What is the required return on ENB stock according to the CAPM? [2 points]