Our Services

Get 15% Discount on your First Order

I have Uploaded the excel formula sheet I had already

December 8, 2021

I have Uploaded the excel formula sheet I had already completed. Use the Excel spreadsheet I had upload to complete assignment.

Competencies

In this project, you will demonstrate your mastery of the following competencies:

Analyze financial and investment decisions that add value to the organization
Analyze financing options to maximize investor value

Scenario

You are a financial analyst for the chosen business that you selected during your Module Two Journal assignment. Your supervisor has discovered last minute that your business’s board of directors is looking for updates on the business’s financial health. Your supervisor has asked you to write a report regarding the business’s current financial health and the available financial options for improving the business. You’ve also been asked to make recommendations as to which options the business should choose to best support its financial health. Your supervisor will then use your report to present to the business’s board of directors, whose members all have varying levels of knowledge in terms of finance.

Directions

Using the business you chose from the Project Two Business Options List, create a report for your supervisor to share with the board of directors during their presentation. Keep in mind that your report needs to be easy for someone unfamiliar with finance to understand, as not all of the board members for your business fully understand finance.

Using Mergent Online, locate the most recent quarterly financial statements for your chosen company, and use these statements to support your analysis throughout the project. Refer to the Project Two Financial Assumptions document located in the Supporting Materials section for the assumptions you need in order to analyze the three available financial options outlined in the Financial Analysis section of the project directions.

You are encouraged to use the Project Two Financial Analyst Report template located in the What to Submit section to help complete this project.

Specifically, you must address the following:

Financial Analysis: In this section of the report, you will use the most recent quarterly financial statements for your chosen business and the Project Two Financial Formulas spreadsheet (located in the What to Submit section) to calculate appropriate financial formulas for assessing the business’s financial health. You will also analyze all three available financial options for improving the business based on your calculations and the provided Project Two Financial Assumptions document.
1. Financial Calculations: Calculate accurate financial formulas to assess the business’s current financial health. Specifically, you must calculate the following:
  - Working capital
  - Current ratio
  - Debt ratio
  - Earnings per share
  - Price/earnings ratio
  - Total asset turnover ratio
  - Financial leverage
  - Net profit margin
  - Return on assets
  - Return on equity
2. Working Capital Management: Explain the impact of working capital management on the business’s operations. Provide examples to support your claims.
3. Bond Investment: Analyze the risks and benefits of the business choosing to invest in a corporate bond, including the necessary ethical considerations, appropriate calculations, and examples to support your analysis.
4. Capital Equipment: Analyze the risks and benefits of the business choosing to invest in capital equipment, including the necessary ethical considerations, appropriate calculations, and examples to support your analysis.
5. Capital Lease: Analyze the risks and benefits of the business choosing to purchase a capital lease, including the necessary ethical considerations, appropriate calculations, and examples to support your analysis.
Financial Evaluation: In this section of the report, you will now determine if the three available financial options in the Project Two Financial Assumptions document are appropriate for the business, considering the analysis you did in the first section. You will also explain financing and describe the business’s likely future performance.
1. Financing: Explain how a business finances its operations and expansion.
2. Bond Investment: Assess the appropriateness of a bond investment as a financing option for the business’s financial health, using your financial analysis and other financial information to your support claims.
3. Capital Equipment: Assess the appropriateness of a capital equipment investment as a financing option for the business’s financial health, using your financial analysis and other financial information to support your claims.
4. Capital Lease: Assess the appropriateness of a capital lease purchase as a financing option for the business’s financial health, using your financial analysis and other financial information to support your claims.
5. Short-Term Financing: Explain how potential short-term financing sources could help the business raise needed funds for improving its financial health. Base your response on the business’s current financial information.
6. Future Financial Considerations: Describe the business’s likely future financial performance based on its current financial well-being and risk levels. Use financial information to support your claims.
Financial Recommendations: In this section of the report, you will recommend which financing option(s) are the best for the business to choose depending on its financial health.
1. Financial Recommendation(s): Recommend the most appropriate financing option(s) based on the business’s financial health, including a rationale for why the option(s) are best.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Anthropology Unit 3 Assignment Choose a subsistence pattern that interests

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Cost-volume-profit analysis is used to make many decisions, including product

Cost-volume-profit analysis is used to make many decisions, including product pricing and controlling costs. What assumptions are used in cost-volume-profit analysis? Are these assumptions always valid? Why do managers put such a great amount of emphasis on controlling fixed costs in their organizations? What is meant by the statement, my

