FIN 320 Final Project Financial Analysis Report
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
320
Subject
Finance
Date
Jun 9, 2024
Type
docx
Pages
7
Uploaded by HighnessPolarBearPerson1139
FIN 320 Final Project Financial Analysis Report
Shantavia Burr
Southern New Hampshire University
Fin 320-Principle Of Finance
Yinfei Chen
April 21, 2024
Financial Analysis, Financial Evaluation, and Financial Recommendations
1.
Financial Analysis
A.
Financial Calculations:
Using the latest quarter’s financial statements for your chosen business and the
Financial Formulas spreadsheet, calculate the financial formulas below to assess the
business’s financial health.
Working capital:
o
The working capital for Johnson & Johnson is $9,333,000. With a
working capital of $9,333,000, it indicates that the company has
significant resources available to cover its short-term obligations
and to fund its day-to-day operations. This suggests a healthy
financial position in the short term.
Current ratio: o
The current ratio for Johnson & Johnson is 1.21, with a current ratio
of 1.21 it means that the company has $1.21 in current assets for
every $1 in current liabilities. A current ratio above 1 generally
indicates that a company has more current assets than current
liabilities, which suggests a healthy liquidity position. It implies that
Johnson & Johnson has sufficient short-term assets to cover its
short-term liabilities.
Debt ratio: o
For Johnson & Johnson, with a debt ratio of 0.571, it means that approximately 57.1% of the company's assets are financed with debt. A lower debt ratio generally indicates greater financial stability, as it suggests that the company relies less on debt financing.
Earnings per share: o
For Johnson & Johnson, with an EPS of $14,603.41, it indicates a positive sign for investors, indicating that the company is effectively managing its operations and generating value for shareholders. However, it's important to consider the trend of EPS over time to assess the company's growth potential.
Price and earnings ratio: o
For Johnson & Johnson, with a P/E ratio of 6.48, it means that investors are willing to pay $6.48 for every $1 of earnings per share. 1
A low P/E ratio of 6.48 may indicate that the company's stock is undervalued relative to its earnings. Investors may view this as an opportunity to buy into the company at a lower price relative to its earnings potential.
Total asset turnover ratio:
o
With a total asset turnover ratio of 512.82, it means that the company generates $512.82 in sales revenue for every dollar of total assets. A high total asset turnover ratio like 512.82 indicates that Johnson & Johnson is efficiently using its assets to generate sales revenue. It suggests that the company is effectively managing its assets to drive revenue growth.
Financial leverage: o
A financial leverage ratio of 2.41 indicates that Johnson & Johnson's assets are financed primarily through debt, with a proportion of debt being 2.41 times greater than equity. This level of leverage suggests that the company has a significant reliance on debt to finance its operations and investments.
Net profit margin: o
A net profit margin of 0.412 for Johnson & Johnson means that the company earns a profit of $0.412 for every dollar of revenue generated. In percentage terms, this would be 41.2%. A net profit margin of 0.412 indicates a relatively healthy level of profitability. It suggests that Johnson & Johnson is effectively managing its costs and expenses relative to its revenue, resulting in a substantial portion of revenue translating into profit.
Return on assets: o
A return on assets of 211.69 for Johnson & Johnson indicates that the company is generating significant profits relative to its total assets. A high ROA like 211.69 suggests that Johnson & Johnson is efficiently utilizing its assets to generate profits. It indicates that the company's management is effectively deploying its resources to generate returns for shareholders.
Return on equity: o
A return on equity of 511.01 for Johnson & Johnson indicates that the company is generating significant returns for its shareholders relative to the amount of equity invested. A high ROE can enhance investor confidence in the company's ability to generate returns. It may lead to higher stock valuations and attract investment capital.
B.
Working Capital Management:
o
With a working capital management of $9,333,000, Johnson & Johnson can efficiently cover its
short-term financial obligations while maintaining operational agility and flexibility. This level of
working capital ensures that the company has ample liquidity to meet its day-to-day operational
needs, such as purchasing raw materials, funding production processes, and managing inventory
levels. Additionally, it provides a buffer against unexpected expenses or fluctuations in cash
flow, enabling the company to navigate market uncertainties and capitalize on growth
opportunities more effectively. By effectively managing its working capital at this level, Johnson
2
& Johnson can sustain its operational excellence, support ongoing investments in research and
development, and maintain its position as a leader in the healthcare industry. An example of this
is with sufficient working capital, Johnson & Johnson can optimize its inventory levels to ensure
that it has the right number of raw materials, work-in-progress, and finished goods on hand.
This allows the company to meet customer demand efficiently without overstocking or
understocking, reducing carrying costs and minimizing the risk of obsolete inventory.
C.
Financing: Businesses typically finance their operations and expansion through a combination of internal and external sources of capital. Internally, they utilize retained earnings, generated from profits reinvested into the company, to fund day-to-day activities and strategic investments. Effective management of working capital, including optimizing cash flow from receivables, inventory, and payables, also contributes to internal funding. Externally, businesses may seek external financing options such as debt financing, through loans or bonds, to access additional capital for expansion projects, acquisitions, or capital expenditures. Equity financing, including issuing shares to investors or seeking venture capital funding, provides another avenue for businesses to raise capital for growth initiatives. By strategically leveraging a mix of internal and external funding sources, businesses can sustain operations, drive growth, and enhance shareholder value while managing financial risk.
D.
Short-Term Financing: Potential short-term financing sources with a liability amount of $44,370,000 could assist Johnson & Johnson in raising necessary funds to enhance its financial health by providing quick access to capital for immediate needs. One option is through short-term bank loans or lines of credit, allowing the company to borrow funds for short periods to bridge cash flow gaps or finance urgent expenses. Commercial paper issuance, a form of
unsecured short-term debt, offers another avenue for raising funds quickly, leveraging the company's strong creditworthiness. Additionally, trade credit arrangements with suppliers could be utilized to negotiate extended payment terms, allowing Johnson & Johnson to delay cash outflows and preserve liquidity. By strategically utilizing these short-term financing sources, Johnson & Johnson can address liquidity needs, capitalize on growth opportunities, and strengthen its financial position in the short term while maintaining long-term sustainability.
E.
Bond Investment:
o
Investing in corporate bonds can offer Johnson & Johnson both benefits and risks. On the benefit side, corporate bonds typically provide a fixed income stream through regular interest payments, offering predictable cash flows that can be used to fund various operational needs or investment initiatives. Additionally, corporate bonds often have higher yields compared to government
bonds, potentially providing attractive returns for the company's investment portfolio. Moreover, investing in corporate bonds can diversify Johnson & Johnson's investment holdings, reducing overall portfolio risk. However, there are also risks associated with corporate bond investments. One major risk is credit risk, where the issuer may default on its debt obligations, leading to potential losses for the investor. Johnson & Johnson must carefully assess the creditworthiness of the bond issuer to mitigate this risk, considering factors 3
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
task 1 question 4
arrow_forward
Finance
Initial Investment
$17,766
End of Year
Income
1
$5,919
2
$4,285
3
$5,143
4
$3,532
5
$1,800
(Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.)
pop-up content ends
PrintDone
Justin Lieberman must earn a minimum rate of return of 9.22% as compensation for the risk of the following investment:
a. Use present value techniques to estimate the IRR on this investment.
b. On the basis of your finding in part
a,
should Justin make the proposed investment?
Question content area bottom
Part 1
a. The yield on this investment is
enter your response here%.
(Round to two decimal places.)
arrow_forward
Table 3.5 presents a computer spreadsheet for estimating R&E Supplies’ external financing required for 2018. The text mentions that with modifications to the equations for equity and net sales, the forecast can easily be extended through 2019. Write the modified equations for equity and net sales.
arrow_forward
This question sir thnksss
arrow_forward
Answer pl
arrow_forward
PROJECT 8 QR Spring 2020 Finances - Word
A jrush416
erences
Mailings
Review
View
Help
Tell me what you want to do
A
Aa -
三 T
AaBbCcDc AaBbCcDc AaBbC AAB6CCE
TNormal
T No Spac. Heading 1
Heading 2
Paragraph
Styles
5. Suppose you want to have $900,000 forretirement in 30 years. Your account earns 8% interest.
a) How much would you needto deposit in the account each month
b) How much interest will you earn?
arrow_forward
Assignment Question:
A. Messi wishes to find the present
value of $ 3,500 that will be received 12
years from now. Messi opportunity cost
is 8%. ?
b. Financial Management means
planning, organizing, directing and
controlling the financial activities such
as procurement and utilization of funds
of the enterprise. Briefly explain the
Popular Sources of Risk Affecting
Financial Managers and Shareholders?
1:06 PM A
arrow_forward
PROGRAMS
SELF DEVELOPMENT
E-LIBRARY
8.
6.
10
11 12
13
14
15
16
Your company wants to invest JD 10,000,000 in network, taking into consideration the below table
Investment
10,000,000.00
Lifetime
Annual Revenues in Yearl
2,000,000.00
2%
Annual decline in revenues from Y2
30%
Direct Cost % of revenues
15%
OPEX % of revenues
7%
Interest Discount rate/fWACC)
CO
arrow_forward
What is the amount of the total paid-in capital? What makes up this amount?
arrow_forward
kar
arrow_forward
Complete solution for letters ABC please
arrow_forward
Problem 2
ABM Enterprise would like to evaluate/analyze an investment proposal.
Given the following:
Investment amount 450,000 (2022)
Dividends / Revenue stream - 100,000 for the first year and an interval of 5,000 for the
succeeding years
Discount rate - 14%
a. NPV for the perio 2023 through 2029;
b. Total NPV using manual computation;
c. Total NPV using the Excel function; and
d. IRR rate.
arrow_forward
What formula should I use to recreate this table in excel?
arrow_forward
financial management ch 18 hw
please show work, thank you.
question 8
arrow_forward
Answer choices:
$120
$130
$42
$55
$-92
arrow_forward
F. A PROBLEM
arrow_forward
Please provide excel template to work thanku
arrow_forward
explain the image provided give recommendation
arrow_forward
Please show the excel solutions. Thank you :)
arrow_forward
Question: 52
You are considering investing in Nuran Security Services.
You have been able to locate the following information
on the firm: total assets are $26.95 million, accounts
receivable are $4.30 million, ACP is 30 days, net income is
$4.50 million, and debt-to-equity is 1.20 times.
Calculate the ROE for the firm.
arrow_forward
Instruction: Use the table below to acquire information and answer the following questions. Please do not use signs like Rs., $, % etc in your answer. If you calculate percentage as 10.23% than answer must write like 10.23 only (do not write like 10.23% or 0.1023)
Year
0
1
2
3
4
Cash flows
−$950
$525
$485
$445
$405
Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's discounted payback in years? Answer should correct up to 2 decimal places.
Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's net present value?
Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's profitability index? Answer should correct up to 2…
arrow_forward
pls solve this ques with clear complete solution I'll give you many upvotes
arrow_forward
I need help with this
arrow_forward
Show your solutions clearly
arrow_forward
Problem 9
Intro
Apollo Learnings needs $39 million to build a new campus. The company has a target debt-equity ratio of 1.
The flotation cost for new equity is 9% and the flotation cost for new debt is 4%.
Part 1
What are the weighted average flotation costs as a fraction of the amount invested?
4+ decimals
Submit
Part 2
What is the true cost of building the new campus (in $ million)?
1+ decimals
Submit
arrow_forward
Pls correct sir thanks stepwise
arrow_forward
The following information is provided for each Investment Center.
Investment Center
Cameras
Phones
Computers
Income
$5,200,000
2,436,000
1,000,000
Average Assets
$ 29,000,000
20,300,000
19,800,000
QS 22-12 (Algo) Computing return on investment LO A1
Compute return on investment for each investment center. Which center performed the best based on return on investment?
Complete this question by entering your answers in the tabs below.
Return on
Performance
Investment Based on ROI
Compute return on investment for each investment center.
Note: Round your final answer to 1 decimal place.
Investment Center
Income
Average Assets
Return on
Investment
Cameras
$ 5,200,000 $ 29,000,000
%
Phones
Computers
2,436,000
1,000,000
20,300,000
%
19,800,000
%
arrow_forward
Q. 1
purchase of equipment in the coming year. The capital budget is limited to $5,000,000 for the
year. Lori Alleyne, staff analyst at McGloire's, is preparing an analysis of the three projects
under consideration by Joyanne McGloire, the company's owner.
McGloire Construction is analyzing its capital expenditure proposals for the
A
в
D
Project A
Project B
Project C
1
Projected cash outflow
Net initial investment
2
3
$3 000 000
$1 500 000
$4 000 000
4
5 Projected cash inflows
Year 1
$1 000 000
1 000 000
1 000 000
1 000 000
$ 400 000
$2 000 000
7
Year 2
900 000
2 000 000
8
Year 3
800 000
200 000
Year 4
100 000
10
11 Required rate of return
10%
10%
10%
1. Because the company's cash is limited, McGloire thinks the payback method
should be used to choose between the capital budgeting projects.
a. List two benefits and two limitations of using the payback method to choose
between projects?
b. Calculate the payback period for each of the three project
Ignore income taxes. Using the payback…
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Hi expart solve this accounting question
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781285867977
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- task 1 question 4arrow_forwardFinance Initial Investment $17,766 End of Year Income 1 $5,919 2 $4,285 3 $5,143 4 $3,532 5 $1,800 (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) pop-up content ends PrintDone Justin Lieberman must earn a minimum rate of return of 9.22% as compensation for the risk of the following investment: a. Use present value techniques to estimate the IRR on this investment. b. On the basis of your finding in part a, should Justin make the proposed investment? Question content area bottom Part 1 a. The yield on this investment is enter your response here%. (Round to two decimal places.)arrow_forwardTable 3.5 presents a computer spreadsheet for estimating R&E Supplies’ external financing required for 2018. The text mentions that with modifications to the equations for equity and net sales, the forecast can easily be extended through 2019. Write the modified equations for equity and net sales.arrow_forward
- This question sir thnksssarrow_forwardAnswer plarrow_forwardPROJECT 8 QR Spring 2020 Finances - Word A jrush416 erences Mailings Review View Help Tell me what you want to do A Aa - 三 T AaBbCcDc AaBbCcDc AaBbC AAB6CCE TNormal T No Spac. Heading 1 Heading 2 Paragraph Styles 5. Suppose you want to have $900,000 forretirement in 30 years. Your account earns 8% interest. a) How much would you needto deposit in the account each month b) How much interest will you earn?arrow_forward
- Assignment Question: A. Messi wishes to find the present value of $ 3,500 that will be received 12 years from now. Messi opportunity cost is 8%. ? b. Financial Management means planning, organizing, directing and controlling the financial activities such as procurement and utilization of funds of the enterprise. Briefly explain the Popular Sources of Risk Affecting Financial Managers and Shareholders? 1:06 PM Aarrow_forwardPROGRAMS SELF DEVELOPMENT E-LIBRARY 8. 6. 10 11 12 13 14 15 16 Your company wants to invest JD 10,000,000 in network, taking into consideration the below table Investment 10,000,000.00 Lifetime Annual Revenues in Yearl 2,000,000.00 2% Annual decline in revenues from Y2 30% Direct Cost % of revenues 15% OPEX % of revenues 7% Interest Discount rate/fWACC) COarrow_forwardWhat is the amount of the total paid-in capital? What makes up this amount?arrow_forward
- kararrow_forwardComplete solution for letters ABC pleasearrow_forwardProblem 2 ABM Enterprise would like to evaluate/analyze an investment proposal. Given the following: Investment amount 450,000 (2022) Dividends / Revenue stream - 100,000 for the first year and an interval of 5,000 for the succeeding years Discount rate - 14% a. NPV for the perio 2023 through 2029; b. Total NPV using manual computation; c. Total NPV using the Excel function; and d. IRR rate.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFundamentals of Financial Management (MindTap Cou...FinanceISBN:9781285867977Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
- Pfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781285867977
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning