P1_Final_Dowe_Report_1-23-24
.docx
keyboard_arrow_up
School
University of Maryland Global Campus (UMGC) *
*We aren’t endorsed by this school
Course
620
Subject
Business
Date
Jun 19, 2024
Type
docx
Pages
7
Uploaded by GrandIceSeal6187
2222
Project 1 Report
Instructions:
Answer the five questions below. They focus entirely on the financial health of Largo Global Inc. (LGI) based on the three years of income statement and balance sheet data provided in the Excel workbook. Base your analysis only on the financial statements provided in
the Excel workbook. Provide support for your reasoning from the readings in Project 1, Step 1, and the discussion in Project 1, Step 3. Be sure to cite your sources.
Provide a detailed response below each question. Use 12-point font and double spacing. Maintain the existing margins in this document. Your final Word document, including the questions, should not exceed 5 pages. Include a title page in addition to the five pages. Any tables and graphs you choose to include are also excluded from the five-page limit. Name your document as follows: P1_Final_lastname_Report_date. You must address all five questions and make full use of the information on tabs 2–4 as well as the competitor and industry data in the Excel workbook (ratio, common-size, and cash flow analysis). You are strongly encouraged to exceed the requirements by refining your analysis. Consider other tools and techniques that were discussed in the required and recommended reading for Project 1. This means adding an in-depth explanation of what happened in the three years for which data was provided to make precise recommendations to LGI.
011022
Title Page
Dominic Dowe
Financial Decision-Making MBA 620
Richard Works
1/23/2024
2222
Questions:
1. How would you assess the overall financial health of Largo Global Inc. (LGI)? You will need to provide a broad view of the main trends that emerge from your analyses of the information in tabs 2, 3, and 4. Your key findings should be synthesized and highlight a clear diagnostic of LGI's financial strength and/or weakness. [HINT: all 5 questions are interrelated and may sometimes build on each other – it is imperative that you develop a “blue-
print” or an outline of what you are answering for each question. Do not answer each question independently as if they were not connected. You should not be redundant but should make sure that you are judiciously coordinating these 5 questions. Question 1 and 5 should be providing the
introduction and conclusion of your analysis. Questions 2, 3, and 4 should be providing the “body” or development of your analysis – with a focus on operations, investing, and financing]
In regard to overall financial health, Largo Global Inc. appears to be in decline from 2020
to 2022, with some significant points of concern. The first concern is that profitability has decreased, with the Net Income decreasing from $325 to $114 from 2020 to 2022. There has ben an increase in cash flow but the increase in accounts payable offsets this. There is a risk that LGI would be depleting too much cash and begin relying on its ability to leverage accounts receivable
to address the current debts. The company's profitability ratios reflect a decline from 11.89% to 5.66% over the last few years. Not only is this a significant drop for LGI, but it is also below the
industry benchmark, which would not make LGI a stronger competitor. 2. How is LGI doing in terms of operating efficiency? How would you assess its performance compared to its main competitor and the industry index? What are the principal areas that need to be addressed to strengthen LGI' s bottom line? Identify and use key indicators from all 3 analyses that provide insight about LGI's operations.
[HINT: Focus of this question is the Income Statement and the Net Working Capital (NWC) as it relates to Current Assets and Current Liabilities]
LGI has suffered a decline in its operating efficiency. One weakness of LGI contributing to its decline in profitability is the large stockpile in inventory. In 2022 the 'day's sales in inventory' reached its highest point in the last several years at 105.33, which is more than double
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
John Ozment, director of special projects and analysis for Ozment’s Corporation, is responsible for preparing corporate financial analyses and monthly statements and reviewing and presenting the economic impacts of proposed strategies to upper management. Data for such financial analyses are obtained from operations and financial databases through direct queries of Ozment’s department staff. Reports and charts for presentations are then prepared by hand and typed. Multiple copies are prepared and distributed to various users. The pressure on Ozment’s group has intensified as demand for more and more current information increases. A solution to this reporting problem must be found.The systems department wants to develop a proprietary software package to produce the reports automatically. The project would require the company to make a considerable programming investment. Ozment is concerned about the accuracy, completeness, and currency of data isautomatically produced reports. He has…
arrow_forward
The purpose of this assignment is to evaluate the impact of a financial analysis on administrative decisions in a health care organization. Review Northwestern Memorial HealthCare's "Consolidated Financial Report" (Years Ended August 31, 2019 and 2018), and answer the following prompts.
Discuss the importance of and need for a financial analysis within a health care organization.
Explain the relationship between a health care organization's financial plan and debt policy to its strategic plan.
Assess the financial position of Northwestern Memorial HealthCare in 2019 as compared to 2018.
Give specific examples of areas where improvement is needed or areas that should be of concern in terms of financial viability.
Based upon these observations, make recommendations that management should consider from a strategic standpoint (i.e., strategic budgeting methods).
arrow_forward
oring: Your score will be based on the number of correct matches. There is no penalty for incorrect or missing matches,
atch the terms with the definitions.
Clear All
The normal balance of asset,
expense, and drawing
accounts.
A list of accounts, showing
the title and balance of each
account, used to prove that
the debit balances equal the
credit balances.
The total dollar amounts on
the debit and credit sides of
an account.
A system in which each
transaction has a dual effect
on the accounting elements.
To enter an amount of the
left side of an account.
debit
trial balance
fobtings
double-entry accounting
debit balance
=
All work saved.
arrow_forward
I need answer typing clear urjent no chatgpt used i will give upvotes
arrow_forward
a) Describe the key characteristics of a feasibility study, including an
example of the tasks that need to be undertaken and techniques
employed.
b) Table Q4b. shows data obtained using the scoring method in a project
selection exercise.
(i)
Describe clearly how the scoring method works, using table Q4b. as
an example upon which to base your description.
(ii) The project manager must select one project only. State which
project, the project manager should select (Project A, Project B or
Project C) and provide a justification based on the data provided in
Table Q4b.
Weighted Score (= Score x Weighting)
Criterion
Weight
Project A
Project B
Project C
Criterion 1
Mandatory
Yes
Yes
No
Criterion 2
10
9 x 10 = 90
8x 10 = 80
9 x 10 = 90
Criterion 3
8
9 x 8 = 72
8 x 8 = 64
9 x 8 = 72
Criterion 4
6
6х6- 36
7x 6 = 42
9 x 6 = 54
Criterion 5
4
7x 4 = 28
8x 4 = 32
9 x 4 = 36
Total Score
226
218
252
Table Q4b
c) In Industry and commerce, it is common to classify estimates according
to three different…
arrow_forward
Manage Your Health, Inc. (MYH) is a Fortune 500 company that provides a variety
of healthcare services across the globe. MYH has more than 20,000 full-time
employees and more than 5,000 part-time employees. MYH recently updated its
strategic plan; key goals include reducing internal costs, increasing cross-selling of
products, and exploiting new Web-based technologies to help employees,
customers, and suppliers work together to improve the development and delivery
of healthcare products and services. Below are some ideas the IT department has
developed for supporting these strategic goals:
1. Recreation and Wellness Intranet Project: Provide an application on
the current intranet to help employees improve their health. A recent study
found that MYH, Inc. pays 20 percent more than the industry average for
employee healthcare premiums, primarily due to the poor health of its
employees. You believe that this application will help improve employee
health within one year of its rollout so…
arrow_forward
Which type of preliminary estimate would be the best in each of the
following situations and explain your answer rationale.
a. Decide whether it is feasible to proceed with constructing a new small office building.
b. Establish the budget for a bond issue to build three new elementary schools.
c. Evaluate which of three alternate designs best fits the budget for a new clinic.
arrow_forward
Can you please solve all of them? Thank you!
arrow_forward
CVP Analysis; Commissions; Ethics Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019: Lionel Corporation Budgeted Income Statement For the Year Ending June 30, 2019 ($000 omitted) Sales $28,500 Cost of goods sold Variable $12,825 Fixed 3,500 16,325 Gross profit $12,175 Selling and administrative costs Commissions $ 5,130 Fixed advertising cost 800 Fixed administrative cost 2,150 8,080 Operating income $ 4,095 Fixed interest cost 705 Income before income taxes $ 3,390 Income taxes (30%) 1,017 Net income $ 2,373 Since the completion of the income statement, Lionel has learned that its sales agents are requiring a 5% increase in their commission rate (to 23%) for the upcoming year. As a result, Lionel’s president has…
arrow_forward
To prepare
the gross margin, include operating expenses, calculate your income, include income taxes, calculate net income and lastly finalize
we need to generate a trial balance report, calculate your revenue, determine the cost of goods sold, calculate
your income statement with business details and the reporting period.
A) Balance Sheet
B) Cash Flow Statement
Income Statement
D Break-even analysis
arrow_forward
Assume that a company provided the following information and assumptions from its master budget:
Sales budget: Unit sales in June, July, and August are 20,000, 18,000, and 17,000, respectively. The selling price per unit is $80. All sales are on account. 20% of sales are collected in the month of sale and 80% are collected in the next month.
What are the budgeted sales for July?
Multiple Choice
$1,440,000
$1,600,000
$288,000
$1,152,000
arrow_forward
Mr. Raheem, the marketing manager of Orphic
company prepared a plan showing the expected
expenses of his department for the coming year
2021. This type of plan is an example of:
a. Contingent Plan.
b. Budget.
c. Strategic Plan.
d. Standing Plan.
arrow_forward
Please address the following:
Eric, your friend, received his Form W-2 from his employer (below) and has asked for your help. Eric’s 2020 salary was $145,000 and he does not understand why the amounts in Boxes 1, 3 and 5 are not $145,000? His final paycheck for the year included the following information:
Eric contributed 5 percent of his salary to the company 401(k) plan on a pre-tax basis.
Eric is married with two children. He had $5,000 deducted from his wages for a Dependent Care Flexible Spending Account.
Eric is enrolled in the company-sponsored life insurance program. He has a policy that provides a benefit of $145,000.
Eric contributed $2,500 to the Health Care Flexible Spending Account (he keeps forgetting that the maximum deferral has increased over the years).
Using the information and Eric’s Form W-2, explain to Eric the reconciling of his salary of $145,000 to the amounts in Boxes 1, 3, and 5.
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Evaluate the firm’s short-term solvency for 2008 by computing:
a. Working Capital
b. Current Ratio
c. Acid-test/Quick Ratio
arrow_forward
The following financial statements are taken from the records of Organo Inc.
a) Use horizontal analysis techniques to compare the changes between 2023 and 2022 balance sheet items.
Do not enter dollar signs or commas in the input boxes.
Use the negative sign for negative values.
Round all percentages to 2 decimal places.
Organo Inc.
Balance Sheet
As at May 31
2023 2022 $ Change % Change
Current Assets
Cash $308,000 $315,100 $Answer
Answer
%
Accounts Receivable $148,000 $192,800 $Answer
Answer
%
Merchandise Inventory $362,700 $393,500 $Answer
Answer
%
Short-Term Investments $136,200 $115,100 $Answer
Answer
%
Total Current Assets $954,900 $1,016,500 $Answer
Answer
%
Long-Term Assets $227,800 $314,300 $Answer
Answer
%
Total Assets $1,182,700 $1,330,800 $Answer
Answer
%
Current Liabilities $293,000 $262,200 $Answer
Answer
%
Long-Term Liabilities $147,000 $111,300 $Answer
Answer
%
Total Liabilities $440,000 $373,500 $Answer…
arrow_forward
XYZ Corp is preparing a financial projection by splitting its P&Ls into two separate P&Ls. What would it include in its "unpredictable" P&L?
Select an answer:
employee salaries and benefits
a large contract from a new customer
projections of sales to existing customers
employee performance-based bonuses
arrow_forward
The Deferred Revenue account is shown in which statement? Multiple Choice 1.Balance sheet 2. Statement of stockholders' equity 3.Income statement 4.Statement of cash flows
Don't use chatgpt,I will 5 upvotes
arrow_forward
Worksheet for Case Analysis (MGT 302). This worksheet follows the format of the case study videos posted in the Course Policies module. Type each significant symptom in its own cell (left column) and complete the rest of the row, demonstrating your ability to correctly apply management principles. Move on to the last page once you have completed the worksheet. In your analysis, use all applicable theories from the readings through the current week, to gain experience in more holistic use of theory in case analysis. (See the video on case study analysis in Course Policies for more on each column.) Before each symptom, it might help you to ensure you have covered the relevant theory bases to include the category of P-O-L-C and sub-category in which the symptom best fits. Use these (taken from the text organization: P (planning): V (vision & mission); S (strategizing); G (goals & objectives). O (organizing): O (organizational design); C (culture); S (social networks). L (leading):…
arrow_forward
Can you help me with figuring out how to do find the correct solution? Other instructions were not as detailed. I need help with part c) . I do not know where to start or how to go about completing, thank you.
arrow_forward
Enterprise resource planning (ERP) represents:
Select one:
O a. The system that integrates only financial aspects of business activities.
O b. The system that integrates financialespects of a company's operations with its traditional AIS.
O C. The system that integrates only non-financial aspects of business activities.
O d. The system that integrates financial data with non-financial operating data.
arrow_forward
9. Marketing Arrangements
Target market, definition of the product or service, pricing, distribution and promotion.
10. Financial Consideration
Source of financing, capital cost, pre-operating expenses, working capital requirements, cash budget over three years (estimation of the cash inflows and outflows).
arrow_forward
Google R & D Spending. In 2009, Google spent about $2800 million on research and development and spent
$8000 million in 2013. The relationship between Google's spending and time has been linear; in the problem that
follows, assume that the relationship will remain linear until 2030.
a) Find a linear function that models Google's spending as a function of time.
b) Use your model to predict Google's R & D spending in 2020.
c) Write, including units, and interpret the slope of your model.
arrow_forward
A budgetary planning and controlsystem may include many individual budgets which are integrated into a ‘master budget’.You are required to outline and briefly explain with reasons the steps that should normally be taken in the preparation of master budgets in a manufacturing company, indicating the main budgets which you think should normally be prepared.
arrow_forward
A brief background on Seprod company Itd. and their Financial statements for 2018 and 2019.
arrow_forward
Need answer of each question minimum 100 words to
What is the return of the creditors? How can it be measured?
arrow_forward
please, I am trying to collect this data, but I am not getting it. help
arrow_forward
CB Winter Sports specializes in providing ski lessons to beginners. The company uses the allowance method to account for
uncollectible accounts expense CB Winter Sports experienced the following four accounting events in Year 1:
1. Recognized $266,000 of revenue on account.
2. Collected $126,000 cash from accounts receivable.
3. Wrote off uncollectible accounts of $2,300,
4. Recognized uncollectible accounts expense, CB Winter Sports estimated that uncollectible accounts expense will be 3 percent of
sales on account
Required:
Use a horizontal financial statements model to show how each event affects the balance sheet, income statement, and statement of
cash flows. More specifically, record the amounts of the events into the model. Also, in the Statement of Cash Flows column, classify
the cash flows as operating activities (OA), investing activities (IA), or financing activities (FA) The first transaction is shown as an
example.
Note: Enter any decreases to account balances and cash…
arrow_forward
The first step in performing projected financial analysis is to
• prepare the projected balance sheet.
forecast sales as accurately as possible.
take an inventory of goods.
calculate the projected net income.
estimate increases in debt.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Related Questions
- John Ozment, director of special projects and analysis for Ozment’s Corporation, is responsible for preparing corporate financial analyses and monthly statements and reviewing and presenting the economic impacts of proposed strategies to upper management. Data for such financial analyses are obtained from operations and financial databases through direct queries of Ozment’s department staff. Reports and charts for presentations are then prepared by hand and typed. Multiple copies are prepared and distributed to various users. The pressure on Ozment’s group has intensified as demand for more and more current information increases. A solution to this reporting problem must be found.The systems department wants to develop a proprietary software package to produce the reports automatically. The project would require the company to make a considerable programming investment. Ozment is concerned about the accuracy, completeness, and currency of data isautomatically produced reports. He has…arrow_forwardThe purpose of this assignment is to evaluate the impact of a financial analysis on administrative decisions in a health care organization. Review Northwestern Memorial HealthCare's "Consolidated Financial Report" (Years Ended August 31, 2019 and 2018), and answer the following prompts. Discuss the importance of and need for a financial analysis within a health care organization. Explain the relationship between a health care organization's financial plan and debt policy to its strategic plan. Assess the financial position of Northwestern Memorial HealthCare in 2019 as compared to 2018. Give specific examples of areas where improvement is needed or areas that should be of concern in terms of financial viability. Based upon these observations, make recommendations that management should consider from a strategic standpoint (i.e., strategic budgeting methods).arrow_forwardoring: Your score will be based on the number of correct matches. There is no penalty for incorrect or missing matches, atch the terms with the definitions. Clear All The normal balance of asset, expense, and drawing accounts. A list of accounts, showing the title and balance of each account, used to prove that the debit balances equal the credit balances. The total dollar amounts on the debit and credit sides of an account. A system in which each transaction has a dual effect on the accounting elements. To enter an amount of the left side of an account. debit trial balance fobtings double-entry accounting debit balance = All work saved.arrow_forward
- I need answer typing clear urjent no chatgpt used i will give upvotesarrow_forwarda) Describe the key characteristics of a feasibility study, including an example of the tasks that need to be undertaken and techniques employed. b) Table Q4b. shows data obtained using the scoring method in a project selection exercise. (i) Describe clearly how the scoring method works, using table Q4b. as an example upon which to base your description. (ii) The project manager must select one project only. State which project, the project manager should select (Project A, Project B or Project C) and provide a justification based on the data provided in Table Q4b. Weighted Score (= Score x Weighting) Criterion Weight Project A Project B Project C Criterion 1 Mandatory Yes Yes No Criterion 2 10 9 x 10 = 90 8x 10 = 80 9 x 10 = 90 Criterion 3 8 9 x 8 = 72 8 x 8 = 64 9 x 8 = 72 Criterion 4 6 6х6- 36 7x 6 = 42 9 x 6 = 54 Criterion 5 4 7x 4 = 28 8x 4 = 32 9 x 4 = 36 Total Score 226 218 252 Table Q4b c) In Industry and commerce, it is common to classify estimates according to three different…arrow_forwardManage Your Health, Inc. (MYH) is a Fortune 500 company that provides a variety of healthcare services across the globe. MYH has more than 20,000 full-time employees and more than 5,000 part-time employees. MYH recently updated its strategic plan; key goals include reducing internal costs, increasing cross-selling of products, and exploiting new Web-based technologies to help employees, customers, and suppliers work together to improve the development and delivery of healthcare products and services. Below are some ideas the IT department has developed for supporting these strategic goals: 1. Recreation and Wellness Intranet Project: Provide an application on the current intranet to help employees improve their health. A recent study found that MYH, Inc. pays 20 percent more than the industry average for employee healthcare premiums, primarily due to the poor health of its employees. You believe that this application will help improve employee health within one year of its rollout so…arrow_forward
- Which type of preliminary estimate would be the best in each of the following situations and explain your answer rationale. a. Decide whether it is feasible to proceed with constructing a new small office building. b. Establish the budget for a bond issue to build three new elementary schools. c. Evaluate which of three alternate designs best fits the budget for a new clinic.arrow_forwardCan you please solve all of them? Thank you!arrow_forwardCVP Analysis; Commissions; Ethics Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019: Lionel Corporation Budgeted Income Statement For the Year Ending June 30, 2019 ($000 omitted) Sales $28,500 Cost of goods sold Variable $12,825 Fixed 3,500 16,325 Gross profit $12,175 Selling and administrative costs Commissions $ 5,130 Fixed advertising cost 800 Fixed administrative cost 2,150 8,080 Operating income $ 4,095 Fixed interest cost 705 Income before income taxes $ 3,390 Income taxes (30%) 1,017 Net income $ 2,373 Since the completion of the income statement, Lionel has learned that its sales agents are requiring a 5% increase in their commission rate (to 23%) for the upcoming year. As a result, Lionel’s president has…arrow_forward
- To prepare the gross margin, include operating expenses, calculate your income, include income taxes, calculate net income and lastly finalize we need to generate a trial balance report, calculate your revenue, determine the cost of goods sold, calculate your income statement with business details and the reporting period. A) Balance Sheet B) Cash Flow Statement Income Statement D Break-even analysisarrow_forwardAssume that a company provided the following information and assumptions from its master budget: Sales budget: Unit sales in June, July, and August are 20,000, 18,000, and 17,000, respectively. The selling price per unit is $80. All sales are on account. 20% of sales are collected in the month of sale and 80% are collected in the next month. What are the budgeted sales for July? Multiple Choice $1,440,000 $1,600,000 $288,000 $1,152,000arrow_forwardMr. Raheem, the marketing manager of Orphic company prepared a plan showing the expected expenses of his department for the coming year 2021. This type of plan is an example of: a. Contingent Plan. b. Budget. c. Strategic Plan. d. Standing Plan.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- BUSN 11 Introduction to Business Student EditionBusinessISBN:9781337407137Author:KellyPublisher:Cengage LearningEssentials of Business Communication (MindTap Cou...BusinessISBN:9781337386494Author:Mary Ellen Guffey, Dana LoewyPublisher:Cengage LearningAccounting Information Systems (14th Edition)BusinessISBN:9780134474021Author:Marshall B. Romney, Paul J. SteinbartPublisher:PEARSON
- International Business: Competing in the Global M...BusinessISBN:9781259929441Author:Charles W. L. Hill Dr, G. Tomas M. HultPublisher:McGraw-Hill Education
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education