Choose a historical or current leader. Describe what you believe

Choose a historical or current leader. Describe what you believe to be their leadership style (or styles). Use the knowledge you have gained in this course to prove your position. Back up your position with events and actions from your leader’s history. Remember that leaders evolve over their live and

Your post should be no longer than 2-3 paragraphs. Simply

Your post should be no longer than 2-3 paragraphs. Simply posting your opinion will not guarantee you any points for the week. You must be able to make intelligent connections between the discussion question topic and course content. Your response should reference relevant concepts, theories, and/or findings from the textbook, additional

The paper shall be about 10 pages long, double spaced,

The paper shall be about 10 pages long, double spaced, with page numbers included. It shall include endnotes, a works cited page (ML8 Guide)., appendices for diagrams & tables, Paper should focus on Salary Cap in Sports: How is it different between Sports and how does the US differ

Instructions Select an article discussing how at least one approach

Instructions Select an article discussing how at least one approach to ethical theory is utilized. After you have selected the article, write at least two double-spaced pages, not counting the title and reference pages, that address the following points/questions: Discuss why you picked the article. Summarize the main topic

Martha is the administrative assistant to Valerie, the practice manager

Martha is the administrative assistant to Valerie, the practice manager in a five-physician practice. Salaries of staff are confidential. Since payroll is handled by an outside company, only the practice manager has knowledge of who makes what salary. Valerie has gone to lunch and left her door open. Several people

Managers often play a dual role, they have to manage

Managers often play a dual role, they have to manage people and also oversee processes. There are some very critical process areas that managers oversee in order to make sure the company functions effectively. Some of these process areas include operations and supply chain management. Please review the following articles

Outline and describe the policy analysis process. Select one Nursing Assignment Help

Outline and describe the policy analysis process. Select one aspect of the process and provide an in-depth analysis determining the most critical elements. Consider the most challenging components of the elements you selected and describe why you believe they are the most challenging. Describe how you think they could be

Introduction: Set the stage for what you will be sharing

Introduction: Set the stage for what you will be sharing regarding effective leadership. Approximately 150-200 words and at least one current and reliable citation. Characteristics of Effective leadership: This is a literature review of the key characteristics of effective leaders. How many traits or characteristics? Research four characteristics of effective

This assignment is actually three-fold: Make sure you read and

This assignment is actually three-fold: Make sure you read and follow through on these directions which will assist you in building your persuasive speech outline– 1. Open the Guideline to Creating Persuasive Speech.docx and print it out. Study it carefully. Keep it next to you and refer to it

The unit learning map gives you some examples of different

The unit learning map gives you some examples of different fractures that can occur in bones. Use this or an outside source to research a type of fracture and follow the below instructions. Pick a fracture unique from your peers. Instructions: Identify the fracture type you will be discussing and

-Upload a research article, please identify if the article is

-Upload a research article, please identify if the article is quantitative or qualitative. -I am requesting locate a scholarly article based on one of the following topics: Quantitative Research Qualitative Research Research Design Literature Review Upload the article and briefly inform the Class what the article is about. APA NO

Discussion question Is the anarchy of the global system the

Discussion question Is the anarchy of the global system the root of the need for power politics and ultimately violence, and if this is true, is it better to prepare and arm (self-help due to the security dilemma) or to try to reduce that anarchy through global institutions via liberalism? Please make this assignment one

Supply Chain Management: Commodity Chain Analysis

Choose a commodity that you and other students use or consume on a regular basis that we have not already examined in this course (i.e. cellphones, coffee). Conduct research on the full life cycle of the commodity extraction or production of the raw materials / ingredients, labour process, transportation, distribution

Subject : Wine bar Business Plan – The business plan describes the opportunity that you have uncovered and how you will take advantage of that

Subject : Wine bar Business Plan – The business plan describes the opportunity that you have uncovered and how you will take advantage of that opportunity. It is a form of storytelling that will persuade readers of the feasibility of the idea. One of the most significant reasons to

Family, Delinquency and Crime

A brief introduction (about 1/2 page) that states your research question and has a thesis that identifies the two most significant themes shared by a majority (if not all) of your research studies. The thesis should also explain why readers should care about what you are writing. Theme 1-(identified by

In this version of your presentation you will incorporate the

In this version of your presentation you will incorporate the feedback from your peer group and you will use the voice over feature in PowerPoint to narrate your revised presentation. Along with the narrated slides, you will submit a summary (minimum 300 words) to document and reflect on any revisions you