Question

Assignment 1- FNCE 371

Luvly Jubbly Inc., is a wholesaler of merchandise with a British flavour. The merchandise is distributed to Canadian retailers in all provinces. Due to the rise in popularity in Canada of British television shows such as Downton Abbey and Sherlock, the company’s sales have grown by an average of 15% per year over the last five years. The company’s sales are expected to grow by a more modest 10% next year, with all costs and expenses growing proportionately with sales.

The company was started 10 years ago by Camilla and Phillip Samuelson, who emigrated from Sweden to Canada 15 years ago. Camilla and Phillip and their three daughters are huge fans of all things British. Before they started the company, they were avid collectors of British memorabilia, particular those for the long-running British soap, East Enders. After one particularly unsettling disagreement with an online retailer of British memorabilia (concerning a misprint on a mug that said “West Enders rule!”), Camilla and Phillip decided to combine their business acumen with their love of British memorabilia and started their company. With profits from the business, they were able to put all three daughters through university. One of their daughters, Margaret, now works for them as their office manager. Margaret is responsible for sending out invoices and bills, checking on when these invoices and bills come due, and calling customers if bills are still unpaid 60 days after sale.

Even with the recent growth in sales, the Samuelsons have noticed a steady decline in their quarterly net profit in the last two years. They think that this may be due to their current policy of giving trade credits. When they first started 10 years ago, to attract customers to their new business they set their credit policy to net 50, which was more generous than the wholesale industry average of net 30. Since then, the company has built up a steady customer base, but has retained the net 50 credit policy. Unfortunately, the rising popularity of British shows and their associated memorabilia in Canada has enticed more companies into the business, including mega-companies such as Walmart.

In the midst of this increased competition, a severe financial crisis hit the world market two years ago, forcing some of Luvly Jubbly’s customers to reduce their orders and forcing a few into bankruptcy. As a result, bad debt increased to about 2% during the last two years. The upcoming year is the first year that bad debt is forecasted to drop back down to its historical level of 1%. Under the current net 50 policy, 85% of customers pay by Day 50, and the remainder pay 10 days later. With the delays in collecting from customers, the Samuelsons have had to use the company’s line of credit to pay its expenses. Their bank, the United Bank of Canada, sets both short-term and long-term debt interest rates for the company at 15%.

At this point, considering the company’s lowered net profit, Camilla and Phillip are finally ready to take a deeper look at their credit policy, and if necessary, to change it. They asked their second daughter, Diana (who has an MBA degree), to take a look at their books. After completing her analysis, Diana gave them two possible alternatives for their credit policy, with suggested outcomes:

Alternative #1: 2/20 net 30

·         Lose 5% sales

·         50% of customers will pay at Day 20

·         40% of customers will pay at Day 30

·         10% of customers will pay at Day 60

·         Cash, inventory, fixed assets, accounts payable, long-term debt, and equity will remain unchanged

Alternative #2: 2/25 net 45

·         No lost sales

·         60% of customers will pay at Day 25

·         35% of customers will pay at Day 45

·         5% customers will pay at Day 60

·         Cash, inventory, fixed assets, accounts payable, long-term debt, and equity will remain unchanged

Industry average: 2/20 net 30

·         Average collection period = 28 days

·         Net profit margin = 5%

·         Return on assets = 5.2%

·         Return on equity = 13%

The company’s most recent statement of comprehensive income and statement of financial position are presented below.

The Samuelsons will have to make a decision on the company’s credit policy based on the available information.

Statement of Comprehensive Income




Sales

$500,000




     Cost   of goods sold

300,000




Gross   profit

$200,000




     Operating   expenses

100,000




Earnings   before interest and taxes

$100,000




     Interest   expense

35,332




Earnings   before taxes

$64,668




     Income   taxes (35%)

22,634




Net income

$42,034




 


 
 

Statement of Financial Position

 


Cash

10,000

http://sb5.athabascau.ca/icons/ecblank.gif

Accounts   payable

$15,000

Accounts   receivable

70,548

http://sb5.athabascau.ca/icons/ecblank.gif

Notes   payable

35,548

Inventory

20,000

http://sb5.athabascau.ca/icons/ecblank.gif

     Current   liabilities

$50,548

     Current   assets

$100,548

http://sb5.athabascau.ca/icons/ecblank.gif

Long-term   debt

200,000

Fixed   assets

500,000

http://sb5.athabascau.ca/icons/ecblank.gif

Equity

$350,000

Total   assets

$600,548

http://sb5.athabascau.ca/icons/ecblank.gif

Total     liabilities & equity 

$600,548

 


Questions:

 

1.            What are the effective annual costs for the two proposed credit policy alternatives? If the average borrowing rate for the company’s customers is 15%, will these credit policies be attractive to these customers?                                                                           (12 marks)

 

2.            Construct aging schedules for the current credit policy and the two proposed new credit policies.                                                                                                   (26 marks)

3.            Construct the Pro-forma Statement of Comprehensive Income and Statement of Financial Position based on the current credit policy and the two proposed credit policies.   (20 marks)

4.            Calculate the average collection period, net profit margin, return on assets, and return on equity for both the current and the proposed policies.                                    (18 marks)

5.            How does the company compare with the industry average in terms of its average collection period, profitability, and returns on assets and equity under the current and proposed policies?                                                                                                   (10 marks)

6.            Which credit policy should the Samuelsons choose? Provide reasons for your recommendation.                                                                                                     (6 marks)


