Jonna Vella, Inc. is raising $250,000 in early stage money to fund development of their prototype. The company is still in a very early stage, and doesn't feel ready to put a valuation on themselves. So they are raising this round as a convertible debt round with the following parameters: the debt will convert to equity on the first priced round, at the valuation of the firm in that priced round, plus a 20% bonus. The debt will earn 5% per year until conversion. Suppose that the company raises $1 million in a priced round in one year, and that the round values the company at $10 million.
How much will the debt be worth (in dollars) at the time of conversion?
What % ownership of the company will that represent, at the time of conversion?
What % ownership of the company will the new investors want to own for their $1 million?
If the founders own 100,000 shares, how many shares will the new investors receive?
How many shares will the convertible debt holders receive at conversion?
Make a simple table to show the shares owned, and corresponding % ownership, by each of the three groups (founders, convertible debt investors, equity investors) after conversion.
Suppose that the convertible debt investors try to negotiate a larger "bonus" of 25% to their investment (so they would receive an extra 25% share of the company instead of 20%). Who would benefit from this, and who would lose?
Suppose that the convertible debt investors negotiate a valuation "cap" of $5 million. This means that their debt would convert as if the company were worth no more than $5 million, regardless of the valuation from the priced round. Who wins and loses with this valuation cap?
Explain each question
In: Finance
You founded your own firm three years ago. You initially contributed $200,000 of your own money and in return you received 3 million shares of stock. Since then, you have sold an additional 2 million shares of stock to angel investors. You are now considering raising capital from a venture capital firm. This venture capital firm would invest $5 million and would receive 4 million newly issued shares in return. Suppose you sold the 2 million shares to the angel investor for $500,000. What was the post-money valuation of your shares immediately following the angel investor's investment?
In: Accounting
Consider the following data.
|
STUDENT |
||||
|
StudentID |
SName |
Gender |
Age |
ClubID |
|
3234 |
Alfred Smith |
Male |
20 |
BSK |
|
2244 |
McJohnson Robert |
Male |
22 |
|
|
2389 |
Jessica Low |
Female |
20 |
JPA |
|
4211 |
Roland Devingo |
Male |
24 |
|
|
4383 |
Jane Usa Khan |
Female |
21 |
BKY |
|
4450 |
Elaine Fong |
Female |
20 |
JPA |
|
CLUB |
|||
|
ClubID |
CName |
Founded |
Budget |
|
BKY |
Bakery Club |
2010 |
2546 |
|
PDC |
Photomedia and Design |
2005 |
1345 |
|
JPA |
Japanese Anime |
2009 |
3453 |
|
BSK |
Basketball |
2011 |
6744 |
What is the value returned by this SQL statement?
SELECT COUNT( CLUBID )
FROM STUDENT
In: Computer Science
Berne Company (lessor) enters into a lease with Fox Company to lease equipment to Fox beginning January 1, 2016. The lease terms, provisions, and related events are as follows:
1. The lease term is 4 years. The lease is noncancelable and requires annual rental payments of $50,000 to be made at the end of each year.
2. The equipment costs $130,000. The equipment has an estimated life of 4 years and an estimated residual value at the end of the lease term of zero.
3. Fox agrees to pay all executory costs.
4. The interest rate implicit in the lease is 12%.
5. The initial direct costs are insignificant and assumed to be zero.
6. The collectibility of the rentals is reasonably assured, and there are no important uncertainties surrounding the amount of unreimbursable costs yet to be incurred by the lessor. Required: 1. Next Level Determine if the lease is a sales-type or direct financing lease from Berne’s point of view (calculate the selling price and assume that this is also the fair value). 2. Prepare a table summarizing the lease receipts and interest revenue earned by the lessor. 3. Prepare journal entries for Berne, the lessor, for the years 2016 and 2017.
Required:
| 1. | Next Level Determine if the lease is a sales-type or direct financing lease from Berne’s point of view (calculate the selling price and assume that this is also the fair value). |
| 2. | Prepare a table summarizing the lease receipts and interest revenue earned by the lessor. |
| 3. |
Prepare journal entries for Berne, the lessor, for the years 2016 and 2017. Please note the other answers posted are NOT correct. Thank you! |
In: Accounting
Data. See Excel spreadsheet “GroupProject1.xlsx”. It contains the monthly returns of value-weighted equity indexes divided into various groups: • North America — Canada and the United states • Japan • Asia Pacific — Australia, Hong Kong, New Zealand, and Singapore • Europe — Austria, Belgium, Denmark, Finland, France, Germany, Greece, Ireland, Italy, the Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, and the United Kingdom • Global – All of the above countries All index returns are in US dollar terms. In addition, the file contains the 1-month US risk-free rate.
Questions 1.) On a single chart, plot the value of $1 invested in each of the five indexes over time. I.e., for all ?, plot the cumulative return series for each index: ??? = (1 + ?1)(1 + ?2)… (1 + ??) What patterns do you observe?
| Date | North_America | Japan | Asia_exJapan | Europe | Global | Rf |
| 9-Nov-44 | -0.82% | 0.78% | 4.85% | 5.05% | 1.47% | 0.68% |
| 10-Nov-44 | -8.93% | -11.25% | -7.82% | -10.20% | -10.10% | 0.66% |
| 11-Nov-44 | -5.41% | -17.43% | -8.25% | -11.74% | -11.64% | 0.60% |
| 12-Nov-44 | -1.33% | 25.59% | -1.58% | 7.27% | 10.26% | 0.68% |
| 13-Nov-44 | 6.43% | -13.52% | -2.29% | 0.17% | -3.30% | 0.57% |
| 14-Nov-44 | 3.11% | 2.34% | -0.61% | -0.95% | 1.63% | 0.60% |
| 11-Feb-45 | 4.73% | 1.67% | 6.03% | 2.12% | 2.99% | 0.52% |
| 12-Feb-45 | 7.70% | 12.81% | 9.26% | 7.78% | 9.57% | 0.48% |
| 13-Feb-45 | 2.80% | -3.76% | 2.13% | -6.34% | -1.93% | 0.44% |
| 14-Feb-45 | 0.34% | 2.68% | 3.24% | -0.21% | 1.13% | 0.53% |
| 15-Feb-45 | 4.16% | -1.59% | -0.40% | 1.13% | 1.22% | 0.47% |
| 16-Feb-45 | -4.27% | -6.61% | -0.50% | -7.02% | -5.65% | 0.42% |
| 17-Feb-45 | 4.42% | 1.85% | 6.04% | 5.94% | 3.93% | 0.49% |
| 18-Feb-45 | 2.62% | -6.79% | -1.48% | 1.86% | -0.94% | 0.46% |
| 19-Feb-45 | -1.29% | 9.10% | 1.16% | 3.42% | 3.34% | 0.46% |
| 20-Feb-45 | 1.84% | 4.47% | 4.33% | -2.33% | 1.78% | 0.42% |
| 21-Feb-45 | -3.76% | -8.14% | -0.26% | -1.89% | -4.75% | 0.39% |
| 22-Feb-45 | 10.30% | 2.85% | 1.58% | 6.61% | 6.56% | 0.38% |
In: Finance
Music-Is-Us, Inc., is a supplier of musical instruments for
professional and amateur musicians. The company’s accountants make
adjusting entries monthly, and they make all closing entries
annually . The company is growing rapidly and prides itself on
having no long-term liabilities. The company has provided the
following trial balance dated December 31, 2018.
MUSIC-IS-US, INC. TRIAL BALANCE DECEMBER 31, 2018
Cash. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . $ 45,000
Marketable securities. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25,000
Accounts receivable. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125,000
Allowance for doubtful accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 5,000
Merchandise inventory. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250,000
Office supplies. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,200
Prepaid insurance. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6,600
Building and fixtures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,791,000
Accumulated depreciation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 800,000
Land. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64,800
Accounts payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70,000
Unearned customer deposits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8,000
Income taxes payable. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75,000
Capital stock. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,000,000
Retained earnings. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240,200
Unrealized holding gain on investments. . . . . . . . . . . . . . . . . . . . . . . . 6,000
Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,600,000
Cost of goods sold . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 958,000
Bank service charges. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200
Uncollectible accounts expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9,000
Salary and wages expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 395,000
Office supplies expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400
Insurance expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6,400
Utilities expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3,600
Depreciation expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48,000
Income tax expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75,000
$3,804,200 $3,804,200
Other information pertaining to the company’s trial balance is
provided as follows. 1. The most recent bank statement reports a
balance of $46,975. Included with the bank statement was a $2,500
check from Iggy Smarts, a professional musician, charged back to
Music-Is-Us as NSF. The bank’s monthly service charge was $25.
Three checks written by Music-Is-Us to suppliers of merchandise
inventory had not yet cleared the bank for payment as of the
statement date. These checks included: no. 508, $5,500; no.
511,
388
$7,500; and no. 521, $8,000. Deposits of $16,500 reached the bank
too late for inclusion in the current bank statement. The company
prepares a bank reconciliation at the end of each month.
2. Music-Is-Us has a portfolio of marketable securities that originally cost $19,000. As of December 31, the market value of these securities was $27,500. All short-term investments are classified as “available for sale.”
3. During December, $6,400 of accounts receivable were written off as uncollectible. A recent aging of the company’s accounts receivable led management to conclude that an allowance for doubtful accounts of $8,500 is needed at December 31, 2018.
4. The company uses a perpetual inventory system. A year-end physical count revealed that several guitars reported in the inventory records were missing. The cost of the missing units amounted to $1,350. This amount is not considered significant relative to the total cost of inventory on hand.
5. At December 31, approximately $900 in office supplies remained on hand.
6. The company pays for its insurance policies 12 months in advance. Its most recent payment was made on November 1, 2018. The cost of this policy was slightly higher than the cost of coverage for the previous 12 months.
7. Depreciation expense related to the company’s building and fixtures is $5,000 for the month ending December 31, 2018.
8. Although Music-Is-Us carries an extensive inventory, it is not uncommon for experienced musicians to order custom guitars made to their exact specifications. Manufacturers do not allow any sales returns of custom-made guitars. The entire sales amount is collected at the time a custom order is placed, and is credited to an account entitled “Unearned Customer Deposits.” As of December 31, $4,800 of these deposits remained unfilled because the special-order guitars have not been received from the manufacturer. The cost of goods sold and the reduction in inventory associated with all custom orders is recorded when the custom merchandise is delivered to customers. At that time, the adjusting entry requires only a decrease to unearned customer deposits and an increase in sales.
9. Accrued income taxes payable for the entire year ending December 31, 2018, total $81,000. No income tax payments are due until early in 2019.
Instructions
a. Prepare a bank reconciliation and make the journal entries to update the accounting records of Music-Is-Us as of December 31, 2018.
b. Prepare the adjusting entry to update the company’s marketable securities portfolio to its mark-to-market value.
c. Prepare the adjusting entry at December 31, 2018, to report the company’s accounts receivable at their net realizable value (i.e., total amount receivable, less estimated allowance for uncollectible accounts).
d. Prepare the entry to account for the guitars missing from the company’s inventory at the end of the year.
e. Prepare the adjusting entry to account for the office supplies used during December.
f. Prepare the adjusting entry to account for the expiration of the company’s insurance policies during December.
g. Prepare the adjusting entry to account for the depreciation of the company’s building and fixtures during December.
h. Prepare the adjusting entry to report the portion of unearned customer deposits that were earned during December.
i. Prepare the adjusting entry to account for income tax expense that accrued during December.
j. On the basis of the adjustments made to the accounting records in parts a through i, prepare the company’s adjusted trial balance at December 31, 2018.
k. Using the adjusted trial balance prepared in part j, prepare
an annual income statement, statement of retained earnings, and a
balance sheet dated December 31, 2018.
389
l. Using the financial statements prepared in part k, determine
approximately how many days on average an account receivable
remains outstanding before it is collected. You may assume that the
company’s ending accounts receivable balance on December 31 is a
close approximation of its average accounts receivable balance
throughout the year.
m. Using the financial statements prepared in part k, determine approximately how many days on average an item of merchandise remains in stock before it is sold. You may assume that the company’s ending merchandise inventory balance on December 31 is a close approximation of its average merchandise inventory balance throughout the year.
n. Using the financial statements prepared in part k, determine approximately how many days it takes to convert the company’s inventory into cash. In other words, what is the length of the company’s operating cycle?
o. Comment briefly upon the company’s financial condition from the perspective of a short-term creditor.
In: Accounting
Lynch was the loan officer at First Bank. Patterson applied to borrow $25,000. Bank policy required that Lynch obtain a loan guaranty from Patterson’s employer, a milk company. The manager of the milk company visited the bank and signed a guaranty on behalf of the company. The last paragraph of the guaranty stated, “This guaranty is signed by an officer having legal right to bind the company through authorization of the Board of Directors.” Should Lynch be satisfied with this guaranty? Would he be satisfied if the president of the milk company, who was also a director, affirmed that the manager had authority to sign the guaranty? Explain.
Ralph owned a retail meat market. Ralph’s agent Sam, without authority but purporting to act on Ralph’s behalf, borrowed $7,500 from Ted. Although he never received the money, Ralph repaid $700 of the alleged loan and promised to repay the rest. If Sam had no authority to make the loan, is Ralph liable? Why?
A guest arrived early one morning at the Hotel Ohio. Clemens, a person in the hotel office who appeared to be in charge, walked behind the counter, registered the guest, gave him a key, and took him to his room. The guest also checked valuables (a diamond pin and money) with Clemens, who signed a receipt on behalf of the hotel. Clemens in fact was a roomer at the hotel, not an employee, and had no authority to act on behalf of the hotel. When Clemens absconded with the valuables, the guest sued the hotel. Is the hotel liable? Why?
In: Operations Management
ShopSmart’s International Growth Strategy
ShopSmart, founded by in 1919 by Nick Smart, is a British multinational grocery and merchandise retailer. It is the largest grocery retailer in the United Kingdom, with a 28% share of the local market and the second largest after Walmart measured in revenue. In 2017, ShopSmart had sales of more than £62 billion ($70 billion US dollars), more than 480,000 employees and 6,553 stores in 13 countries.
In its home market of the United Kingdom, the company’s strengths are reputed to come from strong competencies in marketing and store site selection, logistics and inventory management and its own label product offerings. By the early 1990s, these competencies had already given the company a leading position in the United Kingdom. ShopSmart was generating strong cash flows and senior managers had to decide how to use that cash. One strategy they settled n was international expansion.
As managers looked at international markets, they soon concluded that the best opportunities were not in established markets in North America and Western Europe where strong competitors already existed but in emerging markets of Eastern Europe and Asia, where there were strong underlying growth trends. ShopSmart’s first international foray was into Hungary in 1995 where it acquired Globals Stores, a state-owned grocery chain. By 2017, ShopSmart was the market leader in Hungary accounting for 1% of the whole economy of Hungary.
Next, ShopSmart acquired 31 stores in Poland from Stavia Limited. The following year, in 1996, ShopSmart added 13 stores that it purchased from Kmart in the Czech Republic and Slovakia. The next year, ShopSmart moved to purchase stores in the Republic of Ireland.
ShopSmart’s Asian expansion begun in 1998 when it moved into Thailand. In 1999, the company entered South Korea when it partnered with Samsung to develop a chain of hypermarkets. This was followed by entry into Taiwan in 2000, Malaysia in 2002, Japan in 2003 and China in 2004.
The move into China came after three years of careful research and discussions with potential partners. Like many other western companies, ShopSmart was attracted to the Chinese market by its large size and rapid growth. In the end, ShopSmart settled on a 50-50 joint venture with Hymall, a hypermarket chain that is controlled by Ting Hsin, which has been operating in China for six years. In 2014, ShopSmaart combined its 131 stores in China in a joint venture with the state-run China Resources Enterprise and its nearly 3,000 stores. ShopSmart owned 20% of the joint venture. As a result of these moves, by 2017, ShopSmart generated sales of about $21 billion outside the United Kingdom. The addition of international stores has helped make ShopSmart the second largest company in the global grocery market behind only Walmart. By 2017, all its foreign ventures were making money.
(Source: Adapted from Hill, C.W.L. & Hult, G.T.M., (2019), International Business: Competing in the Global Marketplace, 12th Edition, McGraw Hill Education)
Examine two reasons why ShopSmart’s initial international expansion focused on emerging markets rather than competing with established companies in the more advanced markets of North America and Western Europe.
Discuss two disadvantages that ShopSmart encountered as a first mover into these emerging markets.
ShopSmart’s entry strategy into the Eastern European countries was through acquisition. Discuss three disadvantages that the company is likely to encounter as a result of this entry strategy
Identify ShopSmart’s strategic entry into the Asian market and discuss two benefits that the company sought to achieve with this strategy
In: Economics
Since 2017, HPT has reduced the number of retail locations in hope of saving costs and improving its financial health.
|
HPT Company |
||||
|
2019 |
2018 |
2017 |
Industry Ratios 2019 |
|
|
Current ratio |
0.80 |
1.26 |
1.54 |
1.45 |
|
Inventory turnover |
3.85 |
4.30 |
4.45 |
4.57 |
|
Average Collection Period |
40.45 |
35.45 |
22.45 |
30.00 |
|
Capital asset turnover |
1.12 |
1.33 |
2.46 |
3.19 |
|
Total asset turnover |
1.04 |
1.46 |
1.71 |
2.00 |
|
Debt to total assets |
65.00% |
55.53% |
51.25% |
30.00% |
|
Times interest earned |
2.87 |
3.06 |
4.08 |
14.63 |
|
Gross margin |
40.00% |
39.00% |
39.00% |
42.00% |
|
Profit margin on Revenue |
2.90% |
3.56% |
4.25% |
6.71% |
|
Return on Total Assets |
3.17% |
5.21% |
10.27% |
13.42% |
|
Return on Equity |
6.65% |
10.19% |
12.09% |
19.17% |
|
Days in working capital |
32.45 |
36.58 |
40.45 |
N/A |
|
Cash Conversion Efficiency |
5.29% |
6.18% |
N/A |
N/A |
|
Cash Conversion Cycle |
73.30 |
64.04 |
61.44 |
N/A |
Required:
a. Identify 2 ratios for each category:
Liquidity, Solvency, Productivity, and Profitability (2 marks for each category)
b. Provide an overall trend assessment of each category (do not explain each individual ratio but instead, provide an assessment of the category):
Liquidity , Solvency , Productivity , Profitability
c) The following information for HPT is provided:
|
HPT Company |
|||
|
2019 |
2018 |
2017 |
|
|
Z-Score |
1.53971 |
1.5562 |
2.2341 |
|
Sustainable Growth |
(0.0267) |
0.0180 |
0.0240 |
What do the Z-score and sustainable growth numbers in the above chart mean? Has the company done better or worse since 2017? Explain.
In: Finance
Question C1 You just graduate from University of Hong Kong, major in Management. You are employed by Standard Chartered Bank as wealth management associate. During your training, you are given the situation for practice.
Mary and Eddie, ages 43 and 47, have a daughter who is completing her first year of university and a son three years younger. Currently, they have $200,000 in savings and investment funds set aside for their children’s education. With increasing education costs, they are concerned whether this amount is adequate. In recent months, Mary’s mother has required extensive medical attention and personal care assistance. Unable to live alone, she is now a resident of a long-term care facility. The cost of this service is $6,750 a month, with annual increases of about 5 percent. While a major portion of the cost is covered by Social Security and her savings, Mary’s mother is unable to cover the entire cost. In addition, Mary and Eddie are concerned about saving for their own retirement. While they have consistently made annual deposits to a retirement fund, current financial demands may force them to access some of that money
Required:
a. Identify the main financial planning issues that need to be addressed.
b. Suggest any TWO additional information, one in quantitative and one in qualitative you need before making recommendation.
c. Based on the information provided and your assessment of the situation, recommend TWO most appropriate actions. (Total 25 marks)
In: Finance