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

PHY 413V Grand Canyon University Healing and Autonomy Case Study Nursing Assignment Help

Discussion 1. The four principles, especially in the context of bioethics in the United States, has often been critiqued for raising the principle of autonomy to the highest place, such that it trumps all other principles or values. How would you rank the importance of each of the four principles?

Healthy aging is an important public health issue, both nationally

Healthy aging is an important public health issue, both nationally and internationally. The World Health Organization (WHO) recognizes healthy aging as a process whereby all people of all ages are able to live a healthy, safe and socially inclusive lifestyle. Discuss how social determinants of health for the older adult

Mystery, as a genre of literature.

Analyze the changes over time in mystery as a genre of literature. No introduction is needed. You should just start your essay with an analysis. Describe the main changes in this genre over time Please follow all the requirements. 1. You should use ACADEMIC LANGUAGE only! No personal opinion or

You are an intern at a manufacturing facility. Your boss,

You are an intern at a manufacturing facility. Your boss, the production manager, has seen consumer surveys supporting drone delivery of small packages. She thinks there may be an opportunity for the company to begin manufacturing package delivery drones. She would like your help in preparing a judgmental forecast. The

Summarise the organisational objectives that the HR function is

Activity 2 (1000 words) Question 4) Summarise the organisational objectives that the HR function is responsible for delivering and how these are revolving in contemporary organisations. Book 1 Ch2 P23 Oakwood 6 to 7 Question 5) Focus on the HR function and analyse how the HR function varies between

Web Services

A research paper about Web services in details supported with confidential references(sources) , include: 3 pages on description of what is a web service, their characteristics, their several description languages (explain WSDL (Web service description language) in details mention that it is used as a syntactic language not semantic as

Amendment XIX The right of citizens of the United States

Amendment XIX The right of citizens of the United States to vote shall not be denied or abridged by the United States or by any state on account of sex. Congress shall have power to enforce this article by appropriate legislation. Discussion Topic: Seventy-two years following the first women’s rights

APA format Cite 1 peer reviewed reference 175 – 265

APA format Cite 1 peer reviewed reference 175 – 265 words Respond to the following peer: Christie Artuso I do agree that there are opportunities to improve access to care and services if expanded scopes of practice were to occur. There are significant variations throughout the country in scopes of

Project Quality and Human Resource Management: Running Case Complete the

Project Quality and Human Resource Management: Running Case Complete the three tasks associated with project quality management and the one task associated with project human resource management. (…total of four tasks) Put all your work on one word document. Separate your tasks by headings and page inserts. Remember… turn your

If you run a small business, you’ve probably considered payroll

If you run a small business, you’ve probably considered payroll outsourcing services. The process requires attention to detail and a great deal of time. Outsourcing your payroll allows you to focus on other business priorities. Outsourcing can also give you more time for other tasks. For instance, you can

Early, Later Romantic Poets

This essay is not to be researched. Write the paper about this question– Select one of the poems covered by Keats and compare it to Byron’s Childe Harold’s Pilgrimage. Also times new roman, 12 points, double spaced. Below is the link where you need to read the poems. https://www.poetryfoundation.org/poems/44479/ode-to-a-nightingale https://www.poetryfoundation.org/poems/44477/ode-on-a-grecian-urn

History of Present Illness The case study is that of

History of Present Illness The case study is that of a 58-year-old African-American woman who presents with complaints of worsening shortness of breath and palpitations for about 1 week. She has accompanying dizziness, tiredness, weakness as well as profound dyspnea with little or no exertion. Probable Diagnosis Based on

Often there are more than words or online imagery in

Often there are more than words or online imagery in your workspace—it might be children or pets or roommates or spouses. It might at times seem like you have information overload—as if you were standing in the middle of Times Square, New York, or Piccadilly Circus, London. Even the

The purpose of the assignment is to provide students the opportunity to design a research project meant to improveperformance of an athletic team (or any

The purpose of the assignment is to provide students the opportunity to design a research project meant to improveperformance of an athletic team (or any group that fits personal career aspirations) by applying sports psychologyprinciples studied in class. Students submit a 5-7 page paper using the headings below.OVERVIEW OF ASSIGNMENT*

We have been learning about inventory control decisions within warehouse

We have been learning about inventory control decisions within warehouse operations and now must draw upon that knowledge. Answer the following questions and submit a warehouse layout with details supporting your answer. Identify a manufacturing firm and explain the product characteristics of raw materials, component parts, and finished goods likely

Hardware/Software Setup RequiredWindows computerAccess to cmd.exe and regedit32.exeProblem DescriptionExamine a

Hardware/Software Setup RequiredWindows computerAccess to cmd.exe and regedit32.exeProblem DescriptionExamine a Windows Registry to access keys, subkeys, and values.Estimated completion time: 60 minutesOutcomePrepare a one-paragraph summary detailing how the information contained in the Windows Registry might be useful in a forensic investigation.Validation/Evaluation Open a command line window on a Windows computer

see attached Bmal 560, Corporate Responsibility, Liberty University

see attached Bmal 560, Corporate Responsibility, Liberty University Discussion topic: What fuels technological growth, and is this growth global or is it isolated to a few countries? Discussion instructions: should be between 500–700 words in APA format and must contain real business examples, · include research from 2 scholarly sources,