Question: i need help due to my work schedule with this ratio analysis report. please help FINA5311 Term Project Summer II, 2019 (Due on Monday, August

i need help due to my work schedule with this ratio analysis report. please help

FINA5311 Term Project Summer II, 2019 (Due on Monday, August 12, by 11:59 pm. Students must upload the file on Bb9) Maximum points to be earned=100. For the project, students are required to obtain financial statement data, calculate ratios, and perform a ratio analysis for Honda Motor Co LTD and Toyota Motor Corp. The report should be typed (Times New Roman 12, double space), the tables should be filled using Times New Roman 10. The report should have the following parts A. A title page with the title, FINA5311, Summer II, 2019, Term Project and the student name below it. The title page should also include Honda Motor Co LTD Vs. Toyota Motor Corp.: A Comparative Ratio Analysis B. A short history for each one of the companies (about one page) in your own words. Plagiarizing will result in a zero grade for the project. C. The project should include an in-depth comparative ratio analysis through time and against the other company. The analysis should be based on the tables and graphs (at least 2-3 additional pages. When students analyze the ratios, they must explain to the reader the meaning of each ratio. They should analyze the trend of each ratio through time for each company and compare it to the trend of the other companys corresponding ratio. Include events in the history of a company that might explain why a ratio dropped or increased substantially and perform this justification for all ratios: best sources, 10-K forms, or Annual reports to shareholders. D. A summary of the two companies performance. E. The two tables and the ratio graphs. Students have the option to include the tables and graphs or portions of the tables within the analysis section of the text. F. References (at least 10)- APA style of citation The projects will be graded according to the following weighting scheme 40 percent ratio accuracy 40 percent in-depth ratio analysis 20 percent language and professional appearance of the document Steps for part C a) Using the data from WRDS, students must fill-in the two tables below. If there is no available data for the calculation of a ratio or the denominator of a ratio is zero, they should enter NA in the table for that companys ratio. If the EPSPI is negative in a year for either one of the companies again, students should enter NA for the corresponding PE ratio. There is no meaning to a negative PE ratio. Accuracy should be four decimals for percentages or 2 decimals for numbers (i.e., in percentage format 14.32%, 5.11%, 3.00%, in number format, for days, for example,15.10). Where appropriately, they should express the ratio as, times (2.30). The format of each ratio appears in the tables. They should create graphs in excel for all ratios for the two companies, i. e. for each ratio, there should be a single graph showing the ratios of the two companies for years 2013-2018. They should use consistently the same colors for the ratios of each company in each of the graphs. b) Based on the tables and graphs they should write an in-depth analysis (at least two to three pages - excluding tables, graphs, and references) that will compare the ratios for each company through time and against each other. Students must refer to significant events that affected the ratios and in what way. Formulas to be used for the ratio calculation o Quick ratio= (cash and short-term investments + receivables-total)/current liabilities-total o Cash Ratio= cash/current liabilities-total o Debt-to-equity ratio=liabilities-total/stockholders equity-parent o Days in receivables=365/ (revenue-total/receivables-total) o ROA=net income (loss)/assets-total o PM=net income (loss)/revenue-total o ROE=net income(loss)/stockholders equity-parent o PE ratio=price close-annual-fiscal/earnings per share (basic)-including extraordinary items= Very important: Exclude negative PE ratios, enter NA in such cases o Price-to-sales=price close-annual-fiscal / (revenue-total/(common shares outstanding*adjustment factor (company)-cumulative by ex-date)). Students must use the parentheses exactly as they are shown above. Table 1 Liquidity, financial leverage and asset utilization ratios for Honda Motor Co LTD (HMC) and Toyota Motor Corp. (TM) Fiscal Year HMC Quick Ratio (%) TM Quick Ratio (%) HMC Cash Ratio (%) TM Cash Ratio (%) HMC Debt to Equity Ratio (x) TM Debt to Equity Ratio (x) HMC Days in Receivables (days) TM Days in Receivables (days) HMC ROA (%) TM ROA (%) 2013 2014 2015 2016 2017 2018 Table 2 Profitability, and market value ratios for Honda Motor Co LTD (HMC) and Toyota Motor Corp. (TM) Fiscal Year HMC Profit Margin Ratio (%) TM Profit Margin Ratio (%) HMC ROE (%) TM ROE (%) HMC P/E Ratio (x) TM P/E Ratio (x) HMC Price-to-Sales ratio (x) TM Price-to-Sales ratio (x) 2013 2014 2015 2016 2017 2018

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!