Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The case Stripe Supply Ltd. is an industrial supply company. Stripe primarily supplies finishing products to condominium, apartment, and industrial building construction companies. A new

The case Stripe Supply Ltd. is an industrial supply company. Stripe primarily supplies finishing products to condominium, apartment, and industrial building construction companies. A new customer, Wendel Enterprises Ltd., would like to make a $550,000 purchase of paint and related supplies. This is a large order for Stripe which would be close to 15% of all average current sales for Stripe Supply for a year. You have been asked to provide a recommendation on whether or not to extend credit (essentially a short-term loan) to Wendel Enterprises. Wendel's CFO has also proposed two other potential investment options. One option would be to grant long-term credit to Wendel. Another option is to provide the funds by having Stripe purchase shares in Wendel. You are to consider and conclude on all three issues. You are reporting to the CEO of Stripe Supply Ltd. See Wendell's Financial information in the Appendix to this document. Video Presentation Format The presentation will be based on the financial information extracted from Wendel Enterprises Ltd. financial information enclosed. The requirements are as follows: Your group is a consulting firm (make up your own company name), and your firm has been hired by the CEO of Stripe Supply Ltd. to provide a presentation. The CEO is the user of the Presentation, not your professor. Stripe Supply Ltd. is considering three possible ways to be involved with Wendel Enterprises Ltd.: grant them short-term credit grant them long-term credit purchase shares of Wendel Your task of this project is to analyze the financial data and conclude on all three options. You need to recommend the BEST option and give your reasons. You have been provided industry information to be used as an industry benchmark.

Analysis- Five sections need to be addressed: Profitability, Asset Utilization, Liquidity, Debt Utilization, and Other Items. You should present high level analysis for each one, based on the ratios you are presenting in your Appendix. You will likely want to discuss and highlight: o the trend of the ratios from year to year and compared to Industry o what the ratios tell us about the company in general or its financial management. o any inter-relationships between ratios that might be important. o HINT: you need to go beyond simply commenting on increase/decrease or better or worse than prior years or industry. Consider how the ratios relate to the financial statement accounts. For example, if the current ratio is increasing because inventory is increasing, is that an advantage or disadvantage? If the ratios indicate any problem areas or good financial management, provide your observations and comments.

Conclusion and Recommendations - Based on your analysis, state and explain why Stripe should or should not: (1) grant short-term credit to Wendel (2) grant long-term credit to Wendel, and/or (3) consider purchasing shares in Wendel TIP: If you had to pick just one option, which one would it be? Make sure that is clear to the audience.

Appendix (Ratios Page) Provide a well-organized set of ratio values calculated based on the financial statements (Appendix A) and related information (Appendix B).

Appendix A
Wendel Enterprises Ltd
Income statement
2023 2022 2021
Sales (all on credit) 3,210,200 3,682,600 3,085,400
Cost of goods sold 2,517,900 2,794.80 2,349,600
Gross profit 692,400 887,800 735,800
Selling and administration expenses 531,300 513,700 588,400
Amortization 28,000 28,800 32,000
EBIT 133,100 345,300 115,500
Interest Expenses 130,200 101,100 100,200
Earning before taxes 2,900 244,200 15,200
Taxes 700 54,200 4,400
Earning after tax $2,200 $190,000 $10,800
Dividends declared $140,000 $130,000 $120,000
Balance Sheet at December 31
2023 2022 2021
Assets
Cash $29,800 49,400 23,000
Marketable securities 14,000 14,000 14,000
Account receivable 821,600 723,600 594,600
Inventory 513,200 660,000 579,800
Prepaid Expenses 10,400 1,600 11,000
Total Current Assests 1,389,000 1,448,600 1,222,400
New plant and equipment 324,000 345,800 368,600
Goodwill 50,800 56,400 61,200
Total Assets 1,763,800 $1,850,800 $1,652,200
Liabiity and Shareholders Equity
Account payable $291,800 $393,400 $419,400
Bank Loan 506,800 402,800 388,000
Accrued Expenses 7,400 47,400 28,800
Total Current Liabilities 806,000 843,600 786,200
Long-term debt 451,600 363,200 282,000
Total Liabilities 1,257,600 1,206,800 1,068,200
Common Stock 28,000 28,000 28,000
Retained Earnings 478,200 616,000 556,000
Total Sharholders Equity 506,200 644,000 584,000
Total Liabilities and shareholders equity $1,763,800 $1,850,800 $1,652,200
Industry Norms
Appendix B
Profitabilty ratios: Construction industry
Current ratio 1.60
Quick ratio 1.10
Profit Margin 580.00%
Return on assets 8.10%
Return on equity 20.30%
Assets Utilization:
Receivables turnover 6.30
Average collection period 58.30
Inventory turnover 4.3
Capital assest turnover 8.00
Total asset turnover 1.70
Debt Uitlization:
Debt to total assets 60%
Times interest earned 4.30

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Accounting for Governmental and Not-for-Profit Organizations

Authors: Paul A. Copley

10th Edition

007352705X, 978-0073527055

More Books

Students also viewed these Accounting questions

Question

=+c. Did economic well-being rise more in 2009 or 2010? Explain.

Answered: 1 week ago