.

Sunday, January 27, 2019

Financial Ratios for East Coast Yachts

Question 1 Financial balances for tocopherol playground slide Yachts authorized proportion = original Assets Debt- fair play balance = count liabilities Current Liabilities add up right = $14,651,000 = $19,539,000 + $33,735,000 $19,539,000 $55,341,000 = 0. 75 = 0. 96 Quick dimension = Current Assets scrutinise loveliness multiplier factor = summation summations Current Liabilities be rightfulness = $14,651,000 $6,136,000 = $108,615,000 $19,539,000 $55,341,000 = 0. 44 = 1. 96 hail asset derangement = sales invade reporting = EBIT Total Assets sideline = $167,310,000 = $23,946,000 $108,615,000 $3,009,000 = 1. 54 = 7. 96 blood disturbance = COGS winnings tolerance = Net Income bourgeon-taking sales = $117,910,000 = $12,562,200 $6,136,000 $167,310,000 = 19. 22 = 7. 51% Receivables overthrow = Sales retort on assets = Net Income Accounts receivable Total assets = $167,310,000 = $12,562,200 $5,473,000 $108,615,000 = 30. 57 = 11. 57% Debt ratio = Total assets Total right Return on equity = Net Income Total assets Total equity = $108,615,000 $55,341,000 = $12,562,200 $108,615,000 $55,341,000 = 0. 49 = 22. 70% Question 2 eastern hemisphere sloping trough Yachts Yacht Industry Ratios scorn Quartile Median Upper Quartile Current ratio 0. 75 0. 50 1. 43 1. 9 Quick ratio 0. 44 0. 21 0. 38 0. 62 Total asset turnover 1. 54 0. 68 0. 85 1. 38 Inventory turnover 19. 22 4. 89 6. 15 10. 89 Receivables turnover 30. 57 6. 27 9. 82 14. 11 Debt ratio 0. 49 0. 44 0. 52 0. 61 Debt-equity ratio 0. 96 0. 79 1. 08 1. 56 Equity multiplier 1. 96 1. 79 2. 08 2. 56 Interest coverage 7. 96 5. 18 8. 06 9. 83 advance strand 7. 51% 4. 05% 6. 98% 9. 87% Return on assets 11. 57% 6. 05% 10. 53% 13. 21% Return on equity 22. 70% 9. 93% 16. 54% 26. 15%The liquidity ratio shows that the company has less liquidity as comp ar to the whole attention. easterly Coast Yachts current ratio is infra the median industry ratio and the quick ratio is positioned at the median industry ratio. This indicates that the company may access to short-term borrowing. Referring to the turnover ratio, all the three ratios, I. e. numerate asset turnover, inventory turnover and receivables turnover are high than upper quartile industry ratio. This indicates that the company is more efficient among the whole industry in employ its assets to generate sales.The financial leverage ratios, which include the debt ratio, debt-equity ratio, equity multiplier and chase coverage, are all below the median industry ratio, just higher than the lower quartile. This shows that East Coast Yachts is having less debt than the other companies in the industry, but is still within the normal range. The meshwork margin, return on assets as puff up as return on equity of the company are higher than the industry median. This shows that the companys dineroability is performing well among the whole industry.As an overall, East Coast Yachts is performing well in the industry, fleck more concentration would only be needful to be fixed on the liquidity ratios. Question 3 Return on equity = 22. 70% keeping ratio (b) = Net income Dividends Net Income = $12,562,200 $7,537,320 $12,562,200 = 40% sustainable branch rate (SGR) = Return on equity x belongings ratio = 22. 70% x 0. 4 = 9. 08% Increase in assets = Assets x ? Sales Sales = $108,615,000 x (167,310,000 x 9. 08%) $167,310,000 = $9,862,242. 00 Increase in self-generated liabilities = go forthing liabilities x ? Sales Sales = $6,461,000 x (167,310,000 x 9. 08%) $167,310,000 = $ 586,658. 80 Retention ratio (b) = Addition to RE Net income = $5,024,880 $12,562,200 = 40% professional personfit margin = Net income Sales = $12,562,200 $167,310,000 = 8% Increase in equity = PM x professionaljected sales x retention ratio = 8% x ($167,310,000 x 1. 0908) x 0. 4 = $5,840,055. 94 external Funds unavoidable (EFN) = Increase in assets Increase in instinctive liabilities Increase in equity = $9,862,242. 00 $586,658 $5,840,056 = $3,435,527. 26 East Coast Yachts Pro forma Income Statement Sales 182,501,748 appeal of goods sold 128,616,228 Other expenses 21,809,455 Depreciation 5,460,000 (Assume constant) stipend before affaire and taxes (EBIT) 26,616,065 Interest 3,009,000 (Assume constant)Taxable income 23,607,065 Taxes (40%) 9,442,826 Net Income 14,164,239 Dividends 8,221,709 Addition to RE 5,481,139 East Coast Yachts Pro forma Balance Sheet Assets Current assets currency 3,318,214 Accounts receivable 5,969,948 Inventory 6,693,149 T otal 15,981,311 Fixed assets Net plant and equipment 102,495,931 Total assets 118,477,242 Liabilities Current liabilities Accounts due 7,047,659 Notes payable 14,265,482 Total 21,313,141 Long term debt 33,735,000 Shareholders equity Common stock 5,200,000 maintained earnings 54,693,803 Total equity 59,893,803 Total liabilities and equity 114,941,944 EFN 3,535,298 Current ratio = Current Assets Debt-equity ratio = Total liabilities Current Liabilities Total equity = $15,981,311 = $21,313,141 + $33,735,000 $21,313,141 59,893,803 = 0. 75 = 0. 92 Quick ratio = Current Assets Inventory Equity multiplier = Total assets Current Liabilities Total equity = $15,981,311 $6,693,149 = $118,477,242 $21,313,141 $59,893,803 = 0. 44 = 1. 98 Total asset turnover = Sales Interest coverage = EBIT Total Assets Interest = $182,501,748 = $2 6,616,065 $118,477,242 $3,009,000 = 1. 54 = 8. 85 Inventory turnover = COGS hit margin = Net Income Inventory Sales = $128,616,228 = $14,164,239 $6,693,149 $182,501,748 = 19. 22 = 7. 76% Receivables turnover = Sales Return on assets = Net Income Accounts receivable Total assets = $182,501,748 = $14,164,239 $5,969,948 $118,477,242 = 30. 57 = 11. 96% Debt ratio = Total assets Total equity Return on equity = Net Income Total assets Total equity = $118,477,242 $59,893,803 = $14,164,239 $118,477,242 $59,893,803 = 0. 49 = 23. 5% East Coast Yachts Original ratios Based on pro forma Current ratio 0. 75 0. 75 Quick ratio 0. 44 0. 44 Total asset turnover 1. 54 1. 54 Inventory turnover 19. 22 19. 22 Receivables turnover 30. 57 30. 57 Debt ratio 0. 49 0. 49 Debt-equity ratio 0. 96 0. 92 Equity multiplier 1. 96 1. 98 Interest coverage 7. 96 8. 85 Profit marg in 7. 51% 7. 76% Return on assets 11. 57% 11. 96% Return on equity 22. 70% 23. 65% As mention from above, the liquidity and turnover ratio will remain constant presume ontogeny precisely at 9. 8%. Debt-equity ratio will change magnitude slightly while equity multiplier and interest coverage increased, presumptuous interest remain constant. Slight improvement also noted from profit margin, return on assets and return on equity. Question 4 harvest-tide rate 20% Increase in assets = Assets x ? Sales Sales = $108,615,000 x (167,310,000 x 20%) $167,310,000 = 21,723,000. 00 Increase in spontaneous liabilities = Spontaneous liabilities x ? Sales Sales = $6,461,000 x (167,310,000 x 20%) $167,310,000 = $1,292,200. 00 Retention ratio (b) = Addition to RE Net income = $5,024,880 $12,562,200 = 40% Profit margin = Net income Sales = $12,562,200 $167,310,000 = 8% Increase in equity = PM x Proje cted sales x retention ratio = 8% x ($167,310,000 x 1. 2) x 0. 4 = $6,424,704. 00 External Funds Needed (EFN) = Increase in assets Increase in spontaneous liabilities Increase in equity = $21,723,000. 0 $1,292,200. 00 $6,424,704. 00 = $14,006,096. 00 East Coast Yachts Pro forma Income Statement Sales 200,772,000 Cost of goods sold 141,492,000 Other expenses 23,992,800 Depreciation 5,460,000 (Assuming constant) Earnings before interest and taxes (EBIT) 29,827,200 Interest 3,009,000 (Assuming constant) Taxable income 26,818,200 Taxes (40%) 10,727,280 Net Income 16,090,920 Dividends 9,044,784 Addition to RE 6,029,856 East Coast Yachts Pro forma Balance Sheet Assets Current assets Cash 3,650,400 Accounts receivable 6,567,600 Inventory 7,363,200 Total 17,581,200 Fixed assets Net plant and equipment 112,756,800 Total assets 130,338,000 Liabilities Current liabilities Accounts payable 7,753,200 Notes payable 15,693,600 Total 23,446,800 Long term debt 33,735,000 Shareholders equity Common stock 5,200,000 Retained earnings 60,169,200 Total equity 65,369,200 Total liabilities and equity 122,551,000 EFN 7,787,000 East Coast Yachts Original ratios Growth 9. 08% Growth 20% Debt-equity ratio 0. 96 0. 92 0. 87 Equity multiplier 1. 96 1. 98 1. 99 Interest coverage 7. 96 8. 85 9. 91 Profit margin 7. 51% 7. 76% 8. 01% Return on assets 11. 57% 11. 96% 12. 35% Return on equity 22. 70% 23. 65% 24. 62% The growth rate of 20% indicates that the EFN is $7,787,000.Debt-equity ratio will decrease by 0. 05. The profit margin, return on assets and return on equity shows improvement if the involution plan was taken up, assuming interest and depreciation remain constant. The get on expansion may be taken up as it will bring improvement to the companys profitability. Also, debt-equity ratio is still below 1 hence there is room for the expansion to be taken up. Question 5 Depreciation rate = Depreciation PPE = $5,460,000 $93,964,000 = 5. 81% Cost of new line 30,000,000 New depreciation charged 1,743,220. 81 East Coast Yachts Pro forma Income Statement Sales 200,772,000 (Assuming growth rate 20%) Cost of goods sold 141,492,000 (Assuming growth rate 20%) Other expenses 23,992,800 (Assuming growth rate 20%) Depreciation 1,743,221 Earnings before interest and taxes (EBIT) 33,543,979 Interest 3,009,000 (Assuming constant) Taxable income 30,534,979 Taxes (40%) 12,213,992 Net Income 18,320,988 Dividends 9,044,784 Addition to RE 6,029,856 East Coast Yachts Pro forma Balance Sheet Assets Current assets Cash 3,650,400 Accounts receivable 6,567,600 Inventory 7,363,200 Total 17,581,200 Fixed assets Net plant and equipment 141,013,579 Total assets 158,594,779 Liabilitie s Current liabilities Accounts payable 7,753,200 Notes payable 15,693,600 Total 23,446,800 Long term debt 33,735,000 Shareholders equity Common stock 5,200,000 Retained earnings 60,169,200 Total equity 65,369,200 Total liabilities and equity 122,551,000 New EFN 36,043,779 exist EFN 7,787,000 Additional EFN 28,256,779 Depreciation charged from increase in fixed assets at SGR of 20% was $1,743,220. 81. The new plant would cost $30,000,000. The additional EFN would be $28,256,779. The total EFN would become $36,043,779. This would imply that the capacity utilization would be lower succeeding(a) year, since the new plant would expand capacity much more than the required under SGR.

No comments:

Post a Comment