61705 – UWI Roytec – Associate Degree in ManagementFinancial

SOLUTION AT Australian Expert Writers

UWI Roytec – in FINC 0202Comprehensive Individual Case Analysis (50%)Due Date: November 27th / 28th, 2020 (Week 12)Answer ALL questions. Show all workings clearly.CASE ANALYSIS – UNITED CORPORATION LIMITED 140 MARKSThe following comprehensive is based on a continuing case study of United Corporation Limited. The following financial statements have been provided:United Corporation LimitedIncome StatementFor the years ended December 31, 2018 & 20192018 (‘000s) 2019 (‘000s)Sales 750,000 937,500Cost of Sales (250,000) (255,500)Selling & Marketing Costs (125,000) (130,000)Admin. Expenses (45,000) (47,500)Depreciation Expense (15,000) (17,500)Earnings before Interest & Taxes 315,000 487,000Interest Expense (2,500) (2,500)Taxable Income 312,500 484,500Taxation (35%) (109,375) (169,575)Net Income 203,125 314,925Dividends (40%) 81,250 125,970Addition to Retained Earnings 121,875 188,955Additional Information:Ordinary Share Price 17.50 22.75Ordinary Shares Outstanding (‘000s) 100,000 120,000United Corporation LimitedStatement of Financial PositionAs at December 31, 2018 & 20192018 (‘000s) 2019 (‘000s) 2018 (‘000s) 2019 (‘000s)ASSETS LIABILITIES & EQUITYCurrent Assets Current LiabilitiesInventories 220,000 230,000 Accounts Payables 115,000 95,000Accounts Receivables 245,000 275,000 Notes Payables 125,750 110,545Cash & Equivalents 175,750 225,000 240,750 205,545640,750 730,000Non-current Liabilites 100,000 75,000Non Current Assets, Net 525,500 575,000Total Liabilities 340,750 280,545EquityCommon Stock 220,000 230,000Retained Earnings 605,500 794,455Total Equity 825,500 1,024,455TOTAL ASSETS 1,166,250 1,305,000TOTAL LIAB. & EQUITY 1,166,250 1,305,000Question 1 25 MarksAs part of your analysis, you are required to investigate United Corp.’s cash flows and selected ratios.Required: Using the financial statements provided on page 1:(a) Compute the following ratios for United Corp. for 2018 and 2019:i. Return on Equity using Du Pont Identity (6 Marks)ii. Earnings Per Share (EPS) (2 Marks)iii. Price/Earning (P/E) Ratio (2 Marks)iv. Book Value Per Share (3 Marks)v. Market-to-Book Ratio(b) Calculate the following for 2019: (2 Marks)i. Operating Cash Flow (1 Mark)ii. Net Capital Spending (1 Mark)iii. Change in Net Working Capital (2 Marks)iv. Cash Flow from Assets (2 Marks)v. Cash Flow to Creditors (2 Marks)vi. Cash Flow to Stockholders(2 Marks)Question 2 20 MarksUtilize the 2019 financial statements for United Corporation Limited provided on page 1 and assume that the company is operating below capacity, at 85%.Required: Prepare Pro-Forma statements for 2020 (rounding all figures to the nearest dollar) assuming:? All costs/income/expenses and net working capital vary directly with sales/revenue.? No new equity is raised.? Sales are projected to increase by 12%? The tax rate and the dividend payout ratio will remain constant.? Interest Expense and Depreciation Expense will remain unchanged.Clearly state if United Corp. will require external financing or would have excess financing in2020, and how much. (20 Marks)Question 3 20 Marks(a) United Corp. is considering issuing a $15,000,000 10-year bond in early 2021, with an annual coupon rate of 8%, and quarterly interest payments.Required:If the company anticipates that the yield to maturity on the date of issue is expected to be 10%,given the company’s credit ratings and current market conditions, how much would an investor bewilling to pay for $1,000 face value of this bond? (7 Marks)(b) United Corp. is also considering a Class B issue of its common stock on the market via an Initial Public Offering (IPO) in early 2021. The company is expected to pay the following dividends over the next 4 years: $1.50, $2.00, $3.00, $3.50. Thereafter, the company is expected to increase dividends by an annual rate of 5%.Required: Assuming investors would require a return of 13% on this riskier type of investment, how much would an investor pay for this share ? (10 Marks)(c) United Corp. is also assiduously finalising the issuance of its preference shares. The company plans to pay an annual dividend of $5.00 on each preferred share and anticipates investors required return to be around 10%.Required: Compute the price at United Corp. should issue these preferred shares.(3 Marks)Question 4 20 MarksHaving successfully issued their preference shares, United Corp. is seeking to determine its Weighted Average Cost of Capital, so that it can be used as the company’s required return in evaluating upcoming capital projects.Utilising information from United Corp.’s financial statements, presented on page 1, together with current information, the company has the following capital structure:Debt:Bonds outstanding has a face value of $75,000,000, currently selling at 110% of par. The coupon rate on these bonds is 8% and there is 15 years left to maturity. (Hint: you can use the lowest multiple of $1,000 for the YTM calculation only)Common stock:120,000,000 shares of common stock outstanding with a market price of $20.00.Preferred stock: 10,000,000 shares of preferred shares outstanding with a market price of $52.63. The annual dividend is $5.00.Additional Information:? The Company’s tax rate is 35%.? The current risk free rate is 3.50%; market return is 10%. ? The Company’s beta is 1.40.Required: Calculate the Weighted Average Cost of Capital for United Corporation Limited.(20 Marks)Question 5 25 MarksBased on the Weighted Average Cost of Capital calculated in question 4, United Corp. decides to use a rounded minimum required return of 12%; which it has decided to use for the following capital budgeting evaluation scenario:The company is considering whether to purchase the Basic or Premium version of the AR5 , a key piece of equipment that is expected to improve efficiency of daily operations.You have been tasked with evaluating the quantitative aspects of the projects, which are mutually exclusive. The projected cash flows of both projects are as follows:Years ProjectBasic AR5 Premium AR50 (5,000,000) (7,500,000)1 1,000,000 2,500,0002 1,500,000 2,500,0003 2,000,000 2,500,0004 2,250,000 2,500,000As noted above, the company has a required rate of return of 12%. The following PV factors are provided:Year PV Factor (12%)1 0.89292 0.79723 0.71184 0.6355Required:(a) Evaluate the projects using each of the following criteria, stating which project(s) United Corp.should under each criteria and why:i. Payback (4 Marks) ii. Discounted Payback (8 Marks) iii. Net Present Value (4 Marks) iv. Profitability Index (3 Marks)(b) Compute the Internal Rate of Return (IRR) for the Premium AR5 machine only, given that it falls between 12% and 13%. The PV Factors for 13% are provided below: (6 Marks)Year PV Factor (13%)1 0.88502 0.78313 0.69314 0.6133Question 6 30 MarksIn addition to the projects evaluated above, United Corp. is considering several other savings and financing options in an effort to expand operations and improve overall efficiency of operations, while fully investing idle cash.(a) Based on Statement of Financial Position as at December 31, 2019, the Company had $225,000,000 is Cash & Equivalents. Of this, $5,000,000 was in a fixed deposit that is due to mature on December 15, 2020. The company is considering the following investment options for these funds:Investment A Annual Interest Rate of 6.5%, compounded semi-annuallyInvestment B Annual Interest Rate of 6.25%, compounded monthlyInvestment C Annual Interest Rate of 6.55%, compounded annuallyRequired:i. Advise the company on the best investment option for the maturing funds. (Hint: EAR)(6 Marks)ii. Based on your choice from part (i), if United Corp. invests the lump sum on $5,000,000 on December 16, 2020 and leaves it in the account for 2 years, what will be the value of theinvestment on December 15, 2022? (4 Marks)(b) The company is considering purchasing a new delivery truck for $2,000,000. The intention is to obtain a 5-year loan from their bank, at an interest rate of 9% per annum. Annual payments are expected to be made on the loan.Required:i. Calculate United Corp.’s annual payment on this loan. (5 Marks)ii. Prepare the 5-year Amortization Schedule for this loan, clearly showing the interest and principal payment annually. (5 Marks)(c) As part of being a responsible corporate citizen, United Corp. wants to establish a college fund to assist under-privileged students in pursuing their 4-year under-graduate degree programmes. The tuition fee is estimated to be $75,000 for the first year but is expected to grow/increase by 4% per year thereafter.Required:i. Assuming this college fund will earn 8% interest per annum, calculate the amount required at the start of a student’s college journey to fund his/her full tuition. (5 Marks)ii. If United would like to sponsor the first student in two years’ time and they currently have $225,000 earmarked for investment, what annual rate of interest is required to accumulatethe amount needed as calculated in part (i)? (5 Marks)

Order from Australian Expert Writers
Best Australian Academic Writers