0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Assignment 1- FNCE 371
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Case 2: Credit Policy Management Case Luvly Jubbly Inc., is a wholesaler of merchandise with a British flavour. The merc...

    Case 2: Credit Policy Management Case Luvly Jubbly Inc., is a wholesaler of merchandise with a British flavour. The merchandise is distributed to Canadian retailers in all provinces. Due to the rise in popularity in Canada of British television shows such as Downton Abbey and Sherlock, the company’s sales have grown by an average of 15% per year over the last five years. The company’s sales are expected to grow by a more modest 10% next year, with all costs...

  • Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...

    Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 34,945 $ 43,374 $ 44,312 Accounts receivable, net 104,412 72,956 58,492 Merchandise inventory 132,591 98,354 63,559 Prepaid expenses 11,369 11,386 4,874 Plant assets, net 327,281 300,308 276,363 Total assets $ 610,598 $ 526,378 $ 447,600 Liabilities and Equity Accounts payable $ 155,080 $ 90,737 $ 57,902 Long-term notes payable secured by mortgages on plant assets 114,792 119,856 98,920 Common stock,...

  • Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...

    Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 34,945 $ 43,374 $ 44,312 Accounts receivable, net 104,412 72,956 58,492 Merchandise inventory 132,591 98,354 63,559 Prepaid expenses 11,369 11,386 4,874 Plant assets, net 327,281 300,308 276,363 Total assets $ 610,598 $ 526,378 $ 447,600 Liabilities and Equity Accounts payable $ 155,080 $ 90,737 $ 57,902 Long-term notes payable secured by mortgages on plant assets 114,792 119,856 98,920 Common stock,...

  • Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Ca...

    Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 28,446 $ 32,579 $ 36,403 Accounts receivable, net 84,111 58,189 47,124 Merchandise inventory 103,659 76,892 51,708 Prepaid expenses 9,253 8,640 3,927 Plant assets, net 261,536 243,532 217,838 Total assets $ 487,005 $ 419,832 $ 357,000 Liabilities and Equity Accounts payable $ 123,690 $ 70,952 $ 47,124 Long-term notes payable secured by mortgages on plant assets 92,473 97,527 80,475 Common stock,...

  • Total: 23 Marks Question 4 Suggested time allocation: 414 Minutes The comparative statements of Gong Limited are pre...

    Total: 23 Marks Question 4 Suggested time allocation: 414 Minutes The comparative statements of Gong Limited are presented below. Gong Limited Income Statement For the year ended 30 June 2018 $ 600,000 2017 Net sales (all on account) Expenses: Cost of sales 520,000 415,000 123,800 354,000 114,800 6,000 14,000 488,800 31,200 Selling and administrative Interest Expense Income tax expense Total expenses Profit 7,800 18,000 564,600 35,400 Gong Limited Statement of Financial Position As at 30 June Assets 2018 2017 Current...

  • Liquidity Current ratio 2014 = current assets/current liabilities 204,000/89,000 = 2.292 for 2014 and 230,000/90,000 =...

    Liquidity Current ratio 2014 = current assets/current liabilities 204,000/89,000 = 2.292 for 2014 and 230,000/90,000 = 2.555 for 2015 Quick Ratio = current assets-inventory/current liabilities 204,000-66,000/89000= 1.550 for 2014 and 230,000-75000/90,000 = 1.722 for 2015 Accounts receivable turnover Credit sales/average debts Average debt 75000+82000/2 = 78500 Total sales = 3,199,900/78500 = 40.76 times (2015) Days sales outstanding = average accounts receivable/sales credit 78500/3199900 x 360 = 8.83 days (2015) Inventory turnover 66,000+75,000/2 = 70,500 Inventory turnover ratio = cost of...

  • Question 1 (24 marks) Mr Ekandjo, a law student had graduated five years ago. After graduation...

    Question 1 (24 marks) Mr Ekandjo, a law student had graduated five years ago. After graduation he decided to set up a law firm together with his close friends named: Ekandjo and Associates. The following information apply to Ekandjo and Associates (millions of dollars) for the year 2019. Details N$ (millions) Cash and Marketable Securities 120 Non-Current Assets 300 Sales 1050 Net Income 55 Other information Quick ratio 2.0 Current ratio 3.0 DSO 41 days ROE 12% Ekandjo has no...

  • Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets...

    Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 32,935 $ 38,498 $ 38,545 Accounts receivable, net 89,200 62,800 51,100 Merchandise inventory 114,000 85,000 51,000 Prepaid expenses 10,606 10,106 4,283 Plant assets, net 295,220 270,804 233,072 Total assets $ 541,961 $ 467,208 $ 378,000 Liabilities and Equity Accounts payable $ 138,997 $ 81,327 $ 51,393 Long-term notes payable...

  • Statement of the Assignment: Please prepare a comprehensive list of financial ratios as introduced in Chapter...

    Statement of the Assignment: Please prepare a comprehensive list of financial ratios as introduced in Chapter 3 of the textbook. Write a brief explanation below each financial ratio, e.g. what does the financial ratio measures or what the significance of it is. For example: Current Ratio = Current Assist / Current Liabilities Current ratio measures whether our current assets, if liquidated, are sufficient to pay all of our current liabilities. A CR of 1.5, for example, shows that if we...

  • Tightening Credit Terms Firm's current credit terms, net Industry-wide credit terms, net Discount...

    Tightening Credit Terms Firm's current credit terms, net Industry-wide credit terms, net Discounts Bad Debt Losses Firm's variable cost ratio Tax rate Interest rate on funds invested in receivables Days in year 90 days 30days 63.00% 40.00% 20.00% Current Credit Policy Annual credit sales Days sales outstanding. DSO 2,840,000 95 days New Credit Policy, Tighten to Industry-Average Credit Terms Annual credit sales Days sales outstanding, DSO $2,715,000 35days Effect of Projected Income Statement Under Current Credit Policy Statement Under New...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT