Mini-Case 1 Notes: - This short project is strictly an individual work. - This mini-case is available at 8:00am on August 26th, 2020 and is due on 11:59pm on September 7th, 2020. - You are required to show your working for All questions. Providing the final answer accounts only for 30% of each question grade. - Please type (Do not hand write) both your workings and the final answers in the designated solution areas. - Please feel free to extend the size of the solution boxes provided as you feel the necessity to do so. - Once you are done, please save the document as a PDF and upload it back to the same position on blackboard that you used to download the case in the first place. Golden cup case study You were provided with the following balance sheet for Golden Cup firm for the year ended Dec 31", 2018 Assets Current Assets Cash Accounts Receivables Inventory Total Current Assets Consolidated Balance sheet Golden Cup. As of Dec 31", 2018 Liabilities + Owners Equity Current Liabilities 40,000 Accounts Payable 12,000 4,000 Notes Payable 6,000 14,000 Accrue Wages 1000 58,000 Total Current Liabilities 19,000 Long term debt 40,000 56,000 Fixed Assets Property, Plant, and Equipment Goodwill Total Fixed Assets 24,000 80,000 Owners' equity Common Shares Retained Earnings Total Owners equity Liabilities + O.E 40,000 39,000 79,000 138.000 Total Assets 138.000 In addition to that, you know the following facts about firm's operations throughout the year Golden Cup revenues for the year includes the following: Domestic revenues $160,000. International revenues $80,000. Out of Golden Cup's sales, cost of sales and direct labor is 50% of annual revenues. Because of the strong competition that it faces, Golden Cup has a generous marketing plan. Golden Cup signed a contract with the marketing planet Inc. by which the marketing agency will be responsible for Golden Cup marketing for five years period started this year. The contract costs Golden Cup $100,000 that were paid up front, however the company thinks this plan will affect its sales evenly over the five years period. Golden Cup also spends $30,000 in the form of general and administrative expenses per year. Golden Cup depreciable assets historical value is $40,000 and is depreciated on a straight line basis over 10 years. Golden Cup pays interest rate of 10% on its Long-term debt outstanding Out of the year's net income, Golden Cup is planning to repay $30,000 to its shareholders in the form of cash dividends. The company currently has 60,000 shares outstanding Question 1 a- Please set up income statement for Golden Cup: Consolidated Income Statement Golden Cup As of Dec 31, 2018 Show your workings here Revenues Cost of goods sold Gross margin Marketing expenses General and administrative expenses Depreciation EBIT Domestic + International= 160.000 + 80,000 = CGS = 50% of 2,400,000 = GM = Revenues - CGS = Accrual Concept - $100,000/5 years Given Value Final answer here $240,000 ($120,000) $120,000 ($20,000) ($30,000) (S4,000) $66,000 Interest expenses EBT Tax expenses Net income Dividends Additions to Retained Earnings = $40.000 / 10 years = GM-Marketing Expenses - General and Admin Expenses - Depreciation = = $40,000 * 10% = = EBIT - Interest Expenses = Tax Rate - 21%; = EBT *(0.21) = = EBT - Tax Expenses = Given Value = Net Income - Dividends (S4,000) $62,000 ($13,020) S48,980 $30,000 $18.980 Question 6 6- If you are given the following information about the year ended 2017 (previous year). Total assets = $120,000, Total Equity = $70,000, Sales = 150,000, Net income = $35,000 a- Calculate Golden Cup's profitability for year ended 2017. Solution: b- Calculate Golden Cup's profitability for year ended 2018. Solution: C-Based on your knowledge of determinants of corporate profitability (DuPont identity), did any significant change happen to Golden Cup's profitability? Did it increase or decrease? What is the underlying reason behind the change, if any? Solution: Question 7 7-Ms. Janet McInish is currently considering selling her stock ownership. She strongly believes that the share is overpriced and is going to experience a price drop soon. In order to better understand the current situation of Golden Cup stock, she was advised to use the price earnings ratio. Giving that the total market value of Ms. Janet Golden Cup's shares is $120,000. a- If Ms. Janet believes that any stock that has a P/E ratio that is more than 20% of the industry average to be overpriced, do you recommend Ms. Janet to sell her shares knowing that industry average P/E ratio is 10? Show your calculations as well as your recommendation. Solution: File Hom Inser Draw Desic Layoi Refer Mailir Revie View Help Acrot Design Layout Tell me a- Calculate Golden Cup's profitability for year ended 2017. Solution: Net Income = NI Total Assets = TA Total Equity = TE Profit Margin = NI / Sales = $35,000 / $150,000 = 0.2333 * 100% = 23.33% ROA=NI/TA = $35,000 / $120,000 = 0.29166 * 100% = 29.16% ROE = NI/TE = $35,000 / $70,000 = 0.5 * 100% 50% b- Calculate Golden Cup's profitability for year ended 2018. 1 Solution: POR Net Income = NI Total Assets = TA Total Equity = TE 2 Profit Margin = NI / Sales $48,980 / $240,000 = 0.204 * 100% 20.4% ROA=NI/TA = $48,980 / $138,000 = 0.3549 * 100% = 35.49% ROE=NI/TE = $48,980 / $79,000 = 0.62 * 100% -62% 184 tar C- Based on your knowledge of determinants of corporate profitability (DuPont identity), did any significant change happen to Golden Cup's profitability? Did it increase or decrease? What is the underlying reason behind the change, if any? Solution: 211 Page Bo 2122