EXCEL CASE 1On January 1, 2017, Innovus, Inc., acquired 100 percent of the common stock of ChipTech Company for $670,000 in cash and other fair-value consideration. ChipTech’s fair value was allocated among its net assets as follows:Fair value of consideration transferred for ChipTech$670,000Book value of ChipTech:Common stock and Additional Paid-In Capital (APIC)$130,000Retained earnings370,000500,000Excess fair value over book value to170,000Trademark (10-year remaining life)$?40,000Existing technology (5-year remaining life)?80,000?120,000Goodwill$?50,000The December 31, 2018, trial balances for the parent and subsidiary follow (there were no intra-entity payables on that date): InnovusChipTechRevenues$ (990,000)$ (210,000)Cost of goods sold 500,000 90,000Depreciation expense 100,000 5,000Amortization expense 55,000 18,000Dividend income (40,000)-0-Net income$ (375,000)$ (97,000)Retained earnings 1/1/18$ (1,555,000)$ (450,000)Net income (375,000) (97,000)Dividends declared250,00040,000Retained earnings 12/31/18$ (1,680,000)$ (507,000)Current assets$ 960,000$ 355,000Investment in ChipTech 670,000Equipment (net) 765,000 225,000Trademark 235,000 100,000Existing technology -0- 45,000Goodwill450,000-0-Total assets$ 3,080,000$ 725,000Liabilities$ (780,000) (88,000)Common stock (500,000) (100,000)Additional paid-in capital (120,000) (30,000)Retained earnings 12/31/18 (1,680,000) (507,000)Total liabilities and equity$ (3,080,000)$ (725,000)RequiredUsing Excel, compute consolidated balances for Innovus and ChipTech. Either use a worksheet approach or compute the balances directly.Prepare a second spreadsheet that shows a 2018 impairment loss for the entire amount of goodwill from the ChipTech acquisition.
Also read:
- EXCEL CASE 1On January 1, 2017, Innovus, Inc., acquired 100 percent of
- A portfolio manager is trying to balance investments between bonds, stocks and cash. The return on stocks is 12 percent, 9 percent on bonds, and 3 percent on cash. The total portfolio is $1 billion, and he or she must keep 10 percent in cash in accordance with company policy. The fund's prospectus promises that stocks cannot exceed 75 percent of the portfolio, and the ratio of stocks to bonds must equal two. Formulate this investment decision as a linear programming problem, defining fully your decision variables and then giving the objective function and constraints. Solve the problem and show the optimal solution.
- It is late June, and Sandra Huchim, head of operations at Mintendo, and Bill Smith, head of salesof We “R” Toys, are about to get together to discuss production and marketing plans for the next6 months. Mintendo is the manufacturer of the popular Game Girl handheld electronic game that is sold exclusively through We “R” Toys retail stores. The second half of the year is critical toGame Girl’s success, because a majority of its sales occur during the holiday shopping period.Sandra is worried about the impact that the upcoming holiday surge in demand will have on herproduction line. Costs to subcontract assembly of the Game Girls are expected to increase, andshe has been trying to keep costs down, given that her bonus depends on the level of productioncosts.Bill is worried about competing toy stores gaining share in the handheld electronic game marketduring the Christmas buying season. He has seen many companies lose their share by failing tokeep prices in line with the performance of their products. He would like to maximize the GameGirl market share in the handheld electronic game market.Both Sandra’s and Bill’s teams produce a joint forecast of demand over the next six months, asshown in Table 9-7.We “R” Toys sells Game Girls for $50 apiece. At the end of June, the company has an inventoryof 50,000 Game Girls. Capacity of the production facility is set purely by the number of workersassembling the Game Girls. At the end of June, the company has a workforce of 300 employees,each of whom works 8 hours of regular time at $15/hour for 20 days each month. Work rulesrequire that no employee work more than 40 hours of overtime per month. The various costs areshown in Table 9-8.Sandra, concerned about controlling costs during the periods of surging demand over theholidays, proposes to Bill that the price be lowered by $5 for the month of September. Thiswould likely increase September’s demand by 50 percent due to new customers being attractedto Game Girl. In addition, 30 percent of each of the following two months of demand wouldoccur in September as forward buys. She believes strongly that this leveling of demand will helpthe company.Bill counters with the idea of offering the same promotion in November, during the heart of thebuying season. In this case, the promotion increases November’s demand by 50 percent, owingto new customers being attracted to Game Girl. Additionally, 30 percent of December’s demandwould occur in November as forward buying. Bill wants to increase revenue and sees no betterway to do this than to offer a promotion during the peak season.a. Which option delivers the maximum profit for the supply chain: Sandra’s plan, Bill’splan, or no promotion plan at all?b. How does the answer change if a discount of $10 must be given to reach the samelevel of impact that the $5 discount received?c. Suppose Sandra’s fears about increasing outsourcing costs come to fruition and thecost rises to $22/unit for subcontracting. Does this change the decision when thediscount is $5? need to be able to explain how i got the answer not necessary to show all work but this one is giving me fits.
- Kose, Inc., has a target debt-equity ratio of 0.74. Its WACC is 11 percent, and the tax rate is 32 percent
- principles of economics Which statement is true? A) Today more workers in the U.S. are members of labor unions than any time in our history. B) Today labor unions are weaker than any time in the last 100 years. C) No major labor union has called a strike since the 1940s.D) Labor unions are relatively strong in the public (government) sector. 2. Exclusive union strategy involves A) increasing the demand for the final product, thereby increasing the demand for labor. B) restricting the supply of union labor. C) setting job standards and entry qualifications for members. D) organizing all workers and bargaining for a wage.E) negotiating only after a strike has been called. 3. An example of an exclusive union would be A) the International Brotherhood of the Teamsters. B) the Communications Workers of America. C) the American Medical Association. D) the United Steel Workers. 4. In which one of these years was labor union membership the highest? A) 1940 B) 1960 C) 1980 D) 1990 5. Which of the following laws stated that attempts to monopolize, conspiracies in restraint of trade, and conspiracies to monopolize were illegal? A) The Federal Trade Commission Act B) The Clayton Act C) The Sherman Antitrust Act D) All of the choices. E) None of the choices 6.Until the passage of the Airline Deregulation Act of 1978, the Civil Aeronautics Board controlled all of the following except A) fares. B) assigned routes. C) profits. D) entry into the industry. 7. The Clayton Act prohibited A) interlocking directorates. B) all forms of monopoly. C) foreign control of U.S. corporations. D) false and deceptive advertising. 8. Which statement is true? A) Microsoft is subject to American antitrust laws, but not those of Europe, Asia, or elsewhere. B) Microsoft has never been involved in an antitrust suit. C) The European Commission fined Microsoft over $600 billion for its anticompetitive behavior. D) Microsoft has always gone out of its way to be helpful to its competitors. 9. A monopolist operates at the minimum point of her ATC curve A) only in the short run. B) only in the long run. C) in both the short run and the long run. D) in neither the short run nor the long run. 10. Which of the following is characteristic of a monopoly? A) The absence of political power B) Close substitute products C) The ability to make an economic profit in the long run D) Operating at peak efficiency. (I will send the image) 11. This firm will charge a price of A). $8. B) $9.65. C) $10. D) $12. E) $16 12. Statement I. Only natural monopolies are legal in the United States. Statement II. Large firms generally operate at peak efficiency. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 13. The nation's largest bank has assets over A) $2.5 billion. B) $25 billion. C) $250 billion. D) $800 billion. E) $1.8 trillion. 14. Which statement is true? A) Our money supply is fixed by law and can be raised by only a very small percentage each year. B) Our money supply is backed by gold. C) Credit cards are a form of money. D) Money makes an excellent store of value during times of inflation. E) One of the basic jobs of money is a standard of value. 15. The first bankers were A) goldsmiths. B) printers. C) storekeepers. D) innkeepers. E) blacksmiths. 16. Suppose you had no money in your checking account and your bank granted you overdraft privileges. You then went out and charged $20 on your debit card. How much would your bank charge you in fees for using your overdraft privileges? A) 0 B) $5 C) 15 D) 35 E) $50 17. Statement I: John Maynard Keynes called the hoarding of money at very low interest rates a "liquidity trap." Statement II: Since the late 1990s, Japan has been caught in a liquidity trap. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 18. Banks can A) create money, but not destroy money. B) destroy money, but not create money. C) create and destroy money. D) neither create nor destroy money. 19. The Federal Open Market Committee is made up of all of the following, except A) the board of governors. B) the chairman of the board of governors. C) the president of the United States. D) the president of the Federal Reserve Bank of New York. E) the presidents of four Federal Reserve Banks other than the New York Bank. 20. The Federal Reserve System A) has regional Federal Reserve Banks that make most of the decisions. B) makes decisions subject to the approval of the President. C) makes its major policy decisions in its Open Market Committee. D) makes decisions subject to the approval of Congress. 21. With economic development comes each of the following, except A) a decline in the birth rate. B) an increase in the stock of capital. C) rising per capita GDP D) a declining wage rate. 22. Our educational standards today. A) are the highest in history. B) are much higher than they were 50 years ago. C) are the same as they were 50 years ago. D) are much lower than they were 50 years ago. 23. Brazil should be classified as a(n) A) very poor LDC. B) middle-rank LDC. C) NIC. D) industrial country. 24. The most important reason for our slow rate of productivity growth over the last three decades (of those listed below) is A) lagging business sales. B) foreign imports. C) our low savings rate. D) high tax rates. 25. Structural unemployment occurs when A) workers have quit one job and are looking for a better one. B) high school graduates enter the labor market every June. C) the business cycle is in a downturn and people are laid off. D) the people without jobs have skills that don't match the available job openings. 26. Unemployment caused by economic decline or recession is called A) frictional unemployment. B) cyclical unemployment. C) natural unemployment. D) necessary unemployment. E) structural unemployment.. 27. The recession of 2001 was caused by A) the events of 9/11. B) a decline in consumer spending. C) a decline in investment spending. D) the war in Iraq. 28. A budget deficit is the A) annual excess of government spending over revenue raised by taxes, fees, and charges. B) shortfall of Social Security collections toward payment of benefits. C) amount by which tax revenues and borrowed funds fall short of government expenditures. D) excess of tax revenues over expenditures. E) amount by which tax revenues exceed borrowed funds. 29. The consumer price index is created by A) calculating the cost of a "basket" of consumer goods typically bought by an American family in any year as a percentage of their cost in a base year. B) the Congressional Budget Office. C) averaging the price increases for all consumer goods in the GDP and adding 100. D) dividing nominal dollar consumer expenditures by base year consumer expenditures. 30. Statement I: When equilibrium GDP and full employment GDP are equal, there is no inflationary gap and no deflationary gap.Statement II: Equilibrium GDP is an ideal goal that can never be attained. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 31. When government expenditures in a given year are less than tax receipts, there exists A) a budget deficit. B) public revenue. C) full-employment taxation. D) a budget surplus .32. As price rises, the quantity ______________ rises. A) demanded B) supplied C) demanded and supplied 33. If the MPC were .75, what change in government spending (in billions of dollars) would be required to cause the equilibrium level of GDP to fall by 100? A) A decrease of 25. B) A decrease of 50. C) A decrease of 75. D) A decrease of 100. E) A decrease of 125. (I will send the image) 34. When price is $8 A) quantity demanded is greater than quantity supplied and, therefore, price must fall to get to equilibrium price. B) quantity demanded is greater than quantity supplied and, therefore, price must rise to get to equilibrium price. C) quantity supplied is greater than quantity demanded and, therefore, price must fall to get to equilibrium price. D) quantity supplied is greater than quantity demanded and, therefore, price must rise to get to equilibrium price. 35. Usury is considered the charging of A) higher interest rates than people are willing to pay. B) lower interest rates than people are willing to pay C) unconscionably high interest rates. D) extremely low rates of interest. 36. The present value of a dollar rises as A) the interest rate declines and the number of years you wait for your money declines. B) the interest rate rises and the number of years you wait for your money rises. C) the interest rate declines and the number of years you wait for your money rises. D) the interest rate rises and the number of years you wait for your money declines. 37. In economics we say the amount of land is A) fixed. B) variable. C) both fixed and variable. D) neither fixed nor variable. 38. Which is not determined by supply and demand? A) The wage rate B) The interest rate C) Rent D) Profits 39. Which of the following is false? A) The supply of land is fixed. B) When the demand for a plot of land rises, its supply will rise. C) Land is most efficiently used in cities. D) The rent on a particular piece of land is based on the MRP schedule of the highest bidder. 40. If you knew that interest rates would be rising, then you would predict that the present value of $1 received 5 years from now A) would be higher. B) would be about the same. C) would be lower. D) could be higher or lower. 41. Changes in rent on a plot of land are chiefly due to A) changes in demand. B) changes in supply. C) changes in both demand and supply. D) changes in neither supply nor demand. (I will send the image) 42. The horizontal dotted line is A) a price ceiling. B) a price floor. C) either a price ceiling or a price floor. D) neither a price ceiling nor a price floor. 43. These lenders avoid using the term "interest," but their borrowers still do pay a charge for borrowing money. This would be considered ___________ lending. A) Islamic B) payday C) fringe D) sub-prime 44. __________ sees the entrepreneur as an exploiter of labor. A) Joseph Schumpeter B) Frank Knight C) Henry George D) Karl Marx 45. A more equal distribution of income A) might hurt the incentive to work .B) would not hurt the incentive to work C) would be opposed by nearly all Americans D) would hurt the poor. 46. Between 1994 and 2005 our welfare rolls A) declined substantially every year. B) declined slightly every year .C) declined most years. D) stayed about the same. E) rose most years 47.Who expressed this view? "Unlike the present period, (black) inner-city communities prior to 1960 exhibited the features of social organization—including a sense of community, positive neighborhood identification, and explicit norms and sanctions against aberrant behavior." A) Charles Murray B) William Julius Wilson C) Mickey Kaus D) Lisabeth Schorr E) Celia Dugger 48. According to Darity and Myers A) black men are becoming increasingly marginal to our economy B) the basic cause of poverty is welfare dependency C) the best solution to poverty is the negative income tax D) as our economy continues to expand, black poverty will decline (I will send the image) 49. The percentage share of income of the bottom quintile on curve X is A) 0. B) 5. C) 10. D) 15. E) 20. 50. The percentage of people living in poverty in 2006 in the U.S. was _______. A) 6 B) 11.7 C) 12.3 D) 15.2 51. Child poverty is A) much more of a problem in France, Germany, and Japan than it is in the U.S. B) less of a problem in the United States than in Canada, Britain, or Italy. C) more of a problem in Sweden, Denmark, and Ireland than it is in the U.S. D) much more of a problem in the U.S. than in virtually all other industrialized countries. 52. Statement I: Social Security payments help mostly the poor. Statement II: Poverty may be defined as a relative concept and as an absolute concept. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 53. Compared to their levels in 1999, the poverty line has ______ and the minimum hourly wage has ________. A) gone up; gone up B) stayed the same; stayed the same C) gone up; stayed the same D) stayed the same; gone up 54. In which year was the poverty rate the lowest? A) 1960 B) 1973 C) 1984 D) 1993 E) 2006 55. Which statement is true? A) Most economists support rent control laws. B) Usury laws and rent control are price ceilings. C) Usury laws have never had any effect because they are set well above interest rates. D) None of the choices. (I will send the image) 56. If price were set by the government at $3, there would be a price _____________, that would cause a ___________ of _______ units. A) floor, surplus, 12 B) floor, shortage, 12 C) ceiling, surplus, 14 D) ceiling, shortage, 14 57. Sue Ann Buchanan, can make $800,000 on the pro tennis tour, but would be willing to do it for $200,000. Her economic rent is A) $200,000. B) $600,000. C) $800,000. D) $1,000,000. 58. Despite their fantastic employment gains, African American men earn ____% of what white men earn. A) 65 B) 55 C) 60 D) 76 59. Since 1996, productivity growth has ________ and real wages have ______. A) risen; risen B) fallen; fallen C) risen; fallen D) fallen; risen. 60. Which statement is false? A) The minimum wage has NOT kept up with the rate of inflation .B) The average real hourly earnings fell steadily from 1973 to 1993. C) Workers with some high school education make about the same average annual earnings as those with high school diplomas. D) It is harder for a middle class student to get a college degree because since 1979, the cost of going to college has gone up twice as fast as the rate of inflation.
- Based on the organization you selected, coca cola, this write a financial plan of 350-500 words, plus spreadsheet(s) that addresses the following (guidelines): Using Excel, create a 3-year pro forma income statement for your organization or product/service. What will be your financial break-even point? If you require investment capital, identify possible sources (friends, family, banks, USSBA, etc.). How will you use financial information to help you craft your business strategy? What key financial ratio will you be using to measure the performance of your organization to determine success? Use Microsoft Excel for all computations where applicable. Ensure that the Excel file includes the associated cell computations in order to receive full credit. Prepare this assignment according to the APA guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required. You are not required to submit this assignment to Turnitin, unless otherwise directed by your instructor. If so directed, refer to the Student Success Center for directions. Only Word documents can be submitted to Turnitin
- $14.00 Crane Mechanics acquired 75 percent of Downey Enterprises
- ACC 205 FINAL EXAMINATION (100% SCORE) 100 QUESTION WITH 100% ANSWER