Instruction
• ALL CALCULATIONS FOR THE PROJECT SHOULD BE DONE IN EXCEL AND ALL EXCEL OUTPUTS HAVE TO BE SUBMITTED ALONG WITH THE PROJECT FOR EVALUATION.
• In writing, submit the name of the company (publicly traded) within the first three weeks of classes for approval.
• The students are expected to provide an analysis of the company based on the ratios and accounting measures discussed in chapter 18
o Net Working capital, current ratio, quick ratio, cash flow to total debt, day’s inventory, day’s receivables, day’s payables, cash conversion cycle, cash turnover ratio, total asset turnover, fixed asset turnover, current asset turnover, working capital turnover, times interest earned, long-term debt to total capital, debt to tangible net worth, total liabilities to total asset, long-term debt to total capital, equity ratio, gross profit margin, operating profit margin, net profit margin, EBITDA margin, return on common equity, return on total assets, return on sales, cash profit margin, cash conversion efficiency, return on investment, residual income, free cash flow, economic value added.
• The students are expected to analyze the financial plan and cost behavior of the company and measure its performance based on the topics discussed in chapter 19
• The students are expected to analyze the cost of capital, capital structure, and dividend policy of the company based on the topics discussed in chapter 20
• The students are expected to analyze the following areas of the company performance based on the topics discussed in chapters 8-10
•
Working capital investment and short-term credit
Inventory and accounts receivables management
Credit and accounts payable management
Payment methods practiced by the company
Accounts Receivable Monitoring and Control
Cash positioning and cash management system of the company
Disbursements and Collections
Liquidity Management
• A series of web addresses that provide company financial information and working capital management information are given below.
•
www.MergentOnline.com
Remote access to http://www.mergentonline.com
Username: finacct
Password: rtlibrary
•
•
www.finance.yahoo.com
www.reuters.com/finance
www.sec.gov
www.moneycentral.com
www.frb.org
www.bloomberg.com
http://www.census.gov/econ/
http://www.stat-usa.gov/
http://www.afponline.org
http://www.gtnews.com
http://www.treasuryandrisk.com
http://www.sec.gov/edgar.shtml
http://www.eva.com/evaabout/whatis.php
http://www.gtnews.com
http://cism.bus.utexas.edu
http://www.crfonline.org
http://www.dnb.com
http://www.nacm.org
http://www.nacm.org/bcmag/bcm_index.html
http://www.crfonline.org/surveys/benchmarking/benchmarking.asp
http://www.crfonline.org/orc/ca/ca-7.html
http://www.credit-to-cash-advisor.com/document_50.html
http://www.crfonline.org/surveys/dso/dsoresults.html
http://www.commercialbar.com/sumcoltn.htm
http://www.credit-to-cash-advisor.com/news_91.html
http://www.ecb.int/paym/target/html/index.en.html
http://www.ecb.int/paym/target/target2/html/index.en.html
http://www.frbatlanta.org/publica/finan_update/index.html
http://www.federalreserve.gov/
http://www.nacha.org
http://www.phoenixhecht.com
http://www.treasury.pncbank.com
http://www.treasurystrategies.com
http://www.banxquote.com/
http://www.bloomberg.com
http://www.publicdebt.treas.gov/of/ofsectable.htm
http://www2.standardandpoors.com/spf/pdf/funds/MMFCriteria.pdf
http://www.itmbc.com/
http://www.swift.com
http://www.cme.com
http://www.ita.doc.gov/td/efm
• Make sure to attach all the relevant printouts (submit them as attachments through the Assignment facility in the Blackboard) you have obtained from various web sources with your final write-up.
• A report (20-25 pages) from this research is to be turned in by Due Date: NOVEMBER 06, 2020 (FRIDAY). Details will be discussed throughout the semester.
• Use the Assignment facility in the BlackBoard to submit your DuPont Project.
• Make sure to attach all of the informational printouts (submit them as attachments through the Assignment facility in the BlackBoard) you have obtained from various web sources with your final write-up.
• The report must be of professional quality in terms of format, typing, grammar, spelling, etc. Severe grade reductions will result from failure to present a professional document. It is expected that there will not be any misspelled words or typos. The following format should be used to prepare the report:
1) Cover page 4) Company Analysis 7) Bibliography
2) Abstract 5) Working Capital Analysis 8) Appendix (if any)
3) Introduction 6) Conclusion 9) Excel Calculations
THE INSTRUCTIONS ARE ALL TOGETHER AND ATTACHED MORE IN DEPT IN A WORD DOCUMENT. THE PRICE IS NEGOTIABLE AND THE REPORTS WITH ALL THE DATA ARE INCLUDED IN THE 20-25 PAGES.