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
Is the organization in a good position to take on additional debt?
Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60.
Table 1: Hillside, Inc. Balance Sheet ($ in Millions)
ASSETS
LIABILITIES
Cash & Marketable Securities
449.90
Accounts Payable
1,611.20
Accounts Receivable
954.80
Salaries Payable
225.20
Inventories
3,645.20
Other Current Liabilities
1,118.80
Other Current Assets
116.60
Total Current Liabilities
2,955.20
Total Current Assets
5,165.27
Other Liabilities
693.40
Machinery & Equipment
1,688.90
Land
1,129.70
Total Liabilities
3,648.60
Buildings
2,348.40
Depreciation
(575.60)…
arrow_forward
complete the flexible budget report (use formulas and cell referencing whenever possible in spreadsheet)
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
Comprehensive Problem 1Part 2 and Part 3:
The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete part 1 before completing parts 2 and 3.
Part 2: Using the attached spreadsheet, post the journal entries from part 1 to a ledger of four-column accounts.
Part 3: Prepare an unadjusted trial balance. If an amount box does not require an entry, leave it blank.
arrow_forward
E1
arrow_forward
The following annual account balances are from Armour Sports at December 31.
Accounts receivable
Net sales
Year 2
$ 10,753
143,015
Year 1
$ 53,735
624,463
a. Complete the below table to calculate the number of days' sales uncollected for the Year 1 and Year 2.
Note: Do not round intermediate calculations. Round your "Days' Sales Uncollected" to 1 decimal place.
Year 2:
Year 1:
Days' Sales Uncollected
Choose Numerator:
Choose Denominator:
x
Days
== Days' Sales Uncollected
x
Days' sales uncollected
x
=
days
days
arrow_forward
Pls help ASAP for both
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
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
answer quickly
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
Ethics and Professional Conduct in Business
At the end of the current month, Jonni Rembert prepared a trial balance for Star Rescue Service. The credit side of the trial balance exceeds the debit side by a significant amount. Jonni has decided to add the difference to the balance of the miscellaneous expense account in order to complete the preparation of the current month's financial statements by a 5 o'clock deadline. Jonni will look for the difference next week when she has more time.
Discuss whether Jonni is behaving professionally.
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
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
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
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
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
AYC Shoes just started to develop their own line of custom sneakers. The company has asked you, as a consultant, to prepare a financial plan that includes the following:
1. Variable and fixed expenses for the shoe manufacturing (you can find this information by researching other shoe companies, such as Nike, Adidas, Puma, etc.)
2. Based on the expenses that the organization will have, determine the price that they should sell the shoes for.
3. After deciding on the pricing scale and using the expenses you determined in Question #1, determine the break-even point for the organization.
As a consultant, help this start-up company determine their costs and the break-even point.
arrow_forward
As the manager overseeing Audiot and Co., you commenced the planning of audit work for a
new client, Windo Ltd on June 3, 2021. Windo's financial year ends on June 30, 2021, and
the audit is scheduled to be completed by August 15, 2021.
The following information is relevant to the audit engagement:
Windo specializes in providing repair services for motor vehicles and operates from
five different locations. All inventory, sales, and purchasing systems are
computerized, with each location maintaining its own system.
The software used at each location is identical, as it was custom-developed by a
reputable software house specifically for Windo. Data from all locations is
consolidated monthly at the head office to generate management and financial
accounts.
Currently, you are in the process of planning the audit approach for Windo Ltd. One
option under consideration is to modify Audiot & Co.'s audit software to interface
with Windo's computerized inventory systems at each…
arrow_forward
As the manager overseeing Audiot and Co., you commenced the planning of audit work for a new client, Windo Ltd on June 3, 2021. Windo's financial year ends on June 30, 2021, and the audit is scheduled to be completed by August 15, 2021. The following information is relevant to the audit engagement: Windo specializes in providing repair services for motor vehicles and operates from five different locations. All inventory, sales, and purchasing systems are computerized, with each location maintaining its own system. The software used at each location is identical, as it was custom-developed by a reputable software house specifically for Windo. Data from all locations is consolidated monthly at the head office to generate management and financial accounts. Currently, you are in the process of planning the audit approach for Windo Ltd. One option under consideration is to modify Audiot & Co.'s audit software to interface with Windo's computerized inventory systems at each…
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
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
1 SSO: Texas A&M University San Antonio
110
M Question 7 - Week 13 - Homework #8 (100 points) - Connect
Week 13 - Homework #8 (100 points) i
ezto.mheducation.com
b My Questions | bartleby
Saved
7
Seminoles Corporation's fiscal year-end is December 31, 2024. The following is a partial adjusted trial balance as of December 31.
Accounts
Debit
Retained Earnings
Credit
$30,000
Dividends
$3,000
Service Revenue
15
points
Interest Revenue
50,000
6,000
Salaries Expense
15,000
Rent Expense
6,000
Skipped
Advertising Expense
3,000
Insurance Expense
11,000
Interest Expense
5,000
eBook
101
Hint
Required:
1. Prepare the necessary closing entries.
2. Calculate the ending balance of Retained Earnings.
Complete this question by entering your answers in the tabs below.
Print
Required 1
Required 2
References
Mc
Graw
Hill
Prepare the necessary closing entries. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the
first account field.)
View transaction list…
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_forwardIs the organization in a good position to take on additional debt? Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60. Table 1: Hillside, Inc. Balance Sheet ($ in Millions) ASSETS LIABILITIES Cash & Marketable Securities 449.90 Accounts Payable 1,611.20 Accounts Receivable 954.80 Salaries Payable 225.20 Inventories 3,645.20 Other Current Liabilities 1,118.80 Other Current Assets 116.60 Total Current Liabilities 2,955.20 Total Current Assets 5,165.27 Other Liabilities 693.40 Machinery & Equipment 1,688.90 Land 1,129.70 Total Liabilities 3,648.60 Buildings 2,348.40 Depreciation (575.60)…arrow_forwardcomplete the flexible budget report (use formulas and cell referencing whenever possible in spreadsheet)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_forwardComprehensive Problem 1Part 2 and Part 3: The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete part 1 before completing parts 2 and 3. Part 2: Using the attached spreadsheet, post the journal entries from part 1 to a ledger of four-column accounts. Part 3: Prepare an unadjusted trial balance. If an amount box does not require an entry, leave it blank.arrow_forwardE1arrow_forward
- The following annual account balances are from Armour Sports at December 31. Accounts receivable Net sales Year 2 $ 10,753 143,015 Year 1 $ 53,735 624,463 a. Complete the below table to calculate the number of days' sales uncollected for the Year 1 and Year 2. Note: Do not round intermediate calculations. Round your "Days' Sales Uncollected" to 1 decimal place. Year 2: Year 1: Days' Sales Uncollected Choose Numerator: Choose Denominator: x Days == Days' Sales Uncollected x Days' sales uncollected x = days daysarrow_forwardPls help ASAP for botharrow_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
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