Below are the Balance Sheet then the Income statement for Top Motor Corporation
Instructions:
Compute ratios for 2 years for your company.
- You are not responsible for the following:
- working capital,
- debt service coverage ratio,
- cash-to-cash-operating cycle,
- debt service coverage ratio,
- cash flow from operations to capital expenditures ratio, and
- return on sales ratio.
- Compute the return on asset ratio as Net Income / Average total assets
- You do not need to compute Earnings per share, use earnings per share on the income statement of your company. If there are two earnings per share numbers posted, use the one marked diluted.
- For the price/earnings ratio, use the market price of the stock at the date of the financial statements.
Note that you will probably have to obtain an earlier annual report to find the beginning of the year balance sheet data needed for the averages for the earlier year's ratios.
It is probably best to show computations for the ratios in chart in the appendix and refer back to them in the text or include a table with the information pertinent to the discussion in that section.
In the solvency section of the project, you might have charts in each section that look like:
| | Current Year | Prior Year | Comparison |
| Debt-to-equity ratio | 1.0 | 1.2 | 1.3 |
| Times interest earned ratio | | | |
Your analysis can refer to the numbers in the tables. (More about the comparison next week).
For the Appendix, please include the name of the ratio, how it is calculated in words (per Exhibit 13-3), and show how you fit the numbers in the equations to get to the result. For example:
| Ratio | Computation | Current year | Prior year |
| Debt-to-equity | Total Liabilities/ Total shareholder equity | 100,000/100,000 = 1.0 | 144,000/120,000 = 1.2 |
Breakdown 3/31/2021 3/31/2020 3/31/2019 3/31/2018 62,267,140,000 52,680,436,000 51,936,949,000 50,308,249,000 37,978,811.000 31,942,754,000 31,869,812,000 30,878,147,000 24,288,329,000 20,737,682,000 20,067,137,000 19,430,102,000 36,538,351,000 30,753,516,000 29,899,097,000 28,742,356,000 23,404,547,000 20,060,618,000 19,348,152.000 18,735,982,000 > Total Assets > Total Liabilities Net Minority Int... > Total Equity Gross Minority Inte... Total Capitalization Common Stock Equity Capital Lease Obligations Net Tangible Assets Working Capital Invested Capital Tangible Book Value Total Debt 360,891,000 22,295,913,000 20.060,618,000 19,348,152.000 18,735,982.000 1,316,334.000 740,154,000 652,299,000 355,765,000 48,703,290,000 40,613,587.000 39,498,331,000 38,083,546,000 22,295,913,000 20,060,618,000 19,348,152.000 18,735,982.000 25,659,634,000 20,552,969,000 20,150,179.000 19,347,564,000 Net Debt 20,197,886,000 16,362,451,000 16,575,475,000 16,295,295,000 3,262,997 3,262,997 3,262,997 3,262,997 Share Issued Ordinary Shares Number 2,795.949 2,766,153 2,832,439 2,909,924 Treasury Shares Number 467,049 496,845 430,558 353,074 Breakdown 3/31/2021 3/31/2020 3/31/2019 3/31/2018 > Total Revenue 27.214,593,000 29.929.992.000 30,225,681,000 29,379,510,000 Cost of Revenue 22,382.220,000 24,522,364,000 24,781,785,000 23,889,153,000 4,832,373.000 5,407,628,000 5,443,896,000 5,490,357,000 2,634.625.000 2,964,759,000 2.976,351.000 3,090,495,000 2,197.748.000 2,442,869,000 2,467,545,000 2,399.862.000 298,854,000 200.653,000 197.417.000 151,955,000 435,751,000 -88,915,000 -379,497.000 68,612,000 2.932.354.000 2,554,607,000 2,285,465,000 2,620,429.000 Gross Profit > Operating Expense Operating Income > Net Non Operating interest Inc. > Other Income Expense Pretax Income Tax Provision Earnings from Equity Interest Net... > Net Income Common Stockhold. Average Dilution Earnings Diluted Ni Available to Com Stockh... Basic EPS Diluted EPS 649,976,000 683.430,000 659.944.000 504,406,000 271.152.000 360.066.000 470,083,000 2,257.830,000 2,058.899,000 1,868,085,000 2,481,692.000 12,569.000 17.284.000 14,788,000 12,287.000 2.257.830,000 2,076,183,000 1,882.873,000 2,493.979.000 1.47k 130k 1.68% 1.46k 1.29 1.67K Basic Average Shares 1,399,459 1,435,767 1.473,683 1,423,009 1,459,337 1.497,383 2,197,748,000 2,442,869,000 2,467,545,000 2,399.862.000 25,016,845,000 27,487.123.000 27,758,136.000 26,979,648,000 Diluted Average Shares Total Operating Income as Reported Total Expenses Net Income from Continuing & Dis... Normalized Income Interest Income Interest Expense 2,245.261,000 2,076,183,000 1,882,873,000 2,493.983.000 2,164.365.338 2,152,032,840 2,116,545,994 2.475.670.488 105,600,000 232,870,000 225.495.000 179,541,000 42,421,000 32.217.000 28,078,000 27.586.000 Net Interest Income 298,854,000 200,653,000 197,417,000 151,955,000 EBIT 2,974,775.000 2,586,824,000 2,313,543,000 2,648,015.000 EBITDA Reconciled Cost of Revenue 22,382.220,000 24,522,364.000 24,781.785,000 23,889,153,000 1,644.290.000 1,605,383,000 1,792.375,000 1,734.033.000 2.245.261,000 2,076,183,000 1,882.873,000 2,493.983.000 103,979,000 -103,620,000 -328,654,000 22,664,000 Reconciled Depreciation Net Income from Continuing Oper... Total Unusual Items Excluding Go... Total Unusual Items Normalized EBITDA Tax Rate for Calcs Tax Effect of Unusual Items 103,979,000 -103,620,000 -328,654,000 22.664,000 4.515.086.000 4,295,827,000 4,434,572,000 4,359,384.000 0 0 0 0 23.083,338 -27,770,160 -94.981,006 4.351.488 Breakdown 3/31/2021 3/31/2020 3/31/2019 3/31/2018 62,267,140,000 52,680,436,000 51,936,949,000 50,308,249,000 37,978,811.000 31,942,754,000 31,869,812,000 30,878,147,000 24,288,329,000 20,737,682,000 20,067,137,000 19,430,102,000 36,538,351,000 30,753,516,000 29,899,097,000 28,742,356,000 23,404,547,000 20,060,618,000 19,348,152.000 18,735,982,000 > Total Assets > Total Liabilities Net Minority Int... > Total Equity Gross Minority Inte... Total Capitalization Common Stock Equity Capital Lease Obligations Net Tangible Assets Working Capital Invested Capital Tangible Book Value Total Debt 360,891,000 22,295,913,000 20.060,618,000 19,348,152.000 18,735,982.000 1,316,334.000 740,154,000 652,299,000 355,765,000 48,703,290,000 40,613,587.000 39,498,331,000 38,083,546,000 22,295,913,000 20,060,618,000 19,348,152.000 18,735,982.000 25,659,634,000 20,552,969,000 20,150,179.000 19,347,564,000 Net Debt 20,197,886,000 16,362,451,000 16,575,475,000 16,295,295,000 3,262,997 3,262,997 3,262,997 3,262,997 Share Issued Ordinary Shares Number 2,795.949 2,766,153 2,832,439 2,909,924 Treasury Shares Number 467,049 496,845 430,558 353,074 Breakdown 3/31/2021 3/31/2020 3/31/2019 3/31/2018 > Total Revenue 27.214,593,000 29.929.992.000 30,225,681,000 29,379,510,000 Cost of Revenue 22,382.220,000 24,522,364,000 24,781,785,000 23,889,153,000 4,832,373.000 5,407,628,000 5,443,896,000 5,490,357,000 2,634.625.000 2,964,759,000 2.976,351.000 3,090,495,000 2,197.748.000 2,442,869,000 2,467,545,000 2,399.862.000 298,854,000 200.653,000 197.417.000 151,955,000 435,751,000 -88,915,000 -379,497.000 68,612,000 2.932.354.000 2,554,607,000 2,285,465,000 2,620,429.000 Gross Profit > Operating Expense Operating Income > Net Non Operating interest Inc. > Other Income Expense Pretax Income Tax Provision Earnings from Equity Interest Net... > Net Income Common Stockhold. Average Dilution Earnings Diluted Ni Available to Com Stockh... Basic EPS Diluted EPS 649,976,000 683.430,000 659.944.000 504,406,000 271.152.000 360.066.000 470,083,000 2,257.830,000 2,058.899,000 1,868,085,000 2,481,692.000 12,569.000 17.284.000 14,788,000 12,287.000 2.257.830,000 2,076,183,000 1,882.873,000 2,493.979.000 1.47k 130k 1.68% 1.46k 1.29 1.67K Basic Average Shares 1,399,459 1,435,767 1.473,683 1,423,009 1,459,337 1.497,383 2,197,748,000 2,442,869,000 2,467,545,000 2,399.862.000 25,016,845,000 27,487.123.000 27,758,136.000 26,979,648,000 Diluted Average Shares Total Operating Income as Reported Total Expenses Net Income from Continuing & Dis... Normalized Income Interest Income Interest Expense 2,245.261,000 2,076,183,000 1,882,873,000 2,493.983.000 2,164.365.338 2,152,032,840 2,116,545,994 2.475.670.488 105,600,000 232,870,000 225.495.000 179,541,000 42,421,000 32.217.000 28,078,000 27.586.000 Net Interest Income 298,854,000 200,653,000 197,417,000 151,955,000 EBIT 2,974,775.000 2,586,824,000 2,313,543,000 2,648,015.000 EBITDA Reconciled Cost of Revenue 22,382.220,000 24,522,364.000 24,781.785,000 23,889,153,000 1,644.290.000 1,605,383,000 1,792.375,000 1,734.033.000 2.245.261,000 2,076,183,000 1,882.873,000 2,493.983.000 103,979,000 -103,620,000 -328,654,000 22,664,000 Reconciled Depreciation Net Income from Continuing Oper... Total Unusual Items Excluding Go... Total Unusual Items Normalized EBITDA Tax Rate for Calcs Tax Effect of Unusual Items 103,979,000 -103,620,000 -328,654,000 22.664,000 4.515.086.000 4,295,827,000 4,434,572,000 4,359,384.000 0 0 0 0 23.083,338 -27,770,160 -94.981,006 4.351.488
