Final Project - Financial Analysis Report - MD
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
320
Subject
Finance
Date
Jan 9, 2024
Type
docx
Pages
8
Uploaded by DeanHorse1389
Mariana Ducharme
Southern New Hampshire University FIN 320 – Principles of Finance Lori Lothringer
August 2023
FIN 320 – Principles of Finance
Project Two Financial Analysis Report
Financial Analysis and Financial Evaluation
1.
Financial Analysis
A.
Financial Calculations
i.
Working capital
Currently, as of July 2023, the company has a positive working capital of $1,940,000.00,
which means that the company can repay debt and have easy liquidity. In July 2022, the
company had a working capital of $718,000.00, the current working capital (2023) shows an
increase of 170% from the previous year (2022). For the company, it means that the corporation
has sufficient funds to pay for its operations, debts, or expansion plans, (Tuovila, 2006).
ii.
Current ratio
The third quarter of 2023 shows that Walt Disney World Co. has a current ratio of 1.069 or 1.1.
The company’s current ratio demonstrates that the company has more assets than liabilities,
technically, the company could pay its liabilities 1.1 times over, (Girardin, 2022). In July 2022,
the company obtained a current ratio of 1.023 or 1.0, like the current ratio for the most current
quarter fiscal year. In this case, Walt Disney World Co. demonstrated to have enough liquidity to
cover its short-term debts in the past two years. iii.
Debt ratio
1
As indicated in the most recent quarter, Disney has a debt ratio of 0.52, while in July 2022, the
company indicated a debt ratio of 0.55, which shows that the company obtained a small decrease
in debt ratio and maintained stability by having more assets than debts during both quarterly
periods.
iv.
Earnings per share
Disney’s EPS significantly decreased from $0.79 (July 2022) to -$0.26 (July 2023). The
company is experiencing a loss of -$0.26 for every share of outstanding stock, which at this
moment means that the company is not generating profitability or positive growth from its
shares. v.
Price/earnings ratio
On July 2023, Disney obtained a P/E ratio of -345.67, which was a decrease from 121.52 from
the previous year. These ratios show that the company’s ratio is very low at this moment and
perhaps not valuable for investments because a negative P/E ratio means that a business has
negative earnings or is losing money, which could be only an unprofitable period, (Berger,
2023).
vi.
Total asset turnover ratio
In July 2023, Disney obtained a total asset turnover ratio of 0.11, equal to 0.11 in July 2022. A
total asset turnover ratio below one means a low efficiency, (Hayes, 2003). The company’s ratio
is lower than one, but the company has large assets bases, so it is expected that assets will turn
into sales/revenue slowly.
vii.
Financial leverage
2
In July 2023, Disney obtained a financial leverage ratio of 2.09, and in July 2022, a ratio of
2.21, these numbers are not so high, which means that the company has not taken a lot of debt to
obtain financial growth. viii.
Net profit margin
In July 2023, Disney obtained a net profit margin of -0.0206 or -2%, and in July 2022, a net
profit margin of 0.0655 or 7%. These numbers indicate a significant decrease; the current
negative number, -2%, is considered a very low net profit margin, meaning that the company is
not generating enough sales to be profitable at this moment. Cash flow should be analyzed. ix.
Return on Assets
In July 2023, Disney obtained a ROA ratio of -0.0023 or 0%, and in July 2022, a ratio of
0.0069 or 1%. In this case, the company obtained a decrease in the return of assets, however,
these numbers could be very low due to the type and amount of assets that this company has such
as properties/parks; however, at this moment, seems like the company is not generating profit for
the money invested on assets.
x.
Return on Equity
In July 2023, the Walt Disney Company obtained an ROE of -0.0047 or 0%, and in July 2022,
an ROE of 0.0152 or 2%. A significant difference between the periods, and the ratio considered
very low, this means that the company is being efficient in generating income from its equity.
The higher the ROE, the better the company is obtaining profit from its equity, (Fernando, 2003).
At this moment, the company is not obtaining positive profit from its equities. B.
Working Capital Management
Working capital is the financial metric that represents operating liquidity available for the
company. Working capital represents the company’s available funds to pay for its operations,
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
Problem 4:03 (Algorithmic)
The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union
invests in risk-free securities to stabilize income. The various revenueproducing investments together with annual rates of return are as follows:
Type of Loan/Investment Annual Rate of Return (%)
Automobile loans
8
Furniture loans
Other secured loans
Signature loans
Risk-free securities
The credit union will have $1.4 million available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition of the loans and
investments.
.
10
11
. Risk-free securities may not exceed 30% of the total funds available for investment.
Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans).
• Furniture loans plus other secured loans may not exc…
arrow_forward
Financial Accounting
arrow_forward
1. Accounting Rate of Return on average investment of Project A (expressed to twodecimal places).
1.2 Net Present Value of both projects. 1.3 Internal Rate of Return of Project B (expressed to two decimal places) usinginterpolation
arrow_forward
Question E5-2
arrow_forward
What is the amount of the total paid-in capital? What makes up this amount?
arrow_forward
What amount should they invest on these general accounting question?
arrow_forward
Pls do fast and i will rate instantly for sure
Solution must be in typed form
arrow_forward
Blue Sky Corporation wants to khnow how much to invest today to have $75,000... Please need answer the accounting question
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
This question sir thnksss
arrow_forward
Complete the following 6 Wk 3 Financial Exercises: Problem Set 1, Part 2
problems:
1. Calculate the net present value (NPV) of the following cash flow stream if the
required rate is 12%:
Insert your NPV calculation.
Year
Cash Flow
Is this a good project for the business to accept? Explain why or why not.
Insert your answer.
2. Calculate the NPV of the following cash flow projections based on a required
rate of 10.5%:
Insert your NPV calculation.
Year
Cash Flow
Is this a good project for the business to accept? Explain why or why not.
Insert your answer.
3. A company needs to decide if it will move forward with 2 new products that it is
evaluating. The 2 initiatives have the following cash flow projections:
Project A
Project B
Year
Cash Flow
Year
Cash Flow
Based on the risk of each project, the company has a required rate of return of
11% for Project A and 11.5% for Project B. The company has a $1.5 million
budget to spend on new projects for the year. Should the company move forward…
arrow_forward
Practice Set 7 – The Mathematics of Finance (for CBAE, CHE, & CAE)
Mathematics as a Tool (Part 2)
H. Select the formula to be used in each problem below, then solve.
nt
A = P| 1+-
A
P =
I = A-P,
I = Prt
nt
1+-
1. What is the compound amount and interest if Php 10,000 is invested at 3.6% compounded monthly for
2 years?
2. How much interest earned in 5 years on Php 20,000 deposited in an account paying 6.5%
compounded semi-annually?
3. How much money should you invest at an interest rate of 4.5% compounded monthly, in order to have
Php 300,000 in 4 years?
ctice Set
arrow_forward
Please show the excel solutions. Thank you :)
arrow_forward
I could really use some help with this problem it’s due in a few hours thank you so much
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 thesucceeding yearsDiscount rate - 14%
a. NPV for the perio 2023 through 2029;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.
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
explain the image provided give recommendation
arrow_forward
Use the present value and future value tables to answer the following questions.
Time Value of Money - Principles of Accounting, Volume 2: Managerial Accounting | OpenStax
A. If you would like to accumulate $2,400 over the next 5 years when the interest rate is 15%, how much do you need to deposit in the account?
$_____
B. If you place $6,200 in a savings account, how much will you have at the end of 6 years with a 12% interest rate?
$_____
C. You invest $7,000 per year for 11 years at 12% interest, how much will you have at the end of 11 years?
$_____
D. You win the lottery and can either receive $760,000 as a lump sum or $60,000 per year for 19 years. Assuming you can earn 8% interest, which do you recommend and why?
_____
arrow_forward
Struggling with accounting homework
arrow_forward
A4
Please solve branch B by hand on a piece of paper, please
arrow_forward
Please don't used Ai solution
arrow_forward
Need answer the financial accounting question
arrow_forward
Help please
arrow_forward
Hello tutor please provide this question solution general accounting
arrow_forward
Actual Year
Projected Year 2022
2021
Revenues - high school students
88,200
110,300
Revenues - adult learners
571,200
745,000
Accounts receivable - high schools
7,400
10,200
Accounts receivable - adult learners
47,600
73,000
Commissions expense
21,400
27,800
Commissions payable
900
1,200
Salaries and benefits expense
638,900
947,000
Rent expense
12,000
12,400
Prepaid rent
1,200
1,200
Prepaid insurance
2,800
3,000
High school expenses (Cost of Sales)
49,400
65,300
Adult learner expenses (Cost of Sales)
68,500
98,700
Long-term debt
Depreciation expense
10,000
18,000
Other operating expenses
50,000
55,000
Accounts payable
14,800
15,700
Salaries and benefits payable
26,600
37,500
3,800
Payroll taxes payable
Income tax expense
2,700
Fixed assets, net of accumulated depreciation
35,000
45,000
Retained earnings (Accumulated deficit)
(96,000)
Common and preferred stock
400,000
75,000
400,000
Cash
255,000
Interest expense
arrow_forward
Pls correct sir thanks stepwise
arrow_forward
Deepen
Activity 1. Problem Solving
1. A university professor who receives a basic monthly salary of P80,000, a living allowance of P2,000
per month, and has an investment of P500,000 which carns an interest of 6% per year. Suppose
this university professor has to pay also each year P245,880 for income tax, 912,000 for Philhealth,
P1,200 for Pag-ibig and P86,400 for GSIS contributions. What is his (a) gross income (b) net income?
2. A minimum wage earner in Metro Manila is paid P481 for an 8-hour workday. If he works for 22
days in one month, what would be his gross monthly income? Suppose the minimum wage carner
is exempted from paying income tax. His deductions per month are P100 for Pag-ibig, P200 for
PhilHealth and P363.30 for SSS then what is his net monthly income?
3. Jane receives a basic pay of P9,880.00 a month and a 2% commission on her sales. She sold
P105,000 for the month. Her deductions are: 4% for SSS based on her basic monthly pay; P100.00
for the PhilHealth; Pag-Ibig,…
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
Asap ppzzz
arrow_forward
What is the value of 'FREE CASH FLOW' in the year 2021?
Rs. 1.23 million
Rs. 2.95 million
Rs. 3.95 million
Rs. 5.04 million
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Related Questions
- Problem 4:03 (Algorithmic) The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenueproducing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans Other secured loans Signature loans Risk-free securities The credit union will have $1.4 million available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition of the loans and investments. . 10 11 . Risk-free securities may not exceed 30% of the total funds available for investment. Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans). • Furniture loans plus other secured loans may not exc…arrow_forwardFinancial Accountingarrow_forward1. Accounting Rate of Return on average investment of Project A (expressed to twodecimal places). 1.2 Net Present Value of both projects. 1.3 Internal Rate of Return of Project B (expressed to two decimal places) usinginterpolationarrow_forward
- Pls do fast and i will rate instantly for sure Solution must be in typed formarrow_forwardBlue Sky Corporation wants to khnow how much to invest today to have $75,000... Please need answer the accounting questionarrow_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
- This question sir thnksssarrow_forwardComplete the following 6 Wk 3 Financial Exercises: Problem Set 1, Part 2 problems: 1. Calculate the net present value (NPV) of the following cash flow stream if the required rate is 12%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 2. Calculate the NPV of the following cash flow projections based on a required rate of 10.5%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 3. A company needs to decide if it will move forward with 2 new products that it is evaluating. The 2 initiatives have the following cash flow projections: Project A Project B Year Cash Flow Year Cash Flow Based on the risk of each project, the company has a required rate of return of 11% for Project A and 11.5% for Project B. The company has a $1.5 million budget to spend on new projects for the year. Should the company move forward…arrow_forwardPractice Set 7 – The Mathematics of Finance (for CBAE, CHE, & CAE) Mathematics as a Tool (Part 2) H. Select the formula to be used in each problem below, then solve. nt A = P| 1+- A P = I = A-P, I = Prt nt 1+- 1. What is the compound amount and interest if Php 10,000 is invested at 3.6% compounded monthly for 2 years? 2. How much interest earned in 5 years on Php 20,000 deposited in an account paying 6.5% compounded semi-annually? 3. How much money should you invest at an interest rate of 4.5% compounded monthly, in order to have Php 300,000 in 4 years? ctice Setarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning