The following are extracts of the Income Statement and Balance Sheet of Universal Ltd. Non-current Asset...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following are extracts of the Income Statement and Balance Sheet of Universal Ltd. Non-current Asset Vehicle Furniture Current Assets Inventory Receivable Balance at Bank Cash In hand Total current asset Current Liabilities Shareholders' equity Retained Profit General reserve Sales Cost of Sales Net Profit Investors Ratios: Dividend Per Share Number of Shares Issued Average share price Ratios Gross Profit Margin Net Profit Margin Receivable Collection Period Earning Per Share Dividend Yield PE ratio a. i. Gross Profit Margin ii. Net Profit Margin iii. Current Ratio iv. Quick Ratio 2021 (£000) V. Receivables Collection Period vi. Earnings Per Share 20.00 8.00 28.00 vii. Price Earning Ratio viii. Dividend Yield 4.90 8.80 13.90 2.60 30.20 16.70 41.50 20.00 16.00 5.50 41.50 30.00 8.00 16.00 12 Pence 20,000 units £2.50 The following ratios indicate the benchmark performance of the industry average for the year 2021: 2022 (£000) Measures 50 percent 45 percent 30 days 50 pence 3.2 percent 6.5 times 18.00 5.00 23.00 13.70 11.60 11.50 4.20 41.00 30.80 33.20 20.00 12.50 0.70 33.20 40.00 9.00 18.50 You are required to calculate and show your workings on the following ratios for both years: 18 Pence 20,000 units £3.30 (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (Total: 24 Marks) The following ratios indicate the benchmark performance of the industry average for the year 2021: Ratios Gross Profit Margin Net Profit Margin Receivable Collection Period Earning Per Share Dividend Yield PE ratio a. You are required to calculate and show your workings on the following ratios for both years: i. ii. iii. iv. V. vi. Gross Profit Margin Net Profit Margin i. ii. iii. iv. V. Current Ratio Quick Ratio vii. viii. Dividend Yield Receivables Collection Period Earnings Per Share Price Earning Ratio b. Your management requires you to explain the following category. You are required to calculate the ratio and critically comment on it. Suggest improvements to the ratios for the organisation where possible. Profitability ratio Efficiency ratio i. ii. iii. Liquidity ratio Investor's Ratio The weakness of Ratio PART 2 (20%) Measures 50 percent 45 percent 30 days 50 pence 3.2 percent 6.5 times Year 0 1 2 3 4 5 The net operational cash flows of investment schemes of Cafe and a Disco as follows: Cafe (£000) Disco (£000) (82) (82) 20 30 30 40 40 50 (3 Marks) (3 Marks) (Total: 24 Marks) You are required to calculate, for both schemes, the: Accounting Rate of Return Payback period Weakness of the above investment appraisal method (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (Total: 26 Marks) 30 40 50 30 Given that the residual value for Cafe and Disci are £18,000 and £ 22,000 respectively while the required rate of return is 12%. (5 Marks) (5 Marks) (10 Marks) (Total: 20 Marks) The following are extracts of the Income Statement and Balance Sheet of Universal Ltd. Non-current Asset Vehicle Furniture Current Assets Inventory Receivable Balance at Bank Cash In hand Total current asset Current Liabilities Shareholders' equity Retained Profit General reserve Sales Cost of Sales Net Profit Investors Ratios: Dividend Per Share Number of Shares Issued Average share price Ratios Gross Profit Margin Net Profit Margin Receivable Collection Period Earning Per Share Dividend Yield PE ratio a. i. Gross Profit Margin ii. Net Profit Margin iii. Current Ratio iv. Quick Ratio 2021 (£000) V. Receivables Collection Period vi. Earnings Per Share 20.00 8.00 28.00 vii. Price Earning Ratio viii. Dividend Yield 4.90 8.80 13.90 2.60 30.20 16.70 41.50 20.00 16.00 5.50 41.50 30.00 8.00 16.00 12 Pence 20,000 units £2.50 The following ratios indicate the benchmark performance of the industry average for the year 2021: 2022 (£000) Measures 50 percent 45 percent 30 days 50 pence 3.2 percent 6.5 times 18.00 5.00 23.00 13.70 11.60 11.50 4.20 41.00 30.80 33.20 20.00 12.50 0.70 33.20 40.00 9.00 18.50 You are required to calculate and show your workings on the following ratios for both years: 18 Pence 20,000 units £3.30 (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (Total: 24 Marks) The following ratios indicate the benchmark performance of the industry average for the year 2021: Ratios Gross Profit Margin Net Profit Margin Receivable Collection Period Earning Per Share Dividend Yield PE ratio a. You are required to calculate and show your workings on the following ratios for both years: i. ii. iii. iv. V. vi. Gross Profit Margin Net Profit Margin i. ii. iii. iv. V. Current Ratio Quick Ratio vii. viii. Dividend Yield Receivables Collection Period Earnings Per Share Price Earning Ratio b. Your management requires you to explain the following category. You are required to calculate the ratio and critically comment on it. Suggest improvements to the ratios for the organisation where possible. Profitability ratio Efficiency ratio i. ii. iii. Liquidity ratio Investor's Ratio The weakness of Ratio PART 2 (20%) Measures 50 percent 45 percent 30 days 50 pence 3.2 percent 6.5 times Year 0 1 2 3 4 5 The net operational cash flows of investment schemes of Cafe and a Disco as follows: Cafe (£000) Disco (£000) (82) (82) 20 30 30 40 40 50 (3 Marks) (3 Marks) (Total: 24 Marks) You are required to calculate, for both schemes, the: Accounting Rate of Return Payback period Weakness of the above investment appraisal method (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (3 Marks) (Total: 26 Marks) 30 40 50 30 Given that the residual value for Cafe and Disci are £18,000 and £ 22,000 respectively while the required rate of return is 12%. (5 Marks) (5 Marks) (10 Marks) (Total: 20 Marks)
Expert Answer:
Answer rating: 100% (QA)
Sure Lets calculate the requested ratios and perform the investment appraisal calculations PART 1 Ratios 1 Gross Profit Margin Gross Profit Margin Sales Cost of Sales Sales For 2021 Gross Profit Margi... View the full answer
Related Book For
Financial Accounting
ISBN: 9780078110825
2nd Edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these finance questions
-
Income statement and balance sheet data for Virtual Gaming Systems are provided below. Required: 1. Calculate the following risk ratios for 2015 and 2016: a. Receivables turnover ratio. b. Inventory...
-
Income statement and balance sheet data for Great Adventures, Inc., are provided below. As you can tell from the financial statements, 2014 was an especially busy year. Tony and Suzie were able to...
-
The 2017 comparative income statement and balance sheet of Flowell Design Ltd. follow: Flowell Design Ltd. had no non-cash financing and investing transactions during 2017. During the year, there...
-
Solve each compound inequality. Graph the solution set, and write it using interval notation. -2x +1> -11 or x+1> 10
-
Was Norton entitled to support, based on promissory estoppel? Gail Norton sued Russell Hoyt, and this is what she alleged. The two met when Norton, who was single, worked as an elementary school...
-
Selected transactions for M. Acosta, an interior decorator, in her first month of business, are as follows. Jan. 2 Invested $10,000 cash in business. 3 Purchased used car for $3,000 cash for use in...
-
What are the different types of organizational forms that corporations use for international operations?
-
Below is a brief description of a design-&-build power plant project. The top (i.e. northern) half of the plant plot contains the evaporation pond and tanks for storage of fuel. The...
-
Requirements Devon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Devon Manufacturing's operations: (Click the icon to view the...
-
Tameka wants you to consider a hybrid aggregate plan, using up to the maximum overtime per employee for any period where demand cannot be satisfied with the current regular-time production and the...
-
Mr Michael Maguire lives in Wombat, in the central west of New South Wales. Michael owns a 3000 acre farm in Young, and the main crop he grows is cherries. He has decided he needs to acquire a better...
-
Concord Ltd. had the following 2023 income statement data: Sales revenue $207,500 Cost of goods sold 119,000 Gross profit 88,500 Operating expenses (includes depreciation of $22,900) 48,000 Income...
-
Inventory data for Mushroom Corporation for the year ended December 3 1 , 2 0 2 3 , are as follows: Beginning inventory 5 0 units at $ 1 5 0 each March 3 1 purchase 5 0 units at $ 1 5 5 each 1 st...
-
Suppose that the following simultaneous move game is played twice, with the final payoffs being the sum of the payoffs obtained in the two stages of the game: LCR T 10,105,15 0,0 M 15,5 7,7 0,0 B 0,0...
-
A student records the time (in minutes) that it takes to commute to school for six days. Assume that these six days can be considered a random draw from a normally distributed population. The average...
-
Condo located in Bronx acquired in 2015, cost $1,200,000, to Benjamin, Emma, and Olivia as equal tenants in common. $1,900,000 $1,900,000 Office building, located in Queens built in 2017, cost...
-
Calculate FCFs (to the Firm) for the years 2013 - 2017, assuming depreciation and investment cancel each other out. That is: depreciation=investment in WC + investment in CAPEX. You are the CFO of...
-
Show that the block upper triangular matrix A in Example 5 is invertible if and only if both A 11 and A 22 are invertible. Data from in Example 5 EXAMPLE 5 A matrix of the form A = [ A11 A12 0 A22 is...
-
Pacific Cruise Lines is a defendant in litigation involving a swimming accident on one of its three cruise ships. Required: For each of the following scenarios, determine the appropriate way to...
-
Laker Incorporated's fiscal year-end is December 31, 2012. The following is an adjusted trial balance as of December 31. Required: Prepare the necessary closing entries? Debit Credit Accounts Cash...
-
Refer to the transactions in E6-8. In E8 July 5 Purchases 20 laptop computers on account from Red River Supplies for $1,500 each, terms 3/10, n/30. July 8 Returns to Red River two laptops that had...
-
True or False: Inflation decreases the purchasing power of money.
-
Logan is conducting an economic evaluation under inflation using the then-current approach. If the inflation rate is \(j\) and the real time value of money rate is \(d\), which of the following is...
-
What is a good working definition of inflation in 10 words or less?
Study smarter with the SolutionInn App