Financial management project APA Double space about 10-15 pages
Im studying and need help with a Excel question to help me learn.
The checkpoint assignment for BUS, Financial Management is one of a series of assignments designed to demonstrate that students have achieved the learning outcomes established for the majors in the College of Business and Management.
The specific objective of this critical assignment is to assure that students have a sufficient level of accounting and finance skills to conduct financial analyses of an organization. These exercises will provide students with the opportunity to integrate and implement theory to practice and will prepare students to develop a comprehensive business plan in the capstone course during the final year of study.
For the purpose of this exercise, students will choose a company for which they will conduct an environmental scan and a financial analysis. The analysis of the company should culminate with students recommending that the company is excellent, healthy, or ill. Students will be evaluated based on correctness of the calculations, the insight of the analysis, and the quality of the discussion relating to the requirements.
Before performing the financial analysis, students will prepare an environmental scan, which will discuss the various forces with which an organization must contend to assure that its business model has a chance for success.
The specific calculations should include:
- DuPont Identity
- Current Ratio
- Quick Ratio
- Inventory Holding Period
- Average Collection Period
- Debt Ratio
- Dividend Yield
- Required Rate of Return based on the Capital Asset Pricing Model
- Free Cash Flow
- Market Value Added
- Economic Value Added
Additionally, students will be expected to prepare an executive summary of the process of capital budgeting, using an example that is specific to the company that is being analyzed. An executive summary of cost-volume-profit analysis is also required, using an example that is specific to the company that is being analyzed.
The written paper is to be typed doublespaced, 1 margins, Times New Roman and 12-point font, with correct spelling and grammar, proper citation, references, with a cover page and organized with headings. The instructors approval of the topic is required.
IMPORTANT:
The topic of choice is NVIDIA Corporation (NVDA) stock.
first you will have to place the correct numbers in the corresponding boxes in order to interpret the information. (_fmu_project_UsingBarchartTemplate_sbuxand _fmu_project_UsingBarchartTemplate_sbux -) are the documents to clear the template information and place the corresponding information (NVIDIA). You will use the most recent four years (2016. 2017, 2018, 2019) that you can grab the information from either barchart or yahoo finance (cash flow, balance sheet, and income statement)
(the other excel sheet to fill out is on the rating)
You will use the balance sheet income sheet and cash flow from the yahoo finance and barchart website. Once filled out the template, you can use the information to answer the questions from document: _fmu_project_guide (3). After filling out this template you can go ahead and turn it into paragraph form. You can follow the template i have included as a guide to how the paper should look when it is finished (document: _fmu_project_sampleEssay). and i have included a guide word document you can use to fill in all the information to make it into paragraph form (document: _fmu_project_guide (3)